21,881
社区成员
发帖
与我相关
我的任务
分享
<?php
//PHP区域
header("Content-Type:text/html;charset=utf-8");
mysql_connect('localhost','xxxxxx','xxxxxxxxxx');
mysql_select_db('xxxxxxxx');
function getdata($sql)
{
$result=mysql_query($sql);
if($result)$count = mysql_num_rows($result);
for($i=0;$i<$count;$i++)
{
mysql_data_seek($result,$i);
$data[$i] = mysql_fetch_assoc($result);
}
return $data;
}
$data = getdata("select * from demo");
?>
<!--CSS区域-->
<style type="text/css">
.left{float:left;width:100px;border:1px solid grey;height:300px;}
.right{float:left;width:800px;border:1px solid grey;height:300px;margin-left:15px;}
.left_button{margin:5px;border:1px solid #ccc;cursor:pointer;}
td{margin:1px;border:1px solid #ccc;}
</style>
<!--JS区域-->
<script type="text/javascript" src="https://ajax.googleapis.com/ajax/libs/jquery/1.4.4/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$(".left_button").click(function(){
$(this).css("background","#EEE");
$(this).siblings().css("background","white");
var n = $(this).text();
$.ajax({
type:"get",
url:"ajax.php",
data:{
n:n
},
success:function(msg){
msg = eval("("+msg+")"); //将json字符串转化为js数组对象
$(".show_tr > td:eq(0)").text(msg.id); //将数组的每个元素写到指定位置
$(".show_tr > td:eq(1)").text(msg.col1);
$(".show_tr > td:eq(2)").text(msg.col2);
$(".show_tr > td:eq(3)").text(msg.col3);
$(".show_tr > td:eq(4)").text(msg.col4);
var gender = msg.gender;
if(gender == 1){ //如果为男,第一个单选被选中
$(".show_tr > td:eq(5) > input[name='gender']:eq(0)").attr("checked","checked");
}else{ //如果为女
$(".show_tr > td:eq(5) > input[name='gender']:eq(1)").attr("checked","checked");
}
}
});
});
});
</script>
<!--html区域-->
<div class="left">
<?php foreach($data as $each){?>
<div class="left_button"><?php echo $each['col3'];?></div>
<?php } ?>
</div>
<div class="right">
<table>
<tr>
<td>id</td>
<td>col1</td>
<td>col2</td>
<td>col3</td>
<td>col4</td>
<td>性别</td>
<tr>
<tr class="show_tr">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td><input type="radio" name="gender">男<input type="radio" name="gender">女</td>
<tr>
</table>
</div>
<?php
header("Content-Type:text/html;charset=utf-8");
mysql_connect('localhost','xxxxxxxx','xxxxxxxxx');
mysql_select_db('xxxxxxxx');
mysql_query("set names utf8");
function getdata($sql)
{
$result=mysql_query($sql);
if($result)$count = mysql_num_rows($result);
for($i=0;$i<$count;$i++)
{
mysql_data_seek($result,$i);
$data[$i] = mysql_fetch_assoc($result);
}
return $data;
}
if($_GET){
$n = $_GET['n'];
$data = getdata("select * from demo where col3 = '$n'");
echo json_encode($data[0]);exit;
}
?>