一个对数据库进行操作的程序（之二）

以下粘贴出各个页面的源代码：

db.func:

function GetRows( $Database, $Query ) {
   mysql_connect ("ftp", "root", "");
   $db = mysql_select_db( $Database );
   if ( ! $db ) {
      echo "无法连结数据库！";
      exit;
   }

   $rows = mysql_query( $Query );
   if ( ! $rows ) {
      echo "SQL指令错误!";
      exit;
   }
   return $rows;
}

function ConnectDatabase( $Database ) {
   mysql_connect ("ftp", "root", "");
   $db = mysql_select_db( $Database );
   if ( ! $db ) {
      echo "无法连结数据库！";
      exit;
   }
}
?>

cratetable.php:

function CreateTable() {
   $link = mysql_connect ("ftp", "root", "");
   $db = mysql_select_db("pcadmin");
   if ( ! $db ) {
      echo "连接到数据库失败！";
      exit;
   }
   $rows = mysql_query("select * from Profile");
   if ( ! $rows ) {
      $sql = "Create Table Profile (ID integer auto_increment primary key,Name char(255),Produce char(255),Lianluo char(255),Tel integer(15),Email char(255))";
      mysql_query($sql);
   }
  
   $rows = mysql_query("select * from Aplication");
   if ( ! $rows ) {
      $sql = "Create Table Aplication(Name char(255) primary key,IP char(255),Ap char(255),Directory char(255))";
      mysql_query($sql);
   }
   mysql_close ($link);
}
CreateTable();
?>

input.htm:

輸入表單

---

 
   
   
 
 
   
   
 
 
   
   
 
 
   
   
 
 
   
   
 
 
   
   
 
 
   
   
 
 
   
   
 
 
   
   
 

主機名稱
生產廠商
聯絡人
聯絡人電話
聯絡人郵箱
IP　Address
應用名稱
配置文件
	查看记录

---

 

insert.php:

成功輸入一筆資料去看看 

---

include("../db.func");

if ( !empty($Send) ) {
   ConnectDatabase( "pcadmin" );
   $sql = "insert into Profile(Name,Produce,Lianluo,Tel,Email) values('$Name','$Produce','$Lianluo','$Tel','$Email')";
  
   mysql_query( $sql );
    }
?>

show.php:

function ShowOnePage( $rows, $No ) {
  mysql_data_seek( $rows, $No );
 

  echo "

";
  echo "";
  while ( $field = mysql_fetch_field($rows) ) {
     echo "";
  }
  echo "";
  $nums = mysql_num_rows($rows);
  for ( $I=1; $I <=10; $I++ ) {
     if ( $row = mysql_fetch_row($rows) ) {
          for ( $K=0 ; $K < count($row); $K++ ) {
           echo "";
        }
        echo "";
     }
  }
  echo "

" . $field->name . "

" . $row[$K] . "

";
}
?>

伺服器清單
 

---

  include("../db.func");
  $rows = GetRows( "pcadmin", "Select * From Profile" );

  $num = mysql_num_rows($rows);
  $Pages = intval(($num - 1) / 10) + 1;

  if ( $Page < 1 ) $Page = 1;
  if ( $Page > $Pages ) $Page = $Pages;

  ShowOnePage( $rows, ($Page-1)*10 );
?>

---

Method=GET >

if ( $Page <> 1 ) {  // ?当不是第一页时
   echo "第一页?";
   echo "上一页?";
}

if ( $Page <> $Pages ) {  // ?当不是最后一页时

　echo "下一页?";
   echo "最后一页?";
}
?>
跳转:

当前页:/

cxshow.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:

$db=mysql_connect("ftp","root","");
mysql_select_db ("pcadmin",$db);
if ($ID) {
  echo "有ID的情况,ID是:$ID
";
  if ($submit){
  echo "执行了Submit时：
";
  $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时:
";
          $sql= "select * from Profile where ID=$ID";
          $result = mysql_query($sql);
          $myrow = mysql_fetch_array($result);
          ?>

Method=post>
">
名称:">

厂商:">

联络:">

电话:">

邮箱:">

}
} else {
       echo "没有ID的情况:
";
       $result = mysql_query("select * from Profile",$db);
       if ($myrow = mysql_fetch_array($result)){
       do {
        printf ("%s %s %s %s %s
",$PATH_INFO, $myrow["ID"],$myrow["Name"],$myrow["Produce"],$myrow["Lianluo"],$myrow["Tel"],$myrow["Email"]);
       } while ($myrow = mysql_fetch_array($result));
       } else {
       echo "对不起，没有找到相关记录！";
       exit;
       }
       }
?>

delete.php:

$db = mysql_connect("ftp","root","");
mysql_select_db("pcadmin",$db);
$sql="delete from Profile where ID=$ID";
$result=mysql_query($sql);
echo "Delete one record!";
?>