Excel upload to Table

# Upload Data From Excel File To Database.

#<?php Starts
 
$error_data = "";
$success_data = "";
if(isset($_POST["Import"]))
{
 //First we need to make a connection with the database
 $host = 'localhost';   // Host Name.
 $db_user = 'root';     //User Name
 $db_password= '';
 $db = 'demo';          // Database Name.

$table = "excel_upload";

$conn = mysql_connect($host,$db_user,$db_password) or die (mysql_error());
 mysql_select_db($db) or die (mysql_error());


if(!empty($_FILES)){
   $posted_file = $_FILES;

  //echo "<pre>";print_r($_FILES);print_r($file_ext);echo "</pre>";

  $filename = $_FILES["file"]["tmp_name"];
  
  //filename
  $posted_filename = $_FILES["file"]["name"]; 
  
  //file extension
  $file_ext = pathinfo($posted_filename, PATHINFO_EXTENSION); 

  $allowed_files = array('csv','CSV');

  //check uploaded file formats
  if(in_array( $file_ext, $allowed_files) ) {
 
  if($_FILES["file"]["size"] > 0)
  { 
      //=============================
      $file = fopen($filename, "r");
      $count = 0;     // add this line
      while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
      {
         $count++; 
         //It removes the Header Data (1st Row)
         if($count>1 ){ 
 
            //record in table
            //$sql = "INSERT into excel_upload(p_bench,p_name,p_price,p_reason) values ('$emapData[0]','$emapData[1]','$emapData[2]','$emapData[3]')";

           $sql = "INSERT INTO excel_upload SET 
                   p_bench = '$emapData[0]',
                   p_name = '$emapData[1]',
                   p_price = '$emapData[2]',
                   p_reason= '$emapData[3]'
                   ";
          $recorded_result = mysql_query($sql);
          if($recorded_result){
              $success_data = "Uploaded Successfully";
              //header("Location:excel_upload.php");
              //die;
          }else{
              $error_data = "FAILED TO UPLOAD";
          }
       } 
    }
    //================================
 }
 
       }else{
        $error_data = 'Invalid File: Please Upload CSV File';
       } 
   }else{
     $error_data = 'File Not Found';
   }
}

#?>phpEnds

 

## The HTML Page::

<!DOCTYPE html>
<html>
<head>
 <title>Excel Upload</title>
</head>
<body>

<div style="margin:20px;">
 <?php 
 if(!empty($error_data)){
 echo "<span style='color:red;'>".$error_data."</span>";
 }else if(!empty($success_data)){
 echo "<span style='color:green;'>".$success_data."</span>";
 }
 ?>
</div>

<section style="margin:20px;">
   <form enctype="multipart/form-data" method="post" role="form">
      <div class="form-group">
         <label for="exampleInputFile">File Upload</label>
         <input type="file" name="file" id="file" size="150">
         <p class="help-block">Only Excel/CSV File Import.</p>
      </div>
      <button type="submit" class="btn btn-default" name="Import" value="Import">Upload</button>
   </form>
</section>
</body>
</html>

Sample: Excel File Data Pattern
Stackofcodes.in
Please follow and like us: