{"id":6615245,"date":"2015-10-05T13:30:45","date_gmt":"2015-10-05T13:30:45","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/solved-issue-with-mysql_real_escape_string\/"},"modified":"2016-08-30T18:45:12","modified_gmt":"2016-08-30T18:45:12","slug":"solved-issue-with-mysql_real_escape_string","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/solved-issue-with-mysql_real_escape_string\/","title":{"rendered":"[solved] Issue with mysql_real_escape_string"},"content":{"rendered":"<p>Hello,<\/p>\n<p>There is an issue with mysql_real_escape_string (WP 4.3.1, PHP 5.5):<br \/>\nhttp:\/\/stackoverflow.com\/questions\/4574665\/mysql-real-escape-string-a-link-to-the-server-could-not-be-established<\/p>\n<p>The solution is to replace the line:<br \/>\n$qstr = mysql_real_escape_string($_GET[&#8220;s&#8221;]);<\/p>\n<p>with line:<br \/>\n$qstr = esc_sql($_GET[&#8220;s&#8221;]);<\/p>\n<p>https:\/\/wordpress.org\/plugins\/full-name-search-in-wp-admin\/<\/p>\n","protected":false},"template":"","class_list":["post-6615245","topic","type-topic","status-publish","hentry","topic-tag-mysql-connection"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6615245","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/6615245\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=6615245"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}