PHP Récupérer un seul résultat


Exemple

Outre l'utilisation des instructions SQL LIMIT, vous pouvez également utiliser la fonction SQLite3 querySingle pour extraire une seule ligne ou la première colonne.

<?php
$database = new SQLite3('mysqlitedb.db');

//Without the optional second parameter set to true, this query would return just
//the first column of the first row of results and be of the same type as columnName
$database->querySingle('SELECT column1Name FROM table WHERE column2Name=1');

//With the optional entire_row parameter, this query would return an array of the
//entire first row of query results.
$database->querySingle('SELECT column1Name, column2Name FROM user WHERE column3Name=1', true);
?>