PHP Classes
elePHPant
Icontem

ezSQL: Makes using mySQL ridiculously easy (great docs)

Recommend this page to a friend!

  Author Author  
Picture of Justin Vincent
Name: Justin Vincent <contact>
Classes: 1 package by
Country: United Kingdom United Kingdom


  Detailed description   Download Download .zip .tar.gz   Install with Composer Install with Composer  
ezSQL is a widget that makes it very fast and easy for you to use database(s) within your PHP scripts.

This widget is a php file that you include at the top of your script. Then, instead of using std php database functions listed in the php manual, you use a much smaller (and easier) set of ezSQL functions.

ezSQL can dramatically increase development time and in most cases will streamline your code and make things run faster as well as making it very easy to debug and optimise your database queries.

Please read through these examples to see how easy using databases can be using ezSQL.

-------------------------------------------------------
Example 1
-------------------------------------------------------

// Select multiple records from the database..
$results = $db->get_results("SELECT name, email FROM users");

foreach ( $results as $user )
{
// Access data using object syntax
echo $user->name;
echo $user->email;
}

----------------------------------------------------
Example 2
----------------------------------------------------

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

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


----------------------------------------------------
Example 3
----------------------------------------------------

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

echo $var;


----------------------------------------------------
Example 4
----------------------------------------------------

// Insert into the database
$db->query("INSERT INTO users (id, name, email) VALUES (NULL,'Justin','jv@foo.com')");


----------------------------------------------------
Example 5
----------------------------------------------------

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


----------------------------------------------------
Example 6 (for debugging)
----------------------------------------------------

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


----------------------------------------------------
Example 7 (for debugging)
----------------------------------------------------

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

$db->vardump($results);


----------------------------------------------------
Example 8
----------------------------------------------------

// Get 'one column' (based on index) from a query..
$names = $db->get_col("SELECT name,email FROM users",0)

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

// Get another column from the previous (cached) query results..
$emails = $db->get_col(null,1)

foreach ( $emails as $email )
{
echo $email;
}


----------------------------------------------------
Example 9
----------------------------------------------------

// Map out the full schema of any given database..

$db->select("my_database");

foreach ( $db->get_col("SHOW TABLES",0) as $table_name )
{

$db->debug();
$db->get_results("DESC $table_name");

}

$db->debug();

  Classes of Justin Vincent  >  ezSQL  >  Download Download .zip .tar.gz  >  Support forum Support forum (24)  >  Blog Blog  >  RSS 1.0 feed RSS 2.0 feed Latest changes  
Name: ezSQL
Base name: mysqldb
Description: Makes using mySQL ridiculously easy (great docs)
Version: 1.0.0
PHP version: -
License: Artistic License
 
  Groups   Dependents   Trackback   Applications   Files Files  

  Groups  
Group folder image Databases Database management, accessing and searching View top rated classes


  Other classes that need this package  
Class Why it is needed Dependency
3SS Data Description Form To retrieve data Recommended

  Pages that reference this package  
InvisionYourLife.com Development
A new version of InvisionYourLife.com went live around Christmas 2008...
mysqli kütüphanesi
Evet manual'de, extension listesinde felan görüyorduk ama nedir pek bilemiyorum...
Subtitles with FlowPlayer
I recently built a subtitling system for a site that I am working on: khristos.org...

Latest pages that reference packages Latest pages that reference packages


  Applications that use this package  
No pages of applications that use this class were specified.

Add link image If you know an application of this package, send a message to the author to add a link here.

  Files folder image Files  
File Role Description
Accessible without login Plain text file ez_demo.php Example Demo that maps out your db schema
Plain text file ez_sql.php Class Main File
Accessible without login HTML file ez_sql_help.htm Doc. This will really help you to understand this

Install with Composer Install with Composer - Download Download all files: mysqldb.tar.gz mysqldb.zip
NOTICE: if you are using a download manager program like 'GetRight', please Login before trying to download this archive.