060ad92489947d410d897474079c1477

Edit file

File name : import.php

Content :

<?php
	session_start();

include("../include/config.php");

include("../include/functions.php");

validate_admin();

?>
<!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>Upload page</title>
</head>
<body>
<?php

if ($_FILES[csv][size] > 0) {

//get the csv file
    $file = $_FILES[csv][tmp_name];
    $handle = fopen($file,"r");
    
    //loop through the csv file and insert into database
    do {
        if ($data[0]) {
            mysqli_query("INSERT INTO c_productprice (mrp_price, barcode_number) VALUES
                (
                    '".addslashes($data[0])."',
                    '".addslashes($data[1])."'
					
                )
            ");
        }
    } while ($data = fgetcsv($handle,1000,",","'"));
    //

//redirect
    header('Location: import.php?success=1'); die;

}

<?php if (!empty($_GET[success])) { echo "<b>Your file has been imported.</b><br><br>"; } //generic success notice ?>

<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1">
  Choose your file: <br />
  <input name="csv" type="file" id="csv" />
  <input type="submit" name="Submit" value="Submit" />
</form>

<?php

/*
if (isset($_FILES['csv']['size']) > 0) { 
 
    //get the csv file 
    $file = $_FILES['csv']['tmp_name']; 
    $handle = fopen($file,"r"); 
    $name = $_FILES['csv']['name'];
    //loop through the csv file and insert into database 
    do { 
        if ($data[0]) { 
		$exist = mysql_num_rows(mysql_query("SELECT contact_number FROM contacts WHERE contact_number = '".addslashes(trim($data[1],'"'))."'"));
		if($exist == 0 ) {
            mysql_query("INSERT INTO contacts (contact_name, contact_number,contact_file) VALUES 
                ( 
                    '".addslashes(trim($data[0],'"'))."', 
                    '".addslashes(trim($data[1],'"'))."',
					'".$name."'
                ) 
            "); 
		}
        } 
    } while ($data = fgetcsv($handle,1000,",","'"));     // 
 
    //redirect 
	echo '<script> window.loaction.href="import.php?result=1" </script>';
     die; 
 
} 
 
?> 
 
 
<?php if (isset($_GET['success'])) { echo "<b>Your file has been imported.</b><br><br>"; } //generic success notice ?> 
 
<form action="" method="post" enctype="multipart/form-data" name="form1" id="form1"> 
  Choose your file: <br /> 
  <input name="csv" type="file" id="csv" /> 
  <input type="submit" name="Submit" value="Submit" /> 
</form> 
 <?php
 */

/*
// open the csv file
$fp = fopen($filename,"r");

//parse the csv file row by row
while(($row = fgetcsv($fp,"500",",")) != FALSE)
{
    //insert csv data into mysql table
    $sql = "INSERT INTO tbl_books (name, author, isbn) VALUES('" . implode("','",$row) . "')";
    if(!mysqli_query($connection, $sql))
    {
        die('Error : ' . mysqli_error());
    }
}

fclose($fp);*/

/*
//Upload File
if (isset($_POST['submit'])) {
	if (is_uploaded_file($_FILES['filename']['tmp_name'])) {
		echo "<h1>" . "File ". $_FILES['filename']['name'] ." uploaded successfully." . "</h1>";
		echo "<h2>Displaying contents:</h2>";
		readfile($_FILES['filename']['tmp_name']);
	}

//Import uploaded file to Database
	$handle = fopen($_FILES['filename']['tmp_name'], "r");

while (($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
		$import="INSERT into tablename(item1,item2,item3,item4,item5) values('$data[0]','$data[1]','$data[2]','$data[3]','$data[4]')";

mysql_query($import) or die(mysql_error());
	}

fclose($handle);

print "Import done";

//view upload form
}else {

print "Upload new csv by browsing to file and clicking on Upload<br />\n";

print "<form enctype='multipart/form-data' action='import.php' method='post'>";

print "File name to import:<br />\n";

print "<input size='50' type='file' name='filename'><br />\n";

print "<input type='submit' name='submit' value='Upload'></form>";

}
*/
?>

</body>
</html>

Gel4y Mini Shell

Edit file