for ($row = 5; $row <= $data->rowcount(); $row++) { if ($data->format($row, 3) != "") { $arr_test = explode(" ", $data->format($row, 3)); $uom = str_replace('"', "", $arr_test[1]); if (!in_array($uom, $unit_master)) { $unit_master[] = $uom; } } } foreach ($unit_master as $unit_name) { $sql_unit_master = "insert into ms_uom set\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tname = '" . $unit_name . "'"; $result_ins = mysql_query($sql_unit_master) or die("Error in query:" . $sql_unit_master . "<br>" . mysql_error() . ":" . mysql_errno()); } $dep_id = 0; for ($row = 5; $row <= $data->rowcount(); $row++) { if ($data->bold($row, 1, 0)) { $sql_department = "insert into ms_department set\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tname = '" . $data->value($row, 1, 0) . "'"; $result_ins = mysql_query($sql_department) or die("Error in query:" . $sql_department . "<br>" . mysql_error() . ":" . mysql_errno()); $dep_id = mysql_insert_id(); } else { $unit_id = 0; if ($data->format($row, 3) != "") { $arr_test = explode(" ", $data->format($row, 3)); $uom = str_replace('"', "", $arr_test[1]); } $sql = "SELECT uom_id FROM ms_uom where name = '" . $uom . "'"; $result = mysql_query($sql) or die("Error in : " . $sql . "<br>" . mysql_errno() . " : " . mysql_error()); if (mysql_num_rows($result) > 0) { $row_1 = mysql_fetch_array($result); $unit_id = $row_1['uom_id']; }
table.excel tbody td { vertical-align:bottom; } table.excel tbody td { padding: 0 3px; border: 1px solid #EEEEEE; } </style> </head> <body> <? for ($row=5;$row<=$data->rowcount();$row++) { //for ($col=1;$col<=$xls->colcount();$col++) { //echo $xls->val($row,$col); echo "-"; //echo $xls->raw($row,$col); echo "-"; //echo $sql_ins = "insert into ms_item_master set // name='".$xls->val($row,1)."', // opening_quantity = '".$xls->raw($row,2)."', // uom_id='', // opening_rate = '".$xls->raw($row,3)."'"; //} } ?> <?php echo $data->bold(5, 1, $sheet = 0); ?> </body> </html>