{"id":898,"date":"2021-03-08T01:02:04","date_gmt":"2021-03-07T17:02:04","guid":{"rendered":"http:\/\/www.tra56.com\/?p=898"},"modified":"2021-03-08T01:02:04","modified_gmt":"2021-03-07T17:02:04","slug":"898","status":"publish","type":"post","link":"https:\/\/www.tra56.com\/898.html","title":{"rendered":"PHP\u4f7f\u7528PDO\u5b9e\u73b0\u7b80\u5355\u7684\u589e\u5220\u6539\u67e5"},"content":{"rendered":"<pre class=\"brush:php;toolbar:false\">&lt;?php\r\n\/\/\/\/\/php\u64cd\u4f5cpdo\u5b9e\u73b0\u67e5\u8be2\r\nheader(&nbsp;&quot;Content-type:&nbsp;text\/html;&nbsp;charset=utf-8&quot;&nbsp;);\r\n$dbms&nbsp;=&nbsp;&#39;mysql&#39;;\r\n$user&nbsp;=&nbsp;&#39;root&#39;;\r\n$pwd&nbsp;=&nbsp;&#39;12345678&#39;;\r\n$dbName&nbsp;=&nbsp;&#39;ceshi&#39;;\r\n$host&nbsp;=&nbsp;&#39;localhost&#39;;\r\n$charset&nbsp;=&nbsp;&#39;utf8&#39;;\r\n$dsn&nbsp;=&nbsp;&quot;$dbms:host=$host;dbname=$dbName;charset=$charset&quot;;\r\ntry&nbsp;{\r\n$pdo&nbsp;=&nbsp;new&nbsp;PDO(&nbsp;$dsn,&nbsp;$user,&nbsp;$pwd&nbsp;);\r\n}&nbsp;catch&nbsp;(&nbsp;Exception&nbsp;$e&nbsp;)&nbsp;{\r\necho&nbsp;$e-&gt;getMessage();\r\n}\r\n\/\/\u67e5\u8be2\r\n$sql&nbsp;=&nbsp;&quot;select&nbsp;*&nbsp;from&nbsp;dunling_chat&nbsp;where&nbsp;id=?&nbsp;&quot;;\r\n\/\/\u51c6\u5907sql\u6a21\u677f\r\n$stmt&nbsp;=&nbsp;$pdo-&gt;prepare(&nbsp;$sql&nbsp;);\r\n$id&nbsp;=&nbsp;&#39;1&#39;;\r\n\/\/\u7ed1\u5b9a\u53c2\u6570\r\n$stmt-&gt;bindValue(&nbsp;1,&nbsp;$id&nbsp;);\r\n\/\/\u6267\u884c\u9884\u5904\u7406\u8bed\u53e5\r\n$stmt-&gt;execute();\r\n\/\/\u63a8\u8350\u8fd9\u79cd\u65b9\u5f0f\u6765\u83b7\u53d6\u67e5\u8be2\u7ed3\u679c\r\nwhile&nbsp;(&nbsp;$row&nbsp;=&nbsp;$stmt-&gt;fetch()&nbsp;)&nbsp;{\r\necho&nbsp;$row[&nbsp;&#39;id&#39;&nbsp;]&nbsp;.&nbsp;&quot;&lt;br&nbsp;\/&gt;&quot;;\r\necho&nbsp;$row[&nbsp;&#39;nicheng&#39;&nbsp;]&nbsp;.&nbsp;&quot;&lt;br&nbsp;\/&gt;&quot;;\r\necho&nbsp;$row[&nbsp;&#39;content&#39;&nbsp;]&nbsp;.&nbsp;&quot;&lt;br&nbsp;\/&gt;&quot;;\r\necho&nbsp;$row[&nbsp;&#39;time&#39;&nbsp;]&nbsp;.&nbsp;&quot;&lt;br&nbsp;\/&gt;&quot;;\r\n}\r\n\/\/\u91ca\u653e\u67e5\u8be2\u7ed3\u679c\r\n$stmt&nbsp;=&nbsp;null;\r\n\/\/\u5173\u95ed\u8fde\u63a5\r\n$pdo&nbsp;=&nbsp;null;\r\n?&gt;\r\n&nbsp;\r\n&nbsp;\r\n&nbsp;\r\n&lt;?php\r\n\/\/\/\/\/php\u64cd\u4f5cpdo\u5b9e\u73b0\u66f4\u65b0\r\nheader(&nbsp;&quot;Content-type:&nbsp;text\/html;&nbsp;charset=utf-8&quot;&nbsp;);\r\n$dbms&nbsp;=&nbsp;&#39;mysql&#39;;\r\n$user&nbsp;=&nbsp;&#39;root&#39;;\r\n$pwd&nbsp;=&nbsp;&#39;12345678&#39;;\r\n$dbName&nbsp;=&nbsp;&#39;ceshi&#39;;\r\n$host&nbsp;=&nbsp;&#39;localhost&#39;;\r\n$charset&nbsp;=&nbsp;&#39;utf8&#39;;\r\n$dsn&nbsp;=&nbsp;&quot;$dbms:host=$host;dbname=$dbName;charset=$charset&quot;;\r\ntry&nbsp;{\r\n$pdo&nbsp;=&nbsp;new&nbsp;PDO(&nbsp;$dsn,&nbsp;$user,&nbsp;$pwd&nbsp;);\r\n}&nbsp;catch&nbsp;(&nbsp;Exception&nbsp;$e&nbsp;)&nbsp;{\r\necho&nbsp;$e-&gt;getMessage();\r\n}\r\n\/\/\u66f4\u65b0\r\n$sql&nbsp;=&nbsp;&quot;update&nbsp;dunling_chat&nbsp;set&nbsp;nicheng=?&nbsp;where&nbsp;id=?&quot;;\r\n\/\/\u51c6\u5907sql\u6a21\u677f\r\n$stmt&nbsp;=&nbsp;$pdo-&gt;prepare(&nbsp;$sql&nbsp;);\r\n$name&nbsp;=&nbsp;&#39;one&#39;;\r\n$age&nbsp;=&nbsp;1;\r\n\/\/\u7ed1\u5b9a\u53c2\u6570\r\n$stmt-&gt;bindValue(&nbsp;1,&nbsp;$name&nbsp;);\r\n$stmt-&gt;bindValue(&nbsp;2,&nbsp;$age&nbsp;);\r\n\/\/\u6267\u884c\u9884\u5904\u7406\u8bed\u53e5\r\n$stmt-&gt;execute();\r\n$affect_row&nbsp;=&nbsp;$stmt-&gt;rowCount();\r\nif&nbsp;(&nbsp;$affect_row&nbsp;)&nbsp;{\r\necho&nbsp;&#39;\u66f4\u65b0\u6210\u529f&#39;&nbsp;.&nbsp;&#39;&lt;br&gt;&#39;;\r\n}&nbsp;else&nbsp;{\r\necho&nbsp;&#39;\u66f4\u65b0\u5931\u8d25&#39;&nbsp;.&nbsp;&#39;&lt;br&gt;&#39;;\r\n}\r\n\/\/\u91ca\u653e\u67e5\u8be2\u7ed3\u679c\r\n$stmt&nbsp;=&nbsp;null;\r\n\/\/\u5173\u95ed\u8fde\u63a5\r\n$pdo&nbsp;=&nbsp;null;\r\n?&gt;\r\n&nbsp;\r\n&nbsp;\r\n&lt;?php\r\n\/\/\/\/php\u64cd\u4f5cpdo\u5b9e\u73b0\u63d2\u5165\r\n$dbms&nbsp;=&nbsp;&#39;mysql&#39;;\r\n$user&nbsp;=&nbsp;&#39;root&#39;;\r\n$pwd&nbsp;=&nbsp;&#39;12345678&#39;;\r\n$dbName&nbsp;=&nbsp;&#39;ceshi&#39;;\r\n$host&nbsp;=&nbsp;&#39;localhost&#39;;\r\n$charset&nbsp;=&nbsp;&#39;utf8&#39;;\r\n$dsn&nbsp;=&nbsp;&quot;$dbms:host=$host;dbname=$dbName;charset=$charset&quot;;\r\ntry&nbsp;{\r\n$pdo&nbsp;=&nbsp;new&nbsp;PDO(&nbsp;$dsn,&nbsp;$user,&nbsp;$pwd&nbsp;);\r\n}&nbsp;catch&nbsp;(&nbsp;Exception&nbsp;$e&nbsp;)&nbsp;{\r\necho&nbsp;$e-&gt;getMessage();\r\n}\r\n\/\/\u63d2\u5165\r\n$sql&nbsp;=&nbsp;&quot;insert&nbsp;into&nbsp;dunling_chat(nicheng,content)&nbsp;values(?,?)&quot;;\r\n\/\/\u51c6\u5907sql\u6a21\u677f\r\n$stmt&nbsp;=&nbsp;$pdo-&gt;prepare(&nbsp;$sql&nbsp;);\r\n$nicheng&nbsp;=&nbsp;&#39;two&#39;;\r\n$content&nbsp;=&nbsp;000;\r\n\/\/\u7ed1\u5b9a\u53c2\u6570\r\n$stmt-&gt;bindValue(&nbsp;1,&nbsp;$nicheng&nbsp;);\r\n$stmt-&gt;bindValue(&nbsp;2,&nbsp;$content&nbsp;);\r\n\/\/\u6267\u884c\u9884\u5904\u7406\u8bed\u53e5\r\n$stmt-&gt;execute();\r\n$insert_id&nbsp;=&nbsp;$pdo-&gt;lastInsertId();\r\nif&nbsp;(&nbsp;$insert_id&nbsp;)&nbsp;{\r\necho&nbsp;&#39;\u65b0\u589e\u6210\u529f&#39;&nbsp;.&nbsp;&#39;&lt;br&gt;&#39;;\r\n}&nbsp;else&nbsp;{\r\necho&nbsp;&#39;\u65b0\u589e\u5931\u8d25&#39;&nbsp;.&nbsp;&#39;&lt;br&gt;&#39;;\r\n}\r\n\/\/\u91ca\u653e\u67e5\u8be2\u7ed3\u679c\r\n$stmt&nbsp;=&nbsp;null;\r\n\/\/\u5173\u95ed\u8fde\u63a5\r\n$pdo&nbsp;=&nbsp;null;\r\n?&gt;\r\n&nbsp;\r\n&nbsp;\r\n&lt;?php\r\n\r\n\/\/\/\/php\u64cd\u4f5cpdo\u5b9e\u73b0\u5220\u9664\r\nheader(&quot;Content-type:&nbsp;text\/html;&nbsp;charset=utf-8&quot;);\r\n$dbms&nbsp;=&nbsp;&#39;mysql&#39;;\r\n$user&nbsp;=&nbsp;&#39;root&#39;;\r\n$pwd&nbsp;=&nbsp;&#39;12345678&#39;;\r\n$dbName&nbsp;=&nbsp;&#39;ceshi&#39;;\r\n$host&nbsp;=&nbsp;&#39;localhost&#39;;\r\n$charset&nbsp;=&nbsp;&#39;utf8&#39;;\r\n$dsn=&quot;$dbms:host=$host;dbname=$dbName;charset=$charset&quot;;\r\ntry{\r\n$pdo=new&nbsp;PDO($dsn,$user,$pwd);\r\n}\r\ncatch(Exception&nbsp;$e)\r\n{\r\necho&nbsp;$e-&gt;getMessage();\r\n}\r\n\r\n\/\/\u5220\u9664\r\n$sql&nbsp;=&nbsp;&quot;delete&nbsp;from&nbsp;dunling_chat&nbsp;where&nbsp;id=?&quot;;\r\n\/\/\u51c6\u5907sql\u6a21\u677f\r\n$stmt&nbsp;=&nbsp;$pdo-&gt;prepare($sql);\r\n$id&nbsp;=&nbsp;11;\r\n\/\/\u7ed1\u5b9a\u53c2\u6570\r\n$stmt-&gt;bindValue(1,$id);\r\n\/\/\u6267\u884c\u9884\u5904\u7406\u8bed\u53e5\r\n$stmt-&gt;execute();\r\n$affect_row&nbsp;=&nbsp;$stmt-&gt;rowCount();\r\nif($affect_row)\r\n{\r\necho&nbsp;&#39;\u5220\u9664\u6210\u529f&#39;.&#39;&lt;br&gt;&#39;;\r\n}\r\nelse\r\n{\r\necho&nbsp;&#39;\u5220\u9664\u5931\u8d25&#39;.&#39;&lt;br&gt;&#39;;\r\n}\r\n\/\/\u91ca\u653e\u67e5\u8be2\u7ed3\u679c\r\n$stmt&nbsp;=&nbsp;null;\r\n\/\/\u5173\u95ed\u8fde\u63a5\r\n$pdo&nbsp;=&nbsp;null;\r\n?&gt;<\/pre>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&lt;?php \/\/\/\/\/php\u64cd\u4f5cpdo\u5b9e\u73b0\u67e5\u8be2 header(&nbsp;&quot;Content-t [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[26,72,70],"class_list":["post-898","post","type-post","status-publish","format-standard","hentry","category-php","tag-php"],"_links":{"self":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/898"}],"collection":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/comments?post=898"}],"version-history":[{"count":1,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/898\/revisions"}],"predecessor-version":[{"id":899,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/posts\/898\/revisions\/899"}],"wp:attachment":[{"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/media?parent=898"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/categories?post=898"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.tra56.com\/wp-json\/wp\/v2\/tags?post=898"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}