Import CSV to Database using PHP

Import csv database using PHP. Follow the following code and you will done with CSV import script using PHP. If you have any questions you can feel free comment we will reply you ASAP.


PHP Code 

       

  <?php
 
   if(isset($_POST["Import"]))
   {
 
   $filename=$_FILES["file"]["tmp_name"];
 
   if($_FILES["file"]["size"] > 0)
   {
 
   $file = fopen($filename, "r");
           mysql_query('truncate table table');
           while (($data = fgetcsv($file, 10000, ",")) !== FALSE)
           {
              $sql = "INSERT into table(name,email,avg,sr,runs,wickets,hs,sixes,fours,longsixes,created) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]','$data[5]','$data[6]','$data[7]','$data[8]','$data[9]', now())";
              mysql_query($sql);
           }
           fclose($file);
           echo "CSV File has been successfully Imported";
   }
   else
   echo "Invalid File:Please Upload CSV File";
 
   }
   ?>

HTML Code 
       
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
   <head>
      <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
      <title>Import CSV/Excel file</title>
   </head>
   <body>
      <form enctype="multipart/form-data" method="post">
         <table border="1" width="40%" align="center">
            <tr >
               <td colspan="2" align="center"><strong>Import CSV</strong></td>
            </tr>
            <tr>
               <td align="center">CSV/Excel File:</td>
               <td><input type="file" name="file" id="file"></td>
            </tr>
            <tr >
               <td colspan="2" align="center"><input type="submit" name="Import" value="Import"></td>
            </tr>
         </table>
      </form>
   </body>
</html>

Most Popular

Customize wordpress register form wp_register()

<div>             <h3>Register for this site!</h3>             <p>Sign up now for the good stuff.</p>             <form method="post" action="<?php echo site_url('wp-login.php?action=register', 'login_post') ?>" class="wp-user-form">                 <div class="username">                     <label for="user_login"><?php _e('Username'); ?>: </label>                     <input type="text" name="user_login" value="<?php echo esc_attr(stripslashes($user_login)); ?>" size="20" id="user_login" tabindex="101" />             ...
Keep reading

What is difference between get and post method in php

What is HTTP? The Hypertext Transfer Protocol (HTTP) is designed to enable communications between clients and servers. HTTP works as a request-response protocol between a client and server. Two HTTP Request Methods commonly used for request-response between a client and server: GET and POST The GET Method Following example which shows you how to use get method. http://www.example.com/test/demo_form.php?name1=value1&name2=value2 Following are GET Request Method Points. 1. Request can be cached 2. Requests can be bookmarked 3. Requests remain in the browser history 4. Requests have length restrictions 5. Requests should be used only to retrieve data 6. Requests should never be used when dealing with sensitive data 7. Maximum path length of 2,048 characters 8. Data visible to everyone in URL. 9. GET is less secure compared to POST because data sent is the URL. Following are POST Request Method Points. 1. Requests are never cached 2. Requests do not remain in...
Keep reading

Disable/enable a form element using jQuery?

There are two ways to disable/enable form elements. Set the 'disabled' attribute to true or false: // Disable #x $('#x').attr('disabled', true); // Enable #x $('#x').attr('disabled', false); Add or remove the 'disabled' attribute: // Disable #x $("#x").attr('disabled', 'disabled'); // Enable #x $("#x").removeAttr('disabled');
Keep reading