note 117697 added to class.pdo

Here is a cheeky PDO helper class to get you started . . . define('DB_MAIN', 'localhost|user1|pa55word|db1'); // Connect to database db1 $db = new my_db(DB_MAIN); // Request "SELECT * FROM table1 WHERE a=16 AND b=22" // Get an array of stdClass's $rows = $db->fetchAll('SELECT * FROM table1 WHERE a=? AND b=?', 16, 22); class my_db{ private static $databases; private $connection; public function __construct($connDetails){ if(!is_object(self::$databases[$connDetails])){ list($host, $user, $pass, $dbname) = explode('|', $connDetails); $dsn = "mysql:host=$host;dbname=$dbname"; self::$databases[$connDetails] = new PDO($dsn, $user, $pass); } $this->connection = self::$databases[$connDetails]; } public function fetchAll($sql){ $args = func_get_args(); array_shift($args); $statement = $this->connection->prepare($sql); $statement->execute($args); return $statement->fetchAll(PDO::FETCH_OBJ); } } ---- Server IP: 72.52.91.14 Probable Submitter: 86.132.84.82 ---- Manual Page -- http://php.net/manual/en/class.pdo.php Edit -- https://master.php.net/note/edit/117697 Del: integrated -- https://master.php.net/note/delete/117697/integrated Del: useless -- https://master.php.net/note/delete/117697/useless Del: bad code -- https://master.php.net/note/delete/117697/bad+code Del: spam -- https://master.php.net/note/delete/117697/spam Del: non-english -- https://master.php.net/note/delete/117697/non-english Del: in docs -- https://master.php.net/note/delete/117697/in+docs Del: other reasons-- https://master.php.net/note/delete/117697 Reject -- https://master.php.net/note/reject/117697 Search -- https://master.php.net/manage/user-notes.php