{"id":6792,"date":"2018-11-02T07:50:08","date_gmt":"2018-11-02T11:50:08","guid":{"rendered":"http:\/\/local.brightwhiz\/?p=6792"},"modified":"2021-12-08T11:18:52","modified_gmt":"2021-12-08T16:18:52","slug":"stop-using-mysql-extension-functions-php","status":"publish","type":"post","link":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/","title":{"rendered":"It&#8217;s Time to Stop Using the mysql Extension Functions in PHP"},"content":{"rendered":"\n<p>No, really! You need to stop using the <a href=\"http:\/\/local.brightwhiz\/tag\/mysql\/\">MySQL<\/a> extension functions in <a href=\"http:\/\/local.brightwhiz\/tag\/php\/\">PHP<\/a>. That goes out to the <a href=\"http:\/\/local.brightwhiz\/tag\/web\/\">web<\/a> developers who are still using or maintaining code bases that make use of this extension.<\/p>\n\n\n\n<p>There are several compelling reasons not to use this extension and this guide should be what settles this once and for all.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Reasons to Stop Using the PHP MySQL Extensions<\/h2>\n\n\n\n<ul><li>For starters, the MySQL extension is no longer under active development and it hasn&#8217;t been for over 5 years now. So how long?<\/li><li>The extension was officially deprecated as of PHP 5.5. This version of PHP was released in June 2013.<\/li><li>Things got worse. As of PHP 7.0 it has been entirely removed.<\/li><li>There is no support for prepared statements making it less secure and vulnerable to attacks.<\/li><li>Still, on security, it does not support the new password authentication method which was turned on by default in MySQL 5.6 and required in MySQL 5.7. It is also important to note that MySQL 8.0 introduces yet another new password authentication method not discussed here.<\/li><li>It also does not support all of the functionality that came in in MySQL 5.1.<\/li><li>It lacks an Object-Oriented interface.<\/li><li>The extension does not support non-blocking, asynchronous queries.<\/li><li>It does not support transactions, nor stored procedures.<\/li><li>It keeps getting worse. The MySQL extension functions do not support multiple statements.<\/li><\/ul>\n\n\n\n<p>I&#8217;m sure those should be compelling reasons to get you off using the MySQL extension functions in your current and new projects.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>No, really! You need to stop using the MySQL extension functions in PHP. That goes out to the web developers who are still using or maintaining code bases that make&#8230;<\/p>\n","protected":false},"author":1,"featured_media":6794,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2,27,16],"tags":[313,320,393,452,471,472,526,543,544,549],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>No, Really, Stop Using the MySQL Extension Functions in PHP<\/title>\n<meta name=\"description\" content=\"If you are still using the MySQL extension functions in PHP you need to read this compelling notice to which should convince you to reconsider\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"No, Really, Stop Using the MySQL Extension Functions in PHP\" \/>\n<meta property=\"og:description\" content=\"If you are still using the MySQL extension functions in PHP you need to read this compelling notice to which should convince you to reconsider\" \/>\n<meta property=\"og:url\" content=\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/\" \/>\n<meta property=\"og:site_name\" content=\"Brightwhiz.com\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/brightwhiz\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-02T11:50:08+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-08T16:18:52+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Michael Bright\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:site\" content=\"@brightwhizmag\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Michael Bright\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#article\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/\"},\"author\":{\"name\":\"Michael Bright\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\"},\"headline\":\"It&#8217;s Time to Stop Using the mysql Extension Functions in PHP\",\"datePublished\":\"2018-11-02T11:50:08+00:00\",\"dateModified\":\"2021-12-08T16:18:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/\"},\"wordCount\":254,\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg\",\"keywords\":[\"InfoSec\",\"Internet\",\"MySQL\",\"PHP\",\"Programming\",\"Programming Languages\",\"Security\",\"Software Design\",\"Software development\",\"SQL\"],\"articleSection\":[\"Articles\",\"Programming\",\"Technology\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/\",\"url\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/\",\"name\":\"No, Really, Stop Using the MySQL Extension Functions in PHP\",\"isPartOf\":{\"@id\":\"http:\/\/local.brightwhiz\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg\",\"datePublished\":\"2018-11-02T11:50:08+00:00\",\"dateModified\":\"2021-12-08T16:18:52+00:00\",\"description\":\"If you are still using the MySQL extension functions in PHP you need to read this compelling notice to which should convince you to reconsider\",\"breadcrumb\":{\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg\",\"width\":1200,\"height\":630,\"caption\":\"mysql Extension Functions in PHP\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/local.brightwhiz\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"It&#8217;s Time to Stop Using the mysql Extension Functions in PHP\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/local.brightwhiz\/#website\",\"url\":\"http:\/\/local.brightwhiz\/\",\"name\":\"Brightwhiz.com\",\"description\":\"Best Tech guides, Tutorials, and News\",\"publisher\":{\"@id\":\"http:\/\/local.brightwhiz\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/local.brightwhiz\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\/\/local.brightwhiz\/#organization\",\"name\":\"Brightwhiz\",\"url\":\"http:\/\/local.brightwhiz\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\",\"url\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"contentUrl\":\"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png\",\"width\":706,\"height\":135,\"caption\":\"Brightwhiz\"},\"image\":{\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/brightwhiz\/\",\"https:\/\/twitter.com\/brightwhizmag\",\"https:\/\/instagram.com\/bright_whiz\/\",\"https:\/\/www.pinterest.com\/sobbayi\/\",\"https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ\"]},{\"@type\":\"Person\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32\",\"name\":\"Michael Bright\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"contentUrl\":\"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g\",\"caption\":\"Michael Bright\"},\"sameAs\":[\"https:\/\/sobbayi.com\"],\"url\":\"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"No, Really, Stop Using the MySQL Extension Functions in PHP","description":"If you are still using the MySQL extension functions in PHP you need to read this compelling notice to which should convince you to reconsider","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/","og_locale":"en_US","og_type":"article","og_title":"No, Really, Stop Using the MySQL Extension Functions in PHP","og_description":"If you are still using the MySQL extension functions in PHP you need to read this compelling notice to which should convince you to reconsider","og_url":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/","og_site_name":"Brightwhiz.com","article_publisher":"https:\/\/www.facebook.com\/brightwhiz\/","article_published_time":"2018-11-02T11:50:08+00:00","article_modified_time":"2021-12-08T16:18:52+00:00","og_image":[{"width":1200,"height":630,"url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg","type":"image\/jpeg"}],"author":"Michael Bright","twitter_card":"summary_large_image","twitter_creator":"@brightwhizmag","twitter_site":"@brightwhizmag","twitter_misc":{"Written by":"Michael Bright","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#article","isPartOf":{"@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/"},"author":{"name":"Michael Bright","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32"},"headline":"It&#8217;s Time to Stop Using the mysql Extension Functions in PHP","datePublished":"2018-11-02T11:50:08+00:00","dateModified":"2021-12-08T16:18:52+00:00","mainEntityOfPage":{"@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/"},"wordCount":254,"publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"image":{"@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg","keywords":["InfoSec","Internet","MySQL","PHP","Programming","Programming Languages","Security","Software Design","Software development","SQL"],"articleSection":["Articles","Programming","Technology"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/","url":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/","name":"No, Really, Stop Using the MySQL Extension Functions in PHP","isPartOf":{"@id":"http:\/\/local.brightwhiz\/#website"},"primaryImageOfPage":{"@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage"},"image":{"@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage"},"thumbnailUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg","datePublished":"2018-11-02T11:50:08+00:00","dateModified":"2021-12-08T16:18:52+00:00","description":"If you are still using the MySQL extension functions in PHP you need to read this compelling notice to which should convince you to reconsider","breadcrumb":{"@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#primaryimage","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2018\/11\/php-mysql.jpg","width":1200,"height":630,"caption":"mysql Extension Functions in PHP"},{"@type":"BreadcrumbList","@id":"http:\/\/local.brightwhiz\/stop-using-mysql-extension-functions-php\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/local.brightwhiz\/"},{"@type":"ListItem","position":2,"name":"It&#8217;s Time to Stop Using the mysql Extension Functions in PHP"}]},{"@type":"WebSite","@id":"http:\/\/local.brightwhiz\/#website","url":"http:\/\/local.brightwhiz\/","name":"Brightwhiz.com","description":"Best Tech guides, Tutorials, and News","publisher":{"@id":"http:\/\/local.brightwhiz\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/local.brightwhiz\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/local.brightwhiz\/#organization","name":"Brightwhiz","url":"http:\/\/local.brightwhiz\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/","url":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","contentUrl":"http:\/\/local.brightwhiz\/wp-content\/uploads\/2021\/11\/brightwhiz-com-logo-orange.png","width":706,"height":135,"caption":"Brightwhiz"},"image":{"@id":"http:\/\/local.brightwhiz\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/brightwhiz\/","https:\/\/twitter.com\/brightwhizmag","https:\/\/instagram.com\/bright_whiz\/","https:\/\/www.pinterest.com\/sobbayi\/","https:\/\/www.youtube.com\/channel\/UC6sCdP_d_RiTIM7ErFT-PSQ"]},{"@type":"Person","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/81f0f3126f13834ae2e7f381b3028e32","name":"Michael Bright","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/local.brightwhiz\/#\/schema\/person\/image\/","url":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","contentUrl":"http:\/\/1.gravatar.com\/avatar\/da90485875ff0aafa38fdd494abe87d1?s=96&d=mm&r=g","caption":"Michael Bright"},"sameAs":["https:\/\/sobbayi.com"],"url":"http:\/\/local.brightwhiz\/author\/sobbayiadmin\/"}]}},"_links":{"self":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/6792"}],"collection":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/comments?post=6792"}],"version-history":[{"count":0,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/posts\/6792\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media\/6794"}],"wp:attachment":[{"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/media?parent=6792"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/categories?post=6792"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/local.brightwhiz\/wp-json\/wp\/v2\/tags?post=6792"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}