MAINHACK

Viewing / Editing File: csv.php

<?php
if (isset($_POST["add"])) {
$host="localhost"; // Host name.
$db_user="thesjhvq_thesalonfriend"; //mysql user
$db_password="z+_)d2=SV2n@"; //mysql pass
$db='thesjhvq_thesalonfriend'; // Database name.
$con=mysqli_connect($host,$db_user,$db_password,$db);
// Check connection
if (mysqli_connect_errno())
{
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

$fileName = $_FILES["file"]["tmp_name"];

$file = fopen($fileName, "r");
        
        while (($column = fgetcsv($file, 10000, ",")) !== FALSE) {
            
            $product_name = "";
            if (isset($column[0])) {
                $product_name = mysqli_real_escape_string($con, $column[0]);
            }

$qty  = "";
             if (isset($column[1])) {
                $qty  = mysqli_real_escape_string($con, $column[1]);
            }

$price = "";
            if (isset($column[2])) {
                $price = mysqli_real_escape_string($con, $column[2]);
            }

$supplier = "";
            if (isset($column[3])) {
                $supplier = mysqli_real_escape_string($con, $column[3]);
            }

$date = "";
            if (isset($column[4])) {
                $date = mysqli_real_escape_string($con, $column[4]);
            }

$business_name = "";
            if (isset($column[5])) {
                $business_name = mysqli_real_escape_string($con, $column[5]);
            }

if(!empty($product_name)){

$sql2 = "INSERT INTO  products (product_name,qty,price,supplier,date,business_name)
VALUES('$product_name','$qty','$price','$supplier','$date','$business_name')";
 $de = mysqli_query($con,$sql2);

}  
}
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: csv.php

Server Info

System Features

User Info