How to check the success of a database query?

Question

PHP

I have a Select request, how to check if the request is successful? Didn't find an answer on google.

Answer 1

if (($res = mysql_query ("select ...")) === FALSE) - pure error check, or after mysql_query check for mysql_err !=
0 net/manual/ru/function.mysql-query.php
For mysqli, pdo - about the same and in the same place.

Answer 2

if PDO
$db->STH->rowCount() > 0 - true

Answer 3

And right in the IDE, why not try to make a query to the database? Definitely not writing in a notebook.