validating CSV before saving in MYSQL

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 427,778 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,778 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 1510 | Replies: 3

•

Join Date: Dec 2006

Posts: 34

Reputation: php_coder is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

php_coder

Offline

Light Poster

validating CSV before saving in MYSQL

Dec 15th, 2006

hi all
could someone plz help me out in validating csv file(excel sheet) before i can insert it into the database?

i hv the code for uploading but not validating
reply ASAP.
cheers
coder

•

Join Date: Jul 2004

Location: North East Indiana

Posts: 491

Reputation: Puckdropper is an unknown quantity at this point

Rep Power: 5

Solved Threads: 20

Puckdropper Puckdropper is offline

Offline

Posting Pro in Training

Re: validating CSV before saving in MYSQL

Dec 15th, 2006

Ok, here's a hint: CSV files are normally just plain text. You have to read the information in before you can do anything with it.

www.uncreativelabs.net

Old computers are getting to be a lost art. Here at Uncreative Labs, we still enjoy using the old computers. Sometimes we want to see how far a particular system can go, other times we use a stock system to remind ourselves of what we once had.

•

Join Date: Sep 2006

Location: Michigan

Posts: 22

Reputation: DennisP is an unknown quantity at this point

Rep Power: 3

Solved Threads: 0

DennisP

Offline

Newbie Poster

Re: validating CSV before saving in MYSQL

Dec 16th, 2006

http://codewalkers.com/seecode/585.html

If you're lazy like me.

Simple PHP Pagination - No Database Required.
If you like it, give me some props. ;)

•

Join Date: Dec 2006

Posts: 34

Reputation: php_coder is an unknown quantity at this point

Rep Power: 2

Solved Threads: 0

php_coder

Offline

Light Poster

Re: validating CSV before saving in MYSQL

Dec 18th, 2006

•

Originally Posted by DennisP

http://codewalkers.com/seecode/585.html

If you're lazy like me.

Hi
thanks for the reply. But i hv already done what you hv sent me....
my csv contains firstname,lastname,email id. So i have to validate the
email and not allow specialchar other than @. The following is my code.....
if($_REQUEST['submit'])
{
$errmsg="";
$contents = file ('./email_entries.csv');
for($i=0; $i<sizeof($contents); $i++)
{
$line = trim($contents[$i],'",$#!%&^*()');
$arr = explode(',', $line);

if(!$arr)
{
$errmsg.='Invalid CSV file! Please check again.';
}
else{
$sql = mysql_query("insert into employees(first_name,last_name,email_id) values ('".$arr[0]."','".$arr[1]."','".$arr[2]."')");
}

}
}