{"id":199506,"date":"2025-05-03T09:41:52","date_gmt":"2025-05-03T01:41:52","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199506\/"},"modified":"2025-05-03T09:41:52","modified_gmt":"2025-05-03T01:41:52","slug":"ecshop%e9%80%82%e5%ba%94%e5%9c%a8php7%e7%9a%84%e4%bf%ae%e6%94%b9%e6%96%b9%e6%b3%95%e8%a7%a3%e5%86%b3%e6%8a%a5%e9%94%99","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199506\/","title":{"rendered":"ecshop\u9002\u5e94\u5728PHP7\u7684\u4fee\u6539\u65b9\u6cd5\u89e3\u51b3\u62a5\u9519"},"content":{"rendered":"

ecshop\u8fd9\u4e2a\u7cfb\u7edf\uff0c\u5230\u76ee\u524d\u4e5f\u6ca1\u89c1\u600e\u4e48\u63a8\u51fa\u65b0\u7248\u672c\uff0c\u5982\u679c\u662f\u65b0\u9879\u76ee\uff0c\u4e0d\u592a\u5efa\u8bae\u4f7f\u7528\u5b83\u3002\u4e0d\u8fc7\uff0c\u56e0\u4e3a\u6211\u4e00\u76f4\u4ee5\u6765\u90fd\u5728\u4f7f\u7528\u4e2d\uff0c\u6240\u4ee5\u4e0d\u5f97\u4e0d\u66f4\u6539\u8ba9\u5176\u9002\u5e94PHP\u65b0\u7248\u672c\u3002\u73b0\u5728PHP 7\u5df2\u7ecf\u51fa\u53d1\u884c\u7248\u4e86\uff0c\u6240\u4ee5\u66f4\u6539\u6765\u7ee7\u7eed\u4f7f\u7528\u5427\u3002\u5177\u4f53\u7684\u66f4\u6539\u6709\u4ee5\u4e0b\u65b9\u9762\uff1a<\/p>\n

\uff081\uff09\u5c06mysql\u6269\u5c55\u7684\u4f7f\u7528\u66ff\u6362\u6389\uff0c\u6539\u4e3a\u4f7f\u7528mysqli\u6216pdo\uff1a<\/p>\n

\u4ecephp5.5\u5f00\u59cb\uff0cmysql\u6269\u5c55\u5c06\u5e9f\u5f03\u4e86\u3002<\/p>\n

\u5177\u4f53\u66f4\u6539\u7684\u6587\u4ef6\u5728\u4e8eincludes\/cls_mysql.php\u3002\u8fd9\u662f\u4e2a\u4e0d\u5c0f\u7684\u5de5\u7a0b\uff0c\u6587\u4ef6\u4ee3\u7801\u592a\u957f\u2026\u2026<\/p>\n

<\/span> <\/p>\n

\r\nif<\/span> (!defined<\/span>('DITAN_ECS'))\r\n{\r\n    <\/span>die<\/span>('Hacking attempt');\r\n}\r\n\r\n<\/span>class<\/span> cls_mysql\r\n{\r\n    <\/span>var<\/span> $link_id<\/span>    = NULL<\/span>;\r\n\r\n    <\/span>var<\/span> $settings<\/span>   = array<\/span>();\r\n\r\n    <\/span>var<\/span> $queryCount<\/span> = 0;\r\n    <\/span>var<\/span> $queryTime<\/span>  = '';\r\n    <\/span>var<\/span> $queryLog<\/span>   = array<\/span>();\r\n\r\n    <\/span>var<\/span> $max_cache_time<\/span> = 300; \/\/<\/span> \u6700\u5927\u7684\u7f13\u5b58\u65f6\u95f4\uff0c\u4ee5\u79d2\u4e3a\u5355\u4f4d<\/span>\r\n\r\n    var<\/span> $cache_data_dir<\/span> = 'temp\/query_caches\/';\r\n    <\/span>var<\/span> $root_path<\/span>      = '';\r\n\r\n    <\/span>var<\/span> $error_message<\/span>  = array<\/span>();\r\n    <\/span>var<\/span> $platform<\/span>       = '';\r\n    <\/span>var<\/span> $version<\/span>        = '';\r\n    <\/span>var<\/span> $dbhash<\/span>         = '';\r\n    <\/span>var<\/span> $starttime<\/span>      = 0;\r\n    <\/span>var<\/span> $timeline<\/span>       = 0;\r\n    <\/span>var<\/span> $timezone<\/span>       = 0;\r\n    <\/span>\/\/<\/span> \u4e8b\u52a1\u6307\u4ee4\u6570<\/span>\r\n    protected<\/span> $transTimes<\/span> = 0;\r\n\r\n    <\/span>var<\/span> $mysql_config_cache_file_time<\/span> = 0;\r\n\r\n    <\/span>var<\/span> $mysql_disable_cache_tables<\/span> = array<\/span>(); \/\/<\/span> \u4e0d\u5141\u8bb8\u88ab\u7f13\u5b58\u7684\u8868\uff0c\u9047\u5230\u5c06\u4e0d\u4f1a\u8fdb\u884c\u7f13\u5b58<\/span>\r\n\r\n    function<\/span> __construct($dbhost<\/span>, $dbuser<\/span>, $dbpw<\/span>, $dbname<\/span> = '', $charset<\/span> = 'gbk', $pconnect<\/span> = 0, $quiet<\/span> = 0)\r\n    {\r\n        <\/span>$this<\/span>->cls_mysql($dbhost<\/span>, $dbuser<\/span>, $dbpw<\/span>, $dbname<\/span>, $charset<\/span>, $pconnect<\/span>, $quiet<\/span>);\r\n    }\r\n\r\n    <\/span>function<\/span> cls_mysql($dbhost<\/span>, $dbuser<\/span>, $dbpw<\/span>, $dbname<\/span> = '', $charset<\/span> = 'gbk', $pconnect<\/span> = 0, $quiet<\/span> = 0)\r\n    {\r\n        <\/span>if<\/span> (defined<\/span>('EC_CHARSET'))\r\n        {\r\n            <\/span>$charset<\/span> = strtolower<\/span>(str_replace<\/span>('-', '', EC_CHARSET));\r\n        }\r\n\r\n        <\/span>if<\/span> (defined<\/span>('ROOT_PATH') && !$this<\/span>->root_path)\r\n        {\r\n            <\/span>$this<\/span>->root_path = ROOT_PATH;\r\n        }\r\n\r\n        <\/span>if<\/span> ($quiet<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->connect($dbhost<\/span>, $dbuser<\/span>, $dbpw<\/span>, $dbname<\/span>, $charset<\/span>, $pconnect<\/span>, $quiet<\/span>);\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$this<\/span>->settings = array<\/span>(\r\n                                    <\/span>'dbhost'   => $dbhost<\/span>,\r\n                                    'dbuser'   => $dbuser<\/span>,\r\n                                    'dbpw'     => $dbpw<\/span>,\r\n                                    'dbname'   => $dbname<\/span>,\r\n                                    'charset'  => $charset<\/span>,\r\n                                    'pconnect' => $pconnect<\/span>\r\n                                    );\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> connect($dbhost<\/span>, $dbuser<\/span>, $dbpw<\/span>, $dbname<\/span> = '', $charset<\/span> = 'utf8', $pconnect<\/span> = 0, $quiet<\/span> = 0)\r\n    {\r\n        <\/span>if<\/span> ($pconnect<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->link_id = new<\/span> mysqli('p:'.$dbhost<\/span>, $dbuser<\/span>, $dbpw<\/span>);\r\n            <\/span>if<\/span> ($this<\/span>->link_id->connect_error)\r\n            {\r\n                <\/span>if<\/span> (!$quiet<\/span>)\r\n                {\r\n                    <\/span>$this<\/span>->ErrorMsg(\"Can't pConnect MySQL Server($dbhost<\/span>)!\");\r\n                }\r\n\r\n                <\/span>return<\/span> false<\/span>;\r\n            }\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$this<\/span>->link_id = new<\/span> mysqli($dbhost<\/span>, $dbuser<\/span>, $dbpw<\/span>);\r\n\r\n            <\/span>if<\/span> ($this<\/span>->link_id->connect_error)\r\n            {\r\n                <\/span>if<\/span> (!$quiet<\/span>)\r\n                {\r\n                    <\/span>$this<\/span>->ErrorMsg(\"Can't Connect MySQL Server($dbhost<\/span>)!\");\r\n                }\r\n\r\n                <\/span>return<\/span> false<\/span>;\r\n            }\r\n        }\r\n\r\n        <\/span>$this<\/span>->dbhash  = md5<\/span>($this<\/span>->root_path . $dbhost<\/span> . $dbuser<\/span> . $dbpw<\/span> . $dbname<\/span>);\r\n        <\/span>$this<\/span>->version = $this<\/span>->link_id->server_version;\r\n\r\n        <\/span>\/*<\/span> \u5bf9\u5b57\u7b26\u96c6\u8fdb\u884c\u521d\u59cb\u5316 <\/span>*\/<\/span>\r\n        $this<\/span>->link_id->set_charset($charset<\/span>);\r\n        \r\n        <\/span>$this<\/span>->link_id->query(\"SET sql_mode=''\");\r\n        <\/span>$sqlcache_config_file<\/span> = $this<\/span>->root_path . $this<\/span>->cache_data_dir . 'sqlcache_config_file_' . $this<\/span>->dbhash . '.php';\r\n\r\n        @<\/span>include<\/span>($sqlcache_config_file<\/span>);\r\n\r\n        <\/span>$this<\/span>->starttime = time<\/span>();\r\n\r\n        <\/span>if<\/span> ($this<\/span>->max_cache_time && $this<\/span>->starttime > $this<\/span>->mysql_config_cache_file_time + $this<\/span>->max_cache_time)\r\n        {\r\n            <\/span>if<\/span> ($dbhost<\/span> != '.')\r\n            {\r\n                <\/span>$result<\/span> = $this<\/span>->link_id->query(\"SHOW VARIABLES LIKE 'basedir'\");\r\n                <\/span>$row<\/span> = $result<\/span>->fetch_array(MYSQLI_ASSOC);\r\n                <\/span>$result<\/span>->free();\r\n                <\/span>if<\/span> (!empty<\/span>($row<\/span>['Value']{1}) && $row<\/span>['Value']{1} == ':' && !empty<\/span>($row<\/span>['Value']{2}) && $row<\/span>['Value']{2} == \"\/\")\r\n                {\r\n                    <\/span>$this<\/span>->platform = 'WINDOWS';\r\n                }\r\n                <\/span>else<\/span>\r\n                {\r\n                    <\/span>$this<\/span>->platform = 'OTHER';\r\n                }\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>$this<\/span>->platform = 'WINDOWS';\r\n            }\r\n\r\n            <\/span>if<\/span> ($this<\/span>->platform == 'OTHER' &&\r\n                (<\/span>$dbhost<\/span> != '.' && strtolower<\/span>($dbhost<\/span>) != 'localhost:3306' && $dbhost<\/span> != '127.0.0.1:3306') ||\r\n                date_default_timezone_get() <\/span>== 'UTC')\r\n            {\r\n                <\/span>$result<\/span> = $this<\/span>->link_id->query(\"SELECT UNIX_TIMESTAMP() AS timeline, UNIX_TIMESTAMP('\" . date<\/span>('Y-m-d H:i:s', $this<\/span>->starttime) . \"') AS timezone\");\r\n                <\/span>$row<\/span> = $result<\/span>->fetch_array(MYSQLI_ASSOC);\r\n                <\/span>$result<\/span>->free();\r\n                <\/span>if<\/span> ($dbhost<\/span> != '.' && strtolower<\/span>($dbhost<\/span>) != 'localhost:3306' && $dbhost<\/span> != '127.0.0.1:3306')\r\n                {\r\n                    <\/span>$this<\/span>->timeline = $this<\/span>->starttime - $row<\/span>['timeline'];\r\n                }\r\n                <\/span>if<\/span> (date_default_timezone_get() == 'UTC')\r\n                {\r\n                    <\/span>$this<\/span>->timezone = $this<\/span>->starttime - $row<\/span>['timezone'];\r\n                }\r\n            }\r\n\r\n            <\/span>$content<\/span> = '<' . \"?php\\r\\n\" .\r\n                       '$this->mysql_config_cache_file_time = ' . $this<\/span>->starttime . \";\\r\\n\" .\r\n                       '$this->timeline = ' . $this<\/span>->timeline . \";\\r\\n\" .\r\n                       '$this->timezone = ' . $this<\/span>->timezone . \";\\r\\n\" .\r\n                       '$this->platform = ' . \"'\" . $this<\/span>->platform . \"';\\r\\n?\" . '>';\r\n\r\n            @<\/span>file_put_contents<\/span>($sqlcache_config_file<\/span>, $content<\/span>);\r\n        }\r\n\r\n        <\/span>\/*<\/span> \u9009\u62e9\u6570\u636e\u5e93 <\/span>*\/<\/span>\r\n        if<\/span> ($dbname<\/span>)\r\n        {\r\n            \r\n            <\/span>if<\/span> ($this<\/span>->link_id->select_db($dbname<\/span>) === false<\/span> )\r\n            {\r\n                <\/span>if<\/span> (!$quiet<\/span>)\r\n                {\r\n                    <\/span>$this<\/span>->ErrorMsg(\"Can't select MySQL database($dbname<\/span>)!\");\r\n                }\r\n\r\n                <\/span>return<\/span> false<\/span>;\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>return<\/span> true<\/span>;\r\n            }\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>return<\/span> true<\/span>;\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> select_database($dbname<\/span>)\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->select_db($dbname<\/span>);\r\n    }\r\n\r\n    <\/span>function<\/span> set_mysql_charset($charset<\/span>)\r\n    {\r\n        <\/span>if<\/span> (in_array<\/span>(strtolower<\/span>($charset<\/span>), array<\/span>('gbk', 'big5', 'utf-8', 'utf8')))\r\n        {\r\n            <\/span>$charset<\/span> = str_replace<\/span>('-', '', $charset<\/span>);\r\n        }\r\n        <\/span>$this<\/span>->link_id->set_charset($charset<\/span>);\r\n    }\r\n\r\n    <\/span>function<\/span> fetch_array($query<\/span>, $result_type<\/span> = MYSQLI_ASSOC)\r\n    {\r\n        <\/span>$row<\/span> = $query<\/span>->fetch_array($result_type<\/span>);\r\n        <\/span>$query<\/span>->free();\r\n        <\/span>return<\/span> $row<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> query($sql<\/span>, $type<\/span> = '')\r\n    {\r\n        <\/span>if<\/span> ($this<\/span>->link_id === NULL<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->connect($this<\/span>->settings['dbhost'], $this<\/span>->settings['dbuser'], $this<\/span>->settings['dbpw'], $this<\/span>->settings['dbname'], $this<\/span>->settings['charset'], $this<\/span>->settings['pconnect']);\r\n            <\/span>$this<\/span>->settings = array<\/span>();\r\n        }\r\n\r\n        <\/span>if<\/span> ($this<\/span>->queryCount++ <= 99)\r\n        {\r\n            <\/span>$this<\/span>->queryLog[] = $sql<\/span>;\r\n        }\r\n        <\/span>if<\/span> ($this<\/span>->queryTime == '')\r\n        {\r\n            <\/span>if<\/span> (PHP_VERSION<\/span> >= '5.0.0')\r\n            {\r\n                <\/span>$this<\/span>->queryTime = microtime<\/span>(true<\/span>);\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>$this<\/span>->queryTime = microtime<\/span>();\r\n            }\r\n        }\r\n\r\n        <\/span>\/*<\/span> \u5f53\u5f53\u524d\u7684\u65f6\u95f4\u5927\u4e8e\u7c7b\u521d\u59cb\u5316\u65f6\u95f4\u7684\u65f6\u5019\uff0c\u81ea\u52a8\u6267\u884c ping \u8fd9\u4e2a\u81ea\u52a8\u91cd\u65b0\u8fde\u63a5\u64cd\u4f5c <\/span>*\/<\/span>\r\n        if<\/span> (time<\/span>() > $this<\/span>->starttime + 1)\r\n        {\r\n            <\/span>$this<\/span>->link_id->ping();\r\n        }\r\n\r\n        <\/span>if<\/span> (!($query<\/span> = $this<\/span>->link_id->query($sql<\/span>)) && $type<\/span> != 'SILENT')\r\n        {\r\n            <\/span>$this<\/span>->error_message[]['message'] = 'MySQL Query Error';\r\n            <\/span>$this<\/span>->error_message[]['sql'] = $sql<\/span>;\r\n            <\/span>$this<\/span>->error_message[]['error'] = $this<\/span>->link_id->error;\r\n            <\/span>$this<\/span>->error_message[]['errno'] = $this<\/span>->link_id->errno;\r\n\r\n            <\/span>$this<\/span>->ErrorMsg();\r\n\r\n            <\/span>return<\/span> false<\/span>;\r\n        }\r\n\r\n        <\/span>if<\/span> (defined<\/span>('DEBUG_MODE') && (DEBUG_MODE & 8) == 8)\r\n        {\r\n            <\/span>$logfilename<\/span> = $this<\/span>->root_path . DATA_DIR . '\/mysql_query_' . $this<\/span>->dbhash . '_' . date<\/span>('Y_m_d') . '.log';\r\n            <\/span>$str<\/span> = $sql<\/span> . \"\\n\\n\";\r\n\r\n            <\/span>if<\/span> (PHP_VERSION<\/span> >= '5.0')\r\n            {\r\n                <\/span>file_put_contents<\/span>($logfilename<\/span>, $str<\/span>, FILE_APPEND);\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>$fp<\/span> = @fopen<\/span>($logfilename<\/span>, 'ab+');\r\n                <\/span>if<\/span> ($fp<\/span>)\r\n                {\r\n                    <\/span>fwrite<\/span>($fp<\/span>, $str<\/span>);\r\n                    <\/span>fclose<\/span>($fp<\/span>);\r\n                }\r\n            }\r\n        }\r\n\r\n        <\/span>return<\/span> $query<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> affected_rows()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->affected_rows;\r\n    }\r\n\r\n    <\/span>function<\/span> error()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->error;\r\n    }\r\n\r\n    <\/span>function<\/span> errno()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->errno;\r\n    }\r\n\r\n    <\/span>function<\/span> result($query<\/span>, $row<\/span>)\r\n    {\r\n        <\/span>$query<\/span>->data_seek($row<\/span>);\r\n        <\/span>$result<\/span> = $query<\/span>->fetch_row();\r\n        <\/span>$query<\/span>->free();\r\n        <\/span>return<\/span> $result<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> num_rows($query<\/span>)\r\n    {\r\n        <\/span>return<\/span> $query<\/span>->num_rows;\r\n    }\r\n\r\n    <\/span>function<\/span> num_fields($query<\/span>)\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->field_count;\r\n    }\r\n\r\n    <\/span>function<\/span> free_result($query<\/span>)\r\n    {\r\n        <\/span>return<\/span> $query<\/span>->free();\r\n    }\r\n\r\n    <\/span>function<\/span> insert_id()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->insert_id;\r\n    }\r\n\r\n    <\/span>function<\/span> fetchRow($query<\/span>)\r\n    {\r\n        <\/span>return<\/span> $query<\/span>->fetch_assoc();\r\n    }\r\n\r\n    <\/span>function<\/span> fetch_fields($query<\/span>)\r\n    {\r\n        <\/span>return<\/span> $query<\/span>->fetch_field();\r\n    }\r\n\r\n    <\/span>function<\/span> version()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->version;\r\n    }\r\n\r\n    <\/span>function<\/span> ping()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->ping();\r\n    }\r\n\r\n    <\/span>function<\/span> escape_string($unescaped_string<\/span>)\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->real_escape_string($unescaped_string<\/span>);\r\n    }\r\n\r\n    <\/span>function<\/span> close()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->link_id->close();\r\n    }\r\n\r\n    <\/span>function<\/span> ErrorMsg($message<\/span> = '', $sql<\/span> = '')\r\n    {\r\n        <\/span>if<\/span> ($message<\/span>)\r\n        {\r\n            <\/span>echo<\/span> \"<b>DTXB info<\/b>: $message<\/span>\\n\\n<br \/><br \/>\";\r\n            <\/span>\/\/<\/span>print('<a href=\"http:\/\/faq.comsenz.com\/?type=mysql&dberrno=2003&dberror=Can%27t%20connect%20to%20MySQL%20server%20on\" target=\"_blank\">http:\/\/faq.comsenz.com\/<\/a>');<\/span>\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>echo<\/span> \"<b>MySQL server error report:\";\r\n            <\/span>print_r<\/span>($this<\/span>->error_message);\r\n            <\/span>\/\/<\/span>echo \"<br \/><br \/><a href='http:\/\/faq.comsenz.com\/?type=mysql&dberrno=\" . $this->error_message[3]['errno'] . \"&dberror=\" . urlencode($this->error_message[2]['error']) . \"' target='_blank'>http:\/\/faq.comsenz.com\/<\/a>\";<\/span>\r\n        }\r\n\r\n        <\/span>exit<\/span>;\r\n    }\r\n\r\n<\/span>\/*<\/span> \u4eff\u771f Adodb \u51fd\u6570 <\/span>*\/<\/span>\r\n    function<\/span> selectLimit($sql<\/span>, $num<\/span>, $start<\/span> = 0)\r\n    {\r\n        <\/span>if<\/span> ($start<\/span> == 0)\r\n        {\r\n            <\/span>$sql<\/span> .= ' LIMIT ' . $num<\/span>;\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$sql<\/span> .= ' LIMIT ' . $start<\/span> . ', ' . $num<\/span>;\r\n        }\r\n\r\n        <\/span>return<\/span> $this<\/span>->query($sql<\/span>);\r\n    }\r\n\r\n    <\/span>function<\/span> getOne($sql<\/span>, $limited<\/span> = false<\/span>)\r\n    {\r\n        <\/span>if<\/span> ($limited<\/span> == true<\/span>)\r\n        {\r\n            <\/span>$sql<\/span> = trim<\/span>($sql<\/span> . ' LIMIT 1');\r\n        }\r\n\r\n        <\/span>$res<\/span> = $this<\/span>->query($sql<\/span>);\r\n        <\/span>if<\/span> ($res<\/span> !== false<\/span>)\r\n        {\r\n            <\/span>$row<\/span> = $res<\/span>->fetch_row();\r\n            <\/span>$res<\/span>->free();\r\n            <\/span>if<\/span> ($row<\/span> !== false<\/span>)\r\n            {\r\n                <\/span>return<\/span> $row<\/span>[0];\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>return<\/span> '';\r\n            }\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>return<\/span> false<\/span>;\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> getOneCached($sql<\/span>, $cached<\/span> = 'FILEFIRST')\r\n    {\r\n        <\/span>$sql<\/span> = trim<\/span>($sql<\/span> . ' LIMIT 1');\r\n\r\n        <\/span>$cachefirst<\/span> = ($cached<\/span> == 'FILEFIRST' || ($cached<\/span> == 'MYSQLFIRST' && $this<\/span>->platform != 'WINDOWS')) && $this<\/span>->max_cache_time;\r\n        <\/span>if<\/span> (!$cachefirst<\/span>)\r\n        {\r\n            <\/span>return<\/span> $this<\/span>->getOne($sql<\/span>, true<\/span>);\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$result<\/span> = $this<\/span>->getSqlCacheData($sql<\/span>, $cached<\/span>);\r\n            <\/span>if<\/span> (empty<\/span>($result<\/span>['storecache']) == true<\/span>)\r\n            {\r\n                <\/span>return<\/span> $result<\/span>['data'];\r\n            }\r\n        }\r\n\r\n        <\/span>$arr<\/span> = $this<\/span>->getOne($sql<\/span>, true<\/span>);\r\n\r\n        <\/span>if<\/span> ($arr<\/span> !== false<\/span> && $cachefirst<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->setSqlCacheData($result<\/span>, $arr<\/span>);\r\n        }\r\n\r\n        <\/span>return<\/span> $arr<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> getAll($sql<\/span>)\r\n    {\r\n        <\/span>$res<\/span> = $this<\/span>->query($sql<\/span>);\r\n        <\/span>if<\/span> ($res<\/span> !== false<\/span>)\r\n        {\r\n            <\/span>$arr<\/span> = $res<\/span>->fetch_all(MYSQLI_ASSOC);\r\n            <\/span>$res<\/span>->free();\r\n             <\/span>return<\/span> $arr<\/span>;\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>return<\/span> false<\/span>;\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> getAllCached($sql<\/span>, $cached<\/span> = 'FILEFIRST')\r\n    {\r\n        <\/span>$cachefirst<\/span> = ($cached<\/span> == 'FILEFIRST' || ($cached<\/span> == 'MYSQLFIRST' && $this<\/span>->platform != 'WINDOWS')) && $this<\/span>->max_cache_time;\r\n        <\/span>if<\/span> (!$cachefirst<\/span>)\r\n        {\r\n            <\/span>return<\/span> $this<\/span>->getAll($sql<\/span>);\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$result<\/span> = $this<\/span>->getSqlCacheData($sql<\/span>, $cached<\/span>);\r\n            <\/span>if<\/span> (empty<\/span>($result<\/span>['storecache']) == true<\/span>)\r\n            {\r\n                <\/span>return<\/span> $result<\/span>['data'];\r\n            }\r\n        }\r\n\r\n        <\/span>$arr<\/span> = $this<\/span>->getAll($sql<\/span>);\r\n\r\n        <\/span>if<\/span> ($arr<\/span> !== false<\/span> && $cachefirst<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->setSqlCacheData($result<\/span>, $arr<\/span>);\r\n        }\r\n\r\n        <\/span>return<\/span> $arr<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> getRow($sql<\/span>, $limited<\/span> = false<\/span>)\r\n    {\r\n        <\/span>if<\/span> ($limited<\/span> == true<\/span>)\r\n        {\r\n            <\/span>$sql<\/span> = trim<\/span>($sql<\/span> . ' LIMIT 1');\r\n        }\r\n\r\n        <\/span>$res<\/span> = $this<\/span>->query($sql<\/span>);\r\n        <\/span>if<\/span> ($res<\/span> !== false<\/span>)\r\n        {\r\n            <\/span>$result<\/span> = $res<\/span>->fetch_assoc();\r\n            <\/span>$res<\/span>->free();\r\n            <\/span>return<\/span> $result<\/span>;\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>return<\/span> false<\/span>;\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> getRowCached($sql<\/span>, $cached<\/span> = 'FILEFIRST')\r\n    {\r\n        <\/span>$cachefirst<\/span> = ($cached<\/span> == 'FILEFIRST' || ($cached<\/span> == 'MYSQLFIRST' && $this<\/span>->platform != 'WINDOWS')) && $this<\/span>->max_cache_time;\r\n        <\/span>if<\/span> (!$cachefirst<\/span>)\r\n        {\r\n            <\/span>return<\/span> $this<\/span>->getRow($sql<\/span>, true<\/span>);\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$result<\/span> = $this<\/span>->getSqlCacheData($sql<\/span>, $cached<\/span>);\r\n            <\/span>if<\/span> (empty<\/span>($result<\/span>['storecache']) == true<\/span>)\r\n            {\r\n                <\/span>return<\/span> $result<\/span>['data'];\r\n            }\r\n        }\r\n\r\n        <\/span>$arr<\/span> = $this<\/span>->getRow($sql<\/span>, true<\/span>);\r\n\r\n        <\/span>if<\/span> ($arr<\/span> !== false<\/span> && $cachefirst<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->setSqlCacheData($result<\/span>, $arr<\/span>);\r\n        }\r\n\r\n        <\/span>return<\/span> $arr<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> getCol($sql<\/span>)\r\n    {\r\n        <\/span>$res<\/span> = $this<\/span>->query($sql<\/span>);\r\n        <\/span>if<\/span> ($res<\/span> !== false<\/span>)\r\n        {\r\n            <\/span>$arr<\/span> = array<\/span>();\r\n            <\/span>while<\/span> ($row<\/span> = $res<\/span>->fetch_row())\r\n            {\r\n                <\/span>$arr<\/span>[] = $row<\/span>[0];\r\n            }\r\n            <\/span>$res<\/span>->free();\r\n            <\/span>return<\/span> $arr<\/span>;\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>return<\/span> false<\/span>;\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> getColCached($sql<\/span>, $cached<\/span> = 'FILEFIRST')\r\n    {\r\n        <\/span>$cachefirst<\/span> = ($cached<\/span> == 'FILEFIRST' || ($cached<\/span> == 'MYSQLFIRST' && $this<\/span>->platform != 'WINDOWS')) && $this<\/span>->max_cache_time;\r\n        <\/span>if<\/span> (!$cachefirst<\/span>)\r\n        {\r\n            <\/span>return<\/span> $this<\/span>->getCol($sql<\/span>);\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$result<\/span> = $this<\/span>->getSqlCacheData($sql<\/span>, $cached<\/span>);\r\n            <\/span>if<\/span> (empty<\/span>($result<\/span>['storecache']) == true<\/span>)\r\n            {\r\n                <\/span>return<\/span> $result<\/span>['data'];\r\n            }\r\n        }\r\n\r\n        <\/span>$arr<\/span> = $this<\/span>->getCol($sql<\/span>);\r\n\r\n        <\/span>if<\/span> ($arr<\/span> !== false<\/span> && $cachefirst<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->setSqlCacheData($result<\/span>, $arr<\/span>);\r\n        }\r\n\r\n        <\/span>return<\/span> $arr<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> autoExecute($table<\/span>, $field_values<\/span>, $mode<\/span> = 'INSERT', $where<\/span> = '', $querymode<\/span> = '')\r\n    {\r\n        <\/span>$field_names<\/span> = $this<\/span>->getCol('DESC ' . $table<\/span>);\r\n\r\n        <\/span>$sql<\/span> = '';\r\n        <\/span>if<\/span> ($mode<\/span> == 'INSERT')\r\n        {\r\n            <\/span>$fields<\/span> = $values<\/span> = array<\/span>();\r\n            <\/span>foreach<\/span> ($field_names<\/span> AS<\/span> $value<\/span>)\r\n            {\r\n                <\/span>if<\/span> (array_key_exists<\/span>($value<\/span>, $field_values<\/span>) == true<\/span>)\r\n                {\r\n                    <\/span>$fields<\/span>[] = $value<\/span>;\r\n                    <\/span>$values<\/span>[] = \"'\" . $field_values<\/span>[$value<\/span>] . \"'\";\r\n                }\r\n            }\r\n\r\n            <\/span>if<\/span> (!empty<\/span>($fields<\/span>))\r\n            {\r\n                <\/span>$sql<\/span> = 'INSERT INTO ' . $table<\/span> . ' (' . implode<\/span>(', ', $fields<\/span>) . ') VALUES (' . implode<\/span>(', ', $values<\/span>) . ')';\r\n            }\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$sets<\/span> = array<\/span>();\r\n            <\/span>foreach<\/span> ($field_names<\/span> AS<\/span> $value<\/span>)\r\n            {\r\n                <\/span>if<\/span> (array_key_exists<\/span>($value<\/span>, $field_values<\/span>) == true<\/span>)\r\n                {\r\n                    <\/span>$sets<\/span>[] = $value<\/span> . \" = '\" . $field_values<\/span>[$value<\/span>] . \"'\";\r\n                }\r\n            }\r\n\r\n            <\/span>if<\/span> (!empty<\/span>($sets<\/span>))\r\n            {\r\n                <\/span>$sql<\/span> = 'UPDATE ' . $table<\/span> . ' SET ' . implode<\/span>(', ', $sets<\/span>) . ' WHERE ' . $where<\/span>;\r\n            }\r\n        }\r\n\r\n        <\/span>if<\/span> ($sql<\/span>)\r\n        {\r\n            <\/span>return<\/span> $this<\/span>->query($sql<\/span>, $querymode<\/span>);\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>return<\/span> false<\/span>;\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> autoReplace($table<\/span>, $field_values<\/span>, $update_values<\/span>, $where<\/span> = '', $querymode<\/span> = '')\r\n    {\r\n        <\/span>$field_descs<\/span> = $this<\/span>->getAll('DESC ' . $table<\/span>);\r\n\r\n        <\/span>$primary_keys<\/span> = array<\/span>();\r\n        <\/span>foreach<\/span> ($field_descs<\/span> AS<\/span> $value<\/span>)\r\n        {\r\n            <\/span>$field_names<\/span>[] = $value<\/span>['Field'];\r\n            <\/span>if<\/span> ($value<\/span>['Key'] == 'PRI')\r\n            {\r\n                <\/span>$primary_keys<\/span>[] = $value<\/span>['Field'];\r\n            }\r\n        }\r\n\r\n        <\/span>$fields<\/span> = $values<\/span> = array<\/span>();\r\n        <\/span>foreach<\/span> ($field_names<\/span> AS<\/span> $value<\/span>)\r\n        {\r\n            <\/span>if<\/span> (array_key_exists<\/span>($value<\/span>, $field_values<\/span>) == true<\/span>)\r\n            {\r\n                <\/span>$fields<\/span>[] = $value<\/span>;\r\n                <\/span>$values<\/span>[] = \"'\" . $field_values<\/span>[$value<\/span>] . \"'\";\r\n            }\r\n        }\r\n\r\n        <\/span>$sets<\/span> = array<\/span>();\r\n        <\/span>foreach<\/span> ($update_values<\/span> AS<\/span> $key<\/span> => $value<\/span>)\r\n        {\r\n            <\/span>if<\/span> (array_key_exists<\/span>($key<\/span>, $field_values<\/span>) == true<\/span>)\r\n            {\r\n                <\/span>if<\/span> (is_int<\/span>($value<\/span>) || is_float<\/span>($value<\/span>))\r\n                {\r\n                    <\/span>$sets<\/span>[] = $key<\/span> . ' = ' . $key<\/span> . ' + ' . $value<\/span>;\r\n                }\r\n                <\/span>else<\/span>\r\n                {\r\n                    <\/span>$sets<\/span>[] = $key<\/span> . \" = '\" . $value<\/span> . \"'\";\r\n                }\r\n            }\r\n        }\r\n\r\n        <\/span>$sql<\/span> = '';\r\n        <\/span>if<\/span> (empty<\/span>($primary_keys<\/span>))\r\n        {\r\n            <\/span>if<\/span> (!empty<\/span>($fields<\/span>))\r\n            {\r\n                <\/span>$sql<\/span> = 'INSERT INTO ' . $table<\/span> . ' (' . implode<\/span>(', ', $fields<\/span>) . ') VALUES (' . implode<\/span>(', ', $values<\/span>) . ')';\r\n            }\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>if<\/span> ($this<\/span>->version() >= '4.1')\r\n            {\r\n                <\/span>if<\/span> (!empty<\/span>($fields<\/span>))\r\n                {\r\n                    <\/span>$sql<\/span> = 'INSERT INTO ' . $table<\/span> . ' (' . implode<\/span>(', ', $fields<\/span>) . ') VALUES (' . implode<\/span>(', ', $values<\/span>) . ')';\r\n                    <\/span>if<\/span> (!empty<\/span>($sets<\/span>))\r\n                    {\r\n                        <\/span>$sql<\/span> .=  'ON DUPLICATE KEY UPDATE ' . implode<\/span>(', ', $sets<\/span>);\r\n                    }\r\n                }\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>if<\/span> (empty<\/span>($where<\/span>))\r\n                {\r\n                    <\/span>$where<\/span> = array<\/span>();\r\n                    <\/span>foreach<\/span> ($primary_keys<\/span> AS<\/span> $value<\/span>)\r\n                    {\r\n                        <\/span>if<\/span> (is_numeric<\/span>($value<\/span>))\r\n                        {\r\n                            <\/span>$where<\/span>[] = $value<\/span> . ' = ' . $field_values<\/span>[$value<\/span>];\r\n                        }\r\n                        <\/span>else<\/span>\r\n                        {\r\n                            <\/span>$where<\/span>[] = $value<\/span> . \" = '\" . $field_values<\/span>[$value<\/span>] . \"'\";\r\n                        }\r\n                    }\r\n                    <\/span>$where<\/span> = implode<\/span>(' AND ', $where<\/span>);\r\n                }\r\n\r\n                <\/span>if<\/span> ($where<\/span> && (!empty<\/span>($sets<\/span>) || !empty<\/span>($fields<\/span>)))\r\n                {\r\n                    <\/span>if<\/span> (intval<\/span>($this<\/span>->getOne(\"SELECT COUNT(*) FROM $table<\/span> WHERE $where<\/span>\")) > 0)\r\n                    {\r\n                        <\/span>if<\/span> (!empty<\/span>($sets<\/span>))\r\n                        {\r\n                            <\/span>$sql<\/span> = 'UPDATE ' . $table<\/span> . ' SET ' . implode<\/span>(', ', $sets<\/span>) . ' WHERE ' . $where<\/span>;\r\n                        }\r\n                    }\r\n                    <\/span>else<\/span>\r\n                    {\r\n                        <\/span>if<\/span> (!empty<\/span>($fields<\/span>))\r\n                        {\r\n                            <\/span>$sql<\/span> = 'REPLACE INTO ' . $table<\/span> . ' (' . implode<\/span>(', ', $fields<\/span>) . ') VALUES (' . implode<\/span>(', ', $values<\/span>) . ')';\r\n                        }\r\n                    }\r\n                }\r\n            }\r\n        }\r\n\r\n        <\/span>if<\/span> ($sql<\/span>)\r\n        {\r\n            <\/span>return<\/span> $this<\/span>->query($sql<\/span>, $querymode<\/span>);\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>return<\/span> false<\/span>;\r\n        }\r\n    }\r\n\r\n    <\/span>function<\/span> setMaxCacheTime($second<\/span>)\r\n    {\r\n        <\/span>$this<\/span>->max_cache_time = $second<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> getMaxCacheTime()\r\n    {\r\n        <\/span>return<\/span> $this<\/span>->max_cache_time;\r\n    }\r\n\r\n    <\/span>function<\/span> getSqlCacheData($sql<\/span>, $cached<\/span> = '')\r\n    {\r\n        <\/span>$sql<\/span> = trim<\/span>($sql<\/span>);\r\n\r\n        <\/span>$result<\/span> = array<\/span>();\r\n        <\/span>$result<\/span>['filename'] = $this<\/span>->root_path . $this<\/span>->cache_data_dir . 'sqlcache_' . abs<\/span>(crc32<\/span>($this<\/span>->dbhash . $sql<\/span>)) . '_' . md5<\/span>($this<\/span>->dbhash . $sql<\/span>) . '.php';\r\n\r\n        <\/span>$data<\/span> = @file_get_contents<\/span>($result<\/span>['filename']);\r\n        <\/span>if<\/span> (isset<\/span>($data<\/span>{23}))\r\n        {\r\n            <\/span>$filetime<\/span> = substr<\/span>($data<\/span>, 13, 10);\r\n            <\/span>$data<\/span>     = substr<\/span>($data<\/span>, 23);\r\n\r\n            <\/span>if<\/span> (($cached<\/span> == 'FILEFIRST' && time<\/span>() > $filetime<\/span> + $this<\/span>->max_cache_time) || ($cached<\/span> == 'MYSQLFIRST' && $this<\/span>->table_lastupdate($this<\/span>->get_table_name($sql<\/span>)) > $filetime<\/span>))\r\n            {\r\n                <\/span>$result<\/span>['storecache'] = true<\/span>;\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>$result<\/span>['data'] = @unserialize<\/span>($data<\/span>);\r\n                <\/span>if<\/span> ($result<\/span>['data'] === false<\/span>)\r\n                {\r\n                    <\/span>$result<\/span>['storecache'] = true<\/span>;\r\n                }\r\n                <\/span>else<\/span>\r\n                {\r\n                    <\/span>$result<\/span>['storecache'] = false<\/span>;\r\n                }\r\n            }\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>$result<\/span>['storecache'] = true<\/span>;\r\n        }\r\n\r\n        <\/span>return<\/span> $result<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> setSqlCacheData($result<\/span>, $data<\/span>)\r\n    {\r\n        <\/span>if<\/span> ($result<\/span>['storecache'] === true<\/span> && $result<\/span>['filename'])\r\n        {\r\n            @<\/span>file_put_contents<\/span>($result<\/span>['filename'], '<?php exit;?>' . time<\/span>() . serialize<\/span>($data<\/span>));\r\n            <\/span>clearstatcache<\/span>();\r\n        }\r\n    }\r\n\r\n    <\/span>\/*<\/span> \u83b7\u53d6 SQL \u8bed\u53e5\u4e2d\u6700\u540e\u66f4\u65b0\u7684\u8868\u7684\u65f6\u95f4\uff0c\u6709\u591a\u4e2a\u8868\u7684\u60c5\u51b5\u4e0b\uff0c\u8fd4\u56de\u6700\u65b0\u7684\u8868\u7684\u65f6\u95f4 <\/span>*\/<\/span>\r\n    function<\/span> table_lastupdate($tables<\/span>)\r\n    {\r\n        <\/span>if<\/span> ($this<\/span>->link_id === NULL<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->connect($this<\/span>->settings['dbhost'], $this<\/span>->settings['dbuser'], $this<\/span>->settings['dbpw'], $this<\/span>->settings['dbname'], $this<\/span>->settings['charset'], $this<\/span>->settings['pconnect']);\r\n            <\/span>$this<\/span>->settings = array<\/span>();\r\n        }\r\n\r\n        <\/span>$lastupdatetime<\/span> = '0000-00-00 00:00:00';\r\n\r\n        <\/span>$tables<\/span> = str_replace<\/span>('`', '', $tables<\/span>);\r\n        <\/span>$this<\/span>->mysql_disable_cache_tables = str_replace<\/span>('`', '', $this<\/span>->mysql_disable_cache_tables);\r\n\r\n        <\/span>foreach<\/span> ($tables<\/span> AS<\/span> $table<\/span>)\r\n        {\r\n            <\/span>if<\/span> (in_array<\/span>($table<\/span>, $this<\/span>->mysql_disable_cache_tables) == true<\/span>)\r\n            {\r\n                <\/span>$lastupdatetime<\/span> = '2037-12-31 23:59:59';\r\n\r\n                <\/span>break<\/span>;\r\n            }\r\n\r\n            <\/span>if<\/span> (strstr<\/span>($table<\/span>, '.') != NULL<\/span>)\r\n            {\r\n                <\/span>$tmp<\/span> = explode<\/span>('.', $table<\/span>);\r\n                <\/span>$sql<\/span> = 'SHOW TABLE STATUS FROM `' . trim<\/span>($tmp<\/span>[0]) . \"` LIKE '\" . trim<\/span>($tmp<\/span>[1]) . \"'\";\r\n            }\r\n            <\/span>else<\/span>\r\n            {\r\n                <\/span>$sql<\/span> = \"SHOW TABLE STATUS LIKE '\" . trim<\/span>($table<\/span>) . \"'\";\r\n            }\r\n            <\/span>$result<\/span> = $this<\/span>->link_id->query($sql<\/span>);\r\n            <\/span>$row<\/span> = $result<\/span>->fetch_assoc();\r\n            <\/span>if<\/span> ($row<\/span>['Update_time'] > $lastupdatetime<\/span>)\r\n            {\r\n                <\/span>$lastupdatetime<\/span> = $row<\/span>['Update_time'];\r\n            }\r\n        }\r\n        <\/span>$lastupdatetime<\/span> = strtotime<\/span>($lastupdatetime<\/span>) - $this<\/span>->timezone + $this<\/span>->timeline;\r\n\r\n        <\/span>return<\/span> $lastupdatetime<\/span>;\r\n    }\r\n\r\n    <\/span>function<\/span> get_table_name($query_item<\/span>)\r\n    {\r\n        <\/span>$query_item<\/span> = trim<\/span>($query_item<\/span>);\r\n        <\/span>$table_names<\/span> = array<\/span>();\r\n\r\n        <\/span>\/*<\/span> \u5224\u65ad\u8bed\u53e5\u4e2d\u662f\u4e0d\u662f\u542b\u6709 JOIN <\/span>*\/<\/span>\r\n        if<\/span> (stristr<\/span>($query_item<\/span>, ' JOIN ') == '')\r\n        {\r\n            <\/span>\/*<\/span> \u89e3\u6790\u4e00\u822c\u7684 SELECT FROM \u8bed\u53e5 <\/span>*\/<\/span>\r\n            if<\/span> (preg_match<\/span>('\/^SELECT.*?FROM\\s*((?:`?\\w+`?\\s*\\.\\s*)?`?\\w+`?(?:(?:\\s*AS)?\\s*`?\\w+`?)?(?:\\s*,\\s*(?:`?\\w+`?\\s*\\.\\s*)?`?\\w+`?(?:(?:\\s*AS)?\\s*`?\\w+`?)?)*)\/is', $query_item<\/span>, $table_names<\/span>))\r\n            {\r\n                <\/span>$table_names<\/span> = preg_replace<\/span>('\/((?:`?\\w+`?\\s*\\.\\s*)?`?\\w+`?)[^,]*\/', '\\1', $table_names<\/span>[1]);\r\n\r\n                <\/span>return<\/span> preg_split<\/span>('\/\\s*,\\s*\/', $table_names<\/span>);\r\n            }\r\n        }\r\n        <\/span>else<\/span>\r\n        {\r\n            <\/span>\/*<\/span> \u5bf9\u542b\u6709 JOIN \u7684\u8bed\u53e5\u8fdb\u884c\u89e3\u6790 <\/span>*\/<\/span>\r\n            if<\/span> (preg_match<\/span>('\/^SELECT.*?FROM\\s*((?:`?\\w+`?\\s*\\.\\s*)?`?\\w+`?)(?:(?:\\s*AS)?\\s*`?\\w+`?)?.*?JOIN.*$\/is', $query_item<\/span>, $table_names<\/span>))\r\n            {\r\n                <\/span>$other_table_names<\/span> = array<\/span>();\r\n                <\/span>preg_match_all<\/span>('\/JOIN\\s*((?:`?\\w+`?\\s*\\.\\s*)?`?\\w+`?)\\s*\/i', $query_item<\/span>, $other_table_names<\/span>);\r\n\r\n                <\/span>return<\/span> array_merge<\/span>(array<\/span>($table_names<\/span>[1]), $other_table_names<\/span>[1]);\r\n            }\r\n        }\r\n\r\n        <\/span>return<\/span> $table_names<\/span>;\r\n    }\r\n\r\n    <\/span>\/*<\/span> \u8bbe\u7f6e\u4e0d\u5141\u8bb8\u8fdb\u884c\u7f13\u5b58\u7684\u8868 <\/span>*\/<\/span>\r\n    function<\/span> set_disable_cache_tables($tables<\/span>)\r\n    {\r\n        <\/span>if<\/span> (!is_array<\/span>($tables<\/span>))\r\n        {\r\n            <\/span>$tables<\/span> = explode<\/span>(',', $tables<\/span>);\r\n        }\r\n\r\n        <\/span>foreach<\/span> ($tables<\/span> AS<\/span> $table<\/span>)\r\n        {\r\n            <\/span>$this<\/span>->mysql_disable_cache_tables[] = $table<\/span>;\r\n        }\r\n\r\n        <\/span>array_unique<\/span>($this<\/span>->mysql_disable_cache_tables);\r\n    }\r\n\r\n    \r\n    <\/span>\/*<\/span>*\r\n     +----------------------------------------------------------\r\n     * \u542f\u52a8\u4e8b\u52a1\r\n     +----------------------------------------------------------\r\n     * @access public\r\n     +----------------------------------------------------------\r\n     * @return void\r\n     +----------------------------------------------------------\r\n     <\/span>*\/<\/span>\r\n    public<\/span> function<\/span> startTrans() {\r\n        <\/span>\/\/<\/span>$this->initConnect(true);<\/span>\r\n        if<\/span> ( !$this<\/span>->link_id ) return<\/span> false<\/span>;\r\n        <\/span>\/\/<\/span>\u6570\u636erollback \u652f\u6301<\/span>\r\n        if<\/span> ($this<\/span>->transTimes == 0) {\r\n            <\/span>$this<\/span>->link_id->autocommit(FALSE<\/span>);\r\n        }\r\n        <\/span>$this<\/span>->transTimes++;\r\n        <\/span>return<\/span> ;\r\n    }\r\n    \r\n    <\/span>\/*<\/span>*\r\n     +----------------------------------------------------------\r\n     * \u7528\u4e8e\u975e\u81ea\u52a8\u63d0\u4ea4\u72b6\u6001\u4e0b\u9762\u7684\u67e5\u8be2\u63d0\u4ea4\r\n     +----------------------------------------------------------\r\n     * @access public\r\n     +----------------------------------------------------------\r\n     * @return boolen\r\n     +----------------------------------------------------------\r\n     <\/span>*\/<\/span>\r\n    public<\/span> function<\/span> commit()\r\n    {\r\n        <\/span>if<\/span> ($this<\/span>->transTimes > 0) {\r\n            <\/span>$result<\/span> = $this<\/span>->link_id->commit();\r\n            <\/span>$this<\/span>->transTimes = 0;\r\n            <\/span>if<\/span>(!$result<\/span>){\r\n                <\/span>$this<\/span>->error_message[]['message'] = 'MySQL Query Error';\r\n                <\/span>$this<\/span>->error_message[]['sql'] = $sql<\/span>;\r\n                <\/span>$this<\/span>->error_message[]['error'] = $this<\/span>->link_id->error;\r\n                <\/span>$this<\/span>->error_message[]['errno'] = $this<\/span>->link_id->errno;\r\n                <\/span>$this<\/span>->ErrorMsg();\r\n                <\/span>return<\/span> false<\/span>;\r\n            }\r\n        }\r\n        <\/span>return<\/span> true<\/span>;\r\n    }\r\n    \r\n    <\/span>\/*<\/span>*\r\n     +----------------------------------------------------------\r\n     * \u4e8b\u52a1\u56de\u6eda\r\n     +----------------------------------------------------------\r\n     * @access public\r\n     +----------------------------------------------------------\r\n     * @return boolen\r\n     +----------------------------------------------------------\r\n     <\/span>*\/<\/span>\r\n    public<\/span> function<\/span> rollback()\r\n    {\r\n        <\/span>if<\/span> ($this<\/span>->transTimes > 0) {\r\n            <\/span>$result<\/span> = $this<\/span>->link_id->rollback();\r\n            <\/span>$this<\/span>->transTimes = 0;\r\n            <\/span>if<\/span>(!$result<\/span>){\r\n                <\/span>$this<\/span>->error_message[]['message'] = 'MySQL Query Error';\r\n                <\/span>$this<\/span>->error_message[]['sql'] = $sql<\/span>;\r\n                <\/span>$this<\/span>->error_message[]['error'] = $this<\/span>->link_id->error;\r\n                <\/span>$this<\/span>->error_message[]['errno'] = $this<\/span>->link_id->errno;\r\n                <\/span>$this<\/span>->ErrorMsg();\r\n                <\/span>return<\/span> false<\/span>;\r\n            }\r\n        }\r\n        <\/span>return<\/span> true<\/span>;\r\n    }\r\n    \r\n}<\/span><\/pre>\n
<\/span>    <\/p>\n
 \u4ee3\u7801\u5f53\u4e2d\u52a0\u4e86\u51e0\u4e2a\u65b9\u6cd5\uff0c\u7528\u4e8e\u652f\u6301\u4e8b\u52a1\u3002<\/p>\n
\n","protected":false},"excerpt":{"rendered":"
ecshop\u8fd9\u4e2a\u7cfb\u7edf\uff0c\u5230\u76ee\u524d\u4e5f\u6ca1...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199506","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199506","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199506"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199506\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}