conn->prepare($sql); try { $query->execute(); $person = $query->fetch(PDO::FETCH_ASSOC); } catch (PDOException $er) { echo "Error :" . $er->getMessage(); } //ดึงข้อมูลโทษ $sql = "select id, title from penalty_type"; $query = $cdb->conn->prepare($sql); try { $query->execute(); $count = $query->rowCount(); $i = 1; while ($data = $query->fetch(PDO::FETCH_ASSOC)) { $sjt[$data['id']] = $data['title']; } } catch (PDOException $er) { echo 'Error :' . $er->getMessage(); } //จบข้อมูลโทษ $no_field = array('page', 'qpage', 'form_action'); $sql = "select * "; $sql .= " from $tbname where 1=1 "; foreach ($_GET as $key => $value) { $key = str_replace('pdf_', '', $key); if (!in_array($key, $no_field)) { if ($value <> '') { $field = str_replace('s_', '', $key); $param[$field] = "%$value%"; $sql .= " and $field like :$field "; } } } if ($_GET['page'] == 1) { $start = 0; } else { $start = ($_GET['page'] - 1) * $_GET['qpage']; } $sql .= " order by id "; $sql .= " limit $start,$_GET[qpage] "; //echo $sql; $query = $cdb->conn->prepare($sql); try { $query->execute($param); $count = $query->rowCount(); $i = 1; while ($data = $query->fetch(PDO::FETCH_ASSOC)) { foreach ($data as $key => $value) { $json_data[$i][$key] = $value; } ++$i; } } catch (PDOException $er) { echo 'Error :' . $er->getMessage(); } ?> $value) { echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; ++$i; if ($i == 2) { $i = 0; } ++$x; } ?>

ข้อมูลการปฏิบัติราชการพิเศษ
ลำดับ	พ.ศ.	สถานโทษ	ลักษณะความผิด
' . $x . '	' . $value['year'] . '	' . $sjt[$value['penalty']] . '	' . $value['title'] . '