Loading table data from a CSV file

Code:

<?php

   $conn = mysql_connect("localhost","someuser","secret");
   $db = mysql_select_db("cars");

   $fh = fopen("yourCSVFile.csv", "r");
   while ($line = fgetcsv($fh, 1000, ",")) {
      $year = $line[0];
      $make = $line[1];
      $color = $line[2];

      $query = "INSERT INTO carcollection SET year='$year', make='$make',color='$color'";
      $result = mysql_query($query);
   }

   fclose($fh);
   mysql_close();
?>

_________________
M. S. Rakha, Ph.D.
Queen's University
Canada

Author: DrRakha
Mastermind

Posts: 2715
Have thanks: 74 time

Page 1 of 1

[ 1 post ]

Related Posts to : Loading table data from a CSV file
NULL Data in table -
Delete data from database table in php -
show table data by clicking button -
How to merge the data into file -
Reading selected data from a source file -
How to make PHP form data saved into txt file -
Show loading image from JQuery -
show loading status message until the applet is fully loaded -
Encrypt/Decrypt a file from source file to target file. -
Copy file to file in java code- implementation -

Topic Tags

PHP Database, PHP Files and I/O

Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
All copyrights reserved to codemiles.com 2007-2011
mileX v1.0 designed by codemiles team
Codemiles.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com