# connection to database problem

**URL:** https://forum.kirupa.com/t/connection-to-database-problem/638171
**Category:** web dev
**Created:** [May 3, 2018, 11:04am UTC](https://forum.kirupa.com/t/connection-to-database-problem/638171 "2018-05-03T11:04:58Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![hao](https://avatars.discourse-cdn.com/v4/letter/h/ea5d25/32.png) [@hao](https://forum.kirupa.com/u/hao)
#### Post date: [May 3, 2018, 11:04am UTC](https://forum.kirupa.com/t/connection-to-database-problem/638171/1 "2018-05-03T11:04:58Z")

</div>

how to connect to my database php with google chart… database name=person\_detail, table=gender, type=(1)girl , (2)boy, data (2,5)… not working and donknow why 😥

\<?php $dbhandle = new mysqli('localhost','root','','person\_detail'); echo $dbhandle-\>connect\_error; $query = "SELECT \* FROM gender"; $res = $dbhandle-\>query($query); ?\> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawChart);

```
  function drawChart() {

    var data = google.visualization.arrayToDataTable([
      ['girl', 'boy'],
      
      <?php 

```

while($row=$res-\>fetch\_assoc())  
{  
echo “[’”.$row[‘sum(girl)’]."’,".$row[‘sum(boy)’]."],";  
}

```
      ?>

    ]);

    var options = {
      title: 'Gender Statistic',
      is3D:true,
    };

    var chart = new google.visualization.PieChart(document.getElementById('piechart'));

    chart.draw(data, options);
  }
</script>

```

---

<div class="post-metadata">

### Author: ![hao](https://avatars.discourse-cdn.com/v4/letter/h/ea5d25/32.png) [@hao](https://forum.kirupa.com/u/hao)
#### Post date: [May 4, 2018, 3:25am UTC](https://forum.kirupa.com/t/connection-to-database-problem/638171/2 "2018-05-04T03:25:20Z")

</div>

i already solve tq…