Quick Examples

Quick Examples

Note: In all these examples no other code is required other than including:

either for version 3.x

require 'ez_sql_loader.php';

or for version 4.x

// composer is required for version 4
require 'vendor/autoload.php';

Detailed installation instructions can be found on the Installation and Usage page.

---

Example 1 - get_results()

// Select multiple records from the database and print them out..
$users = $db->get_results("SELECT name, email FROM users");
foreach ( $users as $user )
{
 // Access data using object syntax
 echo $user->name;
 echo $user->email;
}

Example 2 - get_row()

// Get one row from the database and print it out..
$user = $db->get_row("SELECT name,email FROM users WHERE id = 2");

echo $user->name;
echo $user->email;

Example 3 - get_var()

// Get one variable from the database and print it out..
$var = $db->get_var("SELECT count(\*) FROM users");

echo $var;

Example 4 - Insert query()

// Insert into the database
$db->query("INSERT INTO users (id, name, email) VALUES (NULL,'justin','[email protected]')");

Example 5 - Update query()

// Update the database
$db->query("UPDATE users SET name = 'Justin' WHERE id = 2)");

Example 6 - debug()

// Display last query and all associated results
$db->debugOn();
$db->debug();

Example 7 - varDump()

// Display the structure and contents of any result(s) .. or any variable
$results = $db->get_results("SELECT name, email FROM users");

$db->varDump($results);

Example 8 - get_col()

// Get 'one column' (based on column index) and print it out..
$names = $db->get_col("SELECT name,email FROM users", 0)

foreach ( $names as $name ) 
{
 echo $name;
}

Example 9 - get_col() in foreach

// Same as above ‘but quicker’
foreach ( $db->get_col("SELECT name,email FROM users", 0) as $name )
{
 echo $name;
}

Example 10 - Print full schema

// Map out the full schema of any given database and print it out..
$db->select("my_database");

foreach ( $db->get_col("SHOW TABLES",0) as $table-name )
{
 $db->debug();
 $db->get_results("DESC $table-name");
}

$db->debug();