<?php

session_start();

require_once('connect.php');

/*

$conn = mysql_connect('localhost', 'root', '') or die(mysql_error());

$db=mysql_select_db('parts_ordering', $conn) or die(mysql_error());

*/

//$csv = "";

// get total number of fields present in the database

function getcsv($csv,$no_of_field_names)

}

function format($value){

}

$file = "zWebLineItems.csv";

/*

//header to give the order to the browser

header('Content-Type: text/csv');

header('Content-Disposition: attachment;filename='.$file);

*/

//select table to export the data

$select_table=$mysqli->query("SELECT tom.OrderNumber,tom.PartNumber,tom.DateOrdered,4 as HardCodedField,tom.QtyOrdered,tom.LineItemApproved FROM `tblorderlineitem` tom ");

//$select_table=$mysqli->query("SELECT * FROM `TABLE 13`");

//$rows = $select_table->fetch_assoc();

$fileRS = fopen($file,'w');

if ($select_table->num_rows>0)

{

//getcsv(array_keys($rows));

}

while($row = $select_table->fetch_assoc())

{

$row['ShipToID'] = (string)format($row['ShipToID']);

$csv = getcsv($csv,$row);

/*

getcsv($rows);

$rows = mysql_fetch_assoc($select_table);

*/

}

fwrite($fileRS,$csv);

fclose($fileRS);

header('Content-Description: File Transfer');

header('Content-Type: application/octet-stream');

header('Content-Disposition: attachment; filename="'.basename($file).'"');

header('Expires: 0');

header('Cache-Control: must-revalidate');

header('Pragma: public');

header('Content-Length: ' . filesize($file));

readfile($file);

copy('zWebLineItems.csv','extract/zWebLineItems.csv');

unlink('zWebLineItems.csv');

?>