validating CSV before saving in MYSQL

[php_coder]

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

[Puckdropper]

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.

[DennisP]

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

If you're lazy like me.

[php_coder]

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]."')");
         }

     }
  }

[morecambe]

PHP_CODER did you finish your project and learn how to validate the csv contents. I'm exactly at the point where you were when you asked your qustion. If you did find out how to do the validation please can you post the answer.

Thx

[BzzBee]

see this link. may be it can help you

http://www.bigresource.com/PHP-CSV-file-content-validation-hYLSnyxf.html

[morecambe]

see this link. may be it can help you

http://www.bigresource.com/PHP-CSV-file-content-validation-hYLSnyxf.html

Thanks for your message but I already saw that link - it's actually useless - it just takes me to another forum here with half a reply:
http://www.phpfreaks.com/forums/index.php?topic=158173