 |  |  |  |  |  |  |  |
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: 53
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.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
5.2.10 action apache api array beginner beneath binary broken cakephp checkbox class classes cms code cron curl database date destroy display dynamic echo echo$_get[x]changingitintovariable... email encode error fcc file files folder form forms function functions google header howtowriteathesis href htaccess html image images include insert ip javascript joomla limit link local login mail memberships menu mlm mod_rewrite multiple multipletables mysql mysqlquery neutrality oop open passwords paypal pdf php provider query radio random record remote rss script search server sessions sockets source space sql strip_tags syntax system table template thesishelp tutorial update upload url validator variable video voteup web window.onbeforeunload=closeme; youtube
