session_start(); if (!isset($_GET['hospital_id'])) { header("Location: index.php"); exit; } include 'php/config/autoload.inc.php'; use classes as cls; use config as cfg; $db = new cfg\database(); $ht = new cls\hospitals(); $pv = new cls\provinces(); $data = $ht->get_hospital_detail_by_id($_GET['hospital_id']); // print_r($data); $province = $pv->get_province($data['province']); $amphur = $pv->get_amphur($data['amphur']); $district = $pv->get_district($data['district']); /* Array ( [hospital_id] => 1 [hospital_verify_code] => กก11021จ [hospital_name] => ค่ายสรรพสิทธิประสงค์ [hospital_address] => 383 หมู่ 2 ถ.สถิตย์นิมานกาล [province] => 1 [amphur] => 4 [district] => 31 [zipcode] => 34190 [lat] => 15.1939973 [lng] => 104.8732654 [tel] => 045-3211735
<div class="panel-body"> <table class="table table-hover"> <tr> <th>ใบอนุญาติ</th> <th>ชื่อ</th> <th>ที่ตั้ง</th> <th colspan="2">จัดการ</th> </tr> <?php $sql = "select * from hospital order by hospital_id DESC limit 5;"; $result = $db->query($sql, $rows, $num_rows); if ($result) { foreach ($rows as $k => $v) { $province = $pv->get_province($v['province']); $provine_name = $province[0]['PROVINCE_NAME']; $amphur = $pv->get_amphur($v['amphur']); $amphur_name = $amphur[0]['AMPHUR_NAME']; $district = $pv->get_district($v['district']); $district_name = $district[0]['DISTRICT_NAME']; print "\n <tr>\n <td>" . $v['hospital_verify_code'] . "</td>\n <td>โรงพยาบาล" . $v['hospital_name'] . "</td>\n <td>\n " . $v['hospital_address'] . " อำเภอ" . $amphur_name . " ตำบล" . $district_name . " จังหวัด" . $provine_name . $v['zipcode'] . "\n </td>\n <td><a href='delete-hospital.php?id=" . $v['hospital_id'] . "' onclick='return confirm(\"ยืนยันการลบข้อมูล ?\");'><i class='fa fa-trash-o'></i></a></td>\n <td><a href='edit-hospital.php?id=" . $v['hospital_id'] . "'><i class='fa fa-pencil'></i></a></td>\n </tr>\n "; } } $result = null; $rows = null; $num_rows = null; ?> </table> </div> <div class="panel-footer text-right"> <a href="list-hospital.php">โรงพยาบาลทั้งหมด</a> </div>
<span id="province-helpBox" class="help-block">จังหวัดเดิมคือ <?php echo $province[0]['PROVINCE_NAME']; ?> </span> <input type="hidden" name="hidden_province_id" value="<?php echo $province[0]['PROVINCE_ID']; ?> "> </div> </div> <div class="form-group"> <label for="amphur" class="control-label col-md-4">อำเภอ</label> <div class="col-md-8"> <?php $pv = new cls\provinces(); $amphur = $pv->get_amphur($data['company_amphur']); ?> <select name="amphur" id="amphur" class="form-control" aria-describedby="amphur-helpBox"> <option value="">เลือกอำเภอ</option> </select> <span id="amphur-helpBox" class="help-block">อำเภอเดิมคือ <?php echo $amphur[0]['AMPHUR_NAME']; ?> </span> <input type="hidden" name="hidden_amphur_id" value="<?php echo $amphur[0]['AMPHUR_ID']; ?> "> </div> </div> <div class="form-group">
</select> <span id="province-helpBox" class="help-block">จังหวัดเดิมคือ <?php echo $province[0]['PROVINCE_NAME']; ?> </span> <input type="hidden" name="hidden_province_id" value="<?php echo $province[0]['PROVINCE_ID']; ?> "> </div> </div> <div class="form-group"> <label for="amphur" class="control-label col-md-4">อำเภอ</label> <div class="col-md-8"> <?php $amphur = $pv->get_amphur($_SESSION['profile_detail']['amphur']); ?> <select name="amphur" id="amphur" class="form-control" aria-describedby="amphur-helpBox"> <option value="">เลือกอำเภอ</option> </select> <span id="amphur-helpBox" class="help-block">อำเภอเดิมคือ <?php echo $amphur[0]['AMPHUR_NAME']; ?> </span> <input type="hidden" name="hidden_amphur_id" value="<?php echo $amphur[0]['AMPHUR_ID']; ?> "> </div> </div> <div class="form-group">