{"id":113,"date":"2022-09-28T18:38:29","date_gmt":"2022-09-28T10:38:29","guid":{"rendered":"http:\/\/blog.nhl520.cn\/?p=113"},"modified":"2022-09-29T16:15:14","modified_gmt":"2022-09-29T08:15:14","slug":"php%e6%9f%a5%e8%af%a2%e6%95%b0%e6%8d%ae%e5%ba%93%e4%bf%a1%e6%81%af","status":"publish","type":"post","link":"https:\/\/blog.nhl520.cn\/index.php\/2022\/09\/28\/php%e6%9f%a5%e8%af%a2%e6%95%b0%e6%8d%ae%e5%ba%93%e4%bf%a1%e6%81%af\/","title":{"rendered":"php\u67e5\u8be2\u6570\u636e\u5e93\u4fe1\u606f"},"content":{"rendered":"\n<p>\u4f5c\u8005\uff1a\u4e8c\u54c8<\/p>\n\n\n\n<p>\u4f5c\u8005qq\/wx\uff1a3132876589<\/p>\n\n\n\n<p>\u5b98\u65b9\u7f51\u7ad9\uff1a<a href=\"http:\/\/www.nhl520.cn\">www.nhl520.cn<\/a><\/p>\n\n\n\n<p>1\u3001\u5148\u521b\u5efa\u6570\u636e\u6587\u4ef6config.php<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?php\n$servername = \"\u6570\u636e\u5e93\u7684\u5730\u5740\";\n$username = \"\u6570\u636e\u5e93\u540d\";\n$password = \"\u6570\u636e\u5e93\u5bc6\u7801\";\n$dbname = \"\u6570\u636e\u5e93\u540d\";<\/pre>\n\n\n\n<p class=\"has-medium-font-size\">2\u3001\u518d\u968f\u4fbf\u521b\u5efa\u4e00\u4e2aPHP\u6587\u4ef6<\/p>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"php\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">&lt;?php\n\/\/\u8fd9\u91cc\u5916\u63a5\u521a\u521a\u521b\u5efa\u7684config.php\u6587\u4ef6\ninclude \"config.php\";\n \n\/\/ \u521b\u5efa\u8fde\u63a5\n$conn = new mysqli($servername, $username, $password, $dbname);\n\n\/\/\u5224\u65ad\u6570\u636e\u5e93\u662f\u5426\u8fde\u63a5\u6210\u529f\nif ($conn->connect_error) {\n    die(\"\u8fde\u63a5\u5931\u8d25: \" . $conn->connect_error);\n} \n \n$sql= \"select * from user\";\n$result = $conn->query($sql);\n \nif ($result->num_rows > 0) {\n    \/\/ \u8f93\u51fa\u6570\u636e\n    while($row = $result->fetch_assoc()) {\n        \/\/name\u3001sex\u3001text\u3001user\u3001pass\u662f\u6570\u636e\u5e93\u8868\u4e2d\u6570\u636e\n        echo \"\u7528\u6237\u59d3\u540d: \" . $row[\"name\"]. \" \u7528\u6237\u6027\u522b: \" . $row[\"sex\"]. \" \u7528\u6237\u7b7e\u540d\uff1a\" . $row[\"text\"]. \" \u7528\u6237\u8d26\u53f7\uff1a\" . $row[\"user\"].\" \u7528\u6237\u5bc6\u7801\uff1a\" . $row[\"pass\"].\"\\n\";\n    }\n} else {\n    echo \"\u672c\u7cfb\u7edf\u65e0\u7528\u6237\u4fe1\u606f\";\n}\n$conn->close();\n?><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>\u4f5c\u8005\uff1a\u4e8c\u54c8 \u4f5c\u8005qq\/wx\uff1a3132876589 \u5b98\u65b9\u7f51\u7ad9\uff1awww.nhl520.cn 1\u3001\u5148\u521b\u5efa\u6570\u636e\u6587\u4ef6config.php 2\u3001\u518d\u968f\u4fbf\u521b\u5efa\u4e00\u4e2aPHP\u6587\u4ef6<\/p>\n","protected":false},"author":1,"featured_media":174,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-113","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-php"],"_links":{"self":[{"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/posts\/113","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/comments?post=113"}],"version-history":[{"count":6,"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/posts\/113\/revisions"}],"predecessor-version":[{"id":125,"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/posts\/113\/revisions\/125"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/media\/174"}],"wp:attachment":[{"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/media?parent=113"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/categories?post=113"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.nhl520.cn\/index.php\/wp-json\/wp\/v2\/tags?post=113"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}