Loading table data from a CSV file

Computer Programming Forums : Questions and Answers, Articles, Tutorials, and Code Snippets

Switch to full style
:read: Start PHP with us. Includes topics to help you in php
Post a reply
DrRakha
  • DrRakha
  • Posts: 2715
  • Joined: Tue Mar 27, 2007 10:55 pm
  • Location: Earth
  • Website

Loading table data from a CSV file

Mon Oct 27, 2008 6:33 pm

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





Post a reply
  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     -  
 How to make PHP form data saved into txt file     -  
 Reading selected data from a source 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 Files and I/O, PHP Database
Switch to full style

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


Powered by phpBB © phpBB Group.


Codemiles.com