How do I filter sarch results presented in chart view

See more:

PHP

how can i show results in chart after search results am using this method,

i have a php file where results show after i search the database but i need to show the results in chart without the this code

<?php 

$dbhandle = new mysqli('localhost','root','','dbtest');
echo $dbhandle->connect_error;


$query = "SELECT sex, sum(sn) FROM person group by sex ";
$res = $dbhandle->query($query);

?>

and using the gstatic/loader.js the chart is showing but i want results based on my search

What I have tried:

<?php 
include("connect/db.php");  

 if(isset($_GET['id'])){
      $page_id = $_GET['id'];
$dbhandle = new mysqli('localhost','root','','dbtest');
echo $dbhandle->connect_error;


$query = "SELECT sex, sum(sn) FROM person group by sex where id='$page_id' ";
$res = $dbhandle->query($query);

 }
?>


i want the results from the search php file to be displayed on this page where the chart should show 

please help