PHP\u8fde\u63a5\u6570\u636e\u5e93\u7c7b<\/p>\n
\r\nClass MySQLDB\r\n{\r\nvar $host;\r\nvar $user;\r\nvar $passwd;\r\nvar $database;\r\nvar $conn;\r\n\/\/\u5229\u7528\u6784\u9020\u51fd\u6570\u5b9e\u73b0\u53d8\u91cf\u521d\u59cb\u5316\r\n\/\/\u540c\u65f6\u8fde\u63a5\u6570\u636e\u5e93\u64cd\u4f5c\r\nfunction MySQLDB($host,$user,$password,$database)\r\n{\r\n$this->host = $host;\r\n$this->user = $user;\r\n$this->passwd = $password;\r\n$this->database = $database;\r\n$this->conn=mysql_connect($this->host, $this->user,$this->passwd) or die("Could not connect to $this->host");\r\nmysql_select_db($this->database,$this->conn) or die("Could not switch to database $this->database");\r\nmysql_query("set names 'gbk'");\r\n}\r\n\/\/\u8be5\u51fd\u6570\u7528\u6765\u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\r\nfunction Close()\r\n{\r\nMySQL_close($this->conn);\r\n}\r\n\r\n\/\/\u8be5\u51fd\u6570\u5b9e\u73b0\u6570\u636e\u5e93\u67e5\u8be2\u64cd\u4f5c\r\nfunction Query($queryStr)\r\n{\r\n$res =Mysql_query($queryStr, $this->conn) or die("Could not query database");\r\nreturn $res;\r\n}\r\n\r\n\/\/\u8be5\u51fd\u6570\u8fd4\u56de\u8bb0\u5f55\u96c6\r\nfunction getRows($res)\r\n{\r\n $rowno = 0;\r\n $rowno = MySQL_num_rows($res);\r\n if($rowno>0)\r\n {\r\n for($row=0;$row<$rowno;$row++ )\r\n {\r\n $rows[$row]=MySQL_fetch_array($res);\r\n \/\/\u672c\u6765\u4e3aMySQL_fetch_row,\u4f46\u662f\u4e0d\u80fd\u4ee5\u6570\u7ec4\u7684\u65b9\u5f0f\u6765\u63d0\u53d6,\u53ea\u80fd\u7528\u7d22\u5f15\r\n \/\/\u8fd9\u6837\u53ef\u4ee5\u7528\u7d22\u5f15\u548c\u540d\u79f0\uff0c\u66f4\u4e3a\u65b9\u4fbf\r\n }\r\n return $rows;\r\n }\r\n }\r\n\r\n\/\/\u8be5\u51fd\u6570\u53d6\u56de\u6570\u636e\u5e93\u8bb0\u5f55\u6570\r\n\r\nfunction getRowsNum($res)\r\n{\r\n $rowno = 0;\r\n $rowno = mysql_num_rows($res);\r\n return $rowno;\r\n}\r\n\r\n\/\/\u8be5\u51fd\u6570\u8fd4\u56de\u6570\u636e\u5e93\u8868\u5b57\u6bb5\u6570\r\nfunction getFieldsNum($res)\r\n\r\n{\r\n $fieldno = 0;\r\n $fieldno = mysql_num_fields($res);\r\n return $fieldno;\r\n}\r\n\r\n\/\/\u8be5\u51fd\u6570\u8fd4\u56de\u6570\u636e\u5e93\u8868\u5b57\u6bb5\u540d\u79f0\u96c6\r\nfunction getFields($res)\r\n{\r\n$fno = $this->getFieldsNum($res);\r\n if($fno>0)\r\n {\r\n for($i=0;$i<$fno;$i++ )\r\n {\r\n $fs[$i]=MySQL_field_name($res,$i);\/\/\u53d6\u7b2ci\u4e2a\u5b57\u6bb5\u7684\u540d\u79f0\r\n }\r\n return $fs;\r\n }\r\n}\r\n}\r\n<\/pre>\n\u4e0b\u9762\u4e3a\u5b9e\u4f8b<\/p>\n
\r\n$SqlDB = new MySQLDB("127.0.0.1","root","123456","message_book");\r\n$sql = "select * from ad_guestbook";\r\n$result = $SqlDB->Query($sql);\/\/\u67e5\u8be2\r\n$rs = $SqlDB->getRows($result);\/\/\u83b7\u5f97\u8bb0\u5f55\u96c6\r\n$num = $SqlDB->getRowsNum($result);\/\/\u83b7\u5f97\u8bb0\u5f55\u6570\r\n$name = $SqlDB->getFields($result);\r\n$namenum = $SqlDB->getFieldsNum($result);\r\n\r\nfor($i=0;$i<$num;$i++){\r\n\r\n echo ($rs[$i]["id"])." " .($rs[$i]["typeid"]).($rs[$i]["title"])." "\r\n .($rs[$i]["content"])." ".($rs[$i]["name"])." ".($rs[$i]["time"])." "\r\n .($rs[$i]["typeid"])." ".($rs[$i]["time_1"])."<p>";\r\n}\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"PHP\u8fde\u63a5\u6570\u636e\u5e93\u7c7b Class MySQLDB { var $host; var $user; var $pa […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-601","post","type-post","status-publish","format-standard","hentry","category-code_related"],"_links":{"self":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/posts\/601","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/comments?post=601"}],"version-history":[{"count":1,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/posts\/601\/revisions"}],"predecessor-version":[{"id":5261,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/posts\/601\/revisions\/5261"}],"wp:attachment":[{"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/media?parent=601"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/categories?post=601"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kyle.ai\/blog\/wp-json\/wp\/v2\/tags?post=601"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}