SC control or blan app with google charts..

Scriptcase 9 General
#1

Hey all trying to get google charts working with SC…
can anyone tell me why I keep getting this error=?

yntax error, unexpected ‘<’ in C:\Program

I know its cause of the < but dont know how to incorporate
the below code…



<?php
 $con = mysqli_connect('localhost','root','matthew1986','view');
?>
<html>
<head>
 <meta charset="utf-8">
 <title>TechJunkGigs</title>
 <script type="text/javascript" src="https://www.google.com/jsapi"></script>
  <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
 <script type="text/javascript">

 google.load("visualization", "1", {packages:["corechart"]});
 google.setOnLoadCallback(drawChart);
 function drawChart() {
 var data = google.visualization.arrayToDataTable([

 ['osp_id','Day'],
  <?php

            $query = "SELECT osp_id,day,count(*) FROM view.v_os_charting
              where osp_id ='2'  group by osp_id,day";

             $exec = mysqli_query($con,$query);
             echo 'query = '.$exec;
             while($row = mysqli_fetch_array($exec)){

             echo "['".$row['osp_id']."',".$row['Day']."],";
             }
             ?>        

 ]);

 var options = {
 title: 'Number of Students according to their class',
  pieHole: 0.5,
          pieSliceTextStyle: {
            color: 'black',
          },
          legend: 'none'
 };
 var chart = new google.visualization.PieChart(document.getElementById("columnchart12"));
 chart.draw(data,options);
 }

    </script>

</head>
<body>
 <div class="container-fluid">
 <div id="columnchart12" style="width: 100%; height: 500px;"></div>
 </div>

</body>
</html>

Any ideas of getting this to run?

Kevin