Admin Control Panel v2.0

✎ Editing: csv.php ← Back

<?php

header('Content-Type: application/excel');
header('Content-Disposition: attachment; filename="sample.csv"');
$con = mysqli_connect("localhost","miorita_admin","CAMINE@48912102","miorita_shop");
if (mysqli_connect_errno())
  {
  die( "Failed to connect to MySQL: " . mysqli_connect_error());

}
function prod_data($code, $col='thumb'){
	global $con;
	$data = mysqli_query($con,"select * from products where code = '$code'");
	$row = mysqli_fetch_assoc($data);
	return $row[$col];
}
function PDO_Connect($dsn, $user="", $password="")
{
    global $PDO;
    $PDO = new PDO($dsn, $user, $password);
    $PDO->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
	return $PDO;
}
function PDO_FetchOne($query, $params=null)
{
    global $PDO;
    if (isset($params)) {
        $stmt = $PDO->prepare($query);
        $stmt->execute($params);
    } else {
        $stmt = $PDO->query($query);
    }
    $row = $stmt->fetch(PDO::FETCH_NUM);
    if ($row) {
        return $row[0];
    } else {
        return false;
    }
}
function PDO_FetchRow($query, $params=null)
{
    global $PDO;
    if (isset($params)) {
        $stmt = $PDO->prepare($query);
        $stmt->execute($params);
    } else {
        $stmt = $PDO->query($query);
    }
    return $stmt->fetch(PDO::FETCH_ASSOC);
}
function PDO_FetchAll($query, $params=null)
{
    global $PDO;
    if (isset($params)) {
        $stmt = $PDO->prepare($query);
        $stmt->execute($params);
    } else {
        $stmt = $PDO->query($query);
    }
    return $stmt->fetchAll(PDO::FETCH_ASSOC);
}
function PDO_FetchAssoc($query, $params=null)
{
    global $PDO;
    if (isset($params)) {
        $stmt = $PDO->prepare($query);
        $stmt->execute($params);
    } else {
        $stmt = $PDO->query($query);
    }
    $rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
    return $rows[0];
}
function PDO_Execute($query, $params=null)
{
    global $PDO;

if (isset($params)) {
        $stmt = $PDO->prepare($query);
        $stmt->execute($params);
        return $stmt;
    } else {
        return $PDO->query($query);
    }
}
function PDO_LastInsertId()
{
    global $PDO;
    return $PDO->lastInsertId();
}
function PDO_ErrorInfo()
{
    global $PDO;
    return $PDO->errorInfo();
}
function PDO_Num($query){
   global $PDO;
$result = $PDO->prepare($query); 
$result->execute(); 
$number_of_rows = $result->fetchColumn(); 
return $number_of_rows;
}
function PDO_Sanitize($string){
	global $PDO;
	return $PDO->quote($string);
}
$pdo = PDO_Connect("sqlite:2018.db");
$key = 1;
$user_CSV[0] = array('Name','Code','Barcode Symbology','Brand','Category Code','Unit Code','Sale Unit Code', 'Purchase Unit Code','Cost','Price','Alert Quantity', 'Tax Rate Name','Tax Method','Image','Subcategory Code','Product Variants Separated by |','Custom Field 1','Custom Field 2','Custom Field 3','Custom Field 4','Custom Field 5','Custom Field 6', 'HSN Code', 'Slug', 'Second Name');
$prod = PDO_FetchAll("SELECT * FROM products");
foreach($prod as $val){
// very simple to increment with i++ if looping through a database result 
$user_CSV[$key] = array(str_replace(',','',$val['name']), $val['code'], 'code128', $val['supplier'], 'C'.$val['cat_id'], ($val['measure'] != '' ? strtolower($val['measure']) : 'pc'), ($val['measure'] != '' ? strtolower($val['measure']) : 'pc'),'dozen', $val['bought'], $val['price'], $val['warnqty'], 'No Tax', 'exclusive', (prod_data($val['code'], 'thumb') != '' ? str_replace('uploads/images/', '',prod_data($val['code'], 'thumb')) : 'no_image.png'), 'SC'.$val['scat_id'], 'none', $val['ingredients_ro'],$val['ingredients_fr'],$val['ingredients_nl'],$val['translate'],'CF5','CF6','HSN', str_replace(' ','-',strtolower($val['name'])), $val['name']);
$key++;
}

//print_r($user_CSV);
$fp = fopen('php://output', 'w');
foreach ($user_CSV as $line) {
    // though CSV stands for "comma separated value"
    // in many countries (including France) separator is ";"
    fputcsv($fp, $line, ',');
}
fclose($fp);

Cancel