Jump to content

Csv File Import To Phpmyadmin Via Php Help


BenardZMEDIA

Recommended Posts

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

Link to comment
Share on other sites

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 :happy-04:

 

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.