{"id":278,"date":"2013-07-02T11:29:14","date_gmt":"2013-07-02T03:29:14","guid":{"rendered":"http:\/\/140.112.31.82\/wordpress\/?p=278"},"modified":"2013-07-02T11:29:14","modified_gmt":"2013-07-02T03:29:14","slug":"phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php","status":"publish","type":"post","link":"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php","title":{"rendered":"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php"},"content":{"rendered":"<pre class=\"lang:php decode:true \" >&lt;form action=\"\" method=\"post\" name=\"form1\"&gt;&lt;br&gt;\nInput address book data:&lt;br&gt;\nname:&lt;input name=\"name\" type=\"text\" value=\"\"&gt;&lt;br&gt;\nphone:&lt;input name=\"phone\" type=\"text\" value=\"\"&gt;&lt;br&gt;\naddress:&lt;input name=\"address\" type=\"text\" value=\"\"&gt;&lt;br&gt;\n&lt;input name=\"submit\" type=\"submit\" value=\"add\"&gt;&lt;br&gt;\n&lt;?php\n\nmysql_connect('localhost','root','student') or die(\"connect error!\");\nmysql_select_db('phone') or die(\"db error\");\nmysql_query(\"SET NAMES 'utf8'\");\nmysql_query(\"CREATE TABLE  `address_book` (\n `sid` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY ,\n `name` VARCHAR( 20 ) NOT NULL ,\n `phone` VARCHAR( 20 ) NOT NULL ,\n `address` VARCHAR( 20 ) NOT NULL\n) ENGINE = MYISAM ;\");\n\n\nif(count($_POST)&gt;0) {\n\/\/ \u6e96\u5099\u66f4\u65b0\u8cc7\u6599\u7684\u8a9e\u6cd5\n$name = $_POST[\"name\"];\n$phone = $_POST[\"phone\"];\n$address = $_POST[\"address\"];\nmysql_query(\"INSERT INTO address_book (name, phone, address )\n\t\tVALUES( '$name', '$phone', '$address')\");\n}\n\n$result = mysql_query(\"SELECT * FROM address_book\");\nmakeTable($result);\n\nfunction makeTable($result)\n{\necho \"&lt;table border='1'&gt;\";\n\/\/\u8a2d\u5b9aTitle\necho \"&lt;tr&gt;&lt;td&gt;sid&lt;\/td&gt;\";\necho \"&lt;td&gt;name&lt;\/td&gt;\";\necho \"&lt;td&gt;phone&lt;\/td&gt;\";\necho \"&lt;td&gt;address&lt;\/td&gt;\";\necho \"&lt;td&gt;&lt;\/td&gt;\";\necho \"&lt;td&gt;&lt;\/td&gt;&lt;\/tr&gt;\";\n\/\/\u8b80\u53d6\u5167\u5bb9\nwhile($row = mysql_fetch_assoc($result)) {\necho \"&lt;tr&gt;&lt;td&gt;$row[sid]&lt;\/td&gt;\";\necho \"&lt;td&gt;$row[name]&lt;\/td&gt;\";\necho \"&lt;td&gt;$row[phone]&lt;\/td&gt;\";\necho \"&lt;td&gt;$row[address]&lt;\/td&gt;\";\necho \"&lt;td&gt;&lt;a href=add_mysql.php?op=del&amp;sid=$row[sid]&gt;del&lt;\/a&gt;&lt;\/td&gt;\";\necho \"&lt;td&gt;&lt;a href=update.php?sid=$row[sid]&amp;name=$row[name]&amp;phone=$row[phone]&amp;address=$row[address]&gt;update&lt;\/a&gt;&lt;\/td&gt;&lt;\/tr&gt;\";\n}\necho \"&lt;\/table&gt;\";\n}\n?&gt;<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>&lt;form action=\"\" method=\"post\" name=\"form1&#8243;&gt;&lt;br&gt; Input address book data:&lt;br&gt; name:&lt;input name=\"name\" type=\"text\" value=\"\"&gt;&lt;br&gt; phone:&lt;input name=\"phone\" type=\"text\" value=\"\"&gt;&lt;br&gt; address:&lt;input name=\"address\" type=\"text\" value=\"\"&gt;&lt;br&gt; &lt;input name=\"submit\" type=\"submit\" value=\"add\"&gt;&lt;br&gt; &lt;?php mysql_connect(&#8216;localhost&#8217;,&#8217;root&#8217;,&#8217;student&#8217;) or die(&#8220;connect error!\"); mysql_select_db(&#8216;phone&#8217;) or die(&#8220;db error\"); mysql_query(&#8220;SET NAMES &#8216;utf8&#8242;\"); mysql_query(&#8220;CREATE TABLE `address_book` ( `sid` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 20 ) NOT &hellip; <a href=\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php\" class=\"more-link\">\u95b1\u8b80\u5168\u6587 <span class=\"screen-reader-text\">php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php<\/span> <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_mi_skip_tracking":false},"categories":[4],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v19.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php - \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-\u9023\u63a5\u7bc4\u4f8b-add_mysql-php\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php - \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)\" \/>\n<meta property=\"og:description\" content=\"&lt;form action=&quot;&quot; method=&quot;post&quot; name=&quot;form1&quot;&gt;&lt;br&gt; Input address book data:&lt;br&gt; name:&lt;input name=&quot;name&quot; type=&quot;text&quot; value=&quot;&quot;&gt;&lt;br&gt; phone:&lt;input name=&quot;phone&quot; type=&quot;text&quot; value=&quot;&quot;&gt;&lt;br&gt; address:&lt;input name=&quot;address&quot; type=&quot;text&quot; value=&quot;&quot;&gt;&lt;br&gt; &lt;input name=&quot;submit&quot; type=&quot;submit&quot; value=&quot;add&quot;&gt;&lt;br&gt; &lt;?php mysql_connect(&#039;localhost&#039;,&#039;root&#039;,&#039;student&#039;) or die(&quot;connect error!&quot;); mysql_select_db(&#039;phone&#039;) or die(&quot;db error&quot;); mysql_query(&quot;SET NAMES &#039;utf8&#039;&quot;); mysql_query(&quot;CREATE TABLE `address_book` ( `sid` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 20 ) NOT &hellip; \u95b1\u8b80\u5168\u6587 php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php &rarr;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-\u9023\u63a5\u7bc4\u4f8b-add_mysql-php\" \/>\n<meta property=\"og:site_name\" content=\"\u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)\" \/>\n<meta property=\"article:published_time\" content=\"2013-07-02T03:29:14+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Chifu\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cflin.com\/wordpress\/#website\",\"url\":\"https:\/\/cflin.com\/wordpress\/\",\"name\":\"\u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)\",\"description\":\"\u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed python \u8ab2\u7a0b\u76f8\u95dc\u8cc7\u6599\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cflin.com\/wordpress\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php#webpage\",\"url\":\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php\",\"name\":\"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php - \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)\",\"isPartOf\":{\"@id\":\"https:\/\/cflin.com\/wordpress\/#website\"},\"datePublished\":\"2013-07-02T03:29:14+00:00\",\"dateModified\":\"2013-07-02T03:29:14+00:00\",\"author\":{\"@id\":\"https:\/\/cflin.com\/wordpress\/#\/schema\/person\/fcc9937e50465bfaa039229ad12d89aa\"},\"breadcrumb\":{\"@id\":\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u9996\u9801\",\"item\":\"https:\/\/cflin.com\/wordpress\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/cflin.com\/wordpress\/#\/schema\/person\/fcc9937e50465bfaa039229ad12d89aa\",\"name\":\"Chifu\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"zh-TW\",\"@id\":\"https:\/\/cflin.com\/wordpress\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/83c3d40c89fb05d334f2a3eddcfb4ac7?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/83c3d40c89fb05d334f2a3eddcfb4ac7?s=96&d=mm&r=g\",\"caption\":\"Chifu\"},\"sameAs\":[\"http:\/\/cflin.com\"],\"url\":\"https:\/\/cflin.com\/wordpress\/author\/daky\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php - \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cflin.com\/wordpress\/278\/phpmysql-\u9023\u63a5\u7bc4\u4f8b-add_mysql-php","og_locale":"zh_TW","og_type":"article","og_title":"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php - \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)","og_description":"&lt;form action=\"\" method=\"post\" name=\"form1\"&gt;&lt;br&gt; Input address book data:&lt;br&gt; name:&lt;input name=\"name\" type=\"text\" value=\"\"&gt;&lt;br&gt; phone:&lt;input name=\"phone\" type=\"text\" value=\"\"&gt;&lt;br&gt; address:&lt;input name=\"address\" type=\"text\" value=\"\"&gt;&lt;br&gt; &lt;input name=\"submit\" type=\"submit\" value=\"add\"&gt;&lt;br&gt; &lt;?php mysql_connect('localhost','root','student') or die(\"connect error!\"); mysql_select_db('phone') or die(\"db error\"); mysql_query(\"SET NAMES 'utf8'\"); mysql_query(\"CREATE TABLE `address_book` ( `sid` INT( 5 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 20 ) NOT &hellip; \u95b1\u8b80\u5168\u6587 php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php &rarr;","og_url":"https:\/\/cflin.com\/wordpress\/278\/phpmysql-\u9023\u63a5\u7bc4\u4f8b-add_mysql-php","og_site_name":"\u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)","article_published_time":"2013-07-02T03:29:14+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Chifu","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/cflin.com\/wordpress\/#website","url":"https:\/\/cflin.com\/wordpress\/","name":"\u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)","description":"\u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed python \u8ab2\u7a0b\u76f8\u95dc\u8cc7\u6599","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cflin.com\/wordpress\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-TW"},{"@type":"WebPage","@id":"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php#webpage","url":"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php","name":"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php - \u53f0\u5927\u7cfb\u7d71\u8a13\u7df4\u73ed\u8ab2\u7a0b\u7db2\u9801 (\u6797\u5947\u8ce6)","isPartOf":{"@id":"https:\/\/cflin.com\/wordpress\/#website"},"datePublished":"2013-07-02T03:29:14+00:00","dateModified":"2013-07-02T03:29:14+00:00","author":{"@id":"https:\/\/cflin.com\/wordpress\/#\/schema\/person\/fcc9937e50465bfaa039229ad12d89aa"},"breadcrumb":{"@id":"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cflin.com\/wordpress\/278\/phpmysql-%e9%80%a3%e6%8e%a5%e7%af%84%e4%be%8b-add_mysql-php#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/cflin.com\/wordpress"},{"@type":"ListItem","position":2,"name":"php+mysql \u9023\u63a5\u7bc4\u4f8b add_mysql.php"}]},{"@type":"Person","@id":"https:\/\/cflin.com\/wordpress\/#\/schema\/person\/fcc9937e50465bfaa039229ad12d89aa","name":"Chifu","image":{"@type":"ImageObject","inLanguage":"zh-TW","@id":"https:\/\/cflin.com\/wordpress\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/83c3d40c89fb05d334f2a3eddcfb4ac7?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/83c3d40c89fb05d334f2a3eddcfb4ac7?s=96&d=mm&r=g","caption":"Chifu"},"sameAs":["http:\/\/cflin.com"],"url":"https:\/\/cflin.com\/wordpress\/author\/daky"}]}},"_links":{"self":[{"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/posts\/278"}],"collection":[{"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/comments?post=278"}],"version-history":[{"count":0,"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/posts\/278\/revisions"}],"wp:attachment":[{"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/media?parent=278"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/categories?post=278"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cflin.com\/wordpress\/wp-json\/wp\/v2\/tags?post=278"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}