X7ROOT File Manager

Editing: search.php

<?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'); ?>

<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.webp';}
  if($row_sb['category']==8){$cate_img='icon-02-office.webp';}
  if($row_sb['category']==10){$cate_img='icon-05-foster.webp';}
  if($row_sb['category']==11){$cate_img='icon-04-money.webp';}
  if($row_sb['category']==12){$cate_img='icon-03-family.webp';}
  if($row_sb['category']==13){$cate_img='icon-07-chat.webp';}
  if($row_sb['category']==16){$cate_img='icon-06-health.webp';}
  if($row_sb['category']==17){$cate_img='icon-08-avoid.webp';}
  */
  if($se==7){$cate_img='icon-01-love.webp';}
  if($se==8){$cate_img='icon-02-office.webp';}
  if($se==10){$cate_img='icon-05-foster.webp';}
  if($se==11){$cate_img='icon-04-money.webp';}
  if($se==12){$cate_img='icon-03-family.webp';}
  if($se==13){$cate_img='icon-07-chat.webp';}
  if($se==16){$cate_img='icon-06-health.webp';}
  if($se==17){$cate_img='icon-08-avoid.webp';}

if($row_sb['mobilenetwork']==1){$network_img='0222- ais.webp';}
  if($row_sb['mobilenetwork']==2){$network_img='01- ddd.webp';}
  if($row_sb['mobilenetwork']==3){$network_img='03- true.webp';}
  if($row_sb['mobilenetwork']==8){$network_img='05- yyyy.webp';}

$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/<?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'); ?>

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>

<?php include('../include/footer.php')?>
<?php include('../include/footer_js.php')?>

Cancel