php-pdoBind current datetime with PHP PDO
$st = $pdo->prepare('INSERT INTO test SET name = :name, created_at = :now');
$st->execute([':name' => 'Donald', ':now' => date('Y-m-d H:i:s')]);ctrl + c$pdo->prepareprepare given query to execute | $st->execute(run query on the server |
created_atdatetime column to be populated | :nowplaceholder for current date/time value |
date('Y-m-d H:i:s')will return current time in | |
More of Php Pdo
- How to install PHP PDO for Mysql in Ubuntu 22.04
- Get current database name with PHP PDO
- Fetch single column value with PHP PDO
- Set execution timeout with PHP PDO
- Connect to MariaDB using PHP PDO
- Connect to Mysql with PHP PDO
- How to bind table name in PHP PDO
- How to get results after PHP PDO statement execute()
- Escape string with PHP PDO
See more codes...