RPeraltaJr
3/5/2018 - 7:28 PM

UPDATE query

UPDATE query with named placeholders

In the case you have a predefined array with values, or prefer named placeholders in general.

source: https://www.taniarascia.com/overview-of-sql-commands-and-pdo-operations/
source: http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers

index.php
content_copyfile_download
<?php 
$user = [
  'username'  => 'John Doe',
  'email'     => 'johndoe@example.com',
  'location'  => 'New York',
];

$sql = "UPDATE users SET username = :username, email = :email, location = :location, WHERE id = :id";
$statement = $connection->prepare($sql);
$statement->execute($user);