| Server IP : 104.21.37.246 / Your IP : 172.71.28.145 [ Web Server : Apache System : Linux cpanel01wh.bkk1.cloud.z.com 2.6.32-954.3.5.lve1.4.59.el6.x86_64 #1 SMP Thu Dec 6 05:11:00 EST 2018 x86_64 User : cp648411 ( 1354) PHP Version : 7.2.34 Disable Function : NONE Domains : 0 Domains MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/cp648411/www/simded.com/themes/ |
Upload File : |
<?php
//print_r($_POST);
$sql_number_post = '';
$sql_number_post2 = '';
//session_destroy();
if(isset($_POST['num_post2'][0]))//ค้นหาจากตำแหน่งเลข
{
if($_POST['num_post2'][0]!=''){
$_SESSION['s_num_post'] = $_POST['num_post2'][0];
$i = 2;
$post_number = '0';
foreach( $_POST['num_post2'] as $value )
{
$post = $value;
if($value == '')
{
$post = '_';
}
$post_number = $post;
$i++;
}
$sql_number_post = 'AND carregistration.car_s like "'.$post_number.'"';
$sql_number_post2 = 'OR carregistration.car_e like "'.$post_number.'"';
}
}
$sql_number_sum = '';
if($_POST['total'] <> '')//ผลรวม
{
$_SESSION['s_total'] = $_POST['total'];
$sql_number_sum = ' AND phonenumber.total = "'.$_POST['total'].'"';
}
$sql_number_style = '';
if($_POST['stylenum'] <> '')//หมวดหมู่
{
$_SESSION['s_stylenum'] = $_POST['stylenum'];
$sql_number_style = ' AND phonenumber.styleid = "'.$_POST['stylenum'].'"';
}
$sql_number_cat='';
/*
if($_POST['category'] <> '')//ตามหมวดหมู่
{
$_SESSION['s_category'] = $_POST['category'];
$sql_number_cat = ' AND ' . $Phone_class->cat_number($_POST['category']);
}
*/
$sql_number_price_re = '';
if($_POST['price_range'] <> '')//ช่วงราคา
{
$_SESSION['s_price_range'] = $_POST['price_range'];
$_POST['price_range'] = trim($_POST['price_range']);
$arr = explode('-',$_POST['price_range']);
$arr0 = str_replace(',', '',$arr[0]);
$arr0 = trim($arr0);
if( is_numeric($arr0) )
{
$arr[0] = str_replace(',', '', $arr[0]);
$arr[1] = str_replace(',', '', $arr[1]);
$sql_price = ' AND ( carregistration.price >= "' .$arr[0]. '" AND carregistration.price <= "' .$arr[1]. '" )';
}
else
{
$arr = explode(' ',$_POST['price_range']);
if( $arr[0] == 'ไม่เกิน' )
{
$price = str_replace(',', '', str_replace(',', '',$arr[1]));
$sql_price = ' AND carregistration.price <= "' .$price. '"';
}
else
{
$price = str_replace(',', '', str_replace(',', '',$arr[1]));
$sql_price = ' AND carregistration.price >= "' .$price. '"';
}
}
}
$sql_number_like = '';
if($_SESSION['number_like'] <> '')//ค้นหาจากเลขที่ชอบ
{
foreach( $_SESSION['number_like'] as $key => $value )
{
$like = ' AND carregistration.carregistration LIKE "%___'.$value.'%"';
$sql_number_like = $sql_number_like . $like ;
}
}
$sql_number_dislike = '';
if($_SESSION['number_dislike'] <> '')//ค้นหาจากเลขที่ชอบ
{
foreach( $_SESSION['number_dislike'] as $key => $value )
{
$dislike = ' AND carregistration.carregistration NOT LIKE "%___'.$value.'%"';
$sql_number_dislike = $sql_number_dislike . $dislike ;
}
}
$sql_number_setlike = '';
if($_POST['FavoriteSet'][1]<> '')//ค้นหาจากเลขที่ชอบ
{
$_SESSION['s_FavoriteSet'] = $_POST['FavoriteSet'];
$like = ' AND carregistration.carregistration LIKE "%'.$_POST['FavoriteSet'][1].'%"';
$sql_number_setlike = $sql_number_setlike . $like ;
}
$sql_number_network = '';
if($_POST['network']<> '')//ค้นหาจากเลขที่ชอบ
{
$_SESSION['s_network'] = $_POST['network'];
$sql_number_network = ' AND carregistration.carregistration = "'.$_POST['network'].'"';
}
?>
<?php
$sql_s = 'shop.id = carregistration.id_shop AND shop.status = "1" AND shop.status_op = "1" AND shop.activate = "1" AND carregistration.status = "1" '
. $sql_number_post . $sql_number_post2 . $sql_number_sum . $sql_number_style .
$sql_number_price_re . $sql_price . $sql_number_like . $sql_number_dislike . $sql_number_setlike .$sql_number_network .$sql_number_cat ;
/*
echo $sql_s."</br>";
echo $sql_number_post."</br>";
echo $sql_number_post2."</br>";
echo $sql_number_sum."</br>";
echo $sql_number_style."</br>";
echo $sql_number_price_re."</br>";
echo $sql_price."</br>";
echo $sql_number_like."</br>";
echo $sql_number_dislike."</br>";
echo $sql_number_setlike."</br>";
echo $sql_number_network."</br>";
echo $sql_number_cat."</br>";
*/
$max_rows = 8; // แสดงจำนวนแถวต่อหน้า
$page_number = 0;
if(isset($_GET['page_number']))
{
$page_number = $_GET['page_number'];
}
$all_array = array('table'=>'carregistration,shop','where'=>$sql_s);
$start_row = $page_number * $max_rows;
$all_sql = $view_db->view($all_array);
//print_r($all_sql);
$all_result = $view_db->q_re($all_sql);
$total_rows = $view_db->q_nr($all_result);
$total_rows_num = mysql_num_rows($all_result);
$total_pages = ceil($total_rows/$max_rows)-1;
////////////////////////////////////////
$list = array('table'=>'carregistration,shop','where'=>$sql_s, 'limit'=> "$start_row,$max_rows",'order'=> "ORDER BY carregistration.id DESC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$num_tr = 1;
$num = 1+($page_number*$max_rows);
?>
<div class="row">
<div class="col-md-12" style="margin-bottom:20px;margin-top:20px;">
<div style="margin-top:0px;">
<?php
if($_POST['total'] <> '')//ผลรวม
{
$list_sum = array('table'=>'totalcar','where'=>'number = "'.$_POST['total'].'"','order'=> "ORDER BY id DESC");
$view_sum = $view_db->view($list_sum);
$row_sum = $view_db->q($view_sum);
if($row_sum['id'])
{
?>
<div class="row" style="margin-bottom:40px;">
<div class="col-md-12" >
<span class="" style="font-size:30px;">ผลรวม <?php echo $row_sum['number'] .' '. $row_sum['title'];?></span>
</div>
<div class="col-md-12" style="font-size:20px;text-align:left;text-indent: 40px;"><?php echo $row_sum['detail']?> </div>
</div>
<?php
}
}
?>
<div class="row">
<div class="col-md-6" style="margin-bottom:5px;">
<p class="HeadTextL"> ผลการค้าหา</p>
</div>
</div>
<?php
while($row = $view_db->q_ro($result))
{
$phonenumber = $row['carregistration'];
$row_mobilenetwork = $actiondata_db->q_one('stylecar','id = "'.$row['styleid'].'"','image');
$row_totalnumber = $actiondata_db->q_one('totalcar','number = "'.$row['total'].'"','title');
if($row_totalnumber==2){$row_totalnumber = '';}
$list_shr = array('table'=>'shop','where'=>'id = "'.$row['id_shop'].'" ');
$view_shr = $view_db->view($list_shr);
$row_shr = $view_db->q($view_shr);
$countber = $util_class->countber($row_shr['id']);
$txt_phonenumber = $Phone_class->phonecomma($row_shr['phone']);
if($row_shr['image_profile']){ $image_profile = $row_shr['image_profile']; }
else { $image_profile = ''; }
$phonenumber = $row['carregistration'];
$price = $row['price']-1;
?>
<div class="col-xs-6 col-md-3 borded " style="padding-bottom: 15px;">
<!---<div class="row">
<div class="hidden-xs col-md-12" style="text-align:center;padding:0;margin-top:4px;"><img src="../images/icon_Ulike.png" width="24" height="24"
onclick="like(<?php echo $_SESSION["simDed_login"];?>,<?php echo $row_shi['id'] ;?>)" style="cursor:pointer"><br>เลขทะเบียนโปรด</div>
</div>-->
<div class="row">
<div class="col-xs-12 col-md-11" style="text-align: center;
background-image: url(../redbag/idcar/<?php echo $row_mobilenetwork; ?>);
border-radius: 0%;
background-repeat: no-repeat;
background-size: contain;
min-height: 9.5rem;">
<div style="margin-top: 15%;">
<a href="../cart/index2.php?p=<?php echo $row['carregistration'];?>">
<span class="BerDedToday-ber" style=" font-size: 155%;font-family: arial, sans-serif;"><?php echo $phonenumber; ?></span>
</a>
<!--<span class="BerDedToday-sum"> (<?php echo $row['total'];?>) </span>-->
<div class="">
<span class="BerDedToday-price"> <?php echo number_format($row['price']);?> </span>
</div>
</div>
</div>
</div>
</div>
<?php
}
if($total_rows_num == 0)
{
?><div align="center" style="padding-top:20px;color:#F00;font-size:18px;">--- ไม่พบข้อมูล ---</div><?php
}
?>
<div class="row">
<div class="col-md-12 BerDedToday-page">
<?php
if($total_rows_num > 0)
{
page_news($page_number,$total_pages,'index2.php','');
}
?>
</div>
</div>
</div>
</div>
</div>