@include("zadmin/zalapao.setup.php");
/*
$sql = 'ALTER TABLE `aqua_billboard` ADD `bill_location_th` VARCHAR( 255 ) NOT NULL AFTER `bill_date_en` ,'
. ' ADD `bill_location_en` VARCHAR( 255 ) NOT NULL AFTER `bill_location_th` ,'
. ' ADD `bill_eyesview_th` VARCHAR( 255 ) NOT NULL AFTER `bill_location_en` ,'
. ' ADD `bill_eyesview_en` VARCHAR( 255 ) NOT NULL AFTER `bill_eyesview_th` ,'
. ' ADD `bill_size_th` VARCHAR( 255 ) NOT NULL AFTER `bill_eyesview_en` ,'
. ' ADD `bill_size_en` VARCHAR( 255 ) NOT NULL AFTER `bill_size_th` ,'
. ' ADD `bill_produce_th` VARCHAR( 255 ) NOT NULL AFTER `bill_size_en` ,'
. ' ADD `bill_produce_en` VARCHAR( 255 ) NOT NULL AFTER `bill_produce_th` ,'
. ' ADD `bill_light_th` VARCHAR( 255 ) NOT NULL AFTER `bill_produce_en` ,'
. ' ADD `bill_light_en` VARCHAR( 255 ) NOT NULL AFTER `bill_light_th` ,'
. ' ADD `bill_rent_th` VARCHAR( 255 ) NOT NULL AFTER `bill_light_en` ,'
. ' ADD `bill_rent_en` VARCHAR( 255 ) NOT NULL AFTER `bill_rent_th` ,'
. ' ADD `bill_condition_th` VARCHAR( 255 ) NOT NULL AFTER `bill_rent_en` ,'
. ' ADD `bill_condition_en` VARCHAR( 255 ) NOT NULL AFTER `bill_condition_th` ,'
. ' ADD `bill_comment_th` VARCHAR( 255 ) NOT NULL AFTER `bill_condition_en` ,'
. ' ADD `bill_comment_en` VARCHAR( 255 ) NOT NULL AFTER `bill_comment_th` ,'
. ' ADD `bill_price_th` VARCHAR( 255 ) NOT NULL AFTER `bill_comment_en` ,'
. ' ADD `bill_price_en` VARCHAR( 255 ) NOT NULL AFTER `bill_price_th` ,'
. ' ADD `bill_date` DATE NOT NULL AFTER `bill_price_en` ;';
mysql_query($sql);
*/
if(isset($_GET['no'])){
$no=$_GET['no'];
}
if(isset($_GET['idregion'])){
$idregion=$_GET['idregion'];
}
?>
AQUA Corporation
@include("mnu.php");
?> |
 |
include("billboard_menu.php");?>
|
#------------------------------------------------------------------------------------------------- การแสดงผลแบบแบ่งหน้า และคอลัม
$setcolumn = 2 ; # จำนวนคอลัมการแสดงผล
$setpage = 10 ; # กำหนดจำนวนชิ้นที่จะให้แสดงผล
$wh = " WHERE id!='' ";
if($idregion) $wh .=" and idregion='$idregion' ";
$select = "select * from aqua_billboard $wh order by date_create desc";
$url = "idregion=$idregion";
if($no==""){ $no=1;}
$result2 = mysqli_query($conn,"$select");
$number2 = mysqli_num_rows($result2);
$plist = $setpage;
$pgno = $number2/$plist;
if($number2%$plist!=0){
$pgno = $pgno + 1 ;
}
$pgno = sprintf("%d",$pgno);
$start = ($plist*$no)-$plist;
$limit = "limit $start , $plist ";
$result = mysqli_query($conn,"$select $limit");
$number = mysqli_num_rows($result);
# แสดงผลแบบเลขหน้า Select Option -----------------------------------------------------------------------------------------------------
if($number!=0){
for($i=1;$i<=$pgno;$i++){
($i==$no) ? $tt ="$i" : $tt = "$i";
$txtpage1 .= "$tt | ";
}
}
# แสดงผลแบบ ทีละหน้า มีปุ่ม ย้อนหลัง และถัดไป
if($no!=1){$pno=$no-1;$pre=" | ย้อนกลับ";}
if($no<$pgno){$nno=$no+1;$next=" | ถัดไป";}
$txtpage2=" หน้าที่ $no จาก $pgno หน้า ".$pre.$next;
$tt=1;
$i=0;
while($i<$number){
$row= mysqli_fetch_array($result);
$mm01= StripSlashes($row['title_'.$_SESSION['seslg']]);
$detail01=$mm01;
$mm02= StripSlashes($row['detail_'.$_SESSION['seslg']]);
$bill_location = StripSlashes($row['bill_location_'.$_SESSION['seslg']]);
$bill_eyesview = StripSlashes($row['bill_eyesview_'.$_SESSION['seslg']]);
$bill_size = StripSlashes($row['bill_size_'.$_SESSION['seslg']]);
$bill_produce = StripSlashes($row['bill_produce_'.$_SESSION['seslg']]);
$bill_light = StripSlashes($row['bill_light_'.$_SESSION['seslg']]);
$bill_rent = StripSlashes($row['bill_rent_'.$_SESSION['seslg']]);
$bill_condition = StripSlashes($row['bill_condition_'.$_SESSION['seslg']]);
$bill_comment = StripSlashes($row['bill_comment_'.$_SESSION['seslg']]);
$atitle="";
if($bill_location) $atitle .="จุดติดตั้งป้าย : $bill_location ";
if($bill_eyesview) $atitle .="จุดรับสายตา : $bill_eyesview ";
if($bill_size) $atitle .="ขนาดป้าย : $bill_size ";
if($bill_produce) $atitle .="อัตราค่าผลิต : $bill_produce ";
if($bill_light) $atitle .="ไฟส่องป้าย : $bill_light ";
if($bill_rent) $atitle .="อัตราค่าเช่า : $bill_rent ";
if($bill_condition) $atitle .="เงื่อนไขการเช่า : $bill_condition ";
if($bill_comment) $atitle .="หมายเหตุ : $bill_comment ";
#$detail01=substr("$mm01",0,150);
?>
|
if($tt==$setcolumn){
echo " ";
$tt=1;
}else{
echo "";
$tt=$tt+1;
}
$i++;
}
mysqli_free_result($result);
#---------------------------------------------------------------------------------------------------------------------------------
?>
|
|
if($number2>0){?>
Page from page(s). | next Total 0 record(s). }else{ ?>
no result.
} ?>
|
|
|
|
|
|