function dump_dataBase($filename) { $row = array (); $row2 = array (); $row3 = array (); $tb_names = array (); $cadException = TransactionBasicService :: openTransaction($transaction); $sql = "SHOW TABLES"; $cadException = TransactionBasicService :: runArraySelect($sql, $transaction, $row); $i = 0; $workbook = & new Workbook($filename); $text_format = & $workbook->addformat(array ('align' => 'justify', 'border' => 4, 'border_color' => 'gray', 'bottom' => 4, 'valign' => 'vjustify', 'color' => 'black', 'size' => 10, 'font' => 'Times New Roman')); foreach ($row as $row2) { $tb_names[$i] = $row2[0]; $worksheet = & $workbook->addworksheet($tb_names[$i]); $heading = & $workbook->addformat(array ('bold' => 1, 'color' => 'red', 'size' => 18, 'align' => 'center', 'valign' => 'center', 'font' => 'Times New Roman')); $worksheet->write(1, 4, $tb_names[$i], $heading); $worksheet->merge_cells('1', '4', '2', '12'); //Write fields names into Excel sheet $text_format = & $workbook->addformat(array ('color' => 'blue', 'border' => 4, 'border_color' => 'gray', 'bottom' => 4, 'pattern' => 1, 'fg_color' => 'cyan', 'align' => 'center', 'valign' => 'center', 'size' => 12, 'font' => 'Times New Roman')); $sql2 = "DESC ".$tb_names[$i]." ;"; $row3 = array(); $cadException = TransactionBasicService :: runArraySelect($sql2, $transaction, $row3); $j = 2; //$array_size = mysql_num_rows($row3); for ($l=0; $l < count($row3); $l++) { $name_field = $row3[$l][0]; $worksheet->write(4, $j , $name_field, $text_format); $j++; } //Write fields data into Excel sheet $sql3 = "SELECT * FROM ".$tb_names[$i]; $row5 = array (); $cadException = TransactionBasicService :: runArraySelect($sql3, $transaction, $row5); $array_size1 = count($row5); //var_dump ($array_size1); $j = 5; $text_format = & $workbook->addformat(array ('color' => 'blue', 'border' => 4, 'border_color' => 'gray', 'bottom' => 4, 'align' => 'center', 'valign' => 'center', 'size' => 12, 'font' => 'Times New Roman')); for ($i=0;$i<$array_size1;$i++) { $k = 0; foreach ($row5[$i] as $row6) { $worksheet->write_string($j, $k+2, $row6, $text_format); $k++; } $j++; } /* $sql3 = "SELECT * FROM ".$tb_names[$i]; $row5 = array (); $cadException = TransactionBasicService :: runArraySelect($sql3, $transaction, $row5); $j = 5; //$array_size1 = count($row5); $k=0; foreach ($row5 as $row6){ $array_size1 = count($row6); //for($l=0;$l<$array_size1;$l++){ //for($k=0;$k<$array_size1;$k++){ $worksheet->write_string($j, $k+2, $row6[$k] ,$text_format); //} /*$k = 0; $nb_field = count($row5[$l])/2; while ($k < $nb_field) { $worksheet->write_string($j, $k+2, $row5[$l][$k] ,$text_format); $k++; } //} $k++; $j++; }*/ $i++; } $workbook->close(); }