This repository has been archived by the owner on Apr 17, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 17
A singleton pattern object which serves as a MySQL database wrapper and an iterator result set object.
License
MicahCarrick/PHP-MySQL-Database-Class
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
PHP MySQL Database Class ======================== Copyright (c) 2011 Micah Carrick All Rights Reserved. PHP MySQL Database Class is singleton pattern object which serves as a MySQL database wrapper and an iterator result set object. This project was developed as a follow up to my older, PHP4 database class from 2004. Basic Usage ----------- For a more detailed explanation, consult the phpDocumentor docstrings within the source code or visit http://www.micahcarrick.com/php5-mysql-database-class.html Here are some simple examples: // get the database singleton instance $db = MySqlDatabase::getInstance(); // connect try { $db->connect('localhost', 'username', 'password', 'database_name'); } catch (Exception $e) { die($e->getMessage()); } // iterate a resultset foreach ($db->iterate("SELECT foo FROM bar LIMIT 10") as $row) { echo $row->foo; } // get just one row $count = $db->fetchOne("SELECT COUNT(*) FROM foo"); // import from a file (use with caution!) $num = $db->importSqlFile('test-data.sql'); echo "Imported <strong>$num</strong> statements.<br/>";
About
A singleton pattern object which serves as a MySQL database wrapper and an iterator result set object.
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published