Integrate google chart in Laravel5.0 with the data from mysql database

I want to integrate google chart in my laravel5.0 application. The data is in mysql database. As far I've done researching over internet is given bellow

controller part

    public function index(){

    $barChart= DB::table('clients')
        ->select('clients.ClientName','clients.Price')
        ->get();
    $bar = json_encode($barChart);
    return view('home')
        ->with('bar', $bar);
}

view part

<div class="panel-body" id="barChart"> </div>
<script type="text/javascript" src="http://ift.tt/JuZcy0"></script>
<script type="text/javascript">
   google.load('visualization', '1', {'packages':['corechart']});
   google.setOnLoadCallback(drawChart);
   function drawChart() {
      var data = new google.visualization.DataTable(<?=$bar?>);
      var options = {
      title: 'My Bar chart',
      is3D: 'true'
   };
   var chart = new  google.visualization.PieChart(document.getElementById('barChart'));
   chart.draw(data, options);
   }

But it shows "table has no column" . I know I haven't create any column and I also understand that simply writing this google.visualization.DataTable(<?=$bar?>) will not create any column. I've tried many ways to create column but can not find any solution. How can I create data table from this?

I also tried chartWraper

<script type="text/javascript">
    google.load('visualization', '1.0');
    function drawInventoryChart() {
        var wrapper = new google.visualization.ChartWrapper({
            chartType: 'ColumnChart',
            dataTable: [], //don't know how to put $bar here
            option: {title: 'test'}
        });
        wrapper.draw('barChart');
    }
    google.setOnLoadCallback(drawInventoryChart);
</script>

This also does not work as I can not properly have the value of dataTable[] .

from Newest questions tagged laravel-5 - Stack Overflow http://ift.tt/1W8CGzk
via IFTTT