\u7ecf\u5e38\u4f7f\u7528php\u64cd\u4f5cmysql\u65f6\uff0c\u5927\u91cf\u8f93\u5165mysql\u8bed\u53e5\u662f\u6bd4\u8f83\u9ebb\u70e6\u7684<\/p>\n
\u6240\u4ee5\u53ef\u4ee5\u4f7f\u7528\u5c01\u88c5\u7684api\u8fdb\u884c\u64cd\u4f5cmysql\uff0c\u80fd\u591f\u63d0\u9ad8\u6548\u7387\uff0c\u907f\u514d\u51fa\u9519<\/p>\n
MySqlHelper\u7c7b<\/p>\n
<?php \r\n define('DB_HOST', 'localhost'); \r\n define('DB_USER', 'root'); \r\n define('DB_PWD', ''); \r\n define('DB_CHARSET', 'UTF8'); \r\n define('DB_DBNAME', 'incircle'); \r\n \r\n\r\nclass MySqlHelper{ \r\n \/** \r\n * \u8fde\u63a5MYSQL\u51fd\u6570 \r\n * \u8fde\u63a5MYSQL\u51fd\u6570,\u901a\u8fc7\u5e38\u91cf\u7684\u5f62\u5f0f\u6765\u8fde\u63a5\u6570\u636e\u5e93 \r\n * \u81ea\u5b9a\u4e49\u914d\u7f6e\u6587\u4ef6\uff0c\u914d\u7f6e\u6587\u4ef6\u4e2d\u81ea\u5b9a\u4e49\u5e38\u91cf\uff0c\u5305\u542b\u9700\u8981\u4f7f\u7528\u7684\u4fe1\u606f \r\n * @return resource \r\n *\/ \r\n function connect (){ \r\n \/\/\u8fde\u63a5mysql \r\n $link=@mysql_connect(DB_HOST,DB_USER,DB_PWD) or die ('\u6570\u636e\u5e93\u8fde\u63a5\u5931\u8d25<br\/>ERROR '.mysql_errno().':'.mysql_error()); \r\n \/\/\u8bbe\u7f6e\u5b57\u7b26\u96c6 \r\n mysql_set_charset(DB_CHARSET); \r\n \/\/\u6253\u5f00\u6307\u5b9a\u7684\u6570\u636e\u5e93 \r\n mysql_select_db(DB_DBNAME) or die('\u6307\u5b9a\u7684\u6570\u636e\u5e93\u6253\u5f00\u5931\u8d25'); \r\n return $link; \r\n } \r\n \r\n \/** \r\n * \u63d2\u5165\u8bb0\u5f55\u7684\u64cd\u4f5c \r\n * @param array $array \r\n * @param string $table \r\n * @return boolean \r\n *\/ \r\n function insert($array,$table){ \r\n $keys=join(',',array_keys($array)); \r\n $values=\"'\".join(\"','\", array_values($array)).\"'\"; \r\n $sql=\"insert {$table}({$keys}) VALUES ({$values})\"; \r\n $res=mysql_query($sql); \r\n if($res){ \r\n return mysql_insert_id(); \r\n }else{ \r\n return false; \r\n } \r\n } \r\n \r\n \/** \r\n * MYSQL\u66f4\u65b0\u64cd\u4f5c \r\n * @param array $array \r\n * @param string $table \r\n * @param string $where \r\n * @return number|boolean \r\n *\/ \r\n function update($array,$table,$where=null){ \r\n foreach ($array as $key=>$val){ \r\n $sets=$key.\"='\".$val.\"',\"; \r\n } \r\n $sets=rtrim($sets,','); \/\/\u53bb\u6389SQL\u91cc\u7684\u6700\u540e\u4e00\u4e2a\u9017\u53f7 \r\n $where=$where==null?'':' WHERE '.$where; \r\n $sql=\"UPDATE {$table} SET {$sets} {$where}\"; \r\n $res=mysql_query($sql); \r\n if ($res){ \r\n return mysql_affected_rows(); \r\n }else { \r\n return false; \r\n } \r\n } \r\n \r\n \/** \r\n * \u5220\u9664\u8bb0\u5f55\u7684\u64cd\u4f5c \r\n * @param string $table \r\n * @param string $where \r\n * @return number|boolean \r\n *\/ \r\n function delete($table,$where=null){ \r\n $where=$where==null?'':' WHERE '.$where; \r\n $sql=\"DELETE FROM {$table}{$where}\"; \r\n $res=mysql_query($sql); \r\n if ($res){ \r\n return mysql_affected_rows(); \r\n }else { \r\n return false; \r\n } \r\n } \r\n \r\n \/** \r\n * \u67e5\u8be2\u4e00\u6761\u8bb0\u5f55 \r\n * @param string $sql \r\n * @param string $result_type \r\n * @return boolean \r\n *\/ \r\n function fetchOne($sql,$result_type=MYSQL_ASSOC){ \r\n $result=mysql_query($sql); \r\n if ($result && mysql_num_rows($result)>0){ \r\n return mysql_fetch_array($result,$result_type); \r\n }else { \r\n return false; \r\n } \r\n } \r\n \r\n \/** \r\n * \u5f97\u5230\u8868\u4e2d\u7684\u6240\u6709\u8bb0\u5f55 \r\n * @param string $sql \r\n * @param string $result_type \r\n * @return boolean \r\n *\/ \r\n function fetchAll($sql,$result_type=MYSQL_ASSOC){ \r\n $result=mysql_query($sql); \r\n if ($result && mysql_num_rows($result)>0){ \r\n while ($row=mysql_fetch_array($result,$result_type)){ \r\n $rows[]=$row; \r\n } \r\n return $rows; \r\n }else { \r\n return false; \r\n } \r\n } \r\n \r\n \/**\u53d6\u5f97\u7ed3\u679c\u96c6\u4e2d\u7684\u8bb0\u5f55\u7684\u6761\u6570 \r\n * @param string $sql \r\n * @return number|boolean \r\n *\/ \r\n function getTotalRows($sql){ \r\n $result=mysql_query($sql); \r\n if($result){ \r\n return mysql_num_rows($result); \r\n }else { \r\n return false; \r\n } \r\n } \r\n \r\n \/**\u91ca\u653e\u7ed3\u679c\u96c6 \r\n * @param resource $result \r\n * @return boolean \r\n *\/ \r\n function freeResult($result){ \r\n return mysql_free_result($result); \r\n } \r\n \r\n \/**\u65ad\u5f00MYSQL \r\n * @param resource $link \r\n * @return boolean \r\n *\/ \r\n function close($link=null){ \r\n return mysql_close($link); \r\n } \r\n \r\n \/**\u5f97\u5230\u5ba2\u6237\u7aef\u7684\u4fe1\u606f \r\n * @return string \r\n *\/ \r\n function getClientInfo(){ \r\n return mysql_get_client_info(); \r\n } \r\n \r\n \/**\u5f97\u5230MYSQL\u670d\u52a1\u5668\u7aef\u7684\u4fe1\u606f \r\n * @return string \r\n *\/ \r\n function getServerInfo($link=null){ \r\n return mysql_get_server_info($link); \r\n } \r\n\t\r\n \/**\u5f97\u5230\u4e3b\u673a\u7684\u4fe1\u606f \r\n * @return string \r\n *\/ \r\n function getHostInfo($link=null){ \r\n return mysql_get_host_info($link); \r\n } \r\n \r\n \/**\u5f97\u5230\u534f\u8bae\u4fe1\u606f \r\n * @return string \r\n *\/ \r\n function getProtoInfo($link=null){ \r\n return mysql_get_proto_info($link); \r\n } \r\n} \r\n?><\/pre>\n\u64cd\u4f5c\u6d4b\u8bd5\u811a\u672c\uff1a<\/p>\n
<?php\r\n require_once 'MySqlHelper.php'; \r\n\r\n $db = new MySqlHelper(); \r\n\t\r\n\t\/\/ \u8fde\u63a5\u6570\u636e\u5e93\r\n $link = $db->connect(); \r\n\t\r\n\t\/\/ \u8868\u540d\u79f0\r\n\t$table = \"rank\";\r\n\t\r\n\t\/\/ \u5220\u9664\u6240\u6709\u6570\u636e\r\n\t$db->delete($table);\r\n\t \r\n\t\/\/ \u63d2\u5165\u6570\u636e\r\n\t$array1 = array(\r\n\t\t\"name\"=>\"wangchong1\",\r\n\t\t\"score\"=>100\r\n\t);\r\n\t$db->insert($array1, $table);\r\n\t\r\n\t\/\/ \u63d2\u5165\u6570\u636e\r\n\t$array2 = array(\r\n\t\t\"name\"=>\"wangchong2\",\r\n\t\t\"score\"=>200\r\n\t);\r\n\t$db->insert($array2, $table);\r\n\t\r\n\t\/\/ \u63d2\u5165\u6570\u636e\r\n\t$array3 = array(\r\n\t\t\"name\"=>\"wangchong3\",\r\n\t\t\"score\"=>300\r\n\t);\r\n\t$db->insert($array3, $table);\r\n\t\r\n\t\/\/ \u5220\u9664\u6307\u5b9a\u6570\u636e\r\n\t$db->delete($table, \"score=200\");\r\n\t\t\r\n\t\/\/ \u67e5\u627e\u5e76\u6839\u636escore\u5012\u5e8f\u6392\u5e8f\u6240\u6709\u6570\u636e\r\n\t$sql=\"SELECT * FROM {$table} ORDER BY score DESC\"; \r\n $rows = $db->fetchAll($sql); \r\n print_r($rows); \r\n\t\r\n\t\/\/ \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\r\n\t$db->close($link);\r\n?>\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"\u7ecf\u5e38\u4f7f\u7528php\u64cd\u4f5cmysql\u65f6\uff0c\u5927\u91cf\u8f93\u5165mysql\u8bed\u53e5\u662f\u6bd4\u8f83\u9ebb\u70e6\u7684 \u6240\u4ee5\u53ef\u4ee5\u4f7f\u7528 … \u7ee7\u7eed\u9605\u8bfb