Wednesday 11 July 2018

PHP PDO: update data

PHP PDO: update data

<?php

// configuration

$dbhost        = "localhost";
$dbname        = "pdo";
$dbuser        = "root";
$dbpass        = "";
// database connection
$conn = new PDO("mysql:host=$dbhost;dbname=$dbname",$dbuser,$dbpass);

// new data
$title = 'PHP Pattern';
$author = 'Imanda';
$id = 3;

// query
$sql = "UPDATE books SET title=?, author=? WHERE id=?";
$q = $conn->prepare($sql);
$q->execute(array($title,$author,$id));

?>

0 comments:

Post a Comment