{"id":50890,"date":"2024-04-09T17:19:55","date_gmt":"2024-04-09T09:19:55","guid":{"rendered":"http:\/\/jiloc.com\/?p=50890"},"modified":"2024-04-09T17:43:02","modified_gmt":"2024-04-09T09:43:02","slug":"php7%e5%85%bc%e5%ae%b9mysql_connect%e5%87%bd%e6%95%b0%e7%9a%84%e6%96%b9%e6%b3%95-%e5%9b%be%e6%96%87%e6%95%99%e7%a8%8b","status":"publish","type":"post","link":"http:\/\/jiloc.com\/50890.html","title":{"rendered":"PHP7\u517c\u5bb9mysql_connect\u51fd\u6570\u7684\u65b9\u6cd5 \u56fe\u6587\u6559\u7a0b"},"content":{"rendered":"\n<p><a href=\"http:\/\/jiloc.com\/tag\/php\" title=\"\">php<\/a>\u4ece7.0\u5f00\u59cb\u79fb\u9664\u4e86mysql_connect\u8fd9\u4e2a\u51fd\u6570<\/p>\n\n\n\n<p><strong>Warning<\/strong><\/p>\n\n\n\n<p>This extension was deprecated in PHP 5.5.0, and it was removed in PHP 7.0.0. Instead, the\u00a0MySQLi\u00a0or\u00a0PDO_MySQL\u00a0extension should be used. See also\u00a0MySQL: choosing an API\u00a0guide. Alternatives to this function include:<\/p>\n\n\n\n<ul>\n<li>mysqli_connect()<\/li>\n\n\n\n<li>PDO::__construct()<\/li>\n<\/ul>\n\n\n\n<p>\u90a3\u4e48\u6211\u4eec\u4ee5\u524d\u7684\u8001\u7a0b\u5e8f\u5982\u4f55\u517c\u5bb9\uff0c\u8fd9\u91cc\u6211\u4eec\u63d0\u4f9b\u4e00\u4e2a\u601d\u8def\u3002<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>\/\/$dbhost = DATA_HOST;\n$dbport = 3306;\n\/\/$dbuser = DATA_USERNAME;\n\/\/$dbpass = DATA_PASSWORD;\n\/\/$dbname = DATA_NAME;\nif(!function_exists('mysql_connect')){\n    function mysql_connect($dbhost, $dbuser, $dbpass){\n        global $dbport;\n        global $dbname;\n        global $mysqli;\n        $mysqli = mysqli_connect(\"$dbhost:$dbport\", $dbuser, $dbpass, $dbname);\n        return $mysqli;\n        }\n    function mysql_select_db($dbname){\n        global $mysqli;\n        return mysqli_select_db($mysqli,$dbname);\n        }\n    function mysql_set_charset($character)\n    {\n        global $mysqli;\n        return mysqli_query($mysqli, \"set names {$character}\");\n    }\n    function mysql_fetch_array($result){\n        return mysqli_fetch_array($result);\n        }\n    function mysql_fetch_assoc($result){\n        return mysqli_fetch_assoc($result);\n        }\n    function mysql_fetch_row($result){\n        return mysqli_fetch_row($result);\n        }\n    function mysql_query($query){\n        global $mysqli;\n        return mysqli_query($mysqli,$query);\n        }\n    function mysql_escape_string($data){\n        global $mysqli;\n        return mysqli_real_escape_string($mysqli, $data);\n        }\n    function mysql_real_escape_string($data){\n        return mysql_real_escape_string($data);\n        }\n    function mysql_close(){\n        global $mysqli;\n        return mysqli_close($mysqli);\n        }\n    function mysql_error(){\n\t\tglobal $mysqli;\n\t\treturn mysqli_connect_error();\n\t}\n    function mysql_num_rows($data){\n\t\tglobal $mysqli;\n\t\treturn mysqli_num_rows($data);\n\t}\n    function mysql_affected_rows(){\n\t\tglobal $mysqli;\n\t\treturn mysqli_affected_rows($mysqli);\n\t}\n}<\/code><\/pre>\n\n\n\n<p>\u4ec5\u4f9b\u53c2\u8003\uff0c\u5c0f\u4f19\u4f34\u4eec\u6839\u636e\u81ea\u5df1\u5b9e\u9645\u60c5\u51b5\u4fee\u6539\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>php\u4ece7.0\u5f00\u59cb\u79fb\u9664\u4e86mysql_connect\u8fd9\u4e2a\u51fd\u6570 Warning This extension wa [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":43088,"comment_status":"open","ping_status":"open","sticky":false,"template":"single-with-sidebar","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13,276],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/posts\/50890"}],"collection":[{"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/comments?post=50890"}],"version-history":[{"count":2,"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/posts\/50890\/revisions"}],"predecessor-version":[{"id":50892,"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/posts\/50890\/revisions\/50892"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/media\/43088"}],"wp:attachment":[{"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/media?parent=50890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/categories?post=50890"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/jiloc.com\/wp-json\/wp\/v2\/tags?post=50890"}],"curies":[{"name":"wp","href":"http:\/\/api.w.org\/{rel}","templated":true}]}}