doudi8829 2013-08-26 20:55
浏览 27
已采纳

试图将数组返回到表中的列表

Jquery - I am getting undefined but in the php is giving the response with my table information.

function formfill(dblist) {
    var tableheader = "<thead><tr><th>Database Nick</th><th>Database IP</th> <th></th></tr></thead>";

    $('#table2').empty();
    $('#table2').append(tableheader);

    $.each(dblist, function (key, value) {
        $('#table2').append('<tr><td>' 
        + dblist['DBNick'] 
        + '</td><td>' 
        + dblist['DBIP'] 
        + '</td><td><input class="add" id="add" name="add" value="add" type="submit"></input></td></tr>');

    }); 
}

$('#userlist').on('change', function () {
    var selected = $('#userlist').val();

    console.log(selected);

    $.ajax({
        url: '/php/user/userdbtable.php',
        type: 'POST',
        data: { user: selected },
        success: function (data) {
            formfill(data)
        },
        error: function (xhr, status, err) { console.log(xhr, status, err); }
    });
});

Here is the php it is sending out the correct data but i cant figure out how to pull it from the object.

<?php 
session_start(); 

include '../connect/anonconnect.php'; 

$myusername= $_POST['user'];

$useridsql = $dbh->prepare("SELECT * FROM Users WHERE UserLogin= :login");
$useridsql->execute(array(':login' => $myusername));
$useridsql = $useridsql->fetch();

$userid = $useridsql['idUser'];

$query = 'SELECT * FROM DBList  INNER JOIN UserDBList 
    ON DBList.idDatabase = UserDBList.idDatabase ';//WHERE UserDBList.idUser = '.$userid; 
$sql = $dbh->prepare($query); 
$sql->bindParam(':username', $myusername, PDO::PARAM_STR, 12); 
$sql->execute(); 
$user = $sql->fetchAll(PDO::FETCH_ASSOC); 

if($sql->rowCount() == 1){ 
    header('Content-type: application/json'); 
    echo json_encode($user,JSON_FORCE_OBJECT); 
} 
else { 
    echo 0; 
}   
?>
  • 写回答

1条回答 默认 最新

  • douang1243 2013-08-26 21:11
    关注

    I think that your loop has an error. It should look like this:

    $.each(dblist, function (index, item) {
        $('#table2').append('<tr><td>' 
            + item['DBNick'] 
            + '</td><td>' 
            + item['DBIP'] 
            + '</td><td><input class="add" id="add" name="add" value="add" type="submit"></input></td></tr>');
    
    }); 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 利用Java连接API接口总是出问题
  • ¥15 请教一个关于镜头标定,棋盘格格子大小的问题(畸变测试)
  • ¥15 el-table输入多维数组怎么实现
  • ¥15 安装GroudingDINO RuntimeError: Error compiling objects for extension
  • ¥15 关于推送项目到github的问题
  • ¥15 急!C++指针编写相关的问题
  • ¥15 kerberos身份认证配置问题
  • ¥30 用python写一个多签情况下波场的代理资源和回收资源
  • ¥15 怎么在matlab中输出显示泵的流量-扬程和管路损失与流量均在一个表格里
  • ¥15 matlab学期例题代码答疑