{"id":891,"date":"2022-08-20T19:54:47","date_gmt":"2022-08-20T14:24:47","guid":{"rendered":"https:\/\/jassweb.com\/new22\/solved-why-shouldnt-i-use-mysql_-functions-in-php\/"},"modified":"2022-08-20T19:54:47","modified_gmt":"2022-08-20T14:24:47","slug":"solved-why-shouldnt-i-use-mysql_-functions-in-php-2","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/","title":{"rendered":"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP?"},"content":{"rendered":"<h2> Introduction <\/h2>\n<p>[ad_1]<\/p>\n<h2> Solution<\/h2>\n<p><\/p>\n<p>The mysql_* functions in PHP are deprecated and no longer supported. They are also vulnerable to SQL injection attacks, which can be used to gain access to sensitive data. Additionally, the mysql_* functions are not compatible with the newer versions of PHP, so using them can lead to compatibility issues. For these reasons, it is best to avoid using the mysql_* functions in PHP. <\/p>\n<p><\/p>\n<div class=\"entry-content\" itemprop=\"text\">\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/p>\n<p><\/p>\n<div id=\"answer-12860046\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"12860046\" data-parentid=\"12859942\" data-score=\"2205\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>The MySQL extension:<\/p>\n<ul>\n<li>Is not under active development<\/li>\n<li>Is <strong>officially <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/wiki.php.net\/rfc\/mysql_deprecation\">deprecated<\/a><\/strong> as of PHP 5.5 (released June 2013).<\/li>\n<li>Has been <strong><a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/wiki.php.net\/rfc\/remove_deprecated_functionality_in_php7#extmysql\">removed<\/a> entirely<\/strong> as of PHP 7.0 (released December 2015)\n<ul>\n<li>This means that as of <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.php.net\/eol.php\">31 Dec 2018<\/a> it does not exist in any supported version of PHP. If you are using a version of PHP which supports it, you are using a version which doesn\u2019t get security problems fixed.<\/li>\n<\/ul>\n<\/li>\n<li>Lacks an OO interface<\/li>\n<li>Doesn\u2019t support:\n<ul>\n<li>Non-blocking, asynchronous queries<\/li>\n<li><strong><a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/php.net\/manual\/en\/mysqli.quickstart.prepared-statements.php\">Prepared statements<\/a> or parameterized queries<\/strong><\/li>\n<li>Stored procedures<\/li>\n<li>Multiple Statements<\/li>\n<li>Transactions<\/li>\n<li>The \u201cnew\u201d password authentication method (on by default in MySQL 5.6; required in 5.7)<\/li>\n<li>Any of the new functionality in MySQL 5.1 or later<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Since it is deprecated, using it makes your code less future proof. <\/p>\n<p>Lack of support for prepared statements is particularly important as they provide a clearer, less error-prone method of escaping and quoting external data than manually escaping it with a separate function call.<\/p>\n<p>See <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/php.net\/manual\/en\/mysqlinfo.api.choosing.php\"><strong>the comparison of SQL extensions<\/strong><\/a>.<\/p>\n<\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p> <span class=\"d-none\" itemprop=\"commentCount\">5<\/span> <\/p>\n<\/div>\n<\/div>\n<p>solved Why shouldn\u2019t I use mysql_* functions in PHP? <\/p>\n<p><script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1088640234840270\" crossorigin=\"anonymous\"><\/script><br \/>\n<script><\/p>\n<p><\/script><\/div>\n<p>[ad_2]<\/p>\n<p>The <strong>mysql_*<\/strong> functions in PHP are deprecated and should no longer be used. These functions were used to access and manipulate data stored in MySQL databases. However, they are no longer supported and have been replaced by the <strong>MySQLi<\/strong> and <strong>PDO<\/strong> extensions.<\/p>\n<p>The main reason why you should not use the <strong>mysql_*<\/strong> functions is that they are not secure. They are vulnerable to SQL injection attacks, which can be used to gain access to sensitive data. Additionally, they do not support prepared statements, which are necessary for preventing SQL injection attacks.<\/p>\n<p>The <strong>MySQLi<\/strong> and <strong>PDO<\/strong> extensions are more secure and provide better performance. They also support prepared statements, which can help protect against SQL injection attacks. Additionally, they provide an object-oriented interface, which makes it easier to work with databases.<\/p>\n<p>In conclusion, the <strong>mysql_*<\/strong> functions should not be used in PHP. They are not secure and do not provide the same level of performance as the <strong>MySQLi<\/strong> and <strong>PDO<\/strong> extensions. It is recommended that you use the <strong>MySQLi<\/strong> or <strong>PDO<\/strong> extensions instead.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Introduction [ad_1] Solution The mysql_* functions in PHP are deprecated and no longer supported. They are also vulnerable to SQL injection attacks, which can be used to gain access to sensitive data. Additionally, the mysql_* functions are not compatible with the newer versions of PHP, so using them can lead to compatibility issues. For these &#8230; <a title=\"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP?\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\" aria-label=\"More on (Solved) Why shouldn\u2019t I use mysql_* functions in PHP?\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,339],"class_list":["post-891","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-php"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>(Solved) Why shouldn\u2019t I use mysql_* functions in PHP? - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP? - JassWeb\" \/>\n<meta property=\"og:description\" content=\"Introduction [ad_1] Solution The mysql_* functions in PHP are deprecated and no longer supported. They are also vulnerable to SQL injection attacks, which can be used to gain access to sensitive data. Additionally, the mysql_* functions are not compatible with the newer versions of PHP, so using them can lead to compatibility issues. For these ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-20T14:24:47+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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\":\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP?\",\"datePublished\":\"2022-08-20T14:24:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\"},\"wordCount\":415,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\",\"name\":\"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP? - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-08-20T14:24:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP? - JassWeb","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":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/","og_locale":"en_US","og_type":"article","og_title":"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP? - JassWeb","og_description":"Introduction [ad_1] Solution The mysql_* functions in PHP are deprecated and no longer supported. They are also vulnerable to SQL injection attacks, which can be used to gain access to sensitive data. Additionally, the mysql_* functions are not compatible with the newer versions of PHP, so using them can lead to compatibility issues. For these ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/","og_site_name":"JassWeb","article_published_time":"2022-08-20T14:24:47+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP?","datePublished":"2022-08-20T14:24:47+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/"},"wordCount":415,"commentCount":0,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/","url":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/","name":"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP? - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-08-20T14:24:47+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-why-shouldnt-i-use-mysql_-functions-in-php-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"(Solved) Why shouldn\u2019t I use mysql_* functions in PHP?"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/891","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=891"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/891\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=891"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=891"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=891"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}