Total members 11889 |It is currently Thu Mar 28, 2024 1:48 pm Login / Join Codemiles

Java

C/C++

PHP

C#

HTML

CSS

ASP

Javascript

JQuery

AJAX

XSD

Python

Matlab

R Scripts

Weka





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:
Mastermind
User avatar Posts: 2715
Have thanks: 74 time
Post new topic Reply to topic  [ 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 Files and I/O, PHP Database
cron





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