PHP 脚本：自动更新 QQ 号信息到数据库

\u003c?php\n// \u5217\u8868\u91cc\u9762\u5747\u662fqq\u53f7\n$qqList = ['1957860834', '2990306379', '511404375'];\n\n// \u8fde\u63a5\u6570\u636e\u5e93\n$servername = "localhost";\n$username = "blog_yeqingyu_cc";\n$password = "fWKxfy7GpJMzpcHe";\n$dbname = "blog_yeqingyu_cc";\n\n// \u521b\u5efa\u8fde\u63a5\n$conn = new mysqli($servername, $username, $password, $dbname);\n\n// \u68c0\u67e5\u8fde\u63a5\n\u003cif ($conn->connect_error) {\n die("\u8fde\u63a5\u5931\u8d25: " . $conn->connect_error);\n}\n\n// \u8bbe\u7f6e\u6bcf\u969424\u5c0f\u65f6\u68c0\u67e5name\u548cqm\u7684\u6570\u636e\n$lastUpdateTime = time() - 24 * 60 * 60;\n\n// \u5faa\u73afqq\u53f7\u5217\u8868\n\u003c?php\n// \u5faa\u73afqq\u53f7\u5217\u8868\nforeach ($qqList as $qq) {\n // \u53d1\u8d77\u8bf7\u6c42\n $response = file_get_contents("https://www.youwk.cn/api/qq/q_zl?key=zo3W6Y6p1qrICxxPwrFenJW3bdoUne&qq=" . $qq);\n\n // \u89e3\u6790JSON\u54cd\u5e94\n $data = json_decode($response, true);\n\n // \u63d0\u53d6qqstate\u503c\n $name = $data['data']['name'];\n $qm = $data['data']['qm'];\n\n // \u67e5\u8be2\u6570\u636e\u5e93\u4e2d\u662f\u5426\u5b58\u5728\u8be5qq\u53f7\u7684\u8bb0\u5f55\n $sql = "SELECT * FROM qq_data WHERE qq = '" . $qq . "'"";\n $result = $conn->query($sql);\n\n // \u5982\u679c\u5b58\u5728\u8bb0\u5f55\uff0c\u5219\u66f4\u65b0\u6570\u636e\u5e93\u4fdd\u5b58\u7684\u6570\u636e\n \u003cif ($result->num_rows > 0) {\n $row = $result->fetch_assoc();\n $lastUpdate = $row['last_update'];\n\n // \u68c0\u67e5\u4e0a\u6b21\u66f4\u65b0\u65f6\u95f4\u662f\u5426\u8d85\u8fc724\u5c0f\u65f6\n \u003cif ($lastUpdate < $lastUpdateTime) {\n $sql = "UPDATE qq_data SET name = '" . $name . "', qm = '" . $qm . "', last_update = NOW() WHERE qq = '" . $qq . "'"";\n \u003cif ($conn->query($sql) === true) {\n echo "\u8bb0\u5f55\u66f4\u65b0\u6210\u529f";\n } else {\n echo "Error: " . $sql . "
" . $conn->error;\n }\n } else {\n echo "\u672a\u5230\u66f4\u65b0\u65f6\u95f4";\n }\n } else {\n // \u5982\u679c\u4e0d\u5b58\u5728\u8bb0\u5f55\uff0c\u5219\u63d2\u5165\u65b0\u6570\u636e\u5230\u6570\u636e\u5e93\n $sql = "INSERT INTO qq_data (qq, name, qm, last_update) VALUES ('" . $qq . "', '" . $name . "', '" . $qm . "', NOW())";\n \u003cif ($conn->query($sql) === true) {\n echo "\u8bb0\u5f55\u63d2\u5165\u6210\u529f";\n } else {\n echo "Error: " . $sql . "
" . $conn->error;\n }\n }\n}\n\n// \u5173\u95ed\u6570\u636e\u5e93\u8fde\u63a5\n$conn->close();\n\u003f>\n\u003c?php\n// \u521b\u5efa\u6570\u636e\u8868\n$sql = "CREATE TABLE IF NOT EXISTS qq_data (\n id INT(11) AUTO_INCREMENT PRIMARY KEY,\n qq VARCHAR(20) NOT NULL,\n name VARCHAR(50) NOT NULL,\n qm VARCHAR(100) NOT NULL,\n last_update TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP\n)";\n\n\u003cif ($conn->query($sql) === true) {\n echo "\u6570\u636e\u8868\u521b\u5efa\u6210\u529f";\n} else {\n echo "Error creating table: " . $conn->error;\n}\n\u003f>\n\u6b64\u6bb5\u4ee3\u7801\u4f1a\u521b\u5efa\u4e00\u4e2a\u540d\u4e3aqq_data\u7684\u6570\u636e\u8868\uff0c\u5305\u542bid\u3001qq\u3001name\u3001qm\u548clast_update\u4e94\u4e2a\u5b57\u6bb5\u3002\u5176\u4e2did\u4e3a\u4e3b\u952e\uff0c\u81ea\u589e\uff1bqq\u3001name\u548cqm\u4e3a\u5b57\u7b26\u4e32\u7c7b\u578b\uff0c\u4e0d\u7a7a\uff1blast_update\u4e3a\u65f6\u95f4\u6807\u7c7b\u578b\uff0c\u9ed8\u8ba4\u503c\u4e3a\u76ee\u524d\u65f6\u95f4\u3002\n\n\u5c06\u4ee5\u4e0a\u4ee3\u7801\u6dfb\u52a0\u5230\u8fde\u63a5\u6570\u636e\u5e93\u7684\u4ee3\u7801\u540e\u9762\u5c31\u53ef\u4ee5\u521b\u5efa\u6570\u636e\u8868\u3002