Stuck On Csv To Mysql Code...

[techker]

Hey guys im stuck on this code that keeps on putting " " in my tables?

 

i save the xls file to csv comma delimited.

 

when i upload it ,i get "name" "age"....

 

i think it the '".addslashes($data[0])."',

 

 

if ($_FILES[csv][size] > 0) { 

   //get the csv file 
   $file = $_FILES[csv][tmp_name]; 
   $handle = fopen($file,"r"); 

   //loop through the csv file and insert into database 
   do { 
       if ($data[0]) { 
           mysql_query("INSERT INTO  $Year (Ecole,N_Fiche,Nom,Prenom,Code_P,Foyer,Secondaire,Annee,Sortie) VALUES 
               ( 
                   '263',
'".addslashes($data[0])."',
                   '".addslashes($data[1])."', 
'".addslashes($data[2])."',
'".addslashes($data[5])."',
'".addslashes($data[6])."',
                   '".addslashes($data[4])."',
'$Year',
'".addslashes($data[7])."' 
               ) 
           "); 
       } 
   } while ($data = fgetcsv($handle,1000,",","'")); 

 

nice new look by the way.

[Barand]

You don't read any data until you get to the end of the loop with a do..while(). All the processing is on empty $data the first time through the loop.

[techker]

sorry why do you mean read?i have a form that is used to realy the post..

 

<?php if (!empty($_GET[success])) { echo "<b>CSV Importer!.</b><br><br>"; } //generic success notice ?> 

</p>
<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1"> 
 Choose your file: <br /> 
 <input name="csv" type="file" id="csv" /> 
 <input name="Year" type="hidden" value="<?=$Fiscale?>" />
 <input type="submit" name="Submit" value="Submit" /> 

</form> 

 

csv looks like this

 

7864804 Abraham Mohamed Masculin 5 ABRM27079607 501

[Barand]

what you have is

 

do {
   process data
} while (get data)

 

until you get data there is no data to process

[techker]

while ($data = fgetcsv($handle,1000,",","'"));

 

odd cause it works it inserts the data correctly but add quotes before and after the data

[Barand]

It's still an incorrect way to loop in that case.

 

Try

 

fgetcsv($handle,1000)

 

and use the defaults as your code defines single quote as string delimiter.

[techker]

its odd

 

my csv file

2441343 Abatouy, Ch 1336 Actif 263 A 1

1.8E+08

 

the query seperates the first and last name from second colum(data[1]) and puts "

 

"abatouy" "ch"

[Barand]

 

csv looks like this

 

7864804 Abraham Mohamed Masculin 5 ABRM27079607 501

 

Where are the commas?

[techker]

there isnt any..odd ah?and i save it as comma delimited..

[Barand]

What did you you specify as the field delimiter when you created it?

[techker]

nothing?opened the xls saves as CSV(comma delimited)

[Barand]

Perhaps it's tab delimited by default.

Try

 

while ($data = fgetcsv($handle,1000,"\t"));

[techker]

same

 

1 260 2441343 "Abatouy Cha" 263 A Actif Actif

1

 

 

 

how can it take this

 

2441343 Abatouy, Cha 1336 Actif 263 A 1 1.8E+08

 

i guess the, between the first and last name make it data[1] data [2]

[techker]

but its ok the way it is i just need to remove the ""

[Barand]

if you specify the correct field delimiters and string terminators then the quotes should disappear.

 

At the moment you are specifying commas when there aren't any and single quote instead of double quote (default) as string terminators.

[techker]

so how would i do that?cause it is inserting the correct data?

[Barand]

Change the string terminator from "'" (double-single-double) to '"' (single-double-single), or omit it, since double quote is the default, as I did in my earlier post..

[techker]

ok cool i will see if i can figure it out..thx for the help

[fenway]

It's troubling that you export your data, but you don't understand how, or why, it works.

[techker]

why would you say that?there is a few csv file formats..

thx for the comment.

[fenway]

why would you say that?there is a few csv file formats..

thx for the comment.

Yes, but you are supposed to know which one you chose -- i.e. separated by tab, quote spaces, etc.

[techker]

its in my first post comma delimited.thats the only option i have with ms-dos and mac

[techker]

this worked by the way

 

Change the string terminator from "'" (double-single-double) to '"' (single-double-single), or omit it, since double quote is the default, as I did in my earlier post..