[0] empty sno
2025-11-02 12:12:40
/home_new/daprskr/web/module/Component/Board/Broadcast.php (260 line)
| 0249 $data = []; |
| 0250 $appendWhere[] = "b.isDelete = 'n'"; |
| 0251 $rows = $this->select('select', $search, $appendWhere, 'all'); |
| 0252 $data['list'] = $rows; |
| 0253 return $data['list']; |
| 0254 } |
| 0255 |
| 0256 |
| 0257 public function selectOne($sno) |
| 0258 { |
| 0259 if (!$sno) { |
| 0260 throw new \Exception('empty sno'); |
| 0261 } |
| 0262 $this->set('sno', $sno); |
| 0263 |
| 0264 $arrBind = []; |
| 0265 $query = "SELECT b.* FROM " . DB_BOARD_BROADCAST . " as b "; |
| 0266 $query .= " WHERE b.sno = ? and isDelete ='n'"; |
| 0267 |
| 0268 |
| 0269 $this->db->bind_param_push($arrBind, 'i', $sno); |
| 0270 $row = $this->db->query_fetch($query, $arrBind)[0]; |
| 0271 unset($arrBind); |
| 0272 if ($row['isDelete'] == 'y') { |