Варианты
SQL:
$row = $db->querySingle("SELECT COUNT(*) as count FROM articles WHERE title LIKE '%$search%' OR content LIKE '%$search%'");
echo $row;
SQL
if($stmt = $db->prepare("SELECT * FROM articles WHERE title LIKE '%$search%' OR content LIKE '%$search%'")){
$results = $stmt->execute();
$rowCount = 0; // Count Rows
while ($row = $results->fetchArray(SQLITE3_ASSOC)){
++$rowCount;
}
echo $rowCount;
}
Собственно вот
UPD:
// Count rows from select
$count_row = $db->querySingle("SELECT COUNT(*) as count FROM articles WHERE title LIKE '%$search%' OR content LIKE '%$search%'");
if($count_row > 0){
// Table is not empty
$results = $db->query("SELECT * FROM articles WHERE title LIKE '%$search%' OR content LIKE '%$search%'");
while ($row = $results->fetchArray(SQLITE3_ASSOC)) {
var_dump($row);
}
}else{
// Empty table message
}