个人中心
gpt4 book ai didi

php - 将csv文件导入mysql服务器时出错

转载 作者：行者123 更新时间：2023-11-29 03:30:34 24 4
gpt4 key购买 nike

<分区>

我想将 csv 文件导入 mysql 数据库，但我收到了一个我无法修复的错误。请帮我找出问题所在..

我的代码是

    <?php 
if(isset($_POST['submit']))
{   

$connect = mysql_connect('127.0.0.1','root','');


if (!$connect) {
 die('Could not connect to MySQL: ' . mysql_error());
 }
$cid =mysql_select_db('ts_order_track',$connect);

$file = $_FILES['file']['tmp_name'];
if ($_FILES["file"]["error"] > 0)
{
echo "Error: " . $_FILES["file"]["error"] . "<br />";
}

else {


echo "hi";
        $q="LOAD DATA INFILE '$file' INTO TABLE tsd_orders
        FIELDS TERMINATED BY ',' ENCLOSED BY '"'
        LINES TERMINATED BY '\n' 
        IGNORE 1 LINES
        ( order_id, customer_id, firstname, lastname, email, telephone, mobile, shipping_firstname, shipping_lastname, shipping_mobile, shipping_address_1, shipping_address_2, shipping_city, shipping_zone, shipping_postcode, shipping_country, shipping_method, payment_method, payment_code, weight, date_added, date_modified, import_order_id, sub_total, shipping_charges, tax_charges, total, order_status, courier, awb_code, coupon_amount, coupon_code, product_name, product_sku, product_model, product_quantity, product_price )";
        $s=mysql_query($q, $connect );

echo "File data successfully imported to database!!"; 
   } 



mysql_close ( $connect );
}
?>

错误是

Parse error: syntax error, unexpected '' ' (T_CONSTANT_ENCAPSED_STRING) in C:\xampp\htdocs\try.php

请帮我找出错误以及这里的代码应该是什么..

这是我的csv文件

order_id,customer_id,firstname,lastname,email,telephone,mobile,shipping_firstname,shipping_lastname,shipping_mobile,shipping_address_1,shipping_address_2,shipping_city,shipping_zone,shipping_postcode,shipping_country,shipping_method,payment_method,payment_code,weight,date_added,date_modified,import_order_id,sub_total,shipping_charges,tax_charges,total,order_status,courier,awb_code,coupon_amount,coupon_code,product_name,product_sku,product_model,product_quantity,product_price
3605600753,68,Deepali,Agni,deepali@trendspry.com,8800311993,8800311993,Deepali,Agni,8800311993,sushant Lok,Shopping Arc,GGN,Haryana,122001,India,Free shipping,Cash on Delivery,cod,0.50kg,28-05-2015,28-05-2015,bhg9,1299,0,0,1299,Pending,NA,NA,0,NA,A Beautiful  Black And Yellow Georgette Saree,BR19891153,Georgette and Jacquard Embroidery and Printed Casual and Office ,1,1299

24 4 0
文章推荐： mysql - JSP执行select查询不显示结果
文章推荐： php - FuelPHP 的 orm 和 mysql 不区分大小写 `like`
文章推荐： php - 如何将插入数组值存储为单独的记录
文章推荐： c# 带参数的http post 数据并保存到mysql
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com