CSV File Data into Database

[Shalini Bhalla]

i have a csv file in folloeing format

book_nam , author , publisher
abcd , zyz , hij


i want this csv file to put in data base in following format

Id_no , book_id , field_nm, value
xx , 1 , book_nam,abcd
xx , 1 , author,zyz
xx , 1 , publisher,hij

actually from csv file book_name will be picked up first , will be matched in another table from where book_id will be picked up and then i have to insert this code into next tabe in above format .


code i have written is this :

<?php
   $f_name = array();
 
   $conn = mysql_connect("localhost","zzzzz","vvvvv");
   $db = mysql_select_db("mmmmm");
   $fh = fopen("Book1.csv", "r");
   $count1 = 0 ;
 
    while($line = fgetcsv($fh, 1000, ","))
    { 
    $count1 = $count1+1;
    count($line);
    if($count1 == 1)
    {
 
     for($i=0;$i<=count($line);$i++)
        {
 
           $f_name[i] = $line[$i];
 
 
 
        }
 
     }
 
 
        $pname = $line[0];
        echo $qry = "select productid from isc_products where prodname = '".$pname."'";
        $result = mysql_query($qry);
        while($row = mysql_fetch_array($result))
        {
             $pid = $row["productid"];
 
        }
 
          for($i=1;$i<=(count($line)-1);$i++)
          {
           global $f_name; 
           $k= $i-1;
           $fld_nm = $f_name[$k];
           $val = $line[$i]; 
           echo $qry1 = "insert into isc_product_customfields values(,'$pid','$fld_nm','$val')"; 
 
           }
           echo "\n";
 
 
 
 
  }      
   mysql_close();
fclose($fh);
?>
 
 

till now i am just printing the query .

i am stucing at a point , i am getting query build but without field_nm in it .

pls help

[nathj]

Shalini,

If I read the question correctly you want to know how to run the insert command so that it updates the database.

$lnNewID = mysql_query($qry1, $conn) or die("Error: ". mysql_error());
 

This should sort you out and give you the new ID should you need for anything else.

If I've mis-understood or there's anything else I can help with just pot back.

Cheers
nathj

[Shalini Bhalla]

its giving me ID but will insert data into another table for which i need to generate a query , which i am not getting :

for($i=1;$i<=(count($line)-1);$i++)
          {
           global $f_name; 
           print_r($f_name);
           $k= $i-1;
           $fld_nm = $f_name[$k];
           $val = $line[$i]; 
           echo $qry1 = "insert into isc_product_customfields values(,'$pid','$fld_nm','$val')"; 
 
           }

has to insert data in converted format :


csv file has data like :

Prodname , author , publisher
xyz , hij , opq


but i need to put in a table whic is having feilds like


Record_no(auto gen),Prod_id,field_name,value
101 , I , Prodname , xyz
102 , I , author ,hij
103 , I , publisher ,opq



i think i am clear now .......












After taking ID ,

[nathj]

I'm sorry but I'm not sure I understand the problem. If you could answer a couple of questions for me I may be able to get a clearer picture of what is going on.

1. How many CSV files are?
2. If there are multiple CVS files are they connected in any way?

I think you may want to use loops to process the information, but as I don't fully understand (my bad) then I can't help further. I'll have another think when you have answered my questions.

Cheers
nathj

[Shalini Bhalla]

i havi one csv file as follows :
Book1.csv

 
 
prod_name , author , publisher 
   abcd       ,  hij      , opq
 
 
 
 

and 2 data bases :

prod_master and another is storing custom fields for pro_master called : pro_custom_field .



author , publisher are custom field name and
abcd , hij are values for custom fields.


which my client will give me in Book1.csv format.

and i have to insert this data in pro_custom_field like this

 
rec_ID , Pro_ID , custom_fld_nam ,     value                 i.e
101     ,  1        , author      ,     abcd 
 
 

just try to understand the realtion ship of csv file and pro_master then you will be cleared.

if not still cleared , leave it i have changed the csv format and have solved it .




Thanks.

[Shalini Bhalla]

pls tell me how to catch insert statement errors
http://bytes.com/answers/php/856393-...ip-error-msges

[nathj]

@Shalini Bhalla

$lnNewID = mysql_query($qry1, $conn) or die("Error: ". mysql_error());
 

The 'or die' part of this statement would do what you are after.

As for the CSV format, I do now understand what you are after, so I'm sorry for being a bit slow to catch on. I'm glad you have solved the problem.

Cheers
nathj

[Shalini Bhalla]

but if still you can tell me that why my global array in that CSV problem is not working , i will be glad ....


my global array is not working in that code which i posted earlier second time.....



thankyou

[Shalini Bhalla]

but "die " will stop the execution also ....... i don't want to stop in between ....it should continue till eof