Click here to Skip to main content
15,943,623 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I written script for the validation for the fields of csv file.I have done it successfully but if the conditions are false csv file is not importing in database.
Here is my code:
XML
include('db.php');
   if (isset($_POST['load']))
    {
    if ( isset($_FILES["file"]))
     {
      //if there was an error uploading the file
   if ($_FILES["file"]["error"] > 0)
     {
     echo "File Not Selected  <br />";
    }
 else
 {

    $file_name = $_FILES["file"]["name"];
if($_FILES["file"]["type"] != "text/csv")
 {
die("This is not a CSV file.");
 }

else
 {
 $location="C:\\xampp\\mysql\\data\\import\\";
move_uploaded_file($_FILES["file"]["tmp_name"], $location . $_FILES["file"]["name"]);


/* From Validation */
  $handle = fopen($location . $_FILES["file"]["name"], 'r');
  if ($handle)
    {
    //the top line is the field names`
    $fields = fgetcsv($handle, 4096, ',');
    //loop through one row at a time
    $counter=0;
       while (($data = fgetcsv($handle, 1000, '|')) !== FALSE)
    {
    $srno=$data[0];
    $date=$data[1];
    $mobno=$data[2];
    $city=$data[3];
    $state=$data[4];
    $type=$data[5];
    $telecaller=$data[6];

      if(empty($srno)==true)
           {
      echo"there is an empty field for srno<br/>";
          }

        $filter="/^([012]?\d|3[01])-([Jj][Aa][Nn]|[Ff][Ee][bB]|[Mm][Aa][Rr]|[Aa][Pp][Rr]|[Mm][Aa][Yy]|[Jj][Uu][Nn]|[Jj][u]l|[aA][Uu][gG]|[Ss][eE][pP]|[oO][Cc]|[Nn][oO][Vv]|[Dd][Ee][Cc])-(19|20)\d\d$/";
        if(!preg_match($filter,$date))
            {
    $counter++;
    echo"Invalid Date Format in Row "."$counter"."<br/>";
            }
        if(empty($date)==true)
            {
    echo"there is an empty field for date<br/>";

            }
    if( !preg_match("/^[0-9]{10}/",$mobno) )
 {
    echo "Please enter a valid phone number<br/>";
}

    if(empty($mobno)==true)
{

    echo"there is an empty field for mobile no<br/>";
  }

if(!preg_match("/^[a-zA-Z0-9]+$/",$city,$state) == 1)
        {
    echo"check your fields for state or city <br/>";
        }
   if(empty($city)==true)
    {
    echo"there is an empty field for City<br/>";

  }
if(empty($state)==true)
    {
    echo"there is an empty field for State<br/>";

}

    if(empty($type)==true)
{
    echo"there is an empty field for Type<br/>";

}


    $query="SELECT telecaller FROM import2 WHERE telecaller='$telecaller'";
  $result2=mysql_query($query);
  if(mysql_num_rows($result2)==0)
  {
    echo"Check list for telecallers";
  }
if(!is_numeric($srno))
    {
echo"All Sr.NO are only digital not contain any other number<br/>";
}

   if(empty($telecaller)==true)
{
    echo"there is an empty field for telecaller<br/>";

}

}
 fclose($handle);
}
$q="LOAD DATA INFILE '$file_name' IGNORE INTO TABLE import
                FIELDS TERMINATED BY '|'
                LINES TERMINATED BY '\n'
                IGNORE 1 LINES
                (srno,@date,@mobno,@city,@state,@type,@telecaller)
                SET srno=srno,date=@date,mobno=@mobno,city=@city,
                state=@state,type=@type,telecaller=@telecaller";
mysql_query($q) or die(mysql_error());
echo"File Uploaded and Updated Successfully";
mysql_query("INSERT INTO temp1 SELECT mobno,telecaller FROM import GROUP BY mobno HAVING COUNT(*)>1 ") or die(mysql_error());
mysql_query("UPDATE import,temp1 SET import.telecaller=temp1.telecaller WHERE import.mobno=temp1.mobno");

            }        }

}
Posted
Updated 31-Jul-12 22:28pm
v2
Comments
Sergey Alexandrovich Kryukov 1-Aug-12 12:52pm    
How do we know what is in your upload form (or Ajax code) on the client side? How do we know that the indices 'load' and 'file' are correct? How is this related to CSV or MySQL, if this is the POST problem? Why asking about something you don't show in code?
--SA
ZurdoDev 6-Aug-12 14:34pm    
Your question is not clear.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900