{"id":29,"date":"2023-12-02T16:06:06","date_gmt":"2023-12-02T08:06:06","guid":{"rendered":"https:\/\/www.xhome.club\/?p=29"},"modified":"2023-12-02T16:07:34","modified_gmt":"2023-12-02T08:07:34","slug":"php%e5%af%bc%e5%85%a5csv%e6%96%87%e4%bb%b6","status":"publish","type":"post","link":"https:\/\/www.xhome.club\/index.php\/2023\/12\/02\/php%e5%af%bc%e5%85%a5csv%e6%96%87%e4%bb%b6\/","title":{"rendered":"PHP\u5bfc\u5165CSV\u6587\u4ef6"},"content":{"rendered":"

\u767e\u5ea6\u641c\u7d22\u5982\u4f55\u7528PHP\u5bfc\u5165CSV\u6587\u4ef6\uff0c\u7b2c\u4e00\u6761\u5f39\u51fa\u7684\u7adf\u7136\u662fAI\u751f\u6210\u7684\u7b54\u6848\uff0c\u5e76\u7ed9\u51fa\u4e86\u53ef\u590d\u5236\u7684\u4ee3\u7801\uff0c\u60ca\u4e0d\u60ca\u559c\uff1f\uff01<\/p>\n

\u53ef\u4ee5\u4f7f\u7528PHP\u7684\u5185\u7f6e\u51fd\u6570fgetcsv()<\/code>\u6765\u8bfb\u53d6CSV\u6587\u4ef6\u5e76\u5c06\u5176\u4e2d\u7684\u6570\u636e\u5b58\u5165\u5230\u6570\u636e\u5e93\u3002<\/p>\n

\u4e0b\u9762\u662f\u793a\u4f8b\u4ee3\u7801\uff1a<\/p>\n

<?php
\n\/\/ \u8fde\u63a5\u6570\u636e\u5e93
\n$servername = “localhost”; \/\/ \u670d\u52a1\u5668\u540d\u79f0\u6216IP\u5730\u5740
\n$username = “root”; \/\/ MySQL\u7528\u6237\u540d
\n$password = “”; \/\/ MySQL\u5bc6\u7801
\n$dbname = “myDB”; \/\/ \u8981\u64cd\u4f5c\u7684\u6570\u636e\u5e93\u540d\u79f0<\/p>\n

$conn = new mysqli($servername, $username, $password, $dbname);
\nif ($conn->connect_error) {
\ndie(“\u8fde\u63a5\u5931\u8d25: ” . $conn->connect_error);
\n}
\necho “\u6210\u529f\u8fde\u63a5\u5230MySQL<br>”;<\/p>\n

\/\/ CSV\u6587\u4ef6\u8def\u5f84
\n$filepath = ‘data.csv’;<\/p>\n

\/\/ \u6253\u5f00CSV\u6587\u4ef6
\n$handle = fopen($filepath, ‘r’);
\nif (!$handle) {
\necho “\u65e0\u6cd5\u6253\u5f00CSV\u6587\u4ef6\uff01”;
\nexit;
\n}<\/p>\n

while (($rowData = fgetcsv($handle)) !== FALSE) {
\n\/\/ \u83b7\u53d6\u6bcf\u884c\u6570\u636e
\n$column1 = $rowData[0]; \/\/ \u7b2c\u4e00\u5217\u6570\u636e
\n$column2 = $rowData[1]; \/\/ \u7b2c\u4e8c\u5217\u6570\u636e<\/p>\n

\/\/ \u6784\u5efaINSERT\u8bed\u53e5
\n$sql = “INSERT INTO tableName (column1, column2) VALUES (‘” . $column1 . “‘, ‘” . $column2 . “‘)”;<\/p>\n

if ($conn->query($sql) === TRUE) {
\necho “\u8bb0\u5f55\u5df2\u6dfb\u52a0\u5230\u6570\u636e\u5e93<br>”;
\n} else {
\necho “Error: ” . $sql . “<br>” . $conn->error;
\n}
\n}<\/p>\n

\/\/ \u5173\u95edCSV\u6587\u4ef6\u548c\u6570\u636e\u5e93\u8fde\u63a5
\nfclose($handle);
\n$conn->close();
\n?><\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u767e\u5ea6\u641c\u7d22\u5982\u4f55\u7528PHP\u5bfc\u5165CSV\u6587\u4ef6\uff0c\u7b2c\u4e00\u6761\u5f39\u51fa\u7684\u7adf\u7136\u662fAI\u751f\u6210\u7684\u7b54\u6848\uff0c\u5e76\u7ed9\u51fa\u4e86\u53ef\u590d\u5236\u7684\u4ee3\u7801\uff0c\u60ca\u4e0d\u60ca\u559c\uff1f\uff01 \u53ef\u4ee5… \u7ee7\u7eed\u9605\u8bfbPHP\u5bfc\u5165CSV\u6587\u4ef6<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"aside","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-29","post","type-post","status-publish","format-aside","hentry","category-it","post_format-post-format-aside","entry"],"_links":{"self":[{"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/posts\/29","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/comments?post=29"}],"version-history":[{"count":1,"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/posts\/29\/revisions"}],"predecessor-version":[{"id":30,"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/posts\/29\/revisions\/30"}],"wp:attachment":[{"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/media?parent=29"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/categories?post=29"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xhome.club\/index.php\/wp-json\/wp\/v2\/tags?post=29"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}