There are several examples of constructing a DataTable from PHP in this
group; try searching for "php json datatable".
Incidentally, unless you have a need to store the JSON file on your server,
you don't need to copy save the JSON to a file - you can just output it
directly into the javascript on page load, or in response to an AJAX query.
On Friday, October 24, 2014 10:57:40 AM UTC-4, Vamshi Krishna wrote:
>
> Thanks Andrew. It worked with the correction that you mentioned. It was
> the static data which is working. However, I want a JSON file similar to
> the above one to be generated from the data fetched from database. I am
> working with PHP and MYSQL. When i run a select query and generate the PHP
> file i observed that there are few things missing in the JSON file. Also
> guess may be because of that the graph was also not getting generated,
> instead a blank page was displayed.
>
> *My PHP code to fetch data from db and generate a JSON file *
> <?php
> $cal_st_date = '2014-10-2';
> $cal_end_date = '2014-10-9';
> $gph_values = array();
>
> include 'db.php';
> $fetch_rows = mysql_query("SELECT
> cg.attach_doc_path,cg.start_date,cg.end_date,cg.coupon_upc,cg.coupon_type
> FROM CPNS_TESTING cg,CPNS_TESTED ct where cg.cpn_id=ct.coupon_id and
> ct.approved='Y' and ct.valid='T' and cg.end_date >= '$cal_st_date' group by
> cg.cpn_id");
> $num_rows = mysql_num_rows($fetch_rows);
> echo $num_rows;
> while($row = mysql_fetch_array($fetch_rows))
> {
> $row_array['file']= $row['attach_doc_path'];
> $row_array['upc'] = $row['coupon_upc'];
> $row_array['Cpn_type'] = $row['coupon_type'];
> $start_date = $row['start_date'];
> $str_start_date = strtotime($start_date);
> $str_cal_start_date = strtotime($cal_st_date);
> if($str_start_date >= $str_cal_start_date)
> {
> $arr_start_date = explode("-",$start_date);
> $arr_start_date =
> $arr_start_date[0].",".$arr_start_date[1].",".$arr_start_date[2];
> $row_array['start_date'] = $arr_start_date;
> }
> else
> {
> $arr_start_date = explode("-",$cal_st_date);
> $arr_start_date =
> $arr_start_date[0].",".$arr_start_date[1].",".$arr_start_date[2];
> $row_array['start_date'] = $arr_start_date;
> }
> $end_date = $row['end_date'];
> $str_end_date = strtotime($end_date);
> $str_cal_end_date = strtotime($cal_end_date);
> if($str_end_date >= $str_cal_end_date)
> {
> //$arr_end_date = $cal_end_date;
> $arr_end_date = explode("-",$cal_end_date);
> $arr_end_date = $arr_end_date[0].",".$arr_end_date[1].",".$arr_end_date[2];
> $row_array['end_date'] = $arr_end_date;
> }
> else
> {
> //$arr_end_date = $end_date;
> $arr_end_date = explode("-",$end_date);
> $arr_end_date = $arr_end_date[0].",".$arr_end_date[1].",".$arr_end_date[2];
> $row_array['end_date'] = $arr_end_date;
> }
> $text = $upc . "-". $type;
> array_push($gph_values,$row_array);
>
> }
> //echo json_encode($gph_values);
> $fp = fopen('C:\XAMP\htdocs\graph\sampleData.json', 'w+');
> fwrite($fp, json_encode($gph_values));
> fclose($fp);
> $string = file_get_contents("sampleData.json");
> echo $string;
> ?>
>
> JSON file got generated
>
> [{"file":"welcome.txt","upc":"test","Cpn_type":"test","start_date":"2014,10,2","end_date":"2014,10,9"},
>
> {"file":"Queries.txt","upc":"132","Cpn_type":"123","start_date":"2014,10,02","end_date":"2014,10,9"}]
>
> In the above JSON file there is no ROWS and Columns mentioned.
> Please assist in generating a proper JSON file.
>
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
