PHP SqlUtils::selectWhere Exemples

Exemple #1

Fichier : m_database.php Projet : poi5305/yo

 public function getUserByFbId($uid)
 {
     $sql = SqlUtils::selectWhere(self::TABLE_USERS, "fb_uid = '{$uid}'");
     $r = $this->handle->query($sql);
     $results = array();
     while ($row = $r->fetchArray(SQLITE3_ASSOC)) {
         $results[] = $row;
     }
     return $results;
 }

Exemple #2

Fichier : m_database.php Projet : poi5305/ptnovel

 public function searchBooks($name, $offset, $limit)
 {
     $sql = SqlUtils::selectWhere(self::TABLE_BOOKS, "name LIKE '%{$name}%'", $offset, $limit);
     $r = $this->handle->query($sql);
     $results = array();
     while ($row = $r->fetchArray(SQLITE3_ASSOC)) {
         $results[] = $row;
     }
     return $results;
 }