如何使用pdo oop进行更新功能

问题描述

 Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY093]: Invalid parameter number: parameter was not defined' on line 25


any one can help please?


function update($table,$data,$id){

 	global $conn;

  $resultstr = array();

  foreach ($data as $keys => $value) {

 	$resultstr[] = $keys."=:".$keys;


  }

  $values = implode(",",$resultstr);

   $sql ="Update ".$table." SET ".$values."WHERE id=:id";



   $query =  $conn->prepare($sql);

   $query->bindParam(':id',$id);

   foreach($data as $key=>$val){
        $query->bindValue(':'.$key,$val);

    }
    $updateData = $query->execute();



   return $updateData;

 }

我的尝试：



尝试制作更新功能....但是得到错误

What I have tried:

try to make an update function .... but getting errors

推荐答案

这篇关于如何使用pdo oop进行更新功能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！