純ajax遍曆資料庫 遍曆資料庫欄位

來源:互聯網
上載者:User
 
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>
 
<?phpheader('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);}
相關文章

聯繫我們

該頁面正文內容均來源於網絡整理,並不代表阿里雲官方的觀點,該頁面所提到的產品和服務也與阿里云無關,如果該頁面內容對您造成了困擾,歡迎寫郵件給我們,收到郵件我們將在5個工作日內處理。

如果您發現本社區中有涉嫌抄襲的內容,歡迎發送郵件至: info-contact@alibabacloud.com 進行舉報並提供相關證據,工作人員會在 5 個工作天內聯絡您,一經查實,本站將立刻刪除涉嫌侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.