\u524d\u53f0html+js\u90e8\u5206<\/p>\n
<!DOCTYPE html>\r\n<html>\r\n<head>\r\n\t<title>\u6dd8\u5b9d\u7b80\u6613\u540e\u53f0<\/title>\r\n\t<meta charset=\"utf-8\">\r\n\t<script type=\"text\/javascript\" src=\"http:\/\/cdn.static.runoob.com\/libs\/jquery\/1.10.2\/jquery.min.js\"><\/script>\r\n<\/head>\r\n<body>\r\n\r\n<p>\u5b9d\u8d1d\u540d:<input type=\"text\" name=\"\"><\/p>\r\n<p>\u4ef7\u683c:<input type=\"text\" name=\"\"><\/p>\r\n<p>\u79cd\u7c7b:\r\n\t<select>\r\n\t\t<option value=\"0\">\u8bf7\u9009\u62e9\u79cd\u7c7b<\/option>\r\n\t\t<option value=\"1\">\u5e3d\u5b50<\/option>\r\n\t\t<option value=\"2\">\u4e0a\u8863<\/option>\r\n\t\t<option value=\"3\">\u88e4\u5b50<\/option>\r\n\t\t<option value=\"4\">\u978b\u5b50<\/option>\r\n\t\t<option value=\"5\">\u5316\u5986\u54c1<\/option>\r\n\t<\/select>\r\n<\/p>\r\n<p>\u6570\u91cf:<input type=\"text\"><\/p>\r\n<p><input type=\"button\"\tvalue=\"\u4e0a\u4f20\" name=\"\"><\/p>\r\n\r\n<!-- \u6dfb\u52a0\u6570\u636e -->\r\n<table border=\"1px solid #000\">\r\n\t<tr id=\"title_tr\">\r\n\t\t<td>\u5b9d\u8d1d\u540d<\/td>\r\n\t\t<td>\u4ef7\u683c<\/td>\r\n\t\t<td>\u79cd\u7c7b<\/td>\r\n\t\t<td>\u6570\u91cf<\/td>\r\n\t<\/tr>\r\n<\/table>\r\n\r\n<script type=\"text\/javascript\">\r\n\t\/\/ \u4e00\u3002\u5237\u65b0\u9875\u9762\u8868\u683c\r\n\tfunction updateTable() {\r\n\t\t\/\/ \u53d1\u8d77\u8bf7\u6c42\uff0c\u5237\u65b0\u8868\u683c sqltype\uff1a1=\u300b\u63d2\u5165 2=\u300b\u67e5\u8be2\r\n\t\tvar param = {'sqltype':2};\r\n\r\n\t\t\/\/ \u6e05\u7a7atable\u8868\u683c \r\n\t\t$('tr').not('#title_tr').remove();\r\n\r\n\t\t$.post('taobao.php',param,function(obj){\r\n\t\t\t\/\/ console.log(obj);\r\n\t\t\tvar data = JSON.parse(obj);\r\n\t\t\t\/\/ \u8bf7\u6c42\u6210\u529f \r\n\t\t\tif (data.code == 1) {\r\n\t\t\t\tvar goods = data.data;\r\n\t\t\t\t\/\/ console.log(goods);\r\n\t\t\t\t\/\/ \u6dfb\u52a0\u6570\u636e\u5230\u754c\u9762\r\n\t\t\t\tfor (var i = 0; i < goods.length; i++) {\r\n\t\t\t\t\t\/\/ \u521b\u5efatr\r\n\t\t\t\t\tvar $tr = $('<tr><\/tr>');\r\n\t\t\t\t\t\/\/ \u521b\u5efatname \r\n\t\t\t\t\t$('<td><\/td>').html(goods[i].tname).appendTo($tr);\r\n\t\t\t\t\t\/\/ \u4ef7\u683c\r\n\t\t\t\t\t$('<td><\/td>').html(goods[i].tprice).appendTo($tr);\r\n\r\n\t\t\t\t\t\/\/ ttype \r\n\t\t\t\t\t\/\/ console.log(goods[i].ttype);\r\n\t\t\t\t\tvar str = '';\r\n\t\t\t\t\tswitch(goods[i].ttype){\r\n\t\t\t\t\t\tcase '1':\r\n\t\t\t\t\t\t\tstr = '\u5e3d\u5b50';\r\n\t\t\t\t\t\t\tbreak;\r\n\t\t\t\t\t\tcase '2':\r\n\t\t\t\t\t\t\tstr = '\u4e0a\u8863';\r\n\t\t\t\t\t\t\tbreak;\r\n\t\t\t\t\t\tcase '3':\r\n\t\t\t\t\t\t\tstr = '\u88e4\u5b50';\r\n\t\t\t\t\t\t\tbreak;\r\n\t\t\t\t\t\tcase '4':\r\n\t\t\t\t\t\t\tstr = '\u978b\u5b50';\r\n\t\t\t\t\t\t\tbreak;\r\n\t\t\t\t\t\tcase '5':\r\n\t\t\t\t\t\t\tstr = '\u5316\u5986\u54c1';\r\n\t\t\t\t\t\t\tbreak;\r\n\t\t\t\t\t}\r\n\r\n\t\t\t\t\t$('<td><\/td>').html(str).appendTo($tr);\r\n\t\t\t\t\t\/\/ tnum\r\n\t\t\t\t\t$('<td><\/td>').html(goods[i].tnum).appendTo($tr);\r\n\r\n\t\t\t\t\t\/\/ \u6dfb\u52a0\u5230table\r\n\t\t\t\t\t$tr.appendTo('table');\r\n\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t})\r\n\t}\r\n\t\/\/ \u8c03\u7528\u5237\u65b0\u8868\u683c\r\n\tupdateTable();\r\n\r\n\t\/\/ \u4e8c\u3002\u4e0a\u4f20\u64cd\u4f5c\r\n\t\/\/ \u7ed9\u6309\u94ae\u7ed1\u5b9a\u4e0a\u4f20\r\n\t$('input:button').click(function(){\r\n\t\t\/\/ \u62ff\u5230\u5b9d\u8d1d\u540d\r\n\t\tvar tname = $('input').eq(0).val();\r\n\t\t\/\/ \u62ff\u5230\u5b9d\u8d1d\u4ef7\u683c\r\n\t\tvar tprice = $('input').eq(1).val();\r\n\t\t\/\/ \u62ff\u5230\u5b9d\u8d1d\u79cd\u7c7b\r\n\t\tvar ttype = $('select').val();\r\n\t\t\/\/ \u62ff\u5230\u6570\u91cf\r\n\t\tvar tnum = $('input').eq(2).val();\r\n\r\n\t\t\/\/ \u5224\u65ad\u4e0a\u4f20\u5185\u5bb9\u662f\u5426\u5408\u683c\r\n\t\tif (tname == '') {\r\n\t\t\treturn;\r\n\t\t}\r\n\r\n\t\t\/\/ Ajax\u4e0a\u4f20\u6570\u636e\r\n\t\tvar param = {};\r\n\t\tparam.tname = tname;\r\n\t\tparam.tprice = tprice;\r\n\t\tparam.ttype = ttype;\r\n\t\tparam.tnum = tnum;\r\n\t\tparam.sqltype = 1; \/\/ \u63d2\u5165\u64cd\u4f5c\r\n\r\n\t\t$.post('taobao.php',param, function(data){\r\n\t\t\t\/\/ console.log(data.code);\r\n\t\t\tvar obj = JSON.parse(data);\r\n\t\t\t\/\/ console.log(obj.code);\r\n\t\t\tif (obj.code == 1) {\r\n\t\t\t\t\/\/ \u8c03\u7528\u5237\u65b0\u8868\u683c\r\n\t\t\t\tupdateTable();\r\n\t\t\t}\r\n\t\t})\r\n\r\n\t\t\/\/ \u6e05\u7a7a\u8f93\u5165\u5185\u5bb9 \r\n\t\t$('input').eq(0).val('');\r\n\t\t$('input').eq(1).val('');\r\n\t\t$('input').eq(2).val('');\r\n\t\t$('select').val(0);\r\n\t})\r\n<\/script>\r\n\r\n<\/body>\r\n<\/html><\/pre>\n\u540e\u53f0\u90e8\u5206\uff1a\u8fd9\u91cc\u7528php\u5199\u7684\u6a21\u62df\u540e\u53f0<\/p>\n
<?php\r\n\t\r\n\t\/\/ \u94fe\u63a5\u6570\u636e\u5e93\r\n\t$db = mysqli_connect('127.0.0.1','root','','taobao');\r\n\t\/\/ \u5224\u65ad\u662f\u5426\u94fe\u63a5\u6210\u529f\r\n\tif (!mysqli_connect_errno($db)) {\r\n\t\t\/\/ echo \"\u8fde\u63a5\u6210\u529f\";\r\n\t\t\/\/ \u89e3\u51b3\u4e2d\u6587\u4e71\u7801\r\n\t\tmysqli_query($db,\"SET NAMES UTF8\");\r\n\t\t\/\/ \u5224\u65ad\u662f\u67e5\u8be2\u8fd8\u662f\u63d2\u5165\r\n\t\t$sqltype = $_POST['sqltype'];\r\n\t\t\/\/ echo $sqltype;\r\n\t\tif ($sqltype == 1) {\r\n\t\t\t\/\/ \u63d2\u5165\u6570\u636e\r\n\t\t\/*\r\n\t\t\t\/\/ \u65b0\u5efa\u4e00\u4e2a\u53ef\u4ee5\u81ea\u52a8\u589e\u52a0\u987a\u5e8f\u7684\u8868\r\n\t\t\t$sql = \"CREATE TABLE IF NOT EXISTS goods(\r\n\t\t\t\tid INT UNSIGNED\tAUTO_INCREMENT KEY,\r\n\t\t\t\ttname VARCHAR(20) NOT NULL,\r\n\t\t\t\ttprice VARCHAR(20) NOT NULL,\r\n\t\t\t\tttype VARCHAR(20) NOT NULL,\r\n\t\t\t\ttnum VARCHAR(20) NOT NULL\r\n\t\t\t)\";\r\n\t\t\tmysqli_query($db, $sql);\r\n\t\t*\/\t\r\n\t\r\n\t\t\t$tname = $_POST['tname'];\r\n\r\n\t\t\t$tprice = $_POST['tprice'];\r\n\t\t\t$ttype = $_POST['ttype'];\r\n\t\t\t$tnum = $_POST['tnum'];\r\n\t\t\t\/\/ \u5199\u63d2\u5165\u8bed\u53e5\r\n\t\t\t$sql = \"INSERT INTO goods(tname,tprice,ttype,tnum) VALUES ('$tname','$tprice','$ttype','$tnum')\";\r\n\t\t\t\/\/ \u6267\u884c\r\n\t\t\t$result = mysqli_query($db, $sql);\r\n\t\t\t\/\/ \u5224\u65ad\u63d2\u5165\u662f\u5426\u6210\u529f\r\n\t\t\tif ($result) {\r\n\t\t\t\t\/\/ echo \"\u6210\u529f\";\r\n\t\t\t\t\/\/ \u6570\u636e\u63d2\u5165\u6210\u529f\uff0c\u8fd4\u56de\u6210\u529f\r\n\t\t\t\techo json_encode(['code'=>1,'msg'=>'success']);\r\n\t\t\t} else {\r\n\t\t\t\techo \"\u5931\u8d25\";\r\n\t\t\t}\r\n\t\t\t\r\n\t\t} elseif ($sqltype == 2) {\r\n\t\t\t\/\/ \u67e5\u8be2\u6570\u636e\r\n\t\t\t$sql = \"SELECT * FROM goods\";\r\n\t\t\t\/\/ \u6267\u884c\u8bed\u53e5 \r\n\t\t\t$result = mysqli_query($db,$sql);\r\n\t\t\t\/\/ \u6267\u884c\u6210\u529f\r\n\t\t\tif (mysqli_affected_rows($db)) {\r\n\t\t\t\t\/\/ \u58f0\u660e\u6570\u7ec4\r\n\t\t\t\t$arr = [];\r\n\t\t\t\twhile ($row = mysqli_fetch_array($result)) {\r\n\t\t\t\t\t\/\/ \u5c06\u6570\u636e\u653e\u5165\u6570\u7ec4 \r\n\t\t\t\t\tarray_push($arr, $row);\r\n\t\t\t\t}\r\n\t\t\t\t\/\/ \u8fd4\u56de\u6570\u636e\r\n\t\t\t\techo json_encode(['code'=>1,'data'=>$arr]);\r\n\t\t\t}\r\n\t\t}\r\n\t} else {\r\n\t\techo \"\u94fe\u63a5\u5931\u8d25\";\r\n\t}\r\n\r\n?><\/pre>\n\u6b22\u8fce\u5206\u4eab\u672c\u6587\uff0c\u8f6c\u8f7d\u8bf7\u4fdd\u7559\u51fa\u5904\uff1a\u524d\u7aefABC<\/a> » \u6dd8\u5b9d\u7b80\u6613\u540e\u53f0<\/a><\/p>","protected":false},"excerpt":{"rendered":"\u524d\u53f0html+js\u90e8\u5206 <!DOCTYPE html> <html> <head> <title>\u6dd8\u5b9d\u7b80\u6613\u540e\u53f0<\/title> <me […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=\/wp\/v2\/posts\/2720"}],"collection":[{"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2720"}],"version-history":[{"count":1,"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=\/wp\/v2\/posts\/2720\/revisions"}],"predecessor-version":[{"id":2721,"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=\/wp\/v2\/posts\/2720\/revisions\/2721"}],"wp:attachment":[{"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2720"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.qdabc.cn\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}