{"id":299,"date":"2016-02-03T17:06:07","date_gmt":"2016-02-03T08:06:07","guid":{"rendered":"http:\/\/www.onepage.co.kr\/wordpress\/?p=299"},"modified":"2016-04-01T00:44:04","modified_gmt":"2016-03-31T15:44:04","slug":"%e2%80%8busing-mysql-stored-procedures-with-php-mysqlmysqlipdo","status":"publish","type":"post","link":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/2016\/02\/03\/%e2%80%8busing-mysql-stored-procedures-with-php-mysqlmysqlipdo\/","title":{"rendered":"\u200bUsing MySQL Stored Procedures with PHP mysql\/mysqli\/pdo"},"content":{"rendered":"<p><a data-topotext=\"[{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{},&quot;uniqueId&quot;:14},&quot;codePoints&quot;:[85,115,105,110,103,32,77,121,83,81,76,32,83,116,111,114,101,100,32,80,114,111,99,101,100,117,114,101,115,32,119,105,116,104,32,80,72,80,32,109,121,115,113,108,47,109,121,115,113,108,105,47,112,100,111,10,10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{},&quot;link&quot;:&quot;http:\/\/www.joeyrivera.com\/2009\/using-mysql-stored-procedures-with-php-mysqlmysqlipdo\/&quot;,&quot;uniqueId&quot;:49},&quot;codePoints&quot;:[104,116,116,112,58,47,47,119,119,119,46,106,111,101,121,114,105,118,101,114,97,46,99,111,109,47,50,48,48,57,47,117,115,105,110,103,45,109,121,115,113,108,45,115,116,111,114,101,100,45,112,114,111,99,101,100,117,114,101,115,45,119,105,116,104,45,112,104,112,45,109,121,115,113,108,109,121,115,113,108,105,112,100,111,47]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{},&quot;uniqueId&quot;:14},&quot;codePoints&quot;:[10,10,104,116,116,112,58,47,47,119,119,119,46,109,121,115,113,108,116,117,116,111,114,105,97,108,46,111,114,103,47,112,104,112,45,99,97,108,108,105,110,103,45,109,121,115,113,108,45,115,116,111,114,101,100,45,112,114,111,99,101,100,117,114,101,115,47,10,10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;writingDirection&quot;:1},&quot;uniqueId&quot;:9},&quot;codePoints&quot;:[67,111,110,110,101,99,116,105,111,110,32,115,116,114,105,110,103,32,115,97,118,101,32,116,111,32,110,111,110,32,119,101,98,32,102,111,108,100,101,114,32,34,46,46,46,46,46,46,46,46,10,10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;style&quot;:3,&quot;writingDirection&quot;:1},&quot;fontHints&quot;:1,&quot;link&quot;:&quot;https:\/\/gist.github.com\/skhani\/5aebd11015881fb3d288&quot;,&quot;uniqueId&quot;:50},&quot;codePoints&quot;:[99,108,97,115,115,46,112,100,111,46,100,98,46,112,104,112]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;style&quot;:3,&quot;writingDirection&quot;:1},&quot;fontHints&quot;:1,&quot;uniqueId&quot;:51},&quot;codePoints&quot;:[10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;style&quot;:3,&quot;writingDirection&quot;:1},&quot;fontHints&quot;:1,&quot;link&quot;:&quot;https:\/\/gist.github.com\/skhani\/5aebd11015881fb3d288&quot;,&quot;uniqueId&quot;:50},&quot;codePoints&quot;:[10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;writingDirection&quot;:1},&quot;uniqueId&quot;:9},&quot;codePoints&quot;:[104,116,116,112,58,47,47,99,117,108,116,116,116,46,99,111,109,47,50,48,49,50,47,49,48,47,48,49,47,114,111,108,108,45,121,111,117,114,45,111,119,110,45,112,100,111,45,112,104,112,45,99,108,97,115,115,47,10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;style&quot;:3,&quot;writingDirection&quot;:1},&quot;uniqueId&quot;:52},&quot;codePoints&quot;:[10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;writingDirection&quot;:1},&quot;uniqueId&quot;:9},&quot;codePoints&quot;:[104,116,116,112,115,58,47,47,103,105,115,116,46,103,105,116,104,117,98,46,99,111,109,47,115,107,104,97,110,105,47,53,97,101,98,100,49,49,48,49,53,56,56,49,102,98,51,100,50,56,56,10,10,10,10,104,116,116,112,58,47,47,99,117,108,116,116,116,46,99,111,109,47,50,48,49,50,47,48,57,47,50,52,47,112,114,101,118,101,110,116,45,112,104,112,45,115,113,108,45,105,110,106,101,99,116,105,111,110,45,119,105,116,104,45,112,100,111,45,112,114,101,112,97,114,101,100,45,115,116,97,116,101,109,101,110,116,115,47,10,10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;style&quot;:3,&quot;writingDirection&quot;:1},&quot;uniqueId&quot;:52},&quot;codePoints&quot;:[80,68,79,32,10,10]},{&quot;attributes&quot;:{&quot;tombstoned&quot;:false,&quot;paragraphStyle&quot;:{&quot;writingDirection&quot;:1},&quot;uniqueId&quot;:9},&quot;codePoints&quot;:[104,116,116,112,58,47,47,99,111,100,101,114,101,118,105,101,119,46,115,116,97,99,107,101,120,99,104,97,110,103,101,46,99,111,109,47,113,117,101,115,116,105,111,110,115,47,51,56,48,54,47,112,100,111,45,119,114,97,112,112,101,114,45,99,108,97,115,115]}]\">\u200b<\/a>Using MySQL Stored Procedures with PHP mysql\/mysqli\/pdo<\/p>\n<div><\/div>\n<div>http:\/\/www.joeyrivera.com\/2009\/using-mysql-stored-procedures-with-php-mysqlmysqlipdo\/<\/div>\n<div><\/div>\n<div>http:\/\/www.mysqltutorial.org\/php-calling-mysql-stored-procedures\/<\/div>\n<div><\/div>\n<div>Connection string save to non web folder &#8220;&#8230;&#8230;..<\/div>\n<div><\/div>\n<div>class.pdo.db.php<\/div>\n<div><\/div>\n<div>http:\/\/culttt.com\/2012\/10\/01\/roll-your-own-pdo-php-class\/<\/div>\n<div><\/div>\n<div>https:\/\/gist.github.com\/skhani\/5aebd11015881fb3d288<\/div>\n<div><\/div>\n<div><\/div>\n<div><\/div>\n<div>http:\/\/culttt.com\/2012\/09\/24\/prevent-php-sql-injection-with-pdo-prepared-statements\/<\/div>\n<div><\/div>\n<div>PDO<\/div>\n<div><\/div>\n<div>http:\/\/codereview.stackexchange.com\/questions\/3806\/pdo-wrapper-class<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u200bUsing MySQL Stored Procedures with PHP mysql\/mysqli\/pdo http:\/\/www.joeyrivera.com\/2009\/using-mysql-stored-procedures-with-php-mysqlmysqlipdo\/ http:\/\/www.mysqltutorial.org\/php-calling-mysql-stored-procedures\/ Connection string save to non web folder &#8220;&#8230;&#8230;.. class.pdo.db.php http:\/\/culttt.com\/2012\/10\/01\/roll-your-own-pdo-php-class\/ https:\/\/gist.github.com\/skhani\/5aebd11015881fb3d288 http:\/\/culttt.com\/2012\/09\/24\/prevent-php-sql-injection-with-pdo-prepared-statements\/ PDO http:\/\/codereview.stackexchange.com\/questions\/3806\/pdo-wrapper-class<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-299","post","type-post","status-publish","format-standard","hentry","category-mariadb-mysql"],"_links":{"self":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/299","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/comments?post=299"}],"version-history":[{"count":1,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/299\/revisions"}],"predecessor-version":[{"id":300,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/posts\/299\/revisions\/300"}],"wp:attachment":[{"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/media?parent=299"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/categories?post=299"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.onepage.co.kr\/wordpress\/index.php\/wp-json\/wp\/v2\/tags?post=299"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}