Skip to main content

Insert Data from excel into database

<?php
//your database connection here...
//$_POST["Import"]   this is data which you want to insert

$sql='';
if(isset($_POST["Import"]))
{
$filename=$_FILES["file_product"]["tmp_name"];
$type=$_FILES["file_product"]["type"];
//print_r($_FILES);

 if($_FILES["file_product"]["size"] > 0)
{
 
$file = fopen($filename, "r");
while (($emapData = fgetcsv($file, 50000, ",")) !== FALSE)
{
 if($emapData[0]!="")
 {
  $t=mysql_escape_string(trim($emapData[2]));
  $t1=strlen($t);
  $city=mysql_escape_string(trim($emapData[7]));
  $city1=strlen($city);
  $state=mysql_escape_string(trim($emapData[8]));
  $state1=strlen($state);
  $zip=mysql_escape_string(trim($emapData[9]));
  $zip1=strlen($zip);
  $sql=rtrim($sql,',');
$sql ="insert into yourtable (phone_no, firstname, lastname,email, address1, address2, city, state, zip) values ('".mysql_escape_string(trim($emapData[1]))."','".mysql_escape_string(trim($emapData[2]))."','".mysql_escape_string(trim($emapData[3]))."','".mysql_escape_string(trim($emapData[4]))."','".mysql_escape_string(trim($emapData[5]))."','".mysql_escape_string(trim($emapData[6]))."','".mysql_escape_string(trim($emapData[7]))."','".mysql_escape_string(trim($emapData[8]))."','".mysql_escape_string(trim($emapData[9]))."')";
mysql_query($sql) or mysql_error(1);

 }    
}

fclose($file);
echo "CSV File has been successfully Imported";

}
 else
 echo "Invalid File:Please Upload CSV File";
}

?>
<html>
<form method="post" enctype="multipart/form-data">

<input type="file" name="file_product" />

<input type="submit" name="Import" />
</form>

</html>

Comments

Post a Comment

Popular posts from this blog

Parsing Domain Name From URL In PHP

To get Domain name from the url, we can use parse_url() php function. This would filter the domain name from the given url. $domain = str_ireplace ( 'www.' , '' , parse_url ( $url , PHP_URL_HOST )); This would return the google.com for both http://google.com and http://www.google.com
Post a Comment
Read more

get directory paths, get Base URLs, get URLs in static block, get secure URL in Magento

1) Get Directory paths  Mage::getBaseDir()  //output : /var/www/html/magento Mage::getBaseDir('app')  //output : /var/www/html/magento/app Mage::getBaseDir('media') //output : /var/www/html/magento/media Mage::getBaseDir(‘design’) => Get design directory path Mage::getBaseDir(‘code’) => Gives code directory file path Mage::getBaseDir(‘lib’) => Gives lib directory file path Mage::getBaseDir(‘skin’) => Gives skin directory file path Mage::getBaseDir(‘var’) => Gives var directory file path Mage::getBaseDir(‘cache’) => Gives cache directory file path Mage::getBaseDir(‘log’) => Gives log directory file path       2) Get Base URL  Mage::getBaseUrl() => Get base url path e.g. http://yourwebsite.com/  Mage::getBaseUrl('media') => Get MEDIA folder path e.g. http://yourwebsite.com/media/  Mage::getBaseUrl('js') => Get JS folder path e.g. http://yourwebsite.com/js/  Mage::getBaseUrl('skin') => Get...
1 comment
Read more