| Server IP : 172.67.216.113 / 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 : /home2/cp648411/public_html/kainumber.com/home/ |
Upload File : |
<?php include('../include/header.php'); ?>
<?php $menu = 'home';?>
<?php include('../theme/menu.php'); ?>
<?php //include('../banner/index.php')?>
<?php //include('../theme/category.php')?>
<?php include('../theme/search_number_pc.php'); ?>
<!-- /.body -->
<div class="container" style="padding-top:25px;">
<div class="row">
<div class="col-md-12">
<?php
/*
echo'<pre>';
print_r($_POST);
echo'</pre>';
*/
$sql_number_post = '';
if(isset($_POST['num_post']))//ค้นหาจากตำแหน่งเลข
{
$i = 2;
$post_number = '0';
foreach( $_POST['num_post'] as $value )
{
$post = $value;
if($value == '')
{
$post = '_';
}
$post_number = $post_number . $post;
$i++;
}
$sql_number_post = 'AND phonenumber like "'.$post_number.'"';
}
$sql_number_like = '';
if($_POST['num_like']<> '')//ค้นหาจากเลขที่ชอบ
{
foreach( $_POST['num_like'] as $key => $value )
{
$like = ' AND phonenumber LIKE "%'.$key.'%"';
$sql_number_like = $sql_number_like . $like ;
$gg_num_like = $gg_num_like .$key.'/';
}
}
$sql_number_network = '';
if($_POST['network'] <> '')//ค้นหาค่าย
{
$sql_number_network = ' AND mobilenetwork = "'.$_POST['network'].'"';
}
if(!$_POST['network']){
if($_GET['network'] <> '')//ค้นหาค่าย
{
$sql_number_network = ' AND mobilenetwork = "'.$_GET['network'].'"';
}
}
if($_GET['set'] <> '')//ค้นหาค่าย
{
if($_GET['set'] == 'triple')//ค้นหาค่าย
{
$sql_number_set = ' AND status_number=1 AND phonenumber LIKE "%000%" OR phonenumber LIKE "%111%" OR phonenumber LIKE "%222%" OR phonenumber LIKE "%333%" OR phonenumber LIKE "%444%" OR phonenumber LIKE "%555%" OR phonenumber LIKE "%666%" OR phonenumber LIKE "%777%" OR phonenumber LIKE "%888%" OR phonenumber LIKE "%999%"';
$s_cat = '<span >></span> เบอร์ตอง';
}
}
$sql_number_sum = '';
if($_POST['sunnumber'] <> '')//ผลรวม
{
$sql_number_sum = ' AND sum_number = "'.$_POST['sunnumber'].'"';
}
$sql_number_element = '';
if($_POST['element'] <> '')//ธาตุ
{
$g_element = '&element='.$_POST['element'];
$sql_number_element = ' AND element_id = "'.$_POST['element'].'"';
}
$sql_number_sex = '';
if($_POST['sex'] <> '')//เพศ
{
if($_POST['sex'] == 1)//ชาย
{
$sql_number_element = ' AND (phonenumber LIKE "%33%" OR phonenumber LIKE "%38%" OR phonenumber LIKE "%83%" OR phonenumber LIKE "%25%" OR phonenumber LIKE "%52%")';
}
if($_POST['sex'] == 2 || $_POST['sex'] == 3)//หญิง กระเทย
{
$sql_number_element = ' AND (phonenumber LIKE "%22%" OR phonenumber LIKE "%226%" OR phonenumber LIKE "%262%" OR phonenumber LIKE "%622%" OR phonenumber LIKE "%229%" OR phonenumber LIKE "%292%" OR phonenumber LIKE "%922%")';
}
if($_POST['sex'] == 4)//ทอม
{
$sql_number_element = ' AND (phonenumber LIKE "%33%" OR phonenumber LIKE "%38%" OR phonenumber LIKE "%83%")';
}
}
$sql_number_cat = '';
$_SESSION["get_id_cat"] = '';
if($_POST['cat'] <> '')//หมวดหมู่
{
$_SESSION["get_id_cat"] = $_POST['cat'];
$g_cat = '&cat='.$_POST['cat'];
//$sql_number_cat = ' AND category LIKE "'.$_POST['cat'].',%"';
$sql_number_cat = $Phone_class->cat_number($_POST['cat'],$row['phonenumber']);
$sql_number_cat = ' AND '.$sql_number_cat;
}
$sql_number_price_re = '';
if($_POST['price_re'] <> '')//ช่วงราคา
{
if($_POST['price_re'] == 1){$sql_number_price_re = " AND REPLACE( `price` , ',', '' ) <= 5000 ";}
if($_POST['price_re'] == 2){$sql_number_price_re = " AND REPLACE( `price` , ',', '' ) > 5001 AND REPLACE( `price` , ',', '' ) <= 10000";}
if($_POST['price_re'] == 3){$sql_number_price_re = " AND REPLACE( `price` , ',', '' ) > 10000 AND REPLACE( `price` , ',', '' ) <= 50000";}
if($_POST['price_re'] == 4){$sql_number_price_re = " AND REPLACE( `price` , ',', '' ) > 50000 ";}
}
$secrch = 'status = 1 AND status_number = 1 ' .$sql_number_post.$sql_number_like.$sql_number_network.$sql_number_sum.$sql_number_element.$sql_number_cat.$sql_number_price_re.$sql_number_set;
$_SESSION["get_search"] = 'status = 1 AND status_number = 1 ' .$sql_number_post.$sql_number_like.$sql_number_network.$sql_number_sum.$sql_number_element.$sql_number_cat.$sql_number_price_re.$sql_number_set;
?>
<?php
if($_POST['cat'] <> '')
{
$list_mw = array('table'=>'category','where'=>'id = "'.$_POST['cat'].'"','order'=> "ORDER BY id ASC");
$view_mw = $view_db->view($list_mw);
$row_mw = $view_db->q($view_mw);
$s_cat = '<span >></span> '.$row_mw['name'];
}
?>
<div >
<div class="container">
<div class="row px-md-5 mb-3 pt-md-0">
<div class="col-md-12 px-md-2 d-flex justify-content-between align-baseline" >
<div class="">
<h2 class="pb-0 mb-0 border-kai-bottom-light">ค้นหาเบอร์ <?php echo $s_cat?></h2>
</div>
</div>
</div>
</div>
<div class="row" style="padding-top:10px;margin-bottom:10px;">
<link rel="stylesheet" href="../include/infiniteajaxscroll/default.min.css">
<div class="container_2 px-xxl-5 px-md-5 px-3">
<div class="row px-xxl-5">
<?php
$list = array('table'=>'phonenumber','where'=>$secrch,'order'=> "ORDER BY id DESC LIMIT 28");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
//print_r($view);
$num = 1;
$total_rows_num = mysqli_num_rows($result);
if($total_rows_num == 0)
{
?>
<div>ไม่พบ ข้อมูลที่ท่านค้นหา</div>
<?php
}
while($row_sb = $view_db->q_ro($result))
{
$output2='';
$output='';
$arr_P3_all=array();
$pass3_all_n=array();
$Fullscore_p=0;
$TotalScore_plus=0;
$TotalScore_delete=0;
$percent_number=0;
$dpr2 = 0;
$phonenumber = $row_sb['phonenumber'];
//echo $row_sb['category_type'];
include('perl.php');
$Fullscore_p = 100 * count($pass3_all_n);
$percent_number = (($TotalScore_plus - abs($TotalScore_delete))*100)/$Fullscore_p;
//echo $_SESSION["get_id_cat"].'ss';
$se = $Phone_class->catshort_number2($_SESSION["get_id_cat"],$row_sb['phonenumber']);
//echo $se[0];
if($row_sb["category_type"]==2){
$search_1n = 'id="'.$Phone_class->catshort_number2($se,$row_sb['phonenumber']).'"';
}else{
$search_1n = 'id = "'.$_SESSION["get_id_cat"].'"';
}
$list_phrc = array('table'=>'category','where'=>$search_1n,'order'=> "ORDER BY id DESC LIMIT 0 , 1");
$view_phrc = $view_db->view($list_phrc);
$row_phrc = $view_db->q($view_phrc);
//print_r($view_phrc);
$list_phre = array('table'=>'element','where'=>'id = "'.$row_sb['element_id'].'"','order'=> "ORDER BY id DESC LIMIT 0 , 1");
$view_phre = $view_db->view($list_phre);
$row_phre = $view_db->q($view_phre);
$cate_img='';
$network_img='';
/*
if($row_sb['category']==7){$cate_img='icon-01-love.png';}
if($row_sb['category']==8){$cate_img='icon-02-office.png';}
if($row_sb['category']==10){$cate_img='icon-05-foster.png';}
if($row_sb['category']==11){$cate_img='icon-04-money.png';}
if($row_sb['category']==12){$cate_img='icon-03-family.png';}
if($row_sb['category']==13){$cate_img='icon-07-chat.png';}
if($row_sb['category']==16){$cate_img='icon-06-health.png';}
if($row_sb['category']==17){$cate_img='icon-08-avoid.png';}
*/
if($se==7){$cate_img='icon-01-love.png';}
if($se==8){$cate_img='icon-02-office.png';}
if($se==10){$cate_img='icon-05-foster.png';}
if($se==11){$cate_img='icon-04-money.png';}
if($se==12){$cate_img='icon-03-family.png';}
if($se==13){$cate_img='icon-07-chat.png';}
if($se==16){$cate_img='icon-06-health.png';}
if($se==17){$cate_img='icon-08-avoid.png';}
if($row_sb['mobilenetwork']==1){$network_img='0222- ais.png';}
if($row_sb['mobilenetwork']==2){$network_img='01- ddd.png';}
if($row_sb['mobilenetwork']==3){$network_img='03- true.png';}
if($row_sb['mobilenetwork']==8){$network_img='05- yyyy.png';}
$dpr2 = $percent_number*1.67;
$dpr2 = 440 - $dpr2;
$percent_number;
// echo $_SESSION["get_id_cat"];
?>
<div class="col-12 col-sm-6 col-md-6 col-lg-4 col-xxl-3 px-1 mb-3 item_search">
<div class="border-kai2 p-3 text-center cursor-pointer" onclick="location.href='../reading/detail.php?phonenumber=<?php echo $row_sb['phonenumber']; ?>'">
<h2 class="pb-0 mb-0 border-kai-bottom mb-2">
<?php echo $Phone_class->phonenumber($row_sb['phonenumber']);?>
</h2>
<div class="row">
<div class="col-3 p-0">
<div class="container__progressbars" >
<div class="progressbar">
<svg class="progressbar__svg">
<circle cx="23" cy="26" r="27" class="progressbar__svg-circle circle-html1 shadow-html"
style="stroke-dashoffset: <?php echo $dpr2; ?>; "
> </circle>
</svg>
<span class="progressbar__text shadow-html">
<!--<img src="../redbag/category/icon-01-love.png" alt="" class="w-100" >-->
<img src="../redbag/category/<?php echo $cate_img; ?>" alt="" class="w-100" >
</span>
</div>
<small class="progressbar_text2 fix-s" style="top: 2px"> <?php echo number_format($percent_number,2); ?>%</small>
</div>
</div>
<?php
if($row_sb['category_type']==2)
{
$short_number = $Phone_class->catshort_number($se,$row_sb['phonenumber']);
$short_number;
if($short_number==''){
$short_number = $Phone_class->catshort_number('',$row_sb['phonenumber']);
}
}
else
{
$short_number= 'เบอร์สวย';
}
/*
echo "<pre>";
print_r($short_number);
echo "</pre>";
*/
//echo strlen($short_number);
?>
<div class="col-6 px-0">
<div class="border-kai-bottom w-100" style=" min-height: 36px;">
<label style="<?php if(strlen($short_number)>=51){echo 'font-size: 20px;padding-bottom: 2px;';} ?>"> <?php echo $short_number; ?>
</label>
</div>
<div class="border-kai-bottom w-100">
<img src="../redbag/mobilenetwork/<?php echo $network_img; ?>" alt="" height="33" >
</div>
<label style="top: 5px;position: relative;"><?php echo $row_sb['price']; ?>-</small>
</div>
<div class="col-3 p-0 border-kai-left pe-2" >
<div class="py-0 pe-1">
<div class="border-kai-bottom w-100">
<label class="fix-l" >ผลรวม</label>
<h1 class="ps-2 p-0 m-0 fix-h1"><?php echo $row_sb['sum_number']; ?></h1>
</div>
<?php $element = $Phone_class->element_text_img($row_sb['element_id']);?>
<small class="fix-s">
ธาตุ<?php echo $row_phre['name']; ?>
</small>
</div>
</div>
</div>
</div>
</div>
<?php
}
?>
</div>
</div>
<?php
$list = array('table'=>'phonenumber','where'=>$secrch,'order'=> "ORDER BY id DESC");
$view = $view_db->view($list);
$result = $view_db->q_re($view);
$rowcount = mysqli_num_rows($result);
$row_page = $rowcount/28;
$row_page = ceil( $row_page);
?><ul id="pagination" style="color:#000;"><?php
for($i=1;$i<=$row_page;$i++)
{
if($i==1){?><li><a href="../home/search_1.php">2</a></li><?php }
else
{
?><li <?php if($i==2){ ?>class="next_search"<?php }?>><a href="../home/search_load.php?p=<?php echo $i; ?>">2</a></li><?php
}
}
?>
</ul>
<?php include('search_number_mobile.php'); ?>
<script src="../include/infiniteajaxscroll/jquery.min.js"></script>
<script type="text/javascript" src="../include/infiniteajaxscroll/jquery-ias.min.js"></script>
<script type="text/javascript">
var ias = $.ias({
container: ".container_2",
item: ".item_search",
pagination: "#pagination",
next: ".next_search a"
});
ias.extension(new IASSpinnerExtension());
ias.extension(new IASTriggerExtension({offset: 50}));
ias.extension(new IASNoneLeftExtension({text: ''}));
</script>
</div>
</div>
<?php include('../theme/tab_right_showmoblie.php');?>
</div>
</div>
</div>
<!-- /.body -->
<?php include('../include/footer.php')?>
<?php include('../include/footer_js.php')?>