require_once 'DB.php'; $db = DB::connect('mysql://username:password@localhost/database'); $res = $db->query('SELECT * FROM users'); $data = $res->fetchAll();
require_once 'DB.php'; $db = DB::connect('mysql://username:password@localhost/database'); $id = 1; $user = $db->getRow('SELECT * FROM users WHERE id = ?', array($id));
require_once 'DB.php'; $db = DB::connect('mysql://username:password@localhost/database'); $data = array( 'username' => 'john', 'password' => 'secret', 'email' => 'john@example.com' ); $db->insert('users', $data);This code examples are using the "DB" package library, which is a part of the PEAR (PHP Extension and Application Repository) project. To use PHP DataObject, you must have PEAR installed on your system.