文章详情

  • 游戏榜单
  • 软件榜单
关闭导航
热搜榜
热门下载
热门标签
php爱好者> php文档>修改MYSQL数据库

修改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)




相关阅读 更多 +
排行榜 更多 +
辰域智控app

辰域智控app

系统工具 下载
网医联盟app

网医联盟app

运动健身 下载
汇丰汇选App

汇丰汇选App

金融理财 下载