dsiuz86842 2014-11-04 16:52
浏览 72
已采纳

使用ajax php mysql从各种查询中检索多个数据

I'm new in Ajax and JSON notation, so I'm trying to get data from differents tables of a Database, data like country names, state names, departament name, job position etc. and I've seen examples how through JSON can get data but just from a single table, can you give me a little help how can I do it with more than one table and keep it in an array.

<?php 


  $host = "localhost";
  $user = "usuer";
  $pass = "password";

  $databaseName = "jsonExample";
  $tableName = "variables";


  $con = mysql_connect($host,$user,$pass);
  $dbs = mysql_select_db($databaseName, $con);


  $result = mysql_query("SELECT * FROM $tableName");            //query
  //$array = mysql_fetch_row($result);                          //fetch result
    if(mysql_num_rows($result) <= 0){

    }else{
        while($obj = mysql_fetch_row($result)){
        $array[] = $obj;        
        }
    }

  echo json_encode($array);

?>

Html file:

<html>
  <head>
    <script language="javascript" type="text/javascript" src="jquery.js"></script>
  </head>
  <body>-->


  <h2> Client example </h2>
  <h3>Output: </h3>
  <div id="output">this element will be accessed by jquery and this text will be replaced</div>

  <script id="source" language="javascript" type="text/javascript">

  $(function () 
  {


    $.ajax({                                      
      url: 'api.php',                  //the script to call to get data          
      data: "",                        //you can insert url argumnets here to pass to api.php for example "id=5&parent=6"
      dataType: 'json',                //data format      
      success: function(data)          //on recieve of reply
      {

        var id = data[0];              //get id
        var vname = data[1];           //get name



        $('#output').html("<b>id: </b>"+id+"<b> name: </b>"+vname);     //Set output element html
        //recommend reading up on jquery selectors they are awesome http://api.jquery.com/category/selectors/
      } 
    });

  }); 
  </script>

  </body>
</html>  
  • 写回答

1条回答 默认 最新

  • dongzhouhao4316 2014-11-04 17:09
    关注

    If you want to have the results from multiple queries in one array you can add each result to a key. F.i. if you querying table table1 to tablen ...

    // define the array that will contain all result sets
    $array = [];
    
    // create an array for the result set coming from table 1
    $array['table1']= [];
    $result = mysql_query("SELECT * FROM table1");
        if(mysql_num_rows($result) <= 0){
    }else{
        while($obj = mysql_fetch_row($result)){
        $array['table1'][] = $obj;        
        }
    }
    
    // create an array for the result set coming from table 2 
    $array['table2']= [];
    $result = mysql_query("SELECT * FROM table2");
        if(mysql_num_rows($result) <= 0){
    }else{
        while($obj = mysql_fetch_row($result)){
        $array['table2'][] = $obj;        
        }
    }
    ::
    ::
    // create an array for the result set coming from table n
    $array['tablen']= [];
    $result = mysql_query("SELECT * FROM tablen");
        if(mysql_num_rows($result) <= 0){
    }else{
        while($obj = mysql_fetch_row($result)){
        $array['tablen'][] = $obj;        
        }
    }
    
    // return the results formatted as json
    return json_encode($array);
    

    In javascript you can access the results for table1 with data->table1.

    Tip

    Use mysqli instead of mysql. It is the improved version of mysql. Check the answers for this question for some background.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 在获取boss直聘的聊天的时候只能获取到前40条聊天数据
  • ¥20 关于URL获取的参数,无法执行二选一查询
  • ¥15 液位控制,当液位超过高限时常开触点59闭合,直到液位低于低限时,断开
  • ¥15 marlin编译错误,如何解决?
  • ¥15 有偿四位数,节约算法和扫描算法
  • ¥15 VUE项目怎么运行,系统打不开
  • ¥50 pointpillars等目标检测算法怎么融合注意力机制
  • ¥20 Vs code Mac系统 PHP Debug调试环境配置
  • ¥60 大一项目课,微信小程序
  • ¥15 求视频摘要youtube和ovp数据集