| Server IP : 103.233.192.212 / Your IP : 18.118.173.146 Web Server : Apache/2 System : Linux sv1.inde.co.th 3.10.0-1160.36.2.el7.x86_64 #1 SMP Wed Jul 21 11:57:15 UTC 2021 x86_64 User : sumpatuan ( 1058) PHP Version : 5.5.38 Disable Function : symlink,shell_exec,exec,proc_close,proc_open,popen,system,dl,putenv,passthru,escapeshellarg,escapeshellcmd,pcntl_exec,proc_get_status,proc_nice,proc_terminate,pclose,ini_alter,virtual,openlog,ini_restore MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /home/sumpatuan/domains/sumpatuan.go.th/public_html/main/ |
Upload File : |
<?php require_once('db_main.php'); ?>
<!doctype html>
<html lang="en">
<head>
<?php include_once ("head.html"); ?>
</head>
<body class="bg-all animated fadeIn faster ">
<?php include_once ("chatfacebook.php"); ?>
<div class="container-fluid p-0 " >
<div class="container bg-main fix-page mb-0 pb-0" >
<?php include_once ("menu.php"); ?>
</div>
<!------ data ------>
<div class="container bg-white fix-page mt-0" id="data">
<div class="row">
<div class="col bg-cl-0 fcl-cl-1 bg-txt-head text-center">
เกี่ยวกับ อบต.
</div>
<div class="w-100"></div>
<div class="col p-0">
<div class="d-flex align-items-start bg-cl-5">
<div class="nav flex-column w-25 text-start mb-5" id="nav-tab" >
<button class="nav-link btn_about active" id="nav-01-tab" data-bs-toggle="tab" data-bs-target="#nav-01" type="button" role="tab" aria-controls="nav-01" aria-selected="true">ประวัติความเป็นมา</button>
<button class="nav-link btn_about" id="nav-02-tab" data-bs-toggle="tab" data-bs-target="#nav-02" type="button" role="tab" aria-controls="nav-02" aria-selected="false">ตราสัญลักษณ์</button>
<button class="nav-link btn_about" id="nav-03-tab" data-bs-toggle="tab" data-bs-target="#nav-03" type="button" role="tab" aria-controls="nav-03" aria-selected="false">วิสัยทัศน์ และ พันธกิจ</button>
<button class="nav-link btn_about" id="nav-04-tab" data-bs-toggle="tab" data-bs-target="#nav-04" type="button" role="tab" aria-controls="nav-04" aria-selected="false">จำนวนหมู่บ้านประชากร</button>
<button class="nav-link btn_about" id="nav-05-tab" data-bs-toggle="tab" data-bs-target="#nav-05" type="button" role="tab" aria-controls="nav-05" aria-selected="false">สภาพทั่วไป ลักษณะภูมิประเทศ</button>
<button class="nav-link btn_about" id="nav-06-tab" data-bs-toggle="tab" data-bs-target="#nav-06" type="button" role="tab" aria-controls="nav-06" aria-selected="false">การเมืองการปกครอง</button>
<button class="nav-link btn_about" id="nav-07-tab" data-bs-toggle="tab" data-bs-target="#nav-07" type="button" role="tab" aria-controls="nav-07" aria-selected="false">สภาพทางเศรษฐกิจ และ สังคม</button>
<button class="nav-link btn_about" id="nav-08-tab" data-bs-toggle="tab" data-bs-target="#nav-08" type="button" role="tab" aria-controls="nav-08" aria-selected="false">สภาพทางการศึกษา ศาสนา วัฒนธรรม</button>
<button class="nav-link btn_about" id="nav-09-tab" data-bs-toggle="tab" data-bs-target="#nav-09" type="button" role="tab" aria-controls="nav-09" aria-selected="false">การบริการพื้นที่ และ ทรัพยากรธรรมชาติ</button>
</div>
<div class="tab-content w-75 h-100 fw-300 bg-white" id="nav-tabContent" style="min-height:500px;">
<div class="tab-pane fade show p-4 pb-5 active" id="nav-01" role="tabpanel" aria-labelledby="nav-01-tab" tabindex="0">
<?php
$sql_data1 = "SELECT * FROM `data_dataother` WHERE `id_dataother`=1 AND `stt_dataother`=0";
$qr_data1 = mysqli_query($con_db_main,$sql_data1) or die( mysqli_error($con_db_main));
$rs_data1 = mysqli_fetch_assoc($qr_data1);
if( !isset($rs_data1["page_dataother"]) ){
echo '<div class="w-100 text-center mt-5 mb-5 text-secondary opacity-50 fs-20 fw-500" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>ประวัติความเป็นมา</div>';
}else{
echo $rs_data1["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='1' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='1' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB1" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB1" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB1" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-02" role="tabpanel" aria-labelledby="nav-02-tab" tabindex="0">
<?php
$sql_data2 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 2 AND `stt_dataother` = 0 ";
$qr_data2 = mysqli_query($con_db_main,$sql_data2) or die( mysqli_error($con_db_main));
$rs_data2 = mysqli_fetch_assoc($qr_data2);
if( !isset($rs_data2["page_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>ตราสัญลักษณ์</div>';
}else{
echo $rs_data2["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='2' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='2' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB2" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB2" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB2" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-03" role="tabpanel" aria-labelledby="nav-03-tab" tabindex="0">
<?php
$sql_data3 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 3 AND `stt_dataother` = 0 ";
$qr_data3 = mysqli_query($con_db_main,$sql_data3) or die( mysqli_error($con_db_main));
$rs_data3 = mysqli_fetch_assoc($qr_data3);
if( !isset($rs_data3["page_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>วิสัยทัศน์ และ พันธกิจ</div>';
}else{
echo $rs_data3["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='3' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='3' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB3" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB3" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB3" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-04" role="tabpanel" aria-labelledby="nav-04-tab" tabindex="0">
<?php
$sql_data4 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 4 AND `stt_dataother` = 0 ";
$qr_data4 = mysqli_query($con_db_main,$sql_data4) or die( mysqli_error($con_db_main));
$rs_data4 = mysqli_fetch_assoc($qr_data4);
if( !isset($rs_data4["lastupdate_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>หมู่บ้านประชากร</div>';
}else{
$sql_datavl = "SELECT * FROM `data_village` ORDER BY `id_village` ASC ";
$qr_datavl = mysqli_query($con_db_main,$sql_datavl) or die( mysqli_error($con_db_main));
echo '<div class="w-100 h-100 text-center mb-3 fs-30 fw-700">'.$rs_data4["name_dataother"].'</div>';
?>
<table class="table table-bordered table-hover mb-0">
<tdead class="table-secondary">
<tr class="text-center fw-500">
<td style="width:35%">ข้อมูลหมู่บ้าน</th>
<td style="width:20%">จำนวนครัวเรือน</th>
<td style="width:15%">จำนวนผู้ชาย</th>
<td style="width:15%">จำนวนผู้หญิง</th>
<td style="width:15%">รวมประชากร</th>
</tr>
</thead>
<tbody class="table-group-divider fs-16">
<?php
$sum_village = 0;
$sum_male = 0;
$sum_female = 0;
$sum_all = 0;
while($rs_datavl = mysqli_fetch_array($qr_datavl)){
$sum_village = $sum_village + $rs_datavl["family_village"];
$sum_male = $sum_male + $rs_datavl["total_male_village"];
$sum_female = $sum_female + $rs_datavl["total_female_village"];
$sum_all = $sum_all + $rs_datavl["total_all_village"];
?>
<tr class="text-end">
<td class="text-start fw-500 ps-3" style="background-color:#fffbe6;">หมู่ที่ <?php echo $rs_datavl["id_village"];?> <?php echo $rs_datavl["name_village"];?></th>
<td class="fw-500"><span><?php echo number_format($rs_datavl["family_village"]); ?></span> <small class="ms-2 fw-300 fs-12">ครัวเรือน</small></td>
<td class=""><?php echo number_format($rs_datavl["total_male_village"]); ?> <small class="ms-2 fw-300 fs-12">คน</small></td>
<td class=""><?php echo number_format($rs_datavl["total_female_village"]); ?> <small class="ms-2 fw-300 fs-12">คน</small></td>
<td class="fw-500"><span><?php echo number_format($rs_datavl["total_all_village"]); ?></span> <small class="ms-2 fw-300 fs-12">คน</small></td>
</tr>
<?php
}
if( $sum_all==0 ){echo '<tr class="text-center table-secondary"><td colspan="5"><div class="w-100 h-100 text-center mt-5 mb-5 text-white fs-20 fw-300" ><i class="fas fa-eye-slash fs-36"></i><br>ไม่พบข้อมูล<br>หมู่บ้านประชากร</div></td></tr>'; }
?>
<tr class="text-end fw-500 text-success" >
<td class="">ข้อมูลรวม</th>
<td class="table-secondary"><?php echo number_format($sum_village); ?> <small class="ms-2 fw-300 fs-12">ครัวเรือน</small></td>
<td class="table-secondary"><?php echo number_format($sum_male); ?> <small class="ms-2 fw-300 fs-12">คน</small></td>
<td class="table-secondary"><?php echo number_format($sum_female); ?> <small class="ms-2 fw-300 fs-12">คน</small></td>
<td class="table-secondary"><?php echo number_format($sum_all); ?> <small class="ms-2 fw-300 fs-12">คน</small></td>
</tr>
</tbody>
</table>
<div class="text-end w-100 "><small class="text-secondary">อัพเดทข้อมูลล่าสุด : <?php echo $rs_data4["lastupdate_dataother"]; ?></small></div>
<?php
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-05" role="tabpanel" aria-labelledby="nav-05-tab" tabindex="0">
<?php
$sql_data5 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 5 AND `stt_dataother` = 0 ";
$qr_data5 = mysqli_query($con_db_main,$sql_data5) or die( mysqli_error($con_db_main));
$rs_data5 = mysqli_fetch_assoc($qr_data5);
if( !isset($rs_data5["page_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>สภาพทั่วไป ลักษณะภูมิประเทศ</div>';
}else{
echo $rs_data5["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='5' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='5' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB5" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB5" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB5" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-06" role="tabpanel" aria-labelledby="nav-06-tab" tabindex="0">
<?php
$sql_data6 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 6 AND `stt_dataother` = 0 ";
$qr_data6 = mysqli_query($con_db_main,$sql_data6) or die( mysqli_error($con_db_main));
$rs_data6 = mysqli_fetch_assoc($qr_data6);
if( !isset($rs_data6["page_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>การเมืองการปกครอง</div>';
}else{
echo $rs_data6["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='6' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='6' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB6" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB6" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB6" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-07" role="tabpanel" aria-labelledby="nav-07-tab" tabindex="0">
<?php
$sql_data7 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 7 AND `stt_dataother` = 0 ";
$qr_data7 = mysqli_query($con_db_main,$sql_data7) or die( mysqli_error($con_db_main));
$rs_data7 = mysqli_fetch_assoc($qr_data7);
if( !isset($rs_data7["page_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>สภาพทางเศรษฐกิจ และ สังคม</div>';
}else{
echo $rs_data7["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='7' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='7' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB7" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB7" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB7" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-08" role="tabpanel" aria-labelledby="nav-08-tab" tabindex="0">
<?php
$sql_data8 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 8 AND `stt_dataother` = 0 ";
$qr_data8 = mysqli_query($con_db_main,$sql_data8) or die( mysqli_error($con_db_main));
$rs_data8 = mysqli_fetch_assoc($qr_data8);
if( !isset($rs_data8["page_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>สภาพทางการศึกษา ศาสนา วัฒนธรรม</div>';
}else{
echo $rs_data8["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='8' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='8' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB8" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB8" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB8" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
<div class="tab-pane fade p-4 pb-5" id="nav-09" role="tabpanel" aria-labelledby="nav-09-tab" tabindex="0">
<?php
$sql_data9 = "SELECT * FROM `data_dataother` WHERE `id_dataother` = 9 AND `stt_dataother` = 0 ";
$qr_data9 = mysqli_query($con_db_main,$sql_data9) or die( mysqli_error($con_db_main));
$rs_data9 = mysqli_fetch_assoc($qr_data9);
if( !isset($rs_data9["page_dataother"]) ){
echo '<div class="w-100 h-100 text-center mt-5 mb-5 text-secondary opacity-25 fs-30 fw-300" ><i class="fas fa-eye-slash fs-70"></i><br>ไม่พบข้อมูล<br>การบริการพื้นที่ และ ทรัพยากรธรรมชาติ</div>';
}else{
echo $rs_data9["page_dataother"];
$sql_cpwimg = "SELECT COUNT(*) FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='9' ";
$qr_cpwimg = mysqli_query($con_db_main, $sql_cpwimg) or trigger_error("SQL", E_USER_ERROR);
$rs_cpwimg = mysqli_fetch_row($qr_cpwimg);
$sql_data_fileimg = "SELECT * FROM `data_filedoc_dataother` WHERE `id_tbdata_filedoc_dataother`='9' ";
$qr_data_fileimg = mysqli_query($con_db_main,$sql_data_fileimg) or die( mysqli_error($con_db_main));
if($rs_cpwimg[0]==1){
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){
echo '<div class="w-100 text-center mt-3"><img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_1pic"></div>';
}
}else if($rs_cpwimg[0]>1){
echo '<div id="slideAB9" class="carousel slide carousel-dark bg-white w-100 text-center mt-3" data-bs-ride="carousel">
<div class="carousel-inner">';
$c_row=0;
while($rs_data_fileimg = mysqli_fetch_array($qr_data_fileimg)){ $c_row++;
if($c_row==1){
echo '<div class="carousel-item active text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}else{
echo '<div class="carousel-item text-center animated fadeIn" data-bs-interval="2000">
<img src="../'.$rs_data_fileimg['path_filedoc_dataother'].'" class="img-fluid mh_pic">
</div>';
}
}
echo ' </div>
<button class="carousel-control-prev" type="button" data-bs-target="#slideAB9" data-bs-slide="prev">
<span class="carousel-control-prev-icon" aria-hidden="true"></span>
<span class="visually-hidden">Previous</span>
</button>
<button class="carousel-control-next" type="button" data-bs-target="#slideAB9" data-bs-slide="next">
<span class="carousel-control-next-icon" aria-hidden="true"></span>
<span class="visually-hidden">Next</span>
</button>
</div>';
};
}
?>
</div>
</div>
</div>
</div>
<div class="w-100"></div>
<div class="col bg-cl-2 text-center fcl-cl-1 fs-1" style="height:10px;"></div>
</div>
</div>
<!------------------>
<?php include_once ("footer.php"); ?>
</div>
<?php include_once ("cookie.php"); ?>
</body>
</html>