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);}