<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="pragma" content="no-cache"/>
<meta http-equiv="Cache-Control" content="no-cache, no-store"/>
<title>111</title>
<style type="text/css">
</style>
</head>
<body>
<div><form action="listupdate.php" method="post"name="listform">
<table border="1" cellspacing="0" width="500px"id="userinformation">
<tr>
<td>用戶名</td>
<td>密碼</td>
<td>等級</td>
<td>編輯</td>
<td>操作</td>
</tr>
<br>
<?php
$dbhost='localhost';
$dbuser='test2';
$dbpass='test2';
$dbname='test2';
$conn=NULL;
//連接數據庫
function conncctDB($dbhost,$dbuser,$dbpass,$dbname,$conn)
{
$conn=mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error with MySQL connection');
mysql_select_db($dbname,$conn);
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
}
conncctDB($dbhost, $dbuser, $dbpass, $dbname, $conn);
$str="select * from password ";
$query=mysql_query($str);
// echo $str."<br>";
// echo $query."<br>";
while($result=mysql_fetch_array($query))
{ $resultid=$result["ID"];
$resultpw=$result["PW"];
$resultlv=$result["LV"];
$resultedit=$result["EDIT"];
?>
<tr>
<td ><input type='text' value="<?=$resultid?>" name="<?=$resultid?>" readonly='readonly'id=<?=$resultid?>> <?=$result["ID"]?> </td>
<td ><?=$result["PW"]?></td>
<td ><?=$result["LV"]?></td>
<td ><?=$result["EDIT"]?></td>
<td><input type='submit' name='submit' value='修改'action="listupdate.php?user_id=$resultid" '></td>
</tr>
<?php
}
?>
</table>
</form>
</div>
<div>
<form name="form1"method="post" action="listadd.php">
<p>用戶名:<input name="username" type="text" size="20" id="username"></p>
<p>密 碼:<input type="password" name="userpassword" size="20"id="userpassword"></p>
<p>LV:<select name="lv" id="lv" >
<option>1</option>
<option>2</option>
<option>3</option>
</select></p>
<p><input type="submit" name="submit" value="添加"></p>
</form>
</div>
</body>
</html>
已经查询获得数据库中额数据在table中 如何点击修改按钮直接跳转页面 并直接获得所在的td中的数值啊
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta http-equiv="pragma" content="no-cache"/>
<meta http-equiv="Cache-Control" content="no-cache, no-store"/>
<title>111</title>
<style type="text/css">
</style>
</head>
<body>
<div><form action="listupdate.php" method="post"name="listform">
<table border="1" cellspacing="0" width="500px"id="userinformation">
<tr>
<td>用戶名</td>
<td>密碼</td>
<td>等級</td>
<td>編輯</td>
<td>操作</td>
</tr>
<br>
<?php
$dbhost='localhost';
$dbuser='test2';
$dbpass='test2';
$dbname='test2';
$conn=NULL;
//連接數據庫
function conncctDB($dbhost,$dbuser,$dbpass,$dbname,$conn)
{
$conn=mysql_connect($dbhost,$dbuser,$dbpass)
or die ('Error with MySQL connection');
mysql_select_db($dbname,$conn);
mysql_query("SET NAMES 'UTF8'");
mysql_query("SET CHARACTER SET UTF8");
mysql_query("SET CHARACTER_SET_RESULTS=UTF8");
}
conncctDB($dbhost, $dbuser, $dbpass, $dbname, $conn);
$str="select * from password ";
$query=mysql_query($str);
// echo $str."<br>";
// echo $query."<br>";
while($result=mysql_fetch_array($query))
{ $resultid=$result["ID"];
$resultpw=$result["PW"];
$resultlv=$result["LV"];
$resultedit=$result["EDIT"];
?>
<tr>
<td ><input type='text' value="<?=$resultid?>" name="<?=$resultid?>" readonly='readonly'id=<?=$resultid?>> <?=$result["ID"]?> </td>
<td ><?=$result["PW"]?></td>
<td ><?=$result["LV"]?></td>
<td ><?=$result["EDIT"]?></td>
<td><input type='submit' name='submit' value='修改'action="listupdate.php?user_id=$resultid" '></td>
</tr>
<?php
}
?>
</table>
</form>
</div>
<div>
<form name="form1"method="post" action="listadd.php">
<p>用戶名:<input name="username" type="text" size="20" id="username"></p>
<p>密 碼:<input type="password" name="userpassword" size="20"id="userpassword"></p>
<p>LV:<select name="lv" id="lv" >
<option>1</option>
<option>2</option>
<option>3</option>
</select></p>
<p><input type="submit" name="submit" value="添加"></p>
</form>
</div>
</body>
</html>
已经查询获得数据库中额数据在table中 如何点击修改按钮直接跳转页面 并直接获得所在的td中的数值啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货