I try to export data to excel or pdf format on the server side, but I always get empty files.
for notice : using client side work good
<?php //set_time_limit(0); include ("../../resources/db/inc.php"); include ("../../resources/script/fontions.php"); require('../../resources/lib/dhtmlxConnector/codebase/grid_connector.php'); require('../../resources/lib/dhtmlxConnector/codebase/convert.php'); //$convert = new ConvertService("../../resources/lib/dhtmlxGrid/pdf-php/generate.php"); $convert = new ConvertService("../../resources/lib/dhtmlxGrid/excel-php/generate.php"); $convert->excel("some.xls",false); $sql="SELECT * FROM desktops "; $sql.="LEFT JOIN type_marque ON desktops.marque=type_marque.id_marque "; $sql.="LEFT JOIN departements ON desktops.departement=departements.id "; $sql.="WHERE id_desktops IN(1,2,3) ORDER BY id_desktops ASC"; $fields="cb,name,description,date-maj,desc-maj"; function formatting($row) { $id=$row->get_value(""); $pg="P"; $fil1=""; $arr=explode("|",getinfo($id,$pg,$fil1)); $row->set_value("date-maj",$arr[0]); $row->set_value("desc-maj",$arr[1]); } function getinfo($id,$pg,$fil1) { $s="SELECT * FROM maintenance WHERE id_desktops=".$id." AND type_maintenance='".$pg."'"; $s.=$fil1." ORDER BY date_maintenance DESC"; $r=mysql_query($s); $n=mysql_num_rows($r); if($n==0) { $last="-----"; $desc="Aucune Maintenance"; } else { $d=mysql_fetch_array($r); $last=utf8_encode(datEnFr($d['date_maintenance'])." à ".$d['time_maintenance']); $desc=$d['description_maintenance']; } return $last."|".$desc; } $config = new GridConfiguration(); $config->setHeader("C.B,Marque,Projet,Derniere M.a.J,#cspan"); $config->attachHeader("#rspan,#rspan,#rspan,Date,Description"); $config->setInitWidths('100,110,140,120,290'); $config->setColSorting("na,na,na,na,na"); $config->setColTypes("ro,ro,ro,ro,ro"); $config->setColAlign('center,center,center,left,center'); $grid=new GridConnector($connt); $grid->event->attach("beforeRender","formatting"); $grid->set_config($config); $grid->render_sql($sql,"",$fields); ?>