query($query);
$sql="select * from company_master where comp_id=$cmp";
$resulta = $connect->query($sql);
while($rowa = $resulta->fetch_assoc())
{
$cmpn=$rowa["company_name"];
}
$active_sheet = $file->getActiveSheet();
$active_sheet->setCellValue('A1', $cmpn);
$active_sheet->setCellValue('A2', "Reports for Dated : ". $file_type);
$file->getActiveSheet()->getColumnDimension('A')->setWidth(10);
$file->getActiveSheet()->getColumnDimension('B')->setWidth(40);
//$file->->getStyle()->getFont()->setBold(true);
//$file->getActiveSheet()->getStyle("A1:B1")->getFont()->setBold( true );
$file->getActiveSheet()->getStyle('A1:B9')->getFont()->setBold(true);
//$file->getActiveSheet()->getCell('A')->getStyle()->getFont()->setBOLD(true);
$active_sheet->setCellValue('A4', 'Item Code');
$active_sheet->setCellValue('B4', 'Item Desc');
$active_sheet->setCellValue('C4', 'Uom Code');
$active_sheet->setCellValue('D4', 'Location');
$count = 5;
// foreach($result as $row)
while($row = $result->fetch_assoc())
{
$active_sheet->setCellValue('A' . $count, $row["itemcode"]);
$active_sheet->setCellValue('B' . $count, $row["item_desc"]);
$active_sheet->setCellValue('C' . $count, $row["uom_code"]);
$active_sheet->setCellValue('D' . $count, $row["location"]);
$count = $count + 1;
}
$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($file, $_POST["file_type"]);
$file_name = time() . '.' . strtolower($file_type);
$writer->save($file_name);
header('Content-Type: application/x-www-form-urlencoded');
header('Content-Transfer-Encoding: Binary');
header("Content-disposition: attachment; filename=\"".$file_name."\"");
readfile($file_name);
unlink($file_name);
exit;
} else
if($_SERVER["REQUEST_METHOD"] == "POST")
{
$name=($_POST['name']);
//$email=($_POST['eamail']);
$message=($_POST['message']);
$cmp=($_POST['educationg']);
$addpr=($_POST['educationh']);
$_SESSION["favanimal"] = $cmp;
if ($addpr=='C') {
$sql="Update itemmaster set op_2018=0";
if (mysqli_query($connect, $sql)) {
// echo "New record created successfully";
//} else {
// echo "Error: " . $sql . "
" . mysqli_error($conn);
}
}
if ($addpr=='A') {
$sql="Update itemmaster set op_2018=1 where concat(group_code,item_code)='$name' and company_id=$cmp ";
if (mysqli_query($connect, $sql)) {
// echo "New record created successfully";
//} else {
// echo "Error: " . $sql . "
" . mysqli_error($conn);
}
}
$query = "SELECT concat(group_code,item_code) itemcode,item_desc,uom_code,location FROM itemmaster where op_2018=1 and company_id=$cmp order by group_code,item_code";
//$statement = $connect->prepare($query);
//$statement->execute();
//$result = $statement->fetchAll();
$result = $connect->query($query);
}
?>
Export Data From Mysql to Excel using PHPSpreadsheet
Export Data From Mysql to Excel using PHPSpreadsheet
| Item Code |
Item Desc |
Uom Code |
Location |
'.$row["itemcode"].' |
'.$row["item_desc"].' |
'.$row["uom_code"].' |
'.$row["location"].' |
';
}
?>