note 117696 added to book.mysql

Here is a 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); } } (Phillipus - I don't know what nationality you are, but the word "moron" is pretty offensive in UK English. Thank you) ---- Server IP: 72.52.91.14 Probable Submitter: 86.132.84.82 ---- Manual Page -- http://php.net/manual/en/book.mysql.php Edit -- https://master.php.net/note/edit/117696 Del: integrated -- https://master.php.net/note/delete/117696/integrated Del: useless -- https://master.php.net/note/delete/117696/useless Del: bad code -- https://master.php.net/note/delete/117696/bad+code Del: spam -- https://master.php.net/note/delete/117696/spam Del: non-english -- https://master.php.net/note/delete/117696/non-english Del: in docs -- https://master.php.net/note/delete/117696/in+docs Del: other reasons-- https://master.php.net/note/delete/117696 Reject -- https://master.php.net/note/reject/117696 Search -- https://master.php.net/manage/user-notes.php