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


答案：以下粘贴出各个页面的源代码：
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:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>輸入表單</title>
<style type="text/css">
<!--
.INPUT {
 border: 1px solid #003C74;
}
.font {
 font-family: "新宋体";
 font-size: 14px;
 color: #0000FF;
 font-weight: lighter;
}
.table {
 border: 1px solid #000000;
}
.title {
 font-family: "新宋体";
 font-size: 14px;
 color: #FF0000;
}
-->
</style>
</head>
<body><h3><center class="title">輸入表單
</center><hr size="1" noshade>
</h3>
<form name="form1" method="post" action="insert.php">
<table width="400"align=center>
 <tr>
    <th scope="row"><div align="left" class="font">主機名稱</div></th>
    <td><input name="Name" type="text" class="input"></td>
  </tr>
  <tr>
    <th scope="row"><div align="left" class="font">生產廠商</div></th>
    <td><input name="Produce" type="text" class="INPUT"></td>
  </tr>
  <tr>
    <th scope="row"><div align="left" class="font">聯絡人</div></th>
    <td><input name="Lianluo" type="text" class="INPUT">      </td>
  </tr>
  <tr>
    <th scope="row"><div align="left" class="font">聯絡人電話</div></th>
    <td><input name="Tel" type="text" class="INPUT"></td>
  </tr>
  <tr>
    <th scope="row"><div align="left" class="font">聯絡人郵箱</div></th>
    <td><input name="Email" type="text" class="INPUT"></td>
  </tr>
  <tr>
    <th scope="row"><p align="left" class="font">IP　Address</p>
      </th>
    <td><input name="IP" type="text" class="INPUT"></td>
  </tr>
  <tr>
    <th scope="row"><div align="left" class="font">應用名稱</div></th>
    <td><input name="Ap" type="text" class="INPUT"></td>
  </tr>
  <tr>
    <th align="left" valign="top" scope="row"><div align="left" class="font">配置文件</div></th>
    <td><textarea name="Directory" cols="40" rows="5" class="INPUT" clums="15"></textarea></td>
  </tr>
  <tr>
    <th scope="row"><input name="Send" type="submit" class="INPUT" value="提交"></th>
    <td><input name="Submit" type="reset" class="INPUT" value="重寫">
      <a href=>  </tr>
</table>
</form><hr size="1" noshade>
<p>&nbsp;</p>
</body>
</html>
insert.php:
<HTML>
<style type="text/css">
<!--
.font {
 font-family: "新宋体";
 font-size: 14px;
 font-weight: lighter;
 color: #FF0000;
}
-->
</style>
<BODY bgcolor="#FFFFFF">
<H3><a href=><HR></H3>
<?
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 ); 
    }
?>
</BODY>
</HTML>
show.php:
<?
function ShowOnePage( $rows, $No ) {
  mysql_data_seek( $rows, $No );
 
  echo "<TABLE Border=1 Align=Center bordercolordark='#ffffff'  bordercolorlight='#000000' cellpadding='3' cellspacing='0' >";
  echo "<TR BgColor=Cyan>";
  while ( $field = mysql_fetch_field($rows) ) {
     echo "<TD>" . $field->name . "</TD>";
  }
  echo "</TR>";
  $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 "<TD Align=Right>" . $row[$K] . "</TD>";
        }
        echo "</TR>";
     }
  }
  echo "</TABLE>";
}
?>
<HTML>
<style type="text/css">
<!--
.title {
 color: #FF0000;
 font-family: "新宋体";
 font-size: 14px;
}
.body {
 font-family: "新宋体";
 font-size: 12px;
 font-weight: lighter;
 color: #0000FF;
}
-->
</style>
<title>伺服器清单</title><BODY bgcolor="#FFFFFF">
<H2 ALIGN=CENTER><span class="title">伺服器清單</span>
  <HR size="1" noshade color="#0000ff" class="hr" >
</H2>
<?
  include("../db.func");
  $rows = GetRows( "pcadmin", "Select * From Profile" );
  $num = mysql_num_rows($rows);
  $Pages = intval(($num - 1) / 10) + 1;<
上一个：修改mysql密码的方法
下一个：一个对数据库进行操作的程序（之一）
更多图片编程知识: