Google Interactive Chart_问答_开发者_运维开发者技术经验分享

开发者 https://www.devze.com 2023-02-13 08:50 出处：网络

HI All My requirement is To show a table( google interactive ) And download data of shown table in csv format.

相关专题：php

HI All My requirement is To show a table( google interactive ) And download data of shown table in csv format. I am using php. My question is how will i create a datasource in mylocal syatem ? What should be extension of datasourc开发者_StackOverflow中文版e file ? how will i write data in datasource? How will i populate table wit this data ? give a option to users to download it in csv format

To generate the table you'll want to check out the Google Charts Table documentation. The code to generate a table will look something like:

   <head>
    <script type='text/javascript' src='https://www.google.com/jsapi'></script>
    <script type='text/javascript'>
      google.load('visualization', '1', {packages:['table']});
      google.setOnLoadCallback(drawTable);
      function drawTable() {
        var data = new google.visualization.DataTable();
        data.addColumn('string', 'Name');
        data.addColumn('number', 'Salary');
        data.addColumn('boolean', 'Full Time Employee');
        data.addRows(2);
        data.setCell(0, 0, 'Mike');
        data.setCell(0, 1, 10000, '$10,000');
        data.setCell(0, 2, true);
        data.setCell(1, 0, 'Jim');
        data.setCell(1, 1, 8000, '$8,000');
        data.setCell(1, 2, false);    
        var table = new google.visualization.Table(document.getElementById('table_div'));
        table.draw(data, {showRowNumber: true});
      }
    </script>
  </head>

<div id='table_div'></div>

The data you're populating the table with will theoretically need to be stored server-side already. You can store the data in a database such as a MySQL database, of which there are many tutorials online on how to set one up.

There are a number of ways to convert the data into a .csv file server-side. As an example, using PHP you could use fputcsv, by creating an arbitrary .csv file path on your server, then reading the data from your database to populate the .csv file. See the fputscsv documentation for examples on how to properly do this.