首页
学习
活动
专区
圈层
工具
发布
社区首页 >问答首页 >PHP CSV上传到MySQL不做任何事情

问PHP CSV上传到MySQL不做任何事情
EN

Stack Overflow用户
提问于 2018-08-19 12:04:33
回答 1查看 59关注 0票数 0

我编写了一个脚本来下载google工作表,然后将该工作表上传到我的数据库中。

一切似乎都很正常,除了数据现在正在上传到我的数据库中。

我导航到该文件夹,然后运行以下命令:

代码语言:javascript
复制
php -f updatedatabase.php

这是我编写的脚本( googel表中的键是用实际的键填充的--我测试了链接,它正在工作,出于安全原因,数据库凭证被标上了星号):

代码语言:javascript
复制
<?php
    $datas = file_get_contents("https://docs.google.com/spreadsheets/d/1fOe2fz8PmYzTWU7l_KboHdv0zP0KZkhcJUTGJDUXaKk/gviz/tq?tqx=out:csv&sheet=All%20Items&range=A:G");
    $datas = explode( PHP_EOL, $datas );
    //FORMAT ("Name1", "Image1", "Description1", "Rarity1", "Price1", "Status1", "Store1"), ("Name2", "Image2", "Description2", "Rarity2", "Price2", "Status2", "Store2").....

    // Info to connect to the database
        $servername = ".com";
        $dbusername = "";
        $password = "!19";
        $dbname = "";

        $con=mysqli_connect( $servername, $dbusername, $password, $dbname );

    mysqli_query( $con, "TRUNCATE TABLE Items" );

    foreach ( $datas as $data ) {
        echo $data . "\n";
        mysqli_query( $con, "INSERT INTO Items (Name,Image,Description,Rarity,Price,Status,Store) VALUES " . $data );
    }

    mysqli_close($con);
?>
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2018-08-19 16:28:08

您的data字符串的格式不正确:

代码语言:javascript
复制
$csvData = file_get_contents("https://docs.google.com/spreadsheets/d/1fOe2fz8PmYzTWU7l_KboHdv0zP0KZkhcJUTGJDUXaKk/gviz/tq?tqx=out:csv&sheet=All%20Items&range=A:G");
$lines = explode(PHP_EOL, $csvData);
$array = array();
foreach ($lines as $line) {
    $array[] = str_getcsv($line);
}

// format the data string
// work with PHP7.0 or later
$datas = array_map(function ($data) {
    $dataString = implode("','", $data);
    return "('$dataString')";
}, $array);

// remove the head line
array_shift($datas);

// Info to connect to the database
$servername = "192.168.10.10";
$dbusername = "homestead";
$password = "secret";
$dbname = "gooledoc";

$con = mysqli_connect($servername, $dbusername, $password, $dbname);

mysqli_query($con, "TRUNCATE TABLE Items");

foreach ($datas as $data) {
    echo $data . "\n";
    $result = mysqli_query($con, "INSERT INTO `Items` (`Name`,`Image`,`Description`,`Rarity`,`Price`,`Status`,`Store`) VALUES " . $data);
    var_dump($result);
}

mysqli_close($con);
票数 1
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接:

https://stackoverflow.com/questions/51914365

复制
相关文章

相似问题

领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档