纯ajax遍历数据库 遍历数据库字段

host:<input type="text" name="host" id="host" style="width:100px;" value="127.0.0.1"/>
user:<input type="text" name="user" id="user" style="width:100px;" value="root"/>
password:<input type="text" name="password" id="password" style="width:100px;" value="12345"/>
database:<input type="text" name="database" id="database" style="width:100px;" value="ajax"/>
<input type="submit" id="button"  value="链接" />
<select name='sldd' style='width:100px; display: none;' id="sldd">
    <option value='表' selected>数据表</option>
</select>
<table border="1" cellpadding="3" cellspacing="1" id="tab">
    <tr id="tr1">
        <td id="td1">数据库字段</td>
    </tr>
    <tr id="tr2">
        <td id="td2">数据库信息</td>
    </tr>
</table>
<script type="text/javascript" charset="utf-8" src="jquery-2.1.4.min.js"></script>
<script>

        $("#button").click(function(){
        var host=$("#host").val();
        var user=$("#user").val();
        var password=$("#password").val();
        var database=$("#database").val();
        //die();
        var my_data="";
        my_data='{"host":"'+host+'","user":"'+user+'","password":"'
        +password+'","database":"'+database+'","code":"1"}';
        $.ajax({
            url: "ajax_php.php",
            type: "POST",
            data:{trans_data:my_data},
            dataType:'json',
            error: function(){
                alert("Error loading XML document");
            },
            success: function(data,status){//如果调用php成功
                for(var i=0;i<data.length;i++){
                    $('#sldd').show();
                    $('#sldd').append('<option value="'+data[i]+'">'+data[i]+'</option>');
                }
            }
        });

    });
</script>
<script type="text/javascript">
    $(document).ready(function () {
        $("#sldd").bind("change",function(){
            if($(this).val()==0){
                alert(111);
            }
            else{
                var host=$("#host").val();
                var user=$("#user").val();
                var password=$("#password").val();
                var database=$("#database").val();
                //die();
                var my_data="";
                my_data='{"host":"'+host+'","user":"'+user+'","password":"'
                +password+'","database":"'+database+'","code":"2","table":"'+$(this).val()+'"}';
               // "host":"127.0.0.1","user":"root","password":"12345","database":"ajax"}
                $.ajax({
                    url: "ajax_php.php",
                    type: "POST",
                    data:{trans_data:my_data},
                    dataType:'json',
                    error: function(){
                        alert("Error loading XML document");
                    },
                    success: function(data,status){//如果调用php成功
                        for(var i=0;i<data.length;i++){
                            $('#tr1').append('<td>'+data[i]+'</td>');
                        }
                    }
                });
            }
        });
    });
</script>

<?php
header('Content-Type:text/html; charset=utf-8');
//$ar=array('0'=>1087,'1'=>1);
//echo $arr=json_encode($ar);
echo '<br>';
echo print_r(json_decode($arr));
//die();
$bk=$_POST['trans_data'];
//$bk=$backValue='{"host":"127.0.0.1","user":"root","password":"12345","database":"yii","code":"2","table":"order"}';

$bk=json_decode($bk,true);
if($bk['code'] == 1) {
    $db = new mysqli();
    $db->connect($bk['host'], $bk['user'], $bk['password'], $bk['database']);
    $query[0] = $db->query('SET NAMES utf8');
    $sql[0]='show tables';
    $query[0]=$db->query($sql[0]);
    while($rs=mysqli_fetch_array($query[0])){
        $result[]=$rs;
    }
    $db->close();
    foreach($result as $k=>$value ){
        $result2[]=$result[$k][0];
    }
    echo json_encode($result2);
    die();
}
if($bk['code'] == 2) {
    $db = new mysqli();
    $db->connect($bk['host'], $bk['user'], $bk['password'], $bk['database']);
    $db->query('SET NAMES utf8');
    $sql = "SELECT * FROM  `".$bk['table']."`";
    $query = $db->query($sql);
    while ($rs = mysqli_fetch_array($query)) {
        $result[] = $rs;
    }
    $i = 0;
    foreach ($result[0] as $key => $value) {
        $i += 1;
        if ($i % 2 == 0) {
            $a[] = $key;
        }
    }
    $query->free();
    $db->close();
    echo json_encode($a);
}