BenardZMEDIA Posted November 14, 2012 Share Posted November 14, 2012 this is the scrip i currently have but i get "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'range,groups,b_m,product_code,desc_1,desc_2,qty,nett_price,goods_value) VALUES (' at line 1" <?php if (isset($_POST['submit'])) { if(is_uploaded_file($_FILES['filename']['tmp_name'])){ $handle = fopen($_FILES['filename']['tmp_name'], "r"); while(($data = fgetcsv($handle,1000,",")) !==false) { $ST=$data[0]; $date=$data[1]; $actual_date=$data[2]; $account=$data[3]; $branch=$data[4]; $customer_name=$data[5]; $i_c=$data[6]; $invoice_num=$data[7]; $category=$data[8]; $order_no=$data[9]; $order_item=$data[10]; $range=$data[11]; $groups=$data[12]; $b_m=$data[13]; $product_code=$data[14]; $desc_1=$data[15]; $desc_2=$data[16]; $qty=$data[17]; $nett_price=$data[18]; $goods_value=$data[19]; $query = "INSERT INTO sales_orders (ST,date,actual_date,account,branch,customer_name,i_c,invoice_num,category,order_no,order_item,range,groups,b_m,product_code,desc_1,desc_2,qty,nett_price,goods_value) VALUES ('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]','$data[10]','$data[11]','$data[12]','$data[13]','$data[14]','$data[15]','$data[16]','$data[17]','$data[18]','$data[19]')"; mysql_query($query) or die(mysql_error()); } } } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR...nsitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title><?php echo COMPANY_NAME; ?> | Sales Figures Upload Screen</title> <link href="<?php echo ROOT; ?>css/login.css" type="text/css" rel="stylesheet" /> <link type="text/css" href="<?php echo ROOT; ?>css/start/jquery-ui-1.8.7.custom.css" rel="stylesheet" /> <script type="text/javascript" src="<?php echo ROOT; ?>js/jquery-1.4.4.min.js"></script> <script type="text/javascript" src="<?php echo ROOT; ?>js/jquery-ui-1.8.7.custom.min.js"></script> </head> <body> <div id="box"> <div id="content"> <h1>Sales CSV Update</h1> <p>Please use a valid CSV file extracted from Exant Exporter.</p> <form method="post" action="uploadsale.php" enctype="multipart/form-data"> <p> <input type="file" name="filename"/> </p> <input name="submit" type="hidden"/> <button tabindex="4" type="submit">Upload Data</button> </form> </div> </div> </body> </html> <?php mysql_close($connection); ?> Quote Link to comment https://forums.phpfreaks.com/topic/270676-csv-file-import-to-phpmyadmin-via-php-help/ Share on other sites More sharing options...
Pikachu2000 Posted November 14, 2012 Share Posted November 14, 2012 (edited) 'range' is a MySQL reserved word. Edited November 14, 2012 by Pikachu2000 Quote Link to comment https://forums.phpfreaks.com/topic/270676-csv-file-import-to-phpmyadmin-via-php-help/#findComment-1392282 Share on other sites More sharing options...
jazzman1 Posted November 14, 2012 Share Posted November 14, 2012 Ha-ha-ha, Pika I suspected the same like you, oped up this site, so start searching "range" and found nothing -> http://msdn.microsoft.com/en-us/library/aa238507%28v=sql.80%29.aspx After your post I saw that I was looking reserved words in MSSQL @BenardZMEDIA, do you know that phpmyadmin is a not database? Your title is wrong. Quote Link to comment https://forums.phpfreaks.com/topic/270676-csv-file-import-to-phpmyadmin-via-php-help/#findComment-1392285 Share on other sites More sharing options...
BenardZMEDIA Posted November 14, 2012 Author Share Posted November 14, 2012 i changes it to a different name but i still get the error i have an excel sheet with column names ST Date Date (2) A/C BR Customer Name I/C I/C No Cat Order No Order Item Range Group B/M Product Code Description 1 Description 2 Qty Nett Price Goods Value all am trying to do is upload the csv file into mysql table without having to worry about the column names but still be able to insert data by ignoring the first row and read data row by row with "," as my delimiter. Quote Link to comment https://forums.phpfreaks.com/topic/270676-csv-file-import-to-phpmyadmin-via-php-help/#findComment-1392307 Share on other sites More sharing options...
BenardZMEDIA Posted November 14, 2012 Author Share Posted November 14, 2012 @ jazzman1 sorry if i got the wrong title this has been bugging me for hours Quote Link to comment https://forums.phpfreaks.com/topic/270676-csv-file-import-to-phpmyadmin-via-php-help/#findComment-1392310 Share on other sites More sharing options...
Barand Posted November 14, 2012 Share Posted November 14, 2012 This is the fastest way http://dev.mysql.com/doc/refman/5.6/en/load-data.html Quote Link to comment https://forums.phpfreaks.com/topic/270676-csv-file-import-to-phpmyadmin-via-php-help/#findComment-1392340 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.