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