 |  |  |  |  |  |  |  |
insert csv file into mysql through php
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
HI
I want to submit csv file data into mysql
pls tell me how 2 do
if any one has any program made to insert csv file into mysql pls give me the code i really need it
pls help me
bye
I want to submit csv file data into mysql
pls tell me how 2 do
if any one has any program made to insert csv file into mysql pls give me the code i really need it
pls help me
bye
•
•
Join Date: May 2006
Posts: 1,422
Reputation: 
Solved Threads: 35
1) Split the csv file line-by-line using explode()
2) Then insert into your mysql DB normally.
2) Then insert into your mysql DB normally.
John Conde
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!
Brainyminds | Merchant Account Services | I Love Code
IT'S HERE: Merchant Accounts 101 Everything you need to know about merchant accounts!
•
•
Join Date: Jan 2005
Posts: 294
Reputation:
Solved Threads: 6
Posting Whiz in Training
Before you can 'split' the cvs data, you need the following:[php]
// after uploading using a html form
$tmpName = $_FILES['userfile']['tmp_name'];
$fp = fopen($tmpName, 'r');
$fr=fread($fp, filesize($tmpName));
$line = explode("\n", $fr);
// etc etc ...
[/php]
// after uploading using a html form
$tmpName = $_FILES['userfile']['tmp_name'];
$fp = fopen($tmpName, 'r');
$fr=fread($fp, filesize($tmpName));
$line = explode("\n", $fr);
// etc etc ...
[/php]
Ecommerce-Web-Store.com Building Your e-Business.
•
•
•
•
Originally Posted by zippee 
Before you can 'split' the cvs data, you need the following:[php]
// after uploading using a html form
$tmpName = $_FILES['userfile']['tmp_name'];
$fp = fopen($tmpName, 'r');
$fr=fread($fp, filesize($tmpName));
$line = explode("\n", $fr);
// etc etc ...
[/php]
if($_REQUEST['submit'])
{
$contents = file ('./email_entries.csv');
for($i=0; $i<sizeof($contents); $i++)
{
$line = trim($contents[$i],'",');
$arr = explode(',', $line);
// $sql = "insert into employees values ('".implode("','", $arr)."')";
$sql = mysql_query("insert into employees(first_name,last_name,email_id) values ('".$arr[0]."','".$arr[1]."','".$arr[2]."')");
}
}
•
•
Join Date: Sep 2006
Posts: 54
Reputation:
Solved Threads: 0
Junior Poster in Training
Hi,
Just run this code to enter your csv file into mysql. Also enter the database details in a file named config.inc.php.
-----------------
Just run this code to enter your csv file into mysql. Also enter the database details in a file named config.inc.php.
-----------------
php Syntax (Toggle Plain Text)
Last edited by stymiee; Dec 16th, 2006 at 4:22 pm.
•
•
Join Date: Mar 2009
Posts: 1
Reputation:
Solved Threads: 0
Newbie Poster
Ok I have this code running on my site. Only thing is I get an error when I put csv files location in the text box. Also I had to add slashes to everywhere the script said "highlight" I was getting some kind of parse error unless it looked like /"highlight/".
My question is why am I getting the error message when I select my csv file.
My question is why am I getting the error message when I select my csv file.
|
Similar Threads
- how to retrive image file from mysql databse using php (PHP)
- read second line or record of csv file (PHP)
- How to read data from csv file in an array and parse (C++)
- parsing csv file (PHP)
- Save a text file in an csv.file with ascii? (PHP)
Other Threads in the PHP Forum
- Previous Thread: displaying random images
- Next Thread: simple mysql question..plz answer :)
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
ajax apache api array beginner beneath binary broadband broken button cakephp checkbox class cms code countingeverycharactersfromastring crack cron curl database date decode display dynamic echo email error file files folder form forms function functions google href htaccess html image include insert integration ip java javascript joomla limit link login loop mail match md5 menu mlm multiple mysql mysql_real_escape_string oop paypal pdf php problem protocol query radio random recursion regex remote script search server session sessions sms smtp soap source space sql strip_tags survey syntax system table tutorial undefined update upload url validator variable video virus votedown web window.onbeforeunload=closeme; xml youtube
