This is my php code:
public function update($table,$fields_and_values,$condition_field,$condition_field_value) { $query="UPDATE $table SET "; foreach($fields_and_values as $field=>$value) $query.=($field."=:".$field." ,"); $query.=" "; $query=str_replace(", "," WHERE ",$query); $query.=($condition_field."='".$condition_field_value."'"); echo $query; $stmt=$this->conn->prepare($query); foreach($fields_and_values as $field=>$value) $stmt->bindParam(":".$field,$value); $stmt->execute(); } and this is how i call the function in my class:
$db=new db_connection('localhost','root','','maps'); $db->connect(); $arr=array('username'=>'testfromnewclass3','password'=>'123456'); $db->update('users',$arr,'username','term'); $db->disconnect(); It doesn't matter what the other functions like disconnect do! They work correctly.
My problem is that when this command executes, both username and password become 123456 ! And this is what i get from that echo $query:
UPDATE users SET username=:username ,password=:password WHERE username='term' Is something wrong with my function? and if so how can i fix it?
bindValueand notbindParam.bindParamcan alter the value of the variable passed, its intended use is when you have stored procedures which can return values and then those values are contained in variables you passed. Also, never disconnect from MySQL. You don't want that. You're creating overhead that way.