使用 ajax json 提交和加载



index.html:

Function drawChart() {
            var jsonData = $.ajax({
                url: "server.php",
                dataType: "json",
                async: false
            }).responseText;
            var obj = jQuery.parseJSON(jsonData);
            var data = google.visualization.arrayToDataTable(obj);
            var options = {
                title: 'Number of visitors / <?php echo $unit; ?>'
            };
            var chart = new google.visualization.BarChart(
                        document.getElementById('chart_div'));
            chart.draw(data, options);
    }       
       }

服务器.php:

$SQLString = "SELECT (...)'".$_POST['value']."' (...)
$result = mysql_query($SQLString);  
(...)
$data[$i] = array(...)
echo json_encode($data);

所以,索引.html从服务器获取数据.php对吧?我可以将一些值发送到服务器吗.php这对于在索引之前进行查询很重要.html执行 jsonData...等?如何?

谢谢:)

查询参数示例:

var jsonData = $.ajax({
                url: "server.php?someQuery=" + query,
                dataType: "json",
                async: false
            }).responseText;

您可以通过 ajax 使用 post 方法发送。下面是一个 JQuery 示例:

    $.ajax({
             type: "POST",
             url: "some.php",
             data: { name: "John", location: "Boston" }
          }).done(function( msg ) {
                    alert( "Data Saved: " + msg );
                  });

http://api.jquery.com/jQuery.ajax/

您可以使用一个库,该库将使用Phery http://phery-php-ajax.net 自动为您执行此操作,在您的情况下,它将是:

事件phery:json将处理从服务器发送的 JSON

var remote = phery.remote('data', {'argument': 'you want to send'}, {'target':'server.php'}, false);
remote.bind('phery:json', function(event, obj){
  var data = google.visualization.arrayToDataTable(obj);
  var options = {
    title: 'Number of visitors / <?php echo $unit; ?>'
  };
  var chart = new google.visualization.BarChart(
    document.getElementById('chart_div'));
  chart.draw(data, options);
});
remote.phery('remote'); // call the remote AJAX function

在您的server.php

function data($data){
  $r = new PheryResponse;
  // $data['argument'] will have 'you want to send'
  $SQLString = "SELECT (...)'".$_POST['value']."' (...)"
  $result = mysql_query($SQLString);  
  (...);
  $data[$i] = array(...);
  return $r->json($data); 
}
Phery::instance()->set(array(
  'data' => 'data'
))->process();

最新更新