php-pdoUPDATE query example with PHP PDO
$st = $pdo->prepare('UPDATE test SET age = :new_age WHERE id = :id');
$st->execute([':new_age' => 53, ':id' => 1]);ctrl + c$pdo->prepareprepare given query to execute | $st->execute(run query on the server |
[':new_age' => 53, ':id' => 1]bind both update values (used in | |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$st = $pdo->prepare('UPDATE test SET age = :new_age WHERE id = :id');
$st->execute([':new_age' => 53, ':id' => 1]);
echo $st->rowCount();output
1More of Php Pdo
- Set charset in PHP PDO
- Fetch single column value with PHP PDO
- Commit transaction in PHP PDO
- How to get results after PHP PDO statement execute()
- Set execution timeout with PHP PDO
- Get last query error with PHP PDO
- Bind current datetime with PHP PDO
- Escape string with PHP PDO
- Get current database name with PHP PDO
- Insert JSON into table with PHP PDO
See more codes...