Joseph Says: STOP SPAMMING MY %$#@ING SITE $%#@!!!!!

Gorilla Db - MySQLi Wrapper

---

Monday, April 7, 2008

Db has been used in a number of my projects, the main focus of this class is to simplify the overall process of prepared statements. As this was migrated into my work place need for docs and log functions was created.

Db is a connection manager, it will use the connection you first create throughout your application. You can continue to call Db:init() and as long as a connection has already been made, you can run queries. Best of all It has prepared statements thanks to Wrapping MySQLi. For documentation and download please visit Gorilla Labs

 
$db = Db::init('localhost', 'root', 'pass', 'clients');
 
//-- Prepared Statements
$rows = $db->query('SELECT * FROM blog_entries WHERE pub_date < ?', array('2008-04-01'));
 
echo 'Number of result: ' . $db->count();
echo '<br/>';
 
echo 'SQL executed: ' . $db->debug();
echo '<br/>';
 
$rows = $db->fetchAll();
/* Output:
 * Number of result: 22
 * SQL executed: SELECT * FROM blog_entries WHERE pub_date < '2008-04-01'
 */
 

Comments

---

• 0

Add Comment

---

Name

Email

Website

Your Comment