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

Student Result Management System

-
Image
Students can see the result in this system. After the training and Exam, it's very easy to shows the result to students with the help of student roll no. This application is also used for the college management system. Modules of Student Result Management System: Students:- You can add the student detail ie. fields (Student Name, Roll No, Email ID, Gender, Class, and DOB). Student Classes: - In this Module can easily create the class with the section option. Also, you can manage all classes and the section. Subjects:- you can create the subject with the subject code. A very simple method to manage the subjects. You can also assign the subject to the class in a simple way. Result:- Result Section is a very important part of the application. you have to select the class then select the student name after that you will see the subjects than just ad the marks in the subjects fields. Admin Features Change password:- Admin can change the password any time. Dashboard:- On the Dashb
Read more

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 recruitment a
Read more

What Is The Job Role Of A Customer Support Executive?

-
Image
Customer service representatives are the backbone of any company that interacts with its clients frequently. These specialists assist businesses in establishing and maintaining great customer and client connections. You can determine whether or not you would like to follow this career path by learning more about it. In this article, we will talk in detail about  customer support jobs  and support representatives, and go into their primary and high-level responsibilities, as also the scope for success in this field. A consumer service executive listens to customers’ problems and offers them appropriate solutions. They are among the most significant aspects of any company because they reflect the true essence of an organization. They are in charge of maintaining clients by assisting them and developing positive relationships with them. They are the ones who are in direct touch with the customer, hence a Client Service Executive could either make or break the sale. In addition, they are f
Read more