For example:
JavaScript
x
$sql = 'select a, b, c from table where condition';
$stmt->prepare($sql);
$stmt->execute();
$data = $stmt->fetch();
AND
JavaScript
$sql = 'select a, b, c from table where condition';
$stmt->prepare($sql);
$stmt->execute();
$data = $stmt->fetchAll();
How to check if result set is empty or not
Advertisement
Answer
Check $data
variable like:
JavaScript
if ($data) {
//not empty
} else {
// empty
}
If the result of SELECT
query did return any data, variable $data
will contain a non-empty array/object which evaluates to true
, and a false-like value otherwise.