{"id":819,"date":"2016-10-01T17:27:02","date_gmt":"2016-10-01T16:27:02","guid":{"rendered":"http:\/\/duskosavic.com\/blog\/?p=819"},"modified":"2016-12-11T08:10:19","modified_gmt":"2016-12-11T07:10:19","slug":"change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0","status":"publish","type":"post","link":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/","title":{"rendered":"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0"},"content":{"rendered":"<div class=\"seriesmeta\">This entry is part 1 of 2 in the series <a href=\"https:\/\/duskosavic.com\/blog\/series\/php-programming\/\" class=\"series-497\" title=\"PHP Programming\">PHP Programming<\/a><\/div><p>I often use function <strong>safeEscapeString<\/strong> from\u00a0 in my PHP projects. It helps sustain the integrity of data coming to and from MySQL or similar database. However, if the code ran on PHP 5.4 or 5.6 at the highest, and I wanted it to run PHP 7.0, the latest and greatest version of PHP. When the error reporting is turned on, a fatal error in code will appear. The solution is to use the recommended function <strong>mysqli_real_escape_string<\/strong>, which takes two parameters, the link and the string to sanitize.<\/p>\n<p>$temp2 = mysqli_real_escape_string($link, $temp2);<\/p>\n<p>Since I had not had a special link to a database, I just added one to get the $link variable (as shown <a href=\"http:\/\/php.net\/manual\/en\/function.mysqli-connect.php\">here<\/a>):<\/p>\n<pre>$link = mysqli_connect(\"localhost\", \"my_user\", \"my_password\", \"my_db\");\r\n<\/pre>\n<p>The complete function looks like this:<\/p>\n<pre>Function safeEscapeString($string)\r\n{\r\n$temp1 = str_replace(\"[br]\", \"\", $temp2);\r\n$temp2 = str_replace(\"[br \/]\", \"\", $temp1);\r\n\r\nif (get_magic_quotes_gpc())\r\n{\r\nreturn $temp2;\r\n}\r\nelse\r\n{\r\n$link = mysqli_connect(\"localhost\", \"my_user\", \"my_password\", \"my_db\"); \r\nif (!$link) { \r\nif($local_print){ \r\necho \"Error: Unable to connect to MySQL.\" . PHP_EOL; \r\necho \"Debugging errno: \" . mysqli_connect_errno() . PHP_EOL; \r\necho \"Debugging error: \" . mysqli_connect_error() . PHP_EOL; \r\nexit; } \r\n} else { \r\nif($local_print){ \r\necho \"Success: A proper connection to MySQL was made! The my_db database is great.\" . PHP_EOL; \r\necho \"Host information: \" . mysqli_get_host_info($link) . PHP_EOL; \r\n} \r\n} \r\n$temp2 = mysqli_real_escape_string($link, $temp2); \r\nmysqli_close($link); return $temp2; \r\n} \r\n}\r\n \/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/\/<\/pre>\n","protected":false},"excerpt":{"rendered":"<div class=\"seriesmeta\">This entry is part 1 of 2 in the series <a href=\"https:\/\/duskosavic.com\/blog\/series\/php-programming\/\" class=\"series-497\" title=\"PHP Programming\">PHP Programming<\/a><\/div><p>I often use function safeEscapeString from\u00a0 in my PHP projects. It helps sustain the integrity of data coming to and from MySQL or similar database. However, if the code ran on PHP 5.4 or 5.6 at the highest, and I &hellip; <a href=\"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[496,1],"tags":[502,251,500,499,501],"series":[497],"class_list":["post-819","post","type-post","status-publish","format-standard","hentry","category-php","category-programming","tag-mysqli_real_escape_string","tag-php","tag-php-5-6","tag-php-7-0","tag-safeescapestring","series-php-programming"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0 - DuskoSavic.com<\/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:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0 - DuskoSavic.com\" \/>\n<meta property=\"og:description\" content=\"I often use function safeEscapeString from\u00a0 in my PHP projects. It helps sustain the integrity of data coming to and from MySQL or similar database. However, if the code ran on PHP 5.4 or 5.6 at the highest, and I &hellip; Continue reading &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/\" \/>\n<meta property=\"og:site_name\" content=\"DuskoSavic.com\" \/>\n<meta property=\"article:published_time\" content=\"2016-10-01T16:27:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2016-12-11T07:10:19+00:00\" \/>\n<meta name=\"author\" content=\"Dusko\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dusko\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/\"},\"author\":{\"name\":\"Dusko\",\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/#\\\/schema\\\/person\\\/5c90e82c5c70eaeee96d0b2efbfd4396\"},\"headline\":\"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0\",\"datePublished\":\"2016-10-01T16:27:02+00:00\",\"dateModified\":\"2016-12-11T07:10:19+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/\"},\"wordCount\":137,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/#\\\/schema\\\/person\\\/5c90e82c5c70eaeee96d0b2efbfd4396\"},\"keywords\":[\"mysqli_real_escape_string\",\"php\",\"php 5.6\",\"php 7.0\",\"safeEscapeString\"],\"articleSection\":[\"PHP\",\"Programming\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/\",\"url\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/\",\"name\":\"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0 - DuskoSavic.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/#website\"},\"datePublished\":\"2016-10-01T16:27:02+00:00\",\"dateModified\":\"2016-12-11T07:10:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/programming\\\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/\",\"name\":\"DuskoSavic.com\",\"description\":\"Rapid Mobile Apps Development With Flutter\",\"publisher\":{\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/#\\\/schema\\\/person\\\/5c90e82c5c70eaeee96d0b2efbfd4396\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/duskosavic.com\\\/blog\\\/#\\\/schema\\\/person\\\/5c90e82c5c70eaeee96d0b2efbfd4396\",\"name\":\"Dusko\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g\",\"caption\":\"Dusko\"},\"logo\":{\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0 - DuskoSavic.com","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:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/","og_locale":"en_US","og_type":"article","og_title":"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0 - DuskoSavic.com","og_description":"I often use function safeEscapeString from\u00a0 in my PHP projects. It helps sustain the integrity of data coming to and from MySQL or similar database. However, if the code ran on PHP 5.4 or 5.6 at the highest, and I &hellip; Continue reading &rarr;","og_url":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/","og_site_name":"DuskoSavic.com","article_published_time":"2016-10-01T16:27:02+00:00","article_modified_time":"2016-12-11T07:10:19+00:00","author":"Dusko","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Dusko","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/#article","isPartOf":{"@id":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/"},"author":{"name":"Dusko","@id":"https:\/\/duskosavic.com\/blog\/#\/schema\/person\/5c90e82c5c70eaeee96d0b2efbfd4396"},"headline":"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0","datePublished":"2016-10-01T16:27:02+00:00","dateModified":"2016-12-11T07:10:19+00:00","mainEntityOfPage":{"@id":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/"},"wordCount":137,"commentCount":0,"publisher":{"@id":"https:\/\/duskosavic.com\/blog\/#\/schema\/person\/5c90e82c5c70eaeee96d0b2efbfd4396"},"keywords":["mysqli_real_escape_string","php","php 5.6","php 7.0","safeEscapeString"],"articleSection":["PHP","Programming"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/","url":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/","name":"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0 - DuskoSavic.com","isPartOf":{"@id":"https:\/\/duskosavic.com\/blog\/#website"},"datePublished":"2016-10-01T16:27:02+00:00","dateModified":"2016-12-11T07:10:19+00:00","breadcrumb":{"@id":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/duskosavic.com\/blog\/programming\/change-real_escape_string-to-mysqli_real_escape_string-for-function-safeescapestring-in-php-7-0\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/duskosavic.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Change real_escape_string to mysqli_real_escape_string for Function safeEscapeString in PHP 7.0"}]},{"@type":"WebSite","@id":"https:\/\/duskosavic.com\/blog\/#website","url":"https:\/\/duskosavic.com\/blog\/","name":"DuskoSavic.com","description":"Rapid Mobile Apps Development With Flutter","publisher":{"@id":"https:\/\/duskosavic.com\/blog\/#\/schema\/person\/5c90e82c5c70eaeee96d0b2efbfd4396"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/duskosavic.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/duskosavic.com\/blog\/#\/schema\/person\/5c90e82c5c70eaeee96d0b2efbfd4396","name":"Dusko","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g","caption":"Dusko"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/d249b8ea0c85e62fd0339dd1412b99f721f072408db9a9a546efe3a86a93b667?s=96&d=mm&r=g"}}]}},"_links":{"self":[{"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/posts\/819","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/comments?post=819"}],"version-history":[{"count":4,"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/posts\/819\/revisions"}],"predecessor-version":[{"id":857,"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/posts\/819\/revisions\/857"}],"wp:attachment":[{"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/media?parent=819"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/categories?post=819"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/tags?post=819"},{"taxonomy":"series","embeddable":true,"href":"https:\/\/duskosavic.com\/blog\/wp-json\/wp\/v2\/series?post=819"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}