Class db¶
-
class
db
¶ Class db prepare statements for mysql queries to the connected database. We use the global
$db
instance to access its methods.-
query
($q, $args)¶ Runs a query and returns the result.
Parameters: - $q (string) – The query.
- $args ((array)) – Optional. Values to prepare the statement.
Examples
$result1 = $db->query("SELECT title,author FROM post;"); $result2 = $db->query("SELECT title,author FROM post WHERE user_id=?;",[session::user_id()]);
-
get
($q, $args)¶ Runs a query and returns the results as an array.
Parameters: - $q (string) – The query.
- $args ((array)) – Optional. Values to prepare the statement.
Example
$result = $db->get("SELECT title,author FROM post;"); // Returns [ 0=>[0=>'Lorem ipsum', 'title'=>'Lorem ipsum', 1=>'John', 'author'=>'John'], 1=>[0=>'Duis aute irure', 'title'=>'Duis aute irure', 1=>'John', 'author'=>'John'], ]
-
gen
($q, $args)¶ Runs a query and returns a generator that yields the rows.
Parameters: - $q (string) – The query.
- $args ((array)) – Optional. Values to prepare the statement.
Example
$generator = $db->gen("SELECT title,author FROM post;");
-
getRows
($q, $args)¶ Runs a query and returns the results as an array. With rows fetched with mysqli_fetch_row().
Parameters: - $q (string) – The query.
- $args ((array)) – Optional. Values to prepare the statement.
Example
$result = $db->get("SELECT title,author FROM post;"); // Returns [ 0=>[0=>'Lorem ipsum',1=>'John'], 1=>[0=>'Duis aute irure',1=>'John'], ]
-
getList
($q, $args)¶ Runs a query and returns an array with the values of the first columns from the results.
param string $q: The query. param (array) $args: Optional. Values to prepare the statement. Example
$titles = $db->get("SELECT title,author FROM post;"); // Returns [0=>'Lorem ipsum', 1=>'Duis aute irure']
-
value
($q, $args)¶ Runs a query and returns the value of the first column of the first row of the results.
param string $q: The query. param (array) $args: Optional. Values to prepare the statement. Example
$res = $db->get("SELECT title FROM post WHERE id=1;"); // returns 'Lorem ipsum'
-
error
()¶ Return an error if exists from the last query executed.
Example
$res = $db->get("SELECT title,author FROM post;"); if ($error = $db->error()) { trigger_error($error); }
-
close
()¶ Closes the connection to the database.
Example$db->close();
-