Jump to content


Photo

Csv File Import To Phpmyadmin Via Php Help

cvs phpmyadmin php import file

  • Please log in to reply
5 replies to this topic

#1 BenardZMEDIA

BenardZMEDIA

    Newbie

  • New Members
  • Pip
  • 5 posts

Posted 14 November 2012 - 08:10 AM

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); ?>

#2 Pikachu2000

Pikachu2000

    I hate everything.

  • Staff Alumni
  • 11,378 posts
  • LocationFuture Independent Republic of Texas
  • Age:106

Posted 14 November 2012 - 08:40 AM

'range' is a MySQL reserved word.

Edited by Pikachu2000, 14 November 2012 - 08:41 AM.

"Java" is to "Javascript" about the same as "fun" is to "funeral".

Why $_SERVER['PHP_SELF'] is bad. || Why ORDER BY RAND() is bad || Every problem can be solved with rm -rf *

Random Quote: "

#3 jazzman1

jazzman1

    Advanced Member

  • Gurus
  • 2,384 posts
  • LocationMississauga, Canada

Posted 14 November 2012 - 08:51 AM

Ha-ha-ha, Pika I suspected the same like you, oped up this site, so start searching "range" and found nothing -> http://msdn.microsof...(v=sql.80).aspx
After your post I saw that I was looking reserved words in MSSQL :happy-04:

@BenardZMEDIA, do you know that phpmyadmin is a not database? Your title is wrong.

#4 BenardZMEDIA

BenardZMEDIA

    Newbie

  • New Members
  • Pip
  • 5 posts

Posted 14 November 2012 - 09:53 AM

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.

#5 BenardZMEDIA

BenardZMEDIA

    Newbie

  • New Members
  • Pip
  • 5 posts

Posted 14 November 2012 - 09:55 AM

@ jazzman1 sorry if i got the wrong title this has been bugging me for hours

#6 Barand

Barand

    Sen . ( ile || sei )

  • Gurus
  • 14,134 posts
  • LocationCheshire, UK

Posted 14 November 2012 - 10:58 AM

This is the fastest way

http://dev.mysql.com.../load-data.html

|baaGrid| easy data tables - and more
|baaChart| easy line, column and pie charts
|baaSelect| generate js and php code for dynamic linked dropdowns

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Cheap Linux VPS from $5
SSD Storage, 30 day Guarantee
1 TB of BW, 100% Network Uptime

AlphaBit.com