php-pdoTest PHP PDO connection
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$now = $pdo->query('SELECT NOW()')->fetchColumn();ctrl + cnew PDOcreate new PDO connection | query(executes specified SQL and return |
SELECT NOW()DB will return current date and time | fetchColumnwill return single column value |
$nowif this variable contains date/time, our connection is fine | |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
echo $pdo->query('SELECT NOW()')->fetchColumn();output
2021-12-29 15:38:09More 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...