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

Post a Comment

Popular posts from this blog

how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php

 how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads mangement system user and manager auto assign in php how manage leads man...
Read more

How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php

How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filter in php How to add date filte...
Read more

How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python How to Run a Flask framework in Python

 How to Run a Flask framework in Python  from werkzeug.wrappers import Request , Response @Request . application def application ( request ): return Response ( "Hello, World!" ) if __name__ == "__main__" : from werkzeug.serving import run_simple run_simple ( "localhost" , 5000 , application ) How To add a Template File in Python flask First Create a folder templates/main.html from flask import Flask , render_template app = Flask(__name__) @app.route("/") def index(): return render_template('main.html') if __name__ == "__main__": app.run(debug=True) #from werkzeug.serving import run_simple #run_simple("localhost", 5000, application) Main.html <!DOCTYPE html> <html lang="en"> <head> <title>Bootstrap 5 Example</title> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, ini...
Read more