{"id":1685,"date":"2017-01-20T23:22:50","date_gmt":"2017-01-20T15:22:50","guid":{"rendered":"http:\/\/cn.hostease.com\/xueyuan\/?p=1685"},"modified":"2017-01-20T23:22:51","modified_gmt":"2017-01-20T15:22:51","slug":"mysql-php-%e8%af%ad%e6%b3%95","status":"publish","type":"post","link":"https:\/\/cn.hostease.com\/xueyuan\/jishu\/mysql-php-%e8%af%ad%e6%b3%95\/","title":{"rendered":"MySQL PHP \u8bed\u6cd5"},"content":{"rendered":"<p>MySQL \u53ef\u5e94\u7528\u4e8e\u591a\u79cd\u8bed\u8a00\uff0c\u5305\u62ec PERL, C, C++, JAVA \u548c PHP\u3002 \u5728\u8fd9\u4e9b\u8bed\u8a00\u4e2d\uff0cMysql\u5728PHP\u7684web\u5f00\u53d1\u4e2d\u662f\u5e94\u7528\u6700\u5e7f\u6cdb\u3002<\/p>\n<p>\u5728\u672c\u6559\u7a0b\u4e2d\u6211\u4eec\u5927\u90e8\u5206\u5b9e\u4f8b\u90fd\u91c7\u7528\u4e86PHP\u8bed\u8a00\u3002\u5982\u679c\u4f60\u60f3\u4e86\u89e3Mysql\u5728PHP\u4e2d\u7684\u5e94\u7528\uff0c\u53ef\u4ee5\u8bbf\u95ee\u6211\u4eec\u7684 <a href=\"https:\/\/www.w3cschool.cc\/php\/php-mysql-intro.html\" target=\"_blank\">PHP\u4e2d\u4f7f\u7528Mysql\u4ecb\u7ecd<\/a>\u3002<\/p>\n<p>PHP\u63d0\u4f9b\u4e86\u591a\u79cd\u65b9\u5f0f\u6765\u8bbf\u95ee\u548c\u64cd\u4f5cMysql\u6570\u636e\u5e93\u8bb0\u5f55\u3002PHP Mysql\u51fd\u6570\u683c\u5f0f\u5982\u4e0b\uff1a<\/p>\n<pre class=\"prettyprint prettyprinted\"><span class=\"pln\">mysql_function<\/span><span class=\"pun\">(<\/span><span class=\"pln\">value<\/span><span class=\"pun\">,<\/span><span class=\"pln\">value<\/span><span class=\"pun\">,...);<\/span><\/pre>\n<p>\u4ee5\u4e0a\u683c\u5f0f\u4e2d function\u90e8\u5206\u63cf\u8ff0\u4e86mysql\u51fd\u6570\u7684\u529f\u80fd\uff0c\u5982<\/p>\n<pre class=\"prettyprint prettyprinted\"><span class=\"pln\">mysqli_connect<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$connect<\/span><span class=\"pun\">);<\/span><span class=\"pln\">\r\nmysqli_query<\/span><span class=\"pun\">(<\/span><span class=\"pln\">$connect<\/span><span class=\"pun\">,<\/span><span class=\"str\">\"SQL \u8bed\u53e5\"<\/span><span class=\"pun\">);<\/span><span class=\"pln\">\r\nmysql_fetch_array<\/span><span class=\"pun\">()<\/span><span class=\"pln\">\r\nmysql_connect<\/span><span class=\"pun\">()<\/span><span class=\"pln\">\r\nmysql_close<\/span><span class=\"pun\">()<\/span><\/pre>\n<p>\u4ee5\u4e0b\u5b9e\u4f8b\u5c55\u793a\u4e86PHP\u8c03\u7528mysql\u51fd\u6570\u7684\u8bed\u6cd5\uff1a<\/p>\n<pre class=\"prettyprint prettyprinted\"><span class=\"tag\">&lt;html&gt;<\/span>\r\n<span class=\"tag\">&lt;head&gt;<\/span>\r\n<span class=\"tag\">&lt;meta<\/span> <span class=\"atn\">charset<\/span><span class=\"pun\">=<\/span><span class=\"atv\">\"utf-8\"<\/span><span class=\"tag\">&gt;<\/span> \r\n<span class=\"tag\">&lt;title&gt;<\/span><span class=\"pln\">PHP MySQL<\/span><span class=\"tag\">&lt;\/title&gt;<\/span>\r\n<span class=\"tag\">&lt;\/head&gt;<\/span>\r\n<span class=\"tag\">&lt;body&gt;<\/span>\r\n<span class=\"pun\">&lt;?<\/span><span class=\"pln\">php\r\n   $retval <\/span><span class=\"pun\">=<\/span><span class=\"pln\"> mysql_function<\/span><span class=\"pun\">(<\/span><span class=\"pln\">value<\/span><span class=\"pun\">,<\/span> <span class=\"pun\">[<\/span><span class=\"pln\">value<\/span><span class=\"pun\">,...]);<\/span>\r\n   <span class=\"kwd\">if<\/span><span class=\"pun\">(<\/span> <span class=\"pun\">!<\/span><span class=\"pln\">$retval <\/span><span class=\"pun\">)<\/span>\r\n   <span class=\"pun\">{<\/span>\r\n       <span class=\"kwd\">die<\/span> <span class=\"pun\">(<\/span> <span class=\"str\">\"\u76f8\u5173\u9519\u8bef\u4fe1\u606f\"<\/span> <span class=\"pun\">);<\/span>\r\n   <span class=\"pun\">}<\/span>\r\n   <span class=\"com\">\/\/ \u5176\u4ed6 MySQL \u6216 PHP \u8bed\u53e5<\/span>\r\n<span class=\"pun\">?&gt;<\/span>\r\n<span class=\"tag\">&lt;\/body&gt;<\/span>\r\n<span class=\"tag\">&lt;\/html&gt;\r\n\r\n\r\n\u539f\u6587\u94fe\u63a5\uff1ahttps:\/\/www.runoob.com\/mysql\/mysql-php-syntax.html<\/span><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>MySQL \u53ef\u5e94\u7528\u4e8e\u591a\u79cd\u8bed\u8a00\uff0c\u5305\u62ec PERL, C, C++, JAVA \u548c PHP\u3002 \u5728\u8fd9\u4e9b\u8bed\u8a00\u4e2d\uff0cMysq &#8230; <a title=\"MySQL PHP \u8bed\u6cd5\" class=\"read-more\" href=\"https:\/\/cn.hostease.com\/xueyuan\/jishu\/mysql-php-%e8%af%ad%e6%b3%95\/\" aria-label=\"\u9605\u8bfb MySQL PHP \u8bed\u6cd5\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5,10],"tags":[45],"class_list":["post-1685","post","type-post","status-publish","format-standard","hentry","category-jishu","category-shujuku","tag-mysql"],"aioseo_notices":[],"jetpack_featured_media_url":"","jetpack-related-posts":[],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1685","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/comments?post=1685"}],"version-history":[{"count":1,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1685\/revisions"}],"predecessor-version":[{"id":1686,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/posts\/1685\/revisions\/1686"}],"wp:attachment":[{"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/media?parent=1685"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/categories?post=1685"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cn.hostease.com\/xueyuan\/wp-json\/wp\/v2\/tags?post=1685"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}