php-pdoFetch single column value with PHP PDO
$st = $pdo->prepare('SELECT name FROM test LIMIT 1');
$st->execute();
$value = $st->fetchColumn();ctrl + c$pdo->prepareprepare given query to execute | $st->execute(run query on the server |
$st->fetchColumn()return single column value from resulting set | namecolumn to get value of |
Usage example
<?php
$pdo = new PDO('mysql:host=localhost;dbname=test', 'usr', 'pwd');
$st = $pdo->prepare('SELECT id FROM test LIMIT 1');
$st->execute();
$value = $st->fetchColumn();
echo $value;output
1Related
More of Php Pdo
- How to install PHP PDO for Mysql in Ubuntu 22.04
- Bind current datetime with PHP PDO
- Get current database name with PHP PDO
- Set execution timeout with PHP PDO
- Connect to MariaDB using PHP PDO
- How to get results after PHP PDO statement execute()
- How to bind table name in PHP PDO
- Escape string with PHP PDO
- Insert JSON into table with PHP PDO
See more codes...