function update using pdo in php error

Asked Jun 08 '18 at 12:07

Active Jun 08 '18 at 13:05

Viewed 58 times

I'm having trouble with my fonction "update" using PDO with php.

Error :

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;
}

edited Jun 08 '18 at 13:05

Fazie

asked Jun 08 '18 at 12:07

sunil rawat

3

Possible duplicate of ["Invalid parameter number: parameter was not defined" Inserting data](https://stackoverflow.com/questions/5874383/invalid-parameter-number-parameter-was-not-defined-inserting-data) – Muhammad Hassaan Jun 08 '18 at 12:10
you should put a space before `WHERE` – Karsten Koop Jun 08 '18 at 13:19
thank u mr. karsten koop it worked for me.... – sunil rawat Jun 09 '18 at 08:09

function update using pdo in php error

0 Answers0