Popular Posts

Aug 19, 2013

Easy Way to Insert Data into Mysql Table from a CSV or Excel File

Reading each row from excel/csv file and then insert to mysql table is a old way.we can use mysql inbuilt query. The same thing in sqlserver and .net we use bulk insert to insert data from excel to sqlserver.

first create a page named it index.html

<script> // This function will pop a window which will tell the 
                 function popitup(url)
                        if (window.focus) {new_wind.focus();
                        return false;
Add  data : The file should be a .csv file  <a href="index.html" 
 onclick="return popitup('index.html')"
  > Check the format here </a> </br></br> 
 will be directed to ins_data.php-->
        <form action="ins_data.php" method="post" enctype="multipart/form-data">
                <label for="file">   </label>
                <input  type="file" name="file" id="file" />
          </br></br>      <input type="submit" value="Load data" 
 Create new file named it ins_data.php
         if (isset($_POST['button1'])) //  Do  THE FOLLOWING WHEN BUTTON IS PRESSED
                echo "button on is pressed";
                 if ($_FILES["file"]["error"] > 0)
         echo "Error: " . $_FILES["file"]["error"] . 
   "You have not selected a file or some other error <br />";
                {       //Errorless  start 
                        $file_name=$_FILES["file"]["name"];echo $file_name;
                                echo "Please the input file should be a .csv file";
      //      only executed if file is .csv
       echo "its correct";
   // Creating a temporary copy on the server 
     $location=""; //write the location of the uploaded file 
     // upload file to server
     $location . $_FILES["file"]["name"]);
                connect_db(); // MYSQL connection settings
                // I have provided a sample query : 
        // Please make changes as per your requirement 
                $q="LOAD DATA INFILE '$file_name' INTO TABLE t_log 
                              FIELDS TERMINATED BY \"\t\" 
                              LINES TERMINATED BY \"\n\" 
                              ( Lang,Doc_Type,Title,Issue,Keywords )";
                mysql_query($q) or die(mysql_error());

function connect_db()
        //  db config 
        $con = mysql_connect("localhost","username","password");
        if (!$con)
                die('Could not connect: ' . mysql_error());
        // enter your database name
        mysql_select_db("dbname", $con);

No comments:

Post a Comment