[0] empty sno
2026-04-04 00:46:43
/home_new/daprskr/web/module/Component/Board/Knowledge.php (360 line)
| 0349 $data = []; |
| 0350 $appendWhere[] = "b.isDelete = 'n'"; |
| 0351 $rows = $this->select('select', $search, $appendWhere, 'all'); |
| 0352 $data['list'] = $rows; |
| 0353 return $data['list']; |
| 0354 } |
| 0355 |
| 0356 |
| 0357 public function selectOne($sno) |
| 0358 { |
| 0359 if (!$sno) { |
| 0360 throw new \Exception('empty sno'); |
| 0361 } |
| 0362 $this->set('sno', $sno); |
| 0363 |
| 0364 $arrBind = []; |
| 0365 $query = "SELECT b.*, t.subject as videoNm, t.link as videoUrl FROM " . DB_BOARD_KNOWLEDGE . " as b "; |
| 0366 $query .= " LEFT JOIN " . DB_BOARD_TV . " as t ON b.listNo = t.sno "; |
| 0367 $query .= " WHERE b.sno = ? and b.isDelete ='n'"; |
| 0368 |
| 0369 |
| 0370 $this->db->bind_param_push($arrBind, 'i', $sno); |
| 0371 $row = $this->db->query_fetch($query, $arrBind)[0]; |
| 0372 $row['keyword'] = explode(STR_DIVISION, $row['keyword']); |