CSV to Mysql

Admin

8 years ago

Upload CSV to Mysql

<?php

if(isset($_POST['upload_excel']))
{
	
error_reporting(0);
	
include ("conn.php");	

//-- Truncate/Delete Table data--	
$sql = "TRUNCATE TABLE products";
mysqli_query($db,$sql);
//--//
	
if(isset($_POST["upload_excel"]))
	{
	$file = $_FILES['file']['tmp_name'];
	$handle = fopen($file, "r");
	$c = 0;
		while(($filesop = fgetcsv($handle, 10000000, ",")) !== false)
		{
			$code=time();
			$product_name=$filesop[1];
			$category=$filesop[2];
			//==============================
			$price=$filesop[3];
			//----------
			$sql=mysqli_query($db,"INSERT INTO products (product_name,category,price) VALUES ('$product_name','$category','$price')") 
			or die(mysqli_error($db));
			$c = $c + 1;
		}
		
			if($sql){
				echo "<div class='alert alert-success' role='alert'>You database has imported successfully. You have inserted ". $c ." recoreds </div>";
			}else{
				echo "<div class='alert alert-danger' role='alert'>Sorry! There is some problem.</div>";
			}

	}
	
	
}
?>

<?php

if(isset($_POST['upload_excel']))

{

error_reporting(0);

include ("conn.php");

//-- Truncate/Delete Table data--

$sql = "TRUNCATE TABLE products";

mysqli_query($db,$sql);

//--//

if(isset($_POST["upload_excel"]))

{

$file = $_FILES['file']['tmp_name'];

$handle = fopen($file, "r");

$c = 0;

while(($filesop = fgetcsv($handle, 10000000, ",")) !== false)

{

$code=time();

$product_name=$filesop[1];

$category=$filesop[2];

//==============================

$price=$filesop[3];

//----------

$sql=mysqli_query($db,"INSERT INTO products (product_name,category,price) VALUES ('$product_name','$category','$price')")

or die(mysqli_error($db));

$c = $c + 1;

}

if($sql){

echo "<div class='alert alert-success' role='alert'>You database has imported successfully. You have inserted ". $c ." recoreds </div>";

}else{

echo "<div class='alert alert-danger' role='alert'>Sorry! There is some problem.</div>";

}