php excel解析传值查数据库的内容查询不到
查询的num_rows()一直为0,但是插入数据库好使但是查询就不好使
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { // 遍历工作表
foreach ($worksheet->getRowIterator() as $row) { // 遍历行
$rowindex = $row->getRowIndex() . PHP_EOL; // 第几行
$cellIterator = $row->getCellIterator(); // 得到所有列
$cellIterator->setIterateOnlyExistingCells(false); // Loopall cells, even if it is not set
foreach ($cellIterator as $cell) { // 遍历列
if (! is_null($cell)) { // 如果列不给空就得到它的坐标和计算的值
// $cell->getCoordinate()坐标
$address = $cell->getCalculatedValue() . PHP_EOL;
$column = $cell->getColumn(); // 获取单元格坐标列
switch ($column) {
case "A":
$company = $address;
break;
case "B":
$year = $address;
break;
case "C":
$workingHours = $address;
break;
case "D":
$name = $address;
break;
case "E":
$wages = $address;
break;
case "F":
$workload = $address;
break;
case "G":
$subsidy = $address;
break;
case "H":
$totalCost = $address;
break;
case "I":
$city = $address;
break;
}
}
}
if ($rowindex >= '2') {
$staff = $this->invoice_model->get_staffnamewages($name,$wages);
//echo $staff['staff_id'];
// 将解析后的数组存入数据库
//$result = $this->invoice_model->add_workload($company, $year, $workingHours, $name, $wages, $workload, $subsidy, $totalCost, $city);
}
function get_staffnamewages($name, $wages)
{
$query=$this->db->query("SELECT * FROM qb_staff WHERE name = '".$name."' and wages = '".$wages."' and delete_flag = 1");
$rel = $query->result_array ();
print_r($rel);
}