Skip to main content

how to import excel file into mysql database using php script

how to import excel file into mysql database using php script.
using fgetcsv() function to fix this issue.

php code :

<?php
if(isset($_POST["Import"]))
{
$host="localhost"; // Host name.
$db_user="root";//DB User Name
$db_password="";//DB Password
$db='test'; // Database name.
$conn=mysql_connect($host,$db_user,$db_password) or die (mysql_error());
mysql_select_db($db) or die (mysql_error());

 echo $filename=$_FILES["file"]["tmp_name"];
echo $ext=substr($filename,strrpos($filename,"."),(strlen($filename)-strrpos($filename,".")));
 if($_FILES["file"]["size"] > 0)
 {

   $file = fopen($filename, "r");
         while (($data = fgetcsv($file, 10000, ",")) !== FALSE)
         {
            //print_r($data);

            $sql = "INSERT into user(name,address,email,password) values('".$data[0]."','".$data[1]."','".$data[2]."','".$data[3]."')";
            mysql_query($sql);
         }
         fclose($file);
         echo "CSV File has been successfully Imported";
 }
 else
 echo "Invalid File:Please Upload .CSV File";

 }
?>

 html code :

<form enctype="multipart/form-data" method="post">
<table border="1" width="40%" align="center">
<tr >
<td colspan="2" align="center"><strong>Import .CSV/Excel file</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>
output:-


Popular posts from this blog

Collection Shell Commands in MongoDB

Create Collection  Syntax: db.createCollection("Collection Name"); Example: db.createCollection("users"); Delete collection in Mongodb Shell Command db.collection.drop()  Find Collection in Mongodb Shell Command db.collection.find() Show all Collection in Mongodb Shell Command show collections Creat Collection in Mongodb Shell Command db.createCollection("users") Rename the Collection In Mongodb Shell Command db.collection.renameCollection()   Update the single document in MongoDB collections Shell Command db.collection.updateOne()  Updates all the documents in MongoDB collections that match the given query.  db.collection.updateMany() Replaces the first matching document in MongoDB collection db.collection.replaceOne()  Deletes the first document in Mongodb collection db.collection.deleteOne()  db.collection.deleteMany()
Read more

find visitor location php

<?php function geoCheckIP($ip)   {   //check, if the provided ip is valid   if(!filter_var($ip, FILTER_VALIDATE_IP))   {   throw new InvalidArgumentException("IP is not valid");   }   //contact ip-server   $response=@file_get_contents('http://www.netip.de/search?query='.$ip);   if (empty($response))   {   throw new InvalidArgumentException("Error contacting Geo-IP-Server");   }   //Array containing all regex-patterns necessary to extract ip-geoinfo from page   $patterns=array();   $patterns["domain"] = '#Domain: (.*?)&nbsp;#i';   $patterns["country"] = '#Country: (.*?)&nbsp;#i';   $patterns["state"] = '#State/Region: (.*?)<br#i';   $patterns["town"] = '#City: (.*?)<br#i';   //Array where results will be stored   $ipInfo=array();   // &nbsp;   //check response from ipserver for above patterns   foreach ($pa...
Read more