Have you been or are you in this situation:<\/p>\n\n\n\n
Yes? So, why on earth you want to wrap<\/strong> your already wrapped<\/strong> Christmas presents into another paper?!<\/p>\n\n\n\n If you don’t know what are you doing, read next carefully: Do not wrap the wrapper.<\/strong> If you can’t learn PDO. You can. And you have to learn. It will help your life. Trust me. But, but, but if you know what are you doing and you need some life easifying routines. Please create an extension<\/strong> to PDO!<\/p>\n\n\n\n With an extension method you can use PDO as is, but also use functions created by you. Nothing gets broken nor your brains get damaged.<\/p>\n\n\n\n I did my own simple PDO extension: class.db.php<\/a>, that you can use or get inspiration for your own. I forked Imavex’s class<\/a> that didn’t fit into my needs.<\/p>\n\n\n\n Call class like normally Or you can call different database connection parameters like And run prepared stuff normally<\/p>\n\n\n\n Or straightfully<\/p>\n\n\n\n Or use your own functions<\/p>\n\n\n\n Or<\/p>\n\n\n\n
You’ll get into the troubles in deep soulful developments.<\/p>\n\n\n\n
If you think it’s ugly. Look into the mirror and repeat It is beautiful<\/em> until you’ll think so.<\/p>\n\n\n\n$sql = new db ();<\/code> with default connection parameters.<\/p>\n\n\n\n$sqlProd = new db ('production');<\/code> and $sqlDev = new db ('development');<\/code><\/p>\n\n\n\n$stmt = $sql->prepare(\"SELECT * FROM table WHERE field = ?\");\n$stmt->execute(array(\"value\"));\nprint_r($stmt->fetchAll(PDO::FETCH_ASSOC);<\/code><\/pre>\n\n\n\n$stmt = $sql->query(\"SELECT * FROM table WHERE field = 'value'\");\nprint_r($stmt->fetchAll(PDO::FETCH_ASSOC); <\/code><\/pre>\n\n\n\n$stmt = $sql->select(\"table\", \"field = 'value'\");\nprint_r($stmt);\n\n$bind = array(':value'=>'text');\n$stmt = $sql->select(\"table\", \"field = ':value'\", $bind);\nprint_r($stmt);<\/code><\/pre>\n\n\n\n$stmt = $sql->run(\"SELECT * FROM table field = 'value'\");\nprint_r($stmt);<\/code><\/pre>\n\n\n\n