How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses

 How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses How to fetch data with Multiple between Cluses 



<?php 

include('../db_connect.php');

$HolderMin=$_POST['HolderMin'];

$HolderMax=$_POST['HolderMax'];

$PriceMin=$_POST['PriceMin'];

$PriceMax=$_POST['PriceMax'];

$CapitalMax=$_POST['CapitalMax'];

$CapitalMin=$_POST['CapitalMin'];

$LockedMin=$_POST['LockedMin'];

$LockedMax=$_POST['LockedMax'];

$TelegramMin=$_POST['TelegramMin'];

$TelegramMax=$_POST['TelegramMax'];

$TwitterMin=$_POST['TwitterMin'];

$TwitterMax=$_POST['TwitterMax'];

$FacebookMin=$_POST['FacebookMin'];

$FacebookMax=$_POST['FacebookMax'];

$holdersql="(holder_name BETWEEN '".$HolderMin."' AND '".$HolderMax."') ";

$sql_query=  "WHERE ".$holdersql."


      OR (twitter_count BETWEEN '".$TwitterMin."' AND '".$TwitterMax."') 

      OR (fb_count BETWEEN '".$FacebookMin."' AND '".$FacebookMax."') OR (tokenPriceUSD BETWEEN '".$PriceMin."' AND '".$PriceMax."') OR (locked_count BETWEEN '".$LockedMin."' AND '".$LockedMax."') OR (capital_count BETWEEN '".$CapitalMin."' AND '".$CapitalMax."') OR (telegram_count BETWEEN '".$TelegramMin."' AND '".$TelegramMax."')

ORDER BY id DESC";

   $sql="SELECT*FROM tbl_user_data ".$sql_query." ";


 $run_sql=mysqli_query($conn,$sql);

 ?>

 <?php 

while($value=mysqli_fetch_assoc($run_sql)){


//print_r($fetch_data);

//$data[]=$fetch_data; ?>

<tr>

  <td><?=$value['id']?></td>

<td><?=$value['contractAddress']?></td>

<td><?=$value['fb_count']?></td>

<td><?=$value['twitter_count']?></td>

<td><?=$value['telegram_count']?></td> 

<td><?=$value['tokenPriceUSD']?></td>

<td><?=$value['Locked']?></td>

<td><?=$value['capital_count']?></td>

</tr>

<?php }

/*header('Content-Type:application/json');

echo json_encode($data);*/


?>

Comments

Popular posts from this blog

How To Create a dynamic form in mysql php . How to create php dynamic form by admin in php

how to order placed ecoomerce website in php how to order placed ecoomerce website in php how to order placed ecoomerce website in php how to order placed ecoomerce website in php how to order placed ecoomerce website in php

how to create a dynamic study note in php. how to create a dynamic study note in php how to create a dynamic study note in php . how to create a dynamic study note in php how to create a dynamic study note in php