想在IE运行文件A的时候表单显示出数据库中的数据,如何连接?自己作了个连接数据的文件B(只是一下部分),那怎么才能让我的文件A在运行时一一对应的显示出数据库里边的信息呢?
文件A:
<html>
<head><title>无标题</title></head>
<body>
<center><h4>大类管理(一) >管理选项 1> 内容设置</h4></center>
<table width="100%" border="1" cellpadding="3" cellspacing="0" align="center" >
<caption><h1>研发部人员信息</h1></caption>
<tr><th colspan="1">编号</th><th colspan="1">姓名</th><th colspan="1">性别</th><th colspan="1">年龄</th>
<th colspan="1">职务</th><th colspan="1">籍贯</th><th colspan="1">联系方式</th></tr>
</tr> </body>
</html>
文件B
<?php
//连接数据库
$conn = mysql_connect("localhost", "root", "123");
$rs = mysql_query("SET NAMES 'GB2312'");
mysql_select_db( "fusuton", $conn);
$result = mysql_query("SELECT * FROM yanfa");
?>
<form action='b.php' method='post'/>具体google HTML表单提交。
http://www.w3schools.com/html/html_forms.asp用xmlhttp也可以实现
http://www.w3schools.com/ajax/ajax_aspphp.asp
文章我看了下 跟我想要的结果有些不太一样我就是想让在网页上显示的这个表单(大表单)能从数据里边把数据读出来就行了
应该很简单 但我不会! 就像!
编号 姓名 性别 职位 籍贯 联系方式
1 嬴政 男 暴君 陕西 15810209719
2 高渐离 男 侠客 河北 15020201313
简单说下我的数据结构哈数据库名称 fusuton
表单名称是 yanfa含有字段:UserId、 UserName、UserSex、UserJob、UserPro、UserPho
这样??<?php
mysql_connect("localhost", "root", "123");
$rs = mysql_query("set names gbk");
mysql_select_db("fusuton");
$result = mysql_query("select * from yanfa");
?>
<html>
<head><title>无标题</title></head>
<body>
<center><h4>大类管理(一) >管理选项 1> 内容设置</h4></center>
<table width="100%" border="1" cellpadding="3" cellspacing="0" align="center" >
<caption><h1>研发部人员信息</h1></caption>
<tr>
<th colspan="1">编号</th>
<th colspan="1">姓名</th>
<th colspan="1">性别</th>
<th colspan="1">年龄</th>
<th colspan="1">职务</th>
<th colspan="1">籍贯</th>
<th colspan="1">联系方式</th>
</tr>
<?php
while($row = mysql_fetch_assoc($result)){
?>
<tr>
<th colspan="1"><?php echo $row['id']; ?></th>
<th colspan="1"><?php echo $row['name']; ?></th>
<th colspan="1"><?php echo $row['gender']; ?></th>
<th colspan="1"><?php echo $row['age']; ?></th>
<th colspan="1"><?php echo $row['zhiwu']; ?></th>
<th colspan="1"><?php echo $row['jiguan']; ?></th>
<th colspan="1"><?php echo $row['lianxifangshi']; ?></th>
</tr>
<?php
}
?>
</table>
</body>
</html>
<?php
mysql_connect("localhost", "root", "123");
$rs = mysql_query("set names gbk");
mysql_select_db("fusuton");
$result = mysql_query("select * from yanfa");
?>
<html>
<head><title>无标题</title></head>
<body>
<center><h4>大类管理(一) >管理选项 1> 内容设置</h4></center>
<table width="100%" border="1" cellpadding="3" cellspacing="0" align="center" >
<caption><h1>研发部人员信息</h1></caption>
<tr>
<th colspan="1">编号</th>
<th colspan="1">姓名</th>
<th colspan="1">性别</th>
<th colspan="1">年龄</th>
<th colspan="1">职务</th>
<th colspan="1">籍贯</th>
<th colspan="1">联系方式</th>
</tr>
<?php
while($row = mysql_fetch_assoc($result)){
?>
<tr>
<th colspan="1"><?php echo $row['UserId']; ?></th>
<th colspan="1"><?php echo $row['UserName']; ?></th>
<th colspan="1"><?php echo $row['UserSex']; ?></th>
<th colspan="1"><?php echo $row['UserAge']; ?></th>
<th colspan="1"><?php echo $row['UserJob']; ?></th>
<th colspan="1"><?php echo $row['UserPro']; ?></th>
<th colspan="1"><?php echo $row['UserPho']; ?></th>
</tr>
<?php
}
?>
</table>
</body>
</html>
对了 我若是要在页面添加个按钮
怎么才能实现页面的添加 删除 数据内容?
激动ing
mysql_connect("localhost", "root", "123");
$rs = mysql_query("set names gbk");
mysql_select_db("fusuton");
$result = mysql_query("select * from yanfa");if(isset($_POST['del'])){
$del = mysql_query('delete from yanfa where id = '.$_POST['id']);
if($del)echo '删除成功';
else echo '删除失败';
}
?>
<html>
<head><title>无标题</title></head>
<body>
<center><h4>大类管理(一) >管理选项 1> 内容设置</h4></center>
<table width="100%" border="1" cellpadding="3" cellspacing="0" align="center" >
<caption><h1>研发部人员信息</h1></caption>
<tr>
<th colspan="1">编号</th>
<th colspan="1">姓名</th>
<th colspan="1">性别</th>
<th colspan="1">年龄</th>
<th colspan="1">职务</th>
<th colspan="1">籍贯</th>
<th colspan="1">联系方式</th>
</tr>
<?php
while($row = mysql_fetch_assoc($result)){
?>
<tr>
<th colspan="1"><?php echo $row['UserId']; ?></th>
<th colspan="1"><?php echo $row['UserName']; ?></th>
<th colspan="1"><?php echo $row['UserSex']; ?></th>
<th colspan="1"><?php echo $row['UserAge']; ?></th>
<th colspan="1"><?php echo $row['UserJob']; ?></th>
<th colspan="1"><?php echo $row['UserPro']; ?></th>
<th colspan="1"><?php echo $row['UserPho']; ?></th>
</tr>
<?php
}
?>
</table>
<form action="" method="post">
<input type="text" name="id">
<input type="hidden" name="del">
<input type="submit" name="删除">
</form>
</body>
</html>
mysql_connect("localhost", "root", "123");
$rs = mysql_query("set names gbk");
mysql_select_db("fusuton");
$result = mysql_query("select * from yanfa");if(isset($_POST['del'])){
$del = mysql_query('delete from yanfa where id = '.$_POST['id']);
if($del)echo '删除成功';
else echo '删除失败';
}
if(isset($_POST['add'])){
$name = $_POST['UserName'];
$sex = $_POST['UserSex'];
$age = $_POST['UserAge'];
$job = $_POST['UserJob'];
$pro = $_POST['UserPro'];
$pho = $_POST['UserPho'];
$add = mysql_query('insert into yanfa values("$name", "$sex", "$age", "$job", "$pro", "$pho")');
if($add)echo '成功';
else echo '失败';
}
?>
<html>
<head><title>无标题</title></head>
<body>
<center><h4>大类管理(一) >管理选项 1> 内容设置</h4></center>
<table width="100%" border="1" cellpadding="3" cellspacing="0" align="center" >
<caption><h1>研发部人员信息</h1></caption>
<tr>
<th colspan="1">编号</th>
<th colspan="1">姓名</th>
<th colspan="1">性别</th>
<th colspan="1">年龄</th>
<th colspan="1">职务</th>
<th colspan="1">籍贯</th>
<th colspan="1">联系方式</th>
</tr>
<?php
while($row = mysql_fetch_assoc($result)){
?>
<tr>
<th colspan="1"><?php echo $row['UserId']; ?></th>
<th colspan="1"><?php echo $row['UserName']; ?></th>
<th colspan="1"><?php echo $row['UserSex']; ?></th>
<th colspan="1"><?php echo $row['UserAge']; ?></th>
<th colspan="1"><?php echo $row['UserJob']; ?></th>
<th colspan="1"><?php echo $row['UserPro']; ?></th>
<th colspan="1"><?php echo $row['UserPho']; ?></th>
</tr>
<?php
}
?>
</table>
<form action="" method="post">
<input type="text" name="id">
<input type="hidden" name="del">
<input type="submit" name="删除">
</form><form action="" method="post">
<input type="text" name="UserName">
<input type="text" name="UserSex">
<input type="text" name="UserAge">
<input type="text" name="UserJob">
<input type="text" name="UserPro">
<input type="text" name="UserPho">
<input type="hidden" name="add">
<input type="submit" name="添加">
</form>
</body>
</html>
可能要修改下才能可以,不太知道你的具体情况,你修改下