For example:
$sql = 'select a, b, c from table where condition'; $stmt->prepare($sql); $stmt->execute(); $data = $stmt->fetch();
AND
$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:
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.