how to embed image while generating excel report in php?
Code:
$excel=new ExcelWriter("report_'$date'.xls");
if($excel==false)
echo $excel->error;
// this will create heading of each column in excel file
//$myArr=array("Enquiry ID.","Enquiry Title","Enquiry History","Enquiry Keywords","Enquiry Start Date
//","Enquiry End Date,Enquiry Status,Enquirer Name,Enquirer Gender,Enquirer Location,Enquirer Age,Expert Name,Expert Location,Expert Qualification,Assign To Organization,Admin Assigned");
$myArr=array("Sr.No","Enquiry ID.","Enquiry Title","Enquiry History","Enquiry Keywords","Enquiry Start Date","Enquiry End Date","Enquiry Status","Enquirer Name","Enquirer Gender","Enquirer Location","Enquirer Age","Expert Name","Expert Location","Expert Qualification","Assign To Organization","Admin Assigned");
$excel->writeLine($myArr);
// now fetch data from database table, there is a new line create each time loop runs
$qry=mysql_query("select * from ".$Enquiry_details);
if($qry!=false)
{
$i=1;
while($res=mysql_fetch_array($qry))
{
$enquiry_status = $res['e_status_enquirer'];
if($enquiry_status ==0)
{
$enquiry_status_flag ="New";
}
else if($enquiry_status ==1)
{
$enquiry_status_flag="In progress";
}
else
{
$enquiry_status_flag ="Closed";
}
//Get the Enquirer deatils
$enqquery = "select * from " .$Enquirer_registration. " where e_id =".$res['e_id'];
$enqresult = mysql_query($enqquery);
$row = mysql_fetch_array($enqresult,MYSQL_ASSOC);
$enq_f_name = $row['e_firstname'];
$enq_l_name = $row['e_lastname'];
$enq_name = $enq_f_name." ".$enq_l_name;
$country = $row['e_country'];
$gender = $row['e_gender'];
$age = $row['e_age'];
####################select the location of enquirer##########
$country_query = "select * from " .$countries. " where country_id ='$country'";
//echo $country_query;
$country_result = mysql_query($country_query);
$row_country = mysql_fetch_array($country_result);
$country_name = $row_country['country_name'];
#####################End of location of enquirer#########
//End of enquirer details
//Get the Expert deatils
$expquery = "select * from " .$Expert_registration. " where x_id =".$res['x_id'];
$expresult = mysql_query($expquery);
$exp_row = mysql_fetch_array($expresult,MYSQL_ASSOC);
$exp_f_name = $exp_row['x_firstname'];
$exp_l_name = $exp_row['x_lastname'];
$exp_name = $exp_f_name." ".$exp_l_name;
$exp_country = $exp_row['x_country'];
$exp_qual = $exp_row['x_qualifications'];
//$exp_age = $exp_row['e_age'];
####################select the location of expert##########
$exp_country_query = "select * from " .$countries. " where country_id ='$exp_country'";
//echo $country_query;
$exp_country_result = mysql_query($exp_country_query);
$exp_row_country = mysql_fetch_array($exp_country_result);
$exp_country_name = $exp_row_country['country_name'];
#####################End of location of expert#########
//End of expert details
//Get the admin details
$admin_query_email = "select * from " .$Admin_registration. " where a_id=".$res['a_id'];
//echo $admin_query_email;//exit;
$admin_result_email = mysql_query($admin_query_email);
while($row_email = mysql_fetch_array($admin_result_email))
{
$a_email = $row_email['a_email_address'];
$a_f_name = $row_email['a_firstname'];
$a_l_name = $row_email['a_lastname'];
$a_name = $a_f_name." ".$a_l_name;
}
//End of admin details
//$myArr=array($i,base64_decode($res['e_dtl_id']),base64_decode($res['e_desc']),base64_decode($res['e_clinic_case']),base64_decode($res['e_keyword']),base64_decode($res['createdate']),base64_decode($res['createdate']),base64_decode($res['enquiry_status']),base64_decode($res['enquiry_status']),base64_decode($res['enquiry_status']),base64_decode($res['enquiry_status']));
$myArr=array($i,$uniqueId.$res['e_dtl_id'],base64_decode($res['e_desc']),base64_decode($res['e_clinic_case']),base64_decode($res['e_keyword']),base64_decode($res['createdate']),base64_decode($res['createdate']),$enquiry_status_flag,$enq_name,$gender,$country_name,$age,$exp_name,$exp_country_name,$exp_qual,"",$a_name);
$excel->writeLine($myArr);
$i++;
}
}
Comment