How to Import Data in PHP using Mysql Database

-

index.php
<html>
Mhead>    
<title>Import Data in PHP</title>
</head>
<body>
<form action="import.php" method="post" name="upload_excel" enctype="multipart/form-data">
     <fieldset>
      <legend>Import CSV/Excel file</legend>
      <div class="control-group">
       <div class="control-label">
        <label>CSV/Excel File:</label>
       </div>
       <div class="controls">
        <input type="file" name="file" id="file" class="input-large">
       </div>
      </div>
      
      <div class="control-group">
       <div class="controls">
       <button type="submit" id="submit" name="Import" class="btn btn-primary button-loading" data-loading-text="Loading...">Upload</button>
       </div>
      </div>
     </fieldset>
    </form>
</body>
</html>
import.php
<?php
include 'db.php';
if(isset($_POST["Import"])){
  

  echo $filename=$_FILES["file"]["tmp_name"];
  

   if($_FILES["file"]["size"] > 0)
   {

     $file = fopen($filename, "r");
          while (($emapData = fgetcsv($file, 10000, ",")) !== FALSE)
          {
     
           //It wiil insert a row to our subject table from our csv file`
            $sql = "INSERT into subject (`SUBJ_CODE`, `SUBJ_DESCRIPTION`, `UNIT`, `PRE_REQUISITE`,COURSE_ID, `AY`, `SEMESTER`) 
              values('$emapData[1]','$emapData[2]','$emapData[3]','$emapData[4]','$emapData[5]','$emapData[6]','$emapData[7]')";
          //we are using mysql_query function. it returns a resource on true else False on error
           $result = mysql_query( $sql, $conn );
    if(! $result )
    {
     echo "<script type=\"text/javascript\">
       alert(\"Invalid File:Please Upload CSV File.\");
       window.location = \"index.php\"
      </script>";
    
    }

          }
          fclose($file);
          //throws a message if data successfully imported to mysql database from excel file
          echo "<script type=\"text/javascript\">
      alert(\"CSV File has been successfully Imported.\");
      window.location = \"index.php\"
     </script>";
         
    

    //close of connection
   mysql_close($conn); 
    
    
   
   }
 }  
?>
db.php
<?php
$conn=mysql_connect("localhost","root","") or die("Could not connect");
mysql_select_db("db",$conn) or die("could not connect database");
?>
REad full article

Comments

Post a Comment

Popular posts from this blog

TOP RECRUITMENT COMPANIES IN INDIA

-
Image
Placement organization plays a vital role in matching potential candidates to employers. Today, the whole scenario of recruiting talented people has changed drastically as every company approaches placement agencies to hire candidates that would be valuable assets in the future. Every agency thoroughly checks the background details of candidates, interviews them, and trains them with professionals. Before going into detail about the top recruitment companies, we need to see the advantages of hiring through these organizations. Benefits For Recruiting Through Agencies:-  For the past, many year’s recruitment companies are taking the road map of agencies to hire the workforce, which has proven helpful as follow, 1. Quick hiring process 2. Meeting the purposes 3. Negotiate salary TOP RECRUITMENT COMPANIES IN INDIA 1. RANSSTAD INDIA Keeping the legacy of 28 years, the company has 57K+ temporary employees on-site and over 500K placement to date. The Ransstad is one of the best recruitme...
Read more

Best Indian Colleges For MBA

-
Image
  Every Master’s degree plays an important role in any student’s career. For pursuing a Master’s degree selection of the right college is a must. There are many best Indian colleges for MBA. These colleges will provide proper guidance and grooming which is the major need of every MBA student. Prestige Institute of Management And Research The organization has been Accredited Thrice Consecutively by NAAC with the most noteworthy Grade A++ now. The Institute is ISO 9001:2015 affirmed. In acknowledgment of its Performance and High principles in giving quality schooling, the Institute has been presented Autonomous Status by the University Grants Commission 2006, 2012, 2018 just as Devi Ahilya Vishwavidyalaya on the proposal of a powerful master board of trustees named by UGC to assess the Institute. This is a crucial achievement for the Institute. Eminence Institute of Management and Research is pleased to have set up AIC – Prestige Inspire Foundation under the aegis of Atal Innovation ...
Read more

Boost Your Brand New Site Up Google’s Ranking

-
Image
  The best way to rank any of your sites is through Google. There’s a no-brainer to that. Google is regarded as one of the most powerful tools to help you boost your site. If you have developed a brand new site, you should be aware of the effectiveness and importance of google. Google is the world’s biggest search engine which holds 88% of total searches and contains the world’s information, including webpages, images, videos, and much other information. Google SEO  is the most powerful tool to grow your website organically and the rest of other techniques include  Social Media Marketing , Email Marketing, Pay-Per-Click (PPC), and others. All sites want to rank up their sites on Google’s first page as most of the clicks come through the first page only; more than 75% of people don’t tend to go past Google’s first page. Step by Step Guide: Boost your Brand New Site up Google’s ranking To make your site grow, you should target to appear on google’s first page as more  ...
Read more