一个对数据库进行操作的程序(4)

原作者:kuku 添加时间:2007-06-02 原文发表:2007-06-02 人气:8 来源：互联网

本文章共7089字，分5页，当前第4页，快速翻页：

-----------------------------------------------------------------------------------------------------------------------------------------------

本文提示：《一个对数据库进行操作的程序(4)》是本站编辑们为广大网友精选的实用文章，本文阐述了关于文章的相关理论，相对来说专业性强，但是本文只是针对于某个问题提出的见解与论述，未必能辐射到相关问题的方方面面，所以本文处理问题的方法仅仅为您提供一些参考。更多问题请查阅学习中国网其他栏目哦.

-----------------------------------------------------------------------------------------------------------------------------------------------

　echo "<A HREF=$PHP_SELF?Page=" . ($Page+1) . ">下一页</A>";
echo "<A HREF=$PHP_SELF?Page=$Pages>最后一页</A>";
}
?>
<span class="body">跳转</span>:
<INPUT TYPE=TEXT Name=Page SIZE=3>
<span class="body">当前页</span>:<Font color=Red><?echo $Page;?>/<?echo $Pages;?>
</DIV>
</FORM>
</BODY>
</HTML>

cxshow.php:

<title>Get ID</title>
<?php

if ($id){
//编辑状态，选择一条记录
include("../db.func");
mysql_connect("ftp","root","");
mysql_select_db("pcadmin");
$sql = "update Profile set Name='$Name',Produce='$Produce',Lianluo='$Lianluo',Tel='$Tel',Email='$Email' where id=5";
mysql_query($sql);
//$rows = GetRows( "pcadmin", "Select * From Profile where id=$id" );
//$myrow = mysql_fetch_array($rows);
//$id = $myrow["id"];
//$Name = $myrow["Name"];
//$Produce = $myrow["Produce"];
//$Lianluo = $myrow["Lianluo"];
//$Tel = $myrow["Tel"];
//$Email = $myrow["Email"];

echo "你的ID是'$id'";

exit;
} else {
echo "Failure!";
exit;
}

printf.php:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<?php
$db=mysql_connect("ftp","root","");
mysql_select_db ("pcadmin",$db);
if ($ID) {
echo "有ID的情况,ID是:$ID<br>";
if ($submit){
echo "执行了Submit时：<br>";
$sql = "update Profile set name='$Name',Produce='$Produce',Lianluo='$Lianluo',Tel='$Tel',Email='$Email' where ID=$ID";
$result = mysql_query($sql);
echo "Thank you！Information updated!";
} else {
          echo "没有执行Submit时:<br>";
          $sql= "select * from Profile where ID=$ID";
          $result = mysql_query($sql);
          $myrow = mysql_fetch_array($result);
          ?>
<form action = <? echo $PHP_SELF;?> Method=post>
<input type=hIDden name="ID" value="<?php echo $myrow["ID"] ?>">
名称:<input type="test" name="Name" value="<? echo $myrow["Name"] ?>"><br>
厂商:<input type="test" name="Produce" value="<? echo $myrow["Produce"] ?>"><br>
联络:<input type="test" name="Lianluo" value="<? echo $myrow["Lianluo"] ?>"><br>