修改MYSQL数据库
时间:2008-07-11 来源:wstczyl
?php
$link=mysql_connect("localhost","root","123");
mysql_select_db("ylzou",$link);
$q = "SELECT * FROM pc";
mysql_query("SET NAMES GB2312");
$rs = mysql_query($q,$link);
#if(!$rs){die("Valid result!");}
echo "";
echo "
ename
PCname
";
while($row = mysql_fetch_row($rs))
echo "
modify
$row[0]
$row[1]
";
echo "";
mysql_free_result($rs);
?>
?php
$link =mysql_connect("localhost","root","123");
if(!$link){die("error");}
echo "faile";
mysql_select_db("ylzou", $link);
$del_id=$_GET["ename"];
$q="select * from pc where ename='$del_id'";
mysql_query("SET NAMES GB2312"); $rs = mysql_query($q, $link);
if(!$rs){die("faile");}
?>
html>
head>
/head>
body>
form action="modify_finish.php" method="POST">
?php
echo "";
while($row = mysql_fetch_object($rs)) echo "pcname'>";
mysql_close($link); ?>
input type="submit" name="submit" value="submit">
/form>
/body>
/html>
?php
$link =mysql_connect("localhost","root","123");
if(!$link){die("error");}
echo "连接成功";
mysql_select_db("ylzou", $link);
$exec="update pc set pcname='".$_POST['pcname']."' where ename=".$_POST['ename']."";
echo "修改成功" ;
mysql_close($link)
相关阅读 更多 +