Remember that you should't wrap every query into a try.catch statement. $pdo -> prepare ( $sql )-> execute ( $data ) Or you can chain execute() to prepare(): $sql = "UPDATE users SET name=:name, surname=:surname, sex=:sex WHERE id=:id" $sql = "UPDATE users SET name=:name, surname=:surname, sex=:sex WHERE id=:id" In case you have a predefined array with values, or prefer named placeholders in general, the code would be $data = [ $pdo -> prepare ( $sql )-> execute () UPDATE query with named placeholders Or you can chain execute() to prepare(): $sql = "UPDATE users SET name=?, surname=?, sex=? WHERE id=?" UPDATE query with positional placeholdersĪs usual, positional placeholders are more concise and easier to use $sql = "UPDATE users SET name=?, surname=?, sex=? WHERE id=?" execute the statement, sending all the actual values to execute() in the form of array. replace all actual values with placeholders.In order to run an UPDATE query with PDO just follow the steps below: UPDATE query with positional placeholdersįirst of all, make sure you've got a properly configured PDO connection variable that is needed in order to run SQL queries using PDO (and to inform you of the possible errors).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
February 2023
Categories |