{"id":28680,"date":"2024-11-25T17:53:22","date_gmt":"2024-11-25T09:53:22","guid":{"rendered":"https:\/\/fwq.ai\/blog\/28680\/"},"modified":"2024-11-25T17:53:22","modified_gmt":"2024-11-25T09:53:22","slug":"%e5%be%ae%e4%bf%a1%e5%85%ac%e4%bc%97%e5%b9%b3%e5%8f%b0%e5%bc%80%e5%8f%91%e6%95%b0%e6%8d%ae%e5%ba%93%e6%93%8d%e4%bd%9c","status":"publish","type":"post","link":"https:\/\/fwq.ai\/blog\/28680\/","title":{"rendered":"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c"},"content":{"rendered":"<p>\u4e00\u3001\u7b80\u4ecb<\/p>\n<p>\u524d\u9762\u8bb2\u89e3\u7684\u529f\u80fd\u5f00\u53d1\u90fd\u662f\u7b80\u5355\u7684\u8c03\u7528API \u5b8c\u6210\u7684\uff0c\u6ca1\u6709\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\u3002\u5728\u63a5\u4e0b\u6765\u7684\u9ad8\u7ea7\u529f\u80fd\u5f00\u53d1\u4e2d\uff0c\u9700\u8981\u4f7f\u7528\u5230\u6570\u636e\u5e93\uff0c\u6240\u4ee5\u5728\u8fd9\u4e00\u7bc7\u4e2d\uff0c\u5c06\u5bf9MySQL \u6570\u636e\u5e93\u7684\u64cd\u4f5c\u505a\u4e00\u4e0b\u7b80\u5355\u7684\u4ecb\u7ecd\uff0c\u4ee5\u4f9b\u8bfb\u8005\u53c2\u8003\u3002<\/p>\n<p>\u4e8c\u3001\u601d\u8def\u5206\u6790<\/p>\n<p>\u767e\u5ea6\u5f00\u53d1\u8005\u4e2d\u5fc3\u63d0\u4f9b\u4e86\u5f3a\u5927\u7684\u4e91\u6570\u636e\u5e93\uff08\u5305\u62ecMySQL, MongoDB, Redis\uff09\uff0c\u5728\u8fd9\u4e00\u8282\u6559\u7a0b\u4e2d\uff0c\u6211\u4eec\u5c06\u5bf9\u5927\u5bb6\u6bd4\u8f83\u719f\u6089\u7684MySQL \u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\u6f14\u793a\uff0c\u5b9e\u73b0\u5fae\u4fe1\u4e0e\u6570\u636e\u5e93\u7684\u4ea4\u4e92\u3002<\/p>\n<p>\u5728BAE\u5e94\u7528\u4e2d\u4f7f\u7528\u4e91\u6570\u636e\u5e93\u5341\u5206\u7b80\u5355\uff0c\u6570\u636e\u5e93\u5217\u8868\u4e2d\u7684\u540d\u79f0\u5373\u662f\u8fde\u63a5\u6570\u636e\u5e93\u65f6\u7684dbname\u3002\u7528\u6237\u540d\u3001\u5bc6\u7801\u3001\u8fde\u63a5\u5730\u5740\u548c\u7aef\u53e3\u5728\u5e94\u7528\u4e2d\u901a\u8fc7\u73af\u5883\u53d8\u91cf\u53d6\u51fa\u3002<\/p>\n<p>\u53ef\u4f7f\u7528\u6807\u51c6\u7684PHP Mysql \u6216PHP Mysqli \u6269\u5c55\u8bbf\u95ee\u6570\u636e\u5e93\uff0cBAE\u7684PHP\u4e2d\u5df2\u63d0\u4f9b\u8fd9\u4e24\u4e2a\u6269\u5c55\uff0c\u5e94\u7528\u53ef\u76f4\u63a5\u4f7f\u7528\u3002<\/p>\n<p>\u5b98\u65b9\u6587\u6863\uff0c\u8bf7\u53c2\u8003\uff1attp:\/\/developer.baidu.com\/wiki\/index.php?title=docs\/cplat\/rt\/mysql<\/p>\n<p>\u4e09\u3001\u521b\u5efaBAE MySQL\u6570\u636e\u5e93<\/p>\n<p>3.1 \u767b\u9646\u767e\u5ea6\u5f00\u53d1\u8005\u4e2d\u5fc3 -&gt; \u7ba1\u7406\u4e2d\u5fc3 -&gt; \u9009\u62e9\u5e94\u7528 -&gt; \u4e91\u73af\u5883 -&gt; \u670d\u52a1\u7ba1\u7406 -&gt; MySQL(\u4e91\u6570\u636e\u5e93) -&gt; \u521b\u5efa\u6570\u636e\u5e93<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/99db4af1c07a99c90af008b08581c9fd-0.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe\" \/><\/p>\n<p>3.2 \u521b\u5efa\u6570\u636e\u5e93<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/e9ac6e46f397dca14d85bf92b3705f4d-1.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe1\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe1\" \/><\/p>\n<p>\u6ce8\u610f\uff1a\u6bcf\u4e2a\u5e94\u7528\u6709\u4e14\u53ea\u6709\u4e00\u4e2a\u6570\u636e\u5e93\u4eab\u53d71G\u514d\u8d39\u914d\u989d\uff0c\u5176\u4f59\u6570\u636e\u5e93\u5747\u4e0d\u4eab\u53d7\u514d\u8d39\u914d\u989d\u4f18\u60e0\u3002\u53ea\u6709\u5c06\u5df2\u4f7f\u7528\u514d\u8d39\u914d\u989d\u7684\u6570\u636e\u5e93\u5220\u9664\uff0c\u624d\u80fd\u518d\u6b21\u4f7f\u7528\u6b64\u9879\u4f18\u60e0\u3002<\/p>\n<p>3.3 \u521b\u5efa\u6210\u529f<\/p>\n<p>\u5728\u8fd9\u91cc\u53ef\u4ee5\u770b\u5230\u6570\u636e\u5e93\u7684\u540d\u79f0\uff0c\u4e5f\u5c31\u662fdbname\uff0c\u540e\u9762\u4f1a\u4f7f\u7528\u5230\u3002<\/p>\n<p>\u70b9\u51fb \u201cphpMyadmin\u201d \u8bbf\u95ee\u6570\u636e\u5e93\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/e9ac6e46f397dca14d85bf92b3705f4d-2.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe2\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe2\" \/><\/p>\n<p>3.4 phpMyadmin\u754c\u9762<\/p>\n<p>\u65b0\u5efa\u6570\u636e\u8868\uff0c\u8f93\u5165\u8868\u540d\u53ca\u5b57\u6bb5\u6570\uff0c\u70b9\u51fb \u201c\u6267\u884c\u201d \u521b\u5efa\u8868\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3908830e9f928c7f72c965d018b93db8-3.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe3\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe3\" \/><\/p>\n<p>3.5 \u521b\u5efa\u8868<\/p>\n<p>\u8f93\u5165\u5b57\u6bb5\u540d\u53ca\u5b57\u6bb5\u7c7b\u578b\uff0c\u8f93\u5165\u5b8c\u6bd5\u540e\uff0c\u70b9\u51fb\u4e0b\u9762\u7684\u201c\u4fdd\u5b58\u201d\uff0c\u5b8c\u6210\u8868\u7684\u521b\u5efa\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3908830e9f928c7f72c965d018b93db8-4.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe4\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe4\" \/><\/p>\n<p>3.6 \u521b\u5efa\u5b8c\u6210<\/p>\n<p>\u4fee\u6539id \u5b57\u6bb5\u4e3a\u4e3b\u952e\u5e76\u6dfb\u52a0AUTO_INCREMENT\uff1b\u4fee\u6539from_user \u5b57\u6bb5\u4e3a\u552f\u4e00\uff08UNIQUE\uff09\uff0c\u5b8c\u6210\u8868\u7684\u4fee\u6539\u3002<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3908830e9f928c7f72c965d018b93db8-5.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe5\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe5\" \/><\/p>\n<p>\u5efa\u8868\u64cd\u4f5c\u4e5f\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0bSQL\u8bed\u53e5\u5b8c\u6210\uff1a<\/p>\n<\/p>\n<pre>CREATE TABLE IF NOT EXISTS `test_mysql` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `from_user` varchar(40) DEFAULT NULL,\r\n  `account` varchar(40) DEFAULT NULL,\r\n  `password` varchar(40) DEFAULT NULL,\r\n  `update_time` datetime DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  UNIQUE KEY `from_user` (`from_user`)\r\n);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>phpMyAdmin \u64cd\u4f5c<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/2d85838fd729037451a16c551cabd04a-6.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe6\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe6\" \/><\/p>\n<p>\u6570\u636e\u5e93\u53ca\u6570\u636e\u8868\u7684\u521b\u5efa\u5230\u6b64\u7ed3\u675f\uff0c\u4e0b\u9762\u5c06\u7f16\u5199\u4ee3\u7801\u5bf9\u6570\u636e\u5e93\u53ca\u6570\u636e\u8868\u7684\u4f7f\u7528\u505a\u8be6\u7ec6\u8bb2\u89e3\u3002<\/p>\n<p>\u56db\u3001\u5b98\u65b9\u793a\u4f8b\uff08PHP MySQL\uff09<\/p>\n<p>BAE \u5b98\u65b9\u63d0\u4f9b\u7684demo\uff08PHP MySQL\uff09\u793a\u4f8b\u5982\u4e0b\uff1a<\/p>\n<p>mysql\/basic.php \u6587\u4ef6\u5185\u5bb9<\/p>\n<\/p>\n<pre>&lt;?php\r\n\/**\r\n * MySQL\u793a\u4f8b\uff0c\u901a\u8fc7\u8be5\u793a\u4f8b\u53ef\u719f\u6089BAE\u5e73\u53f0MySQL\u7684\u4f7f\u7528\uff08CRUD\uff09\r\n *\/\r\nrequire_once(\"..\/configure.php\");\r\n    \/*\u66ff\u6362\u4e3a\u4f60\u81ea\u5df1\u7684\u6570\u636e\u5e93\u540d\uff08\u53ef\u4ece\u7ba1\u7406\u4e2d\u5fc3\u67e5\u770b\u5230\uff09*\/\r\n    $dbname = MYSQLNAME;\r\n     \r\n    \/*\u4ece\u73af\u5883\u53d8\u91cf\u91cc\u53d6\u51fa\u6570\u636e\u5e93\u8fde\u63a5\u9700\u8981\u7684\u53c2\u6570*\/\r\n    $host = getenv('HTTP_BAE_ENV_ADDR_SQL_IP');\r\n    $port = getenv('HTTP_BAE_ENV_ADDR_SQL_PORT');\r\n    $user = getenv('HTTP_BAE_ENV_AK');\r\n    $pwd = getenv('HTTP_BAE_ENV_SK');\r\n    \r\n    \/*\u63a5\u7740\u8c03\u7528mysql_connect()\u8fde\u63a5\u670d\u52a1\u5668*\/\r\n    $link = @mysql_connect(\"{$host}:{$port}\",$user,$pwd,true);\r\n    if(!$link) {\r\n      die(\"Connect Server Failed: \" . mysql_error());\r\n    }\r\n    \/*\u8fde\u63a5\u6210\u529f\u540e\u7acb\u5373\u8c03\u7528mysql_select_db()\u9009\u4e2d\u9700\u8981\u8fde\u63a5\u7684\u6570\u636e\u5e93*\/\r\n    if(!mysql_select_db($dbname,$link)) {\r\n      die(\"Select Database Failed: \" . mysql_error($link));\r\n    }\r\n    \/*\u81f3\u6b64\u8fde\u63a5\u5df2\u5b8c\u5168\u5efa\u7acb\uff0c\u5c31\u53ef\u5bf9\u5f53\u524d\u6570\u636e\u5e93\u8fdb\u884c\u76f8\u5e94\u7684\u64cd\u4f5c\u4e86*\/\r\n    \/*\uff01\uff01\uff01\u6ce8\u610f\uff0c\u65e0\u6cd5\u518d\u901a\u8fc7\u672c\u6b21\u8fde\u63a5\u8c03\u7528mysql_select_db\u6765\u5207\u6362\u5230\u5176\u5b83\u6570\u636e\u5e93\u4e86\uff01\uff01\uff01*\/\r\n    \/* \u9700\u8981\u518d\u8fde\u63a5\u5176\u5b83\u6570\u636e\u5e93\uff0c\u8bf7\u518d\u4f7f\u7528mysql_connect+mysql_select_db\u542f\u52a8\u53e6\u4e00\u4e2a\u8fde\u63a5*\/\r\n     \r\n    \/**\r\n    * \u63a5\u4e0b\u6765\u5c31\u53ef\u4ee5\u4f7f\u7528\u5176\u5b83\u6807\u51c6php mysql\u51fd\u6570\u64cd\u4f5c\u8fdb\u884c\u6570\u636e\u5e93\u64cd\u4f5c\r\n    *\/\r\n    \r\n    \/\/\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u8868\r\n    $sql = \"create table if not exists test_mysql(\r\n            id int primary key auto_increment,\r\n            no int, \r\n            name varchar(1024),\r\n            key idx_no(no))\";\r\n    $ret = mysql_query($sql, $link);\r\n    if ($ret === false) {\r\n        die(\"Create Table Failed: \" . mysql_error($link));\r\n    } else {\r\n        echo \"Create Table Succeed&lt;br \/&gt;\";\r\n    }\r\n    \r\n    \/\/\u63d2\u5165\u6570\u636e\r\n    $sql = \"insert into test_mysql(no, name) values(2007,'this is a test message'),\r\n            (2008,'this is another test message'),\r\n            (2009,'xxxxxxxxxxxxxx')\";\r\n    $ret = mysql_query($sql, $link);\r\n    if ($ret === false) {\r\n        die(\"Insert Failed: \" . mysql_error($link));\r\n    } else {\r\n        echo \"Insert Succeed&lt;br \/&gt;\";\r\n    }\r\n    \r\n    \/\/\u5220\u9664\u6570\u636e\r\n    $sql = \"delete from test_mysql where no = 2008\";\r\n    $ret = mysql_query($sql, $link);\r\n    if ($ret === false) {\r\n        die(\"Delete Failed: \" . mysql_error($link));\r\n    } else {\r\n        echo \"Delete  Succeed&lt;br \/&gt;\";\r\n    }\r\n    \r\n    \/\/\u4fee\u6539\u6570\u636e\r\n    $sql = \"update test_mysql set name = 'yyyyyy' where no = 2009\";\r\n    $ret = mysql_query($sql, $link);\r\n    if ($ret === false) {\r\n        die(\"Update Failed: \" . mysql_error($link));\r\n    } else {\r\n        echo \"Update Succeed&lt;br \/&gt;\";\r\n    }\r\n    \r\n    \r\n    \/\/\u68c0\u7d22\u6570\u636e\r\n    $sql = \"select id,no,name from test_mysql\";\r\n    $ret = mysql_query($sql, $link);\r\n    if ($ret === false) {\r\n        die(\"Select Failed: \" . mysql_error($link));\r\n    } else {\r\n        echo \"Select Succeed&lt;br \/&gt;\";\r\n        while ($row = mysql_fetch_assoc($ret)) {\r\n            echo \"{$row['id']} {$row['no']} {$row['name']}&lt;br \/&gt;\";\r\n        }\r\n    }\r\n    \r\n    \/\/\u5220\u9664\u8868\r\n    $sql = \"drop table if exists test_mysql\";\r\n    $ret = mysql_query($sql, $link);\r\n    if ($ret === false) {\r\n        die(\"Drop Table Failed: \" . mysql_error($link));\r\n    } else {\r\n        echo \"Drop Table Succeed&lt;br \/&gt;\";\r\n    }\r\n\r\n\r\n?&gt;<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>configure.php \u6587\u4ef6\u5185\u5bb9<\/p>\n<\/p>\n<pre>&lt;?php\r\n\r\n    \/***\u914d\u7f6e\u6570\u636e\u5e93\u540d\u79f0***\/\r\n    define(\"MYSQLNAME\", \"qzMlSkByflhScPCOFtax\");\r\n\r\n?&gt;<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u4f7f\u7528\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/2d85838fd729037451a16c551cabd04a-7.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe7\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe7\" \/>&nbsp;<\/p>\n<p>\u6267\u884c\u6210\u529f\u3002&nbsp;<\/p>\n<p>\u4e94\u3001\u4fee\u6539\u6210\u53ef\u8c03\u7528\u7684\u51fd\u6570\u5f62\u5f0f\uff08PHP MySQL\uff09<\/p>\n<p>5.1 \u521b\u5efa\u6570\u636e\u8868<\/p>\n<\/p>\n<pre>\/\/\u521b\u5efa\u4e00\u4e2a\u6570\u636e\u5e93\u8868\r\nfunction _create_table($sql){\r\n    mysql_query($sql) or die('\u521b\u5efa\u8868\u5931\u8d25\uff0c\u9519\u8bef\u4fe1\u606f\uff1a'.mysql_error());\r\n    return \"\u521b\u5efa\u8868\u6210\u529f\";\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>5.2 \u63d2\u5165\u6570\u636e<\/p>\n<\/p>\n<pre>\/\/\u63d2\u5165\u6570\u636e\r\nfunction _insert_data($sql){\r\n      if(!mysql_query($sql)){\r\n        return 0;    \/\/\u63d2\u5165\u6570\u636e\u5931\u8d25\r\n    }else{\r\n          if(mysql_affected_rows()&gt;0){\r\n              return 1;    \/\/\u63d2\u5165\u6210\u529f\r\n          }else{\r\n              return 2;    \/\/\u6ca1\u6709\u884c\u53d7\u5230\u5f71\u54cd\r\n          }\r\n    }\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>5.3 \u5220\u9664\u6570\u636e<\/p>\n<\/p>\n<pre>\/\/\u5220\u9664\u6570\u636e\r\nfunction _delete_data($sql){\r\n      if(!mysql_query($sql)){\r\n        return 0;    \/\/\u5220\u9664\u5931\u8d25\r\n      }else{\r\n          if(mysql_affected_rows()&gt;0){\r\n              return 1;    \/\/\u5220\u9664\u6210\u529f\r\n          }else{\r\n              return 2;    \/\/\u6ca1\u6709\u884c\u53d7\u5230\u5f71\u54cd\r\n          }\r\n    }\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>5.4 \u4fee\u6539\u6570\u636e<\/p>\n<\/p>\n<pre>\/\/\u4fee\u6539\u6570\u636e\r\nfunction _update_data($sql){\r\n      if(!mysql_query($sql)){\r\n        return 0;    \/\/\u66f4\u65b0\u6570\u636e\u5931\u8d25\r\n    }else{\r\n          if(mysql_affected_rows()&gt;0){\r\n              return 1;    \/\/\u66f4\u65b0\u6210\u529f;\r\n          }else{\r\n              return 2;    \/\/\u6ca1\u6709\u884c\u53d7\u5230\u5f71\u54cd\r\n          }\r\n    }\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>5.5 \u68c0\u7d22\u6570\u636e<\/p>\n<\/p>\n<pre>\/\/\u68c0\u7d22\u6570\u636e\r\nfunction _select_data($sql){\r\n    $ret = mysql_query($sql) or die('SQL\u8bed\u53e5\u6709\u9519\u8bef\uff0c\u9519\u8bef\u4fe1\u606f\uff1a'.mysql_error());\r\n    return $ret;\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>5.6 \u5220\u9664\u6570\u636e\u8868<\/p>\n<\/p>\n<pre>\/\/\u5220\u9664\u8868\r\nfunction _drop_table($sql){\r\n    mysql_query($sql) or die('\u5220\u9664\u8868\u5931\u8d25\uff0c\u9519\u8bef\u4fe1\u606f\uff1a'.mysql_error());\r\n    return \"\u5220\u9664\u8868\u6210\u529f\";\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u5c06\u4ee5\u4e0a\u51fd\u6570\u548c\u8fde\u63a5\u6570\u636e\u5e93\u7684\u4ee3\u7801\u7ed3\u5408\u8d77\u6765\uff0c\u751f\u6210mysql_bae.func.php \u6587\u4ef6\uff0c\u4f9b\u4e0b\u9762\u6d4b\u8bd5\u4f7f\u7528\u3002<\/p>\n<p>\u516d\u3001\u6d4b\u8bd5MySQL \u51fd\u6570\u4f7f\u7528<\/p>\n<p>6.1 \u65b0\u5efa\u6587\u4ef6dev_mysql.php \u5728\u540c\u4e00\u76ee\u5f55\u4e0b\u5e76\u5f15\u5165mysql_bae.func.php \u6587\u4ef6<\/p>\n<\/p>\n<pre>require_once '.\/mysql_bae.func.php';<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>6.2 \u6d4b\u8bd5\u521b\u5efa\u8868<\/p>\n<p>\u5c06\u4e0a\u9762\u4f7f\u7528phpMyAdmin \u521b\u5efa\u7684test_mysql \u8868\u5220\u9664\uff0c\u6d4b\u8bd5\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<\/p>\n<pre>\/\/\u521b\u5efa\u8868\r\n$create_sql = \"CREATE TABLE IF NOT EXISTS `test_mysql` (\r\n  `id` int(11) NOT NULL AUTO_INCREMENT,\r\n  `from_user` varchar(40) DEFAULT NULL,\r\n  `account` varchar(40) DEFAULT NULL,\r\n  `password` varchar(40) DEFAULT NULL,\r\n  `update_time` datetime DEFAULT NULL,\r\n  PRIMARY KEY (`id`),\r\n  UNIQUE KEY `from_user` (`from_user`)\r\n)\";\r\n\r\necho _create_table($create_sql);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u6b63\u786e\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/2d85838fd729037451a16c551cabd04a-8.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe8\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe8\" \/>&nbsp;<\/p>\n<p>\u5230phpMyAdmin\u4e2d\u67e5\u770b<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/929c659e8663bca4f2e5922068a56fb4-9.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe9\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe9\" \/><\/p>\n<p>\u6545\u610f\u5c06SQL\u8bed\u53e5\u5199\u9519<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/929c659e8663bca4f2e5922068a56fb4-10.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe10\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe10\" \/><\/p>\n<p>\u6d4b\u8bd5\u9519\u8bef\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/929c659e8663bca4f2e5922068a56fb4-11.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe11\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe11\" \/><\/p>\n<p>6.3 \u6d4b\u8bd5\u63d2\u5165\u6570\u636e<\/p>\n<p>\u6d4b\u8bd5\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<\/p>\n<pre>\/\/\u63d2\u5165\u6570\u636e\r\n$insert_sql = \"insert into test_mysql(from_user, account, password, update_time) values('David','860510', 'abcabc', '2013-09-29 17:14:28')\";\r\n\r\n$res = _insert_data($insert_sql);\r\nif($res == 1){\r\n    echo \"\u63d2\u5165\u6210\u529f\";\r\n}else{\r\n    echo \"\u63d2\u5165\u5931\u8d25\";\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/71e5c9647cfa8b887d6b8efe8e576f7c-12.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe12\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe12\" \/><\/p>\n<p>6.4 \u6d4b\u8bd5\u66f4\u65b0\u6570\u636e<\/p>\n<p>\u6d4b\u8bd5\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<\/p>\n<pre>\/\/\u66f4\u65b0\u6570\u636e\r\n$update_sql = \"update test_mysql set account = 860512 where account = 860510\";\r\n\r\n$res = _update_data($update_sql);\r\nif($res == 1){\r\n    echo \"\u66f4\u65b0\u6210\u529f\";\r\n}elseif($res == 0){\r\n    echo \"\u66f4\u65b0\u5931\u8d25\";\r\n}elseif($res == 2){\r\n    echo \"\u6ca1\u6709\u884c\u53d7\u5230\u5f71\u54cd\";\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/71e5c9647cfa8b887d6b8efe8e576f7c-13.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe13\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe13\" \/><\/p>\n<p>\u518d\u6b21\u66f4\u65b0\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/71e5c9647cfa8b887d6b8efe8e576f7c-14.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe14\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe14\" \/><\/p>\n<p>6.5 \u6d4b\u8bd5\u5220\u9664\u6570\u636e<\/p>\n<p>\u6d4b\u8bd5\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<\/p>\n<pre>\/\/\u5220\u9664\u6570\u636e\r\n$delete_sql = \"delete from test_mysql where account = 860512\";\r\n\r\n$res = _delete_data($delete_sql);\r\nif($res == 1){\r\n    echo \"\u5220\u9664\u6210\u529f\";\r\n}elseif($res == 0){\r\n    echo \"\u5220\u9664\u5931\u8d25\";\r\n}elseif($res == 2){\r\n    echo \"\u6ca1\u6709\u8be5\u6761\u8bb0\u5f55\";\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/71e5c9647cfa8b887d6b8efe8e576f7c-15.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe15\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe15\" \/><\/p>\n<p>\u518d\u6b21\u5220\u9664\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3c7af7e23bc73c096835ed493d3f2e9f-16.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe16\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe16\" \/><\/p>\n<p>6.6 \u6d4b\u8bd5\u68c0\u7d22\u6570\u636e<\/p>\n<p>\u518d\u6b21\u6267\u884c\u4e0a\u9762\u7684\u63d2\u5165\u64cd\u4f5c\u505a\u68c0\u7d22\u6d4b\u8bd5\uff0c\u6d4b\u8bd5\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<\/p>\n<pre>\/\/\u68c0\u7d22\u6570\u636e\r\n$select_sql = \"select * from test_mysql\";\r\n\r\n$result = _select_data($select_sql);\r\n\r\nwhile($rows = mysql_fetch_array($result,MYSQL_ASSOC)){\r\n\r\n    echo $rows[id].\"--\".$rows[from_user].\"--\".$rows[account].\"--\".$rows[password].\"--\".$rows[update_time];\r\n    echo \"&lt;br \/&gt;\";\r\n\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3c7af7e23bc73c096835ed493d3f2e9f-17.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe17\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe17\" \/><\/p>\n<p>6.7 \u6d4b\u8bd5\u5220\u9664\u8868<\/p>\n<p>\u6d4b\u8bd5\u8bed\u53e5\u5982\u4e0b\uff1a<\/p>\n<\/p>\n<pre>\/\/\u5220\u9664\u8868$drop_sql = \"drop table if exists test_mysql\";echo _drop_table($drop_sql);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3c7af7e23bc73c096835ed493d3f2e9f-18.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe18\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe18\" \/><\/p>\n<p>MySQL \u51fd\u6570\u6d4b\u8bd5\u5168\u90e8\u6210\u529f\u3002<\/p>\n<p>\u4e03\u3001\u5b9e\u73b0\u4e0e\u5fae\u4fe1\u7684\u4ea4\u4e92\uff08Mysql \u6269\u5c55\uff09<\/p>\n<p>\u4fdd\u8bc1\u6570\u636e\u5e93\u4e2d\u5b58\u5728test_msyql\u8868\uff0c\u8fd9\u91cc\u6d4b\u8bd5\u5fae\u4fe1\u5bf9MySQL\u6570\u636e\u5e93\u7684\u589e\u5220\u6539\u67e5\u64cd\u4f5c\uff0c\u4e0d\u8003\u8651\u7279\u6b8a\u60c5\u51b5\uff0c\u53ea\u6309\u7167\u4e0b\u9762\u7684\u65b9\u6cd5\u6d4b\u8bd5\uff1a<\/p>\n<\/p>\n<pre>1. \u7ed1\u5b9a+\u8d26\u6237+\u5bc6\u7801\r\n\u5982\uff1a\u7ed1\u5b9a+860512+abc123\r\n\r\n2. \u67e5\u8be2\r\n\u5982\uff1a\u67e5\u8be2\r\n\r\n3. \u4fee\u6539+\u65e7\u5bc6\u7801+\u65b0\u5bc6\u7801\r\n\u5982\uff1a\u4fee\u6539+abc123+123456\r\n\r\n4. \u5220\u9664\r\n\u5982\uff1a\u5220\u9664<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>7.1&nbsp;\u5f15\u5165mysql_bae.func.php \u6587\u4ef6<\/p>\n<\/p>\n<pre>\/\/\u5f15\u5165\u6570\u636e\u5e93\u51fd\u6570\u6587\u4ef6require_once 'mysql_bae.func.php';<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>7.2 \u524d\u7f6e\u64cd\u4f5c<\/p>\n<p>A. \u5c06\u8f93\u5165\u7684\u8bed\u53e5\u62c6\u5206\u6210\u6570\u7ec4\uff0c\u4ee5\u201c+\u201d\u53f7\u5206\u9694<\/p>\n<\/p>\n<pre>$keywords = explode(\"+\",$keyword);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>B. \u83b7\u53d6\u5f53\u524d\u65f6\u95f4<\/p>\n<\/p>\n<pre>\/\/\u83b7\u53d6\u5f53\u524d\u65f6\u95f4$nowtime=date(\"Y-m-d G:i:s\");<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>C. \u5224\u65ad\u7528\u6237\u662f\u5426\u5df2\u7ecf\u7ed1\u5b9a<\/p>\n<\/p>\n<pre>\/\/\u5224\u65ad\u662f\u5426\u5df2\u7ecf\u7ed1\u5b9a\r\n$select_sql=\"SELECT id from test_mysql WHERE from_user='$fromUsername'\";\r\n$res=_select_data($select_sql);\r\n$rows=mysql_fetch_array($res, MYSQL_ASSOC);\r\nif($rows[id] &lt;&gt; ''){\r\n        $user_flag='y';          \r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>7.3 \u6d4b\u8bd5\u63d2\u5165\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>if(trim($keywords[0] == '\u7ed1\u5b9a')){\r\n    if($user_flag &lt;&gt; 'y'){\r\n        $insert_sql=\"INSERT INTO test_mysql(from_user, account, password, update_time) VALUES('$fromUsername','$keywords[1]','$keywords[2]','$nowtime')\";\r\n        $res = _insert_data($insert_sql);\r\n        if($res == 1){\r\n            $contentStr = \"\u7ed1\u5b9a\u6210\u529f\";\r\n        }elseif($res == 0){\r\n            $contentStr = \"\u7ed1\u5b9a\u5931\u8d25\";\r\n        }\r\n    }else{\r\n        $contentStr = \"\u8be5\u8d26\u6237\u5df2\u7ed1\u5b9a\";\r\n    }\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3c7af7e23bc73c096835ed493d3f2e9f-19.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe19\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe19\" \/><\/p>\n<p>7.4 \u6d4b\u8bd5\u67e5\u8be2\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>if(trim($keywords[0] == '\u67e5\u8be2')){\r\n    $select_sql=\"SELECT * FROM test_mysql WHERE from_user='$fromUsername'\";\r\n    $select_res=_select_data($select_sql);\r\n    $rows=mysql_fetch_assoc($select_res);\r\n    if($rows[id] &lt;&gt; ''){\r\n    $contentStr=\"\u8d26\u6237:$rows[account]\n\".\"\u5bc6\u7801\uff1a$rows[password]\n\".\"From_user\uff1a$rows[from_user]\n\".\"\u66f4\u65b0\u65f6\u95f4\uff1a$rows[update_time]\";\r\n    }else{\r\n    $contentStr=\"\u60a8\u8fd8\u672a\u7ed1\u5b9a\u8d26\u6237\uff0c\u67e5\u8be2\u4e0d\u5230\u76f8\u5173\u4fe1\u606f\uff0c\u8bf7\u5148\u7ed1\u5b9a\uff0c\u8c22\u8c22\uff01\";\r\n    }\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/86646469d6cd455b7a4d641dc39296bb-20.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe20\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe20\" \/><\/p>\n<p>7.5 \u6d4b\u8bd5\u66f4\u65b0\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>if(trim($keywords[0] == \"\u4fee\u6539\")){\r\n    $old_password=$keywords[1];\r\n    $new_password=$keywords[2];\r\n    $select_password_sql=\"SELECT * FROM test_mysql WHERE from_user='$fromUsername'\";\r\n    $select_res=_select_data($select_password_sql);\r\n    $rows=mysql_fetch_assoc($select_res);\r\n    if($old_password == $rows[password]){\r\n        $update_sql=\"UPDATE test_mysql SET password='$new_password' WHERE from_user='$fromUsername'\";\r\n        $res = _update_data($update_sql);\r\n        if($res == 1){\r\n            $contentStr = \"\u4fee\u6539\u6210\u529f\";\r\n        }elseif($res == 0){\r\n            $contentStr = \"\u4fee\u6539\u5931\u8d25\";\r\n        }\r\n    }else{\r\n        $contentStr = \"\u539f\u5bc6\u7801\u6709\u8bef\uff0c\u8bf7\u786e\u8ba4\u540e\u91cd\u8bd5\";\r\n    }\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/86646469d6cd455b7a4d641dc39296bb-21.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe21\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe21\" \/><\/p>\n<p>7.6 \u6d4b\u8bd5\u5220\u9664\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>if(trim($keywords[0] == \"\u5220\u9664\")){\r\n    $delete_sql=\"DELETE FROM test_mysql WHERE from_user='$fromUsername'\";\r\n    $res = _delete_data($delete_sql);\r\n    if($res == 1){\r\n        $contentStr = \"\u5220\u9664\u6210\u529f\";\r\n    }elseif($res == 0){\r\n        $contentStr = \"\u5220\u9664\u5931\u8d25\";\r\n    }\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3de59fbb3be6ad8066a73df0bc77747b-22.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe22\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe22\" \/><\/p>\n<p>\u4e0e\u5fae\u4fe1\u7684\u4ea4\u4e92\u6d4b\u8bd5\u6210\u529f\u3002<\/p>\n<p>\u516b\u3001PHP Mysqli \u6269\u5c55\uff0c\u5c01\u88c5\u6210\u7c7b<\/p>\n<p>\u5c06Mysqli \u6269\u5c55\u5c01\u88c5\u6210\u7c7b\u4f7f\u7528\uff0c\u4ee3\u7801\u5982\u4e0b\uff1a<\/p>\n<\/p>\n<pre>&lt;?php\r\n\r\nrequire_once 'includes\/configure.php';\r\n\r\nclass MySQLi_BAE{\r\n\r\n    private $mysqli;\r\n    private $host;\r\n    private $user;\r\n    private $password;\r\n    private $port;\r\n    private $database;\r\n\r\n    \/\/\u5728\u7c7b\u4e4b\u5916\u8bbf\u95ee\u79c1\u6709\u53d8\u91cf\u65f6\u4f7f\u7528\r\n    function __get($property_name){\r\n        if(isset($this-&gt;$property_name)){\r\n            return($this-&gt;$property_name);\r\n        }else{\r\n            return(NULL);\r\n        }    \r\n    }\r\n\r\n    function __set($property_name, $value){\r\n        $this-&gt;$property_name=$value;\r\n    }\r\n\r\n    function __construct(){\r\n\r\n        \/*\u4ece\u5e73\u53f0\u83b7\u53d6\u67e5\u8be2\u8981\u8fde\u63a5\u7684\u6570\u636e\u5e93\u540d\u79f0*\/\r\n        $this-&gt;database = MYSQLNAME;\r\n\r\n        \/*\u4ece\u73af\u5883\u53d8\u91cf\u91cc\u53d6\u51fa\u6570\u636e\u5e93\u8fde\u63a5\u9700\u8981\u7684\u53c2\u6570*\/\r\n        $this-&gt;host = getenv('HTTP_BAE_ENV_ADDR_SQL_IP');\r\n        $this-&gt;user = getenv('HTTP_BAE_ENV_AK');\r\n        $this-&gt;password = getenv('HTTP_BAE_ENV_SK');\r\n        $this-&gt;port = getenv('HTTP_BAE_ENV_ADDR_SQL_PORT');\r\n\r\n        $this-&gt;mysqli = new mysqli($this-&gt;host, $this-&gt;user, $this-&gt;password, $this-&gt;database, $this-&gt;port);\r\n        if($this-&gt;mysqli-&gt;connect_error){\r\n            die(\"Connect Server Failed:\".$this-&gt;mysqli-&gt;error);\r\n        }\r\n        \r\n        $this-&gt;mysqli-&gt;query(\"set names utf8\");\r\n    }\r\n\r\n    \/\/dql statement\r\n    function execute_dql($query){\r\n        \r\n        $res = $this-&gt;mysqli-&gt;query($query) or die(\"\u64cd\u4f5c\u5931\u8d25\".$this-&gt;mysqli-&gt;error);\r\n        return $res;\r\n        \r\n        \/\/$this-&gt;mysqli-&gt;close();\r\n    }\r\n\r\n    \/\/dml statement\r\n    function execute_dml($query){\r\n        \r\n        $res = $this-&gt;mysqli-&gt;query($query) or die(\"\u64cd\u4f5c\u5931\u8d25\".$this-&gt;mysqli-&gt;error);\r\n        \r\n        if(!$res){\r\n            return 0;\/\/\u5931\u8d25\r\n        }else{\r\n            if($this-&gt;mysqli-&gt;affected_rows &gt; 0){\r\n                return 1;\/\/\u6267\u884c\u6210\u529f\r\n            }else{\r\n                return 2;\/\/\u6ca1\u6709\u884c\u53d7\u5f71\u54cd\r\n            }\r\n        }\r\n    \r\n        \/\/$this-&gt;mysqli-&gt;close();\r\n    }\r\n}\r\n?&gt;<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u4e5d\u3001\u6d4b\u8bd5\u7c7b\u7684\u4f7f\u7528<\/p>\n<p>9.1 \u6d4b\u8bd5DML\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>&lt;?php\r\n\r\nrequire_once \"MySQLi_BAE.class.php\";\r\n\r\n$mysqli_BAE=new MySQLi_BAE();\r\n\r\n\r\n\/\/**************dml*******************\r\n$sql=\"insert into test_mysql (from_user, account, password, update_time) values('David','860510', 'abcabc', '2013-09-27 17:14:28')\";\r\n\r\n\/\/$sql=\"update test_mysql set account = 860512 where account = 860510\";\r\n\r\n\/\/$sql=\"delete from test_mysql where account = 860512\";\r\n\r\n$res=$mysqli_BAE-&gt;execute_dml($sql);\r\n\r\nif($res==0){\r\n    echo \"\u6267\u884c\u5931\u8d25\";\r\n}elseif($res==1){\r\n    echo \"\u6267\u884c\u6210\u529f\";\r\n}else{\r\n    echo \"\u6ca1\u6709\u884c\u6570\u5f71\u54cd\";\r\n}\r\n?&gt;<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/3de59fbb3be6ad8066a73df0bc77747b-23.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe23\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe23\" \/><\/p>\n<p>9.2 \u6d4b\u8bd5DQL\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>&lt;?php\r\n\r\nrequire_once \"MySQLi_BAE.class.php\";\r\n\r\n$mysqli_BAE=new MySQLi_BAE();\r\n\r\n\/\/**************dql******************\r\n$sql=\"select * from test_mysql\";\r\n\r\n$res=$mysqli_BAE-&gt;execute_dql($sql);\r\n\r\nwhile($row=$res-&gt;fetch_row()){\r\n    \r\n    foreach($row as $key=&gt;$val){\r\n        echo \"$val--\";\r\n    }\r\n    echo '&lt;br\/&gt;';\r\n}\r\n\r\n$res-&gt;free();\r\n?&gt;<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/e1af98b607169413a7a3cbd9812365d5-24.jpg\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe24\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe24\" \/><\/p>\n<p>\u5341\u3001\u5b9e\u73b0\u4e0e\u5fae\u4fe1\u7684\u4ea4\u4e92\uff08Mysqli \u6269\u5c55\uff09<\/p>\n<p>10.1 \u524d\u7f6e\u64cd\u4f5c<\/p>\n<p>A. \u5f15\u5165MySQLi_BAE.class.php \u6587\u4ef6<\/p>\n<\/p>\n<pre>\/\/\u5f15\u5165\u6570\u636e\u5e93\u51fd\u6570\u6587\u4ef6require_once \"MySQLi_BAE.class.php\";<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>B. \u5b9e\u4f8b\u5316\u5bf9\u8c61<\/p>\n<\/p>\n<pre>public function __construct()\r\n{    $this-&gt;mysqli_BAE=new MySQLi_BAE();\r\n}<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>10.2 \u6d4b\u8bd5\u63d2\u5165\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>$insert_sql=\"INSERT INTO test_mysql(from_user, account, password, update_time) VALUES('$fromUsername','$keywords[1]','$keywords[2]','$nowtime')\";\r\n$res = $this-&gt;mysqli_BAE-&gt;execute_dml($insert_sql);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/e1af98b607169413a7a3cbd9812365d5-25.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe25\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe25\" \/><\/p>\n<p>10.3 \u6d4b\u8bd5\u67e5\u8be2\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>$select_sql=\"SELECT * FROM test_mysql WHERE from_user='$fromUsername'\";\r\n$select_res=$this-&gt;mysqli_BAE-&gt;execute_dql($select_sql);\r\n$rows=$select_res-&gt;fetch_array(MYSQLI_ASSOC);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/e1af98b607169413a7a3cbd9812365d5-26.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe26\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe26\" \/><\/p>\n<p>10.4 \u6d4b\u8bd5\u66f4\u65b0\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>$update_sql=\"UPDATE test_mysql SET password='$new_password' WHERE from_user='$fromUsername'\"; \r\n$res = $this-&gt;mysqli_BAE-&gt;execute_dml($update_sql);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/e16a2b1b57a07f15ab924d22fc677d39-27.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe27\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe27\" \/><\/p>\n<p>10.5 \u6d4b\u8bd5\u5220\u9664\u64cd\u4f5c<\/p>\n<p>\u6d4b\u8bd5\u4ee3\u7801\uff1a<\/p>\n<\/p>\n<pre>$delete_sql=\"DELETE FROM test_mysql WHERE from_user='$fromUsername'\";\r\n$res = $this-&gt;mysqli_BAE-&gt;execute_dml($delete_sql);<\/pre>\n<p>  \u767b\u5f55\u540e\u590d\u5236   <\/p>\n<p>\u6d4b\u8bd5\u7ed3\u679c\uff1a<\/p>\n<p><img decoding=\"async\" src=\"https:\/\/img.php.cn\/upload\/article\/000\/000\/013\/e16a2b1b57a07f15ab924d22fc677d39-28.png\" style=\"max-width:90%\" class=\"aligncenter\" title=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe28\" alt=\"\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u63d2\u56fe28\" \/><\/p>\n<p>\u4e0e\u5fae\u4fe1\u4ea4\u4e92\u6d4b\u8bd5\u6210\u529f\u3002&nbsp;<\/p>\n<p>\u66f4\u591a\u5fae\u4fe1\u516c\u4f17\u5e73\u53f0\u5f00\u53d1\u6570\u636e\u5e93\u64cd\u4f5c\u76f8\u5173\u6587\u7ae0\u8bf7\u5173\u6ce8PHP\u4e2d\u6587\u7f51\uff01<\/p>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4e00\u3001\u7b80\u4ecb \u524d\u9762\u8bb2\u89e3\u7684\u529f\u80fd\u5f00\u53d1\u90fd\u662f\u7b80\u5355\u7684\u8c03\u7528API \u5b8c\u6210\u7684\uff0c\u6ca1\u6709\u5bf9\u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\u3002\u5728\u63a5\u4e0b\u6765\u7684\u9ad8\u7ea7\u529f\u80fd\u5f00\u53d1\u4e2d\uff0c\u9700\u8981\u4f7f\u7528\u5230\u6570\u636e\u5e93\uff0c\u6240\u4ee5\u5728\u8fd9\u4e00\u7bc7\u4e2d\uff0c\u5c06\u5bf9MySQL \u6570\u636e\u5e93\u7684\u64cd\u4f5c\u505a\u4e00\u4e0b\u7b80\u5355\u7684\u4ecb\u7ecd\uff0c\u4ee5\u4f9b\u8bfb\u8005\u53c2\u8003\u3002 \u4e8c\u3001\u601d\u8def\u5206\u6790 \u767e\u5ea6\u5f00\u53d1\u8005\u4e2d\u5fc3\u63d0\u4f9b\u4e86\u5f3a\u5927\u7684\u4e91\u6570\u636e\u5e93\uff08\u5305\u62ecMySQL, MongoDB, Redis\uff09\uff0c\u5728\u8fd9\u4e00\u8282\u6559\u7a0b\u4e2d\uff0c\u6211\u4eec\u5c06\u5bf9\u5927\u5bb6\u6bd4\u8f83\u719f\u6089\u7684MySQL \u6570\u636e\u5e93\u8fdb\u884c\u64cd\u4f5c\u6f14\u793a\uff0c\u5b9e\u73b0\u5fae\u4fe1\u4e0e\u6570\u636e\u5e93\u7684\u4ea4\u4e92\u3002 \u5728BAE\u5e94\u7528\u4e2d\u4f7f\u7528\u4e91\u6570\u636e\u5e93\u5341\u5206\u7b80\u5355\uff0c\u6570\u636e\u5e93\u5217\u8868\u4e2d\u7684\u540d\u79f0\u5373\u662f\u8fde\u63a5\u6570\u636e\u5e93\u65f6\u7684dbname\u3002\u7528\u6237\u540d\u3001\u5bc6\u7801\u3001\u8fde\u63a5\u5730\u5740\u548c\u7aef\u53e3\u5728\u5e94\u7528\u4e2d\u901a\u8fc7\u73af\u5883\u53d8\u91cf\u53d6\u51fa\u3002 \u53ef\u4f7f\u7528\u6807\u51c6\u7684PHP Mysql \u6216PHP Mysqli \u6269\u5c55\u8bbf\u95ee\u6570\u636e\u5e93\uff0cBAE\u7684PHP\u4e2d\u5df2\u63d0\u4f9b\u8fd9\u4e24\u4e2a\u6269\u5c55\uff0c\u5e94\u7528\u53ef\u76f4\u63a5\u4f7f\u7528\u3002 \u5b98\u65b9\u6587\u6863\uff0c\u8bf7\u53c2\u8003\uff1attp:\/\/developer.baidu.com\/wiki\/index.php?title=docs\/cplat\/rt\/mysql \u4e09\u3001\u521b\u5efaBAE MySQL\u6570\u636e\u5e93 3.1 \u767b\u9646\u767e\u5ea6\u5f00\u53d1\u8005\u4e2d\u5fc3 -&gt; \u7ba1\u7406\u4e2d\u5fc3 -&gt; \u9009\u62e9\u5e94\u7528 -&gt; \u4e91\u73af\u5883 -&gt; \u670d\u52a1\u7ba1\u7406 -&gt; MySQL(\u4e91\u6570\u636e\u5e93) -&gt; \u521b\u5efa\u6570\u636e\u5e93 3.2 \u521b\u5efa\u6570\u636e\u5e93 \u6ce8\u610f\uff1a\u6bcf\u4e2a\u5e94\u7528\u6709\u4e14\u53ea\u6709\u4e00\u4e2a\u6570\u636e\u5e93\u4eab\u53d71G\u514d\u8d39\u914d\u989d\uff0c\u5176\u4f59\u6570\u636e\u5e93\u5747\u4e0d\u4eab\u53d7\u514d\u8d39\u914d\u989d\u4f18\u60e0\u3002\u53ea\u6709\u5c06\u5df2\u4f7f\u7528\u514d\u8d39\u914d\u989d\u7684\u6570\u636e\u5e93\u5220\u9664\uff0c\u624d\u80fd\u518d\u6b21\u4f7f\u7528\u6b64\u9879\u4f18\u60e0\u3002 3.3 \u521b\u5efa\u6210\u529f \u5728\u8fd9\u91cc\u53ef\u4ee5\u770b\u5230\u6570\u636e\u5e93\u7684\u540d\u79f0\uff0c\u4e5f\u5c31\u662fdbname\uff0c\u540e\u9762\u4f1a\u4f7f\u7528\u5230\u3002 \u70b9\u51fb \u201cphpMyadmin\u201d \u8bbf\u95ee\u6570\u636e\u5e93\u3002 3.4 phpMyadmin\u754c\u9762 \u65b0\u5efa\u6570\u636e\u8868\uff0c\u8f93\u5165\u8868\u540d\u53ca\u5b57\u6bb5\u6570\uff0c\u70b9\u51fb \u201c\u6267\u884c\u201d \u521b\u5efa\u8868\u3002 3.5 \u521b\u5efa\u8868 \u8f93\u5165\u5b57\u6bb5\u540d\u53ca\u5b57\u6bb5\u7c7b\u578b\uff0c\u8f93\u5165\u5b8c\u6bd5\u540e\uff0c\u70b9\u51fb\u4e0b\u9762\u7684\u201c\u4fdd\u5b58\u201d\uff0c\u5b8c\u6210\u8868\u7684\u521b\u5efa\u3002 3.6 \u521b\u5efa\u5b8c\u6210 \u4fee\u6539id \u5b57\u6bb5\u4e3a\u4e3b\u952e\u5e76\u6dfb\u52a0AUTO_INCREMENT\uff1b\u4fee\u6539from_user \u5b57\u6bb5\u4e3a\u552f\u4e00\uff08UNIQUE\uff09\uff0c\u5b8c\u6210\u8868\u7684\u4fee\u6539\u3002 \u5efa\u8868\u64cd\u4f5c\u4e5f\u53ef\u4ee5\u4f7f\u7528\u4ee5\u4e0bSQL\u8bed\u53e5\u5b8c\u6210\uff1a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[19],"tags":[],"class_list":["post-28680","post","type-post","status-publish","format-standard","hentry","category-19"],"_links":{"self":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28680","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/comments?post=28680"}],"version-history":[{"count":0,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/posts\/28680\/revisions"}],"wp:attachment":[{"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/media?parent=28680"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/categories?post=28680"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fwq.ai\/blog\/wp-json\/wp\/v2\/tags?post=28680"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}