export2.php

<?php
//session_start();
$nojunk='';
require_once 'project_common.php';
require_once 'base/verify_login.php';

$link=get_link($GLOBALS['main_user'],$GLOBALS['main_pass']);

//////////////////Code for salary//////////

//echo '<pre>';print_r($_POST);echo '</pre>';

//print_r($ex_sample_id);
//export_h_examination($link);

$fp = fopen('php://output', 'w');
if ($fp) 
{
	header('Content-Type: text/csv');
	header('Content-Disposition: attachment; filename="export.csv"');
}

$ex_list=export_h_examination($link);

fputcsv($fp, $ex_list);
		
for($sample_id=$_POST['from'];$sample_id<=$_POST['to'];$sample_id++)
{
	$result_data=export_h_result($link,$sample_id,$ex_list);
	fputcsv($fp, $result_data);

}

function export_h_examination($link)
{
	$sql='select * from report where id=\''.$_POST['id'].'\'';
	$result=run_query($link,$GLOBALS['database'],$sql);
	$csv=mysqli_fetch_assoc($result);
	$explod=explode(',',$csv['examination_id']);
	
	
	$ret=array(0=>'DbID');
	//print_r($ret);
	foreach($explod as $v)
	{
		$ex_detail=get_one_examination_details($link,$v);
		$ret[$v]=$ex_detail['name'];
	}
	return $ret;
}

function export_h_result($link,$sample_id,$ex_list)
{
	foreach($ex_list as $k=>$v)
	{
		$sql='select * from result where sample_id=\''.$sample_id.'\' and examination_id=\''.$k.'\'';
		//echo $sql;
		$result=run_query($link,$GLOBALS['database'],$sql);
		$ar=get_single_row($result);
		//print_r($ar);
		$ret[$k]=isset($ar['result'])?$ar['result']:'';
		//print_r( $ret);
	}
	$ret['0']=$sample_id;
	return $ret;
}

















?>