Member Avatar for Kparas

Hi all,

I want to import a .csv file into mysql database with using php code.
How i can do this . what php code i will have to use for this. Please help me to do this. Because i have thousand of records which is in .csv file format. If i will put it manully in my databae . It will take so much time. If there is any code to import directly. Please provide me or help me to solve this problem.

With Regards,
Kparas

  • 8 Contributors
  • 7 Replies
  • 480 Views
  • 4 Years Discussion Span
  • Latest Post Latest Post by rahulnamdev
Member Avatar for diafol

Dear,
maybe the tool [snipped - no advertising] solve your problem.
Excel/CSV => PHP => mySQL

Greetings

Andreas

Looks like a cool app Andy, BUT you fail to mention that users have to pay you for the privilege. Shame really.

Edited by Ezzaral because: Snipped advertising link from quoted text.
Member Avatar for FreeGroup

Dear,

you are right. I really feel ashamed. :-)

In the past (3 years) I did have a DONATE button for snipped and
snipped. Unfortunately I had received only 5 Euro from 2 friends.

...so - I have changed my model.

Sorry for that

Andreas

Edited by Ezzaral because: snipped - no advertising please
Member Avatar for storm123

The code realized with fgetcsv() should be something like this :

PHP Code:
<?php
$fp         = fopen("english.csv", "r");

$length         = 4096; /// have to be optional length ...
$fildDelineate  = ','; /// or "|" ... declare what you need
$databasetable  = 'tableName';
$counter        = 1; // to omission first row if it is table headers

while( !feof($fp) ) {

  if( !$line = fgetcsv($fp, $length, $fildDelineate, '') && $counter) {
     continue;
  }
  foreach($line as $key => $value){
   // For example insert in 3 column (e.g. id, name, email )
   $importSQL = "insert into $databasetable values('$line[0]','$line[1]','$line[2]')";
   mysql_query($importSQL) or die(mysql_error());
  }
  $counter++;
}

fclose($fp);
?>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.