Ошибки Apt с момента обновления до 12.04

Варианты

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
}
6
задан 2 May 2012 в 23:36

0 ответов

Другие вопросы по тегам:

Похожие вопросы: