一個(gè)對(duì)數(shù)據(jù)庫(kù)進(jìn)行設(shè)置的程序
發(fā)表時(shí)間：2024-02-05 來(lái)源：明輝站整理相關(guān)軟件相關(guān)文章人氣：
[摘要]db.func:<?function GetRows( $Database, $Query ) { mysql_connect ("ftp", "root", ""); $db = mysql_select_db( $Dat...
db.func:
<?
function GetRows( $Database, $Query ) {
mysql_connect ("ftp", "root", "");
$db = mysql_select_db( $Database );
if ( ! $db ) {
echo "無(wú)法連結(jié)數(shù)據(jù)庫(kù)！";
exit;
}
$rows = mysql_query( $Query );
if ( ! $rows ) {
echo "SQL指令錯(cuò)誤!";
exit;
}
return $rows;
}
function ConnectDatabase( $Database ) {
mysql_connect ("ftp", "root", "");
$db = mysql_select_db( $Database );
if ( ! $db ) {
echo "無(wú)法連結(jié)數(shù)據(jù)庫(kù)！";
exit;
}
}
?>
cratetable.php:
<?
function CreateTable() {
$link = mysql_connect ("ftp", "root", "");
$db = mysql_select_db("pcadmin");
if ( ! $db ) {
echo "連接到數(shù)據(jù)庫(kù)失��！";
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">主機(jī)名稱</div></th>
<td><input name="Name" type="text" class="input"></td>
</tr>
<tr>
<th scope="row"><div align="left" class="font">生產(chǎn)廠商</div></th>
<td><input name="Produce" type="text" class="INPUT"></td>
</tr>
<tr>
<th scope="row"><div align="left" class="font">聯(lián)絡(luò)人</div></th>
<td><input name="Lianluo" type="text" class="INPUT"> </td>
</tr>
<tr>
<th scope="row"><div align="left" class="font">聯(lián)絡(luò)人電話</div></th>
<td><input name="Tel" type="text" class="INPUT"></td>
</tr>
<tr>
<th scope="row"><div align="left" class="font">聯(lián)絡(luò)人郵箱</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">應(yīng)用名稱</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="重寫(xiě)">
<a href="show.php">查看記錄</a></td>
</tr>
</table>
</form><hr size="1" noshade>
<p> </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="show.php" class="font">成功輸入一筆資料去看看</a>
<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>
[page_break]
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;
if ( $Page < 1 ) $Page = 1;
if ( $Page > $Pages ) $Page = $Pages;
ShowOnePage( $rows, ($Page-1)*10 );
?>
<HR size="1" noshade color="#0000ff" class="hr">
<FORM Action=<? echo $PHP_SELF;?> Method=GET >
<DIV Align=right>
<?
if ( $Page <> 1 ) { // 當(dāng)不是第一頁(yè)時(shí)
echo "<A HREF=$PHP_SELF?Page=1>第一頁(yè)</A>";
echo "<A HREF=$PHP_SELF?Page=" . ($Page-1) . ">上一頁(yè)</A>";
}
if ( $Page <> $Pages ) { // 當(dāng)不是最后一頁(yè)時(shí)
echo "<A HREF=$PHP_SELF?Page=" . ($Page+1) . ">下一頁(yè)</A>";
echo "<A HREF=$PHP_SELF?Page=$Pages>最后一頁(yè)</A>";
}
?>
<span class="body">跳轉(zhuǎn)</span>:
<INPUT TYPE=TEXT Name=Page SIZE=3>
<span class="body">當(dāng)前頁(yè)</span>:<Font color=Red><?echo $Page;?>/<?echo $Pages;?>
</DIV>
</FORM>
</BODY>
</HTML>
cxshow.php:
<title>Get ID</title>
<?php
if ($id){
//編輯狀態(tài)，選擇一條記錄
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>無(wú)標(biāo)題文檔</title>
</head>
<body>
<?php
$db=mysql_connect("ftp","root","");
mysql_select_db ("pcadmin",$db);
if ($ID) {
echo "有ID的情況,ID是:$ID<br>";
if ($submit){
echo "執(zhí)行了Submit時(shí)：<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 "沒(méi)有執(zhí)行Submit時(shí):<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>
聯(lián)絡(luò):<input type="test" name="Lianluo" value="<? echo $myrow["Lianluo"] ?>"><br>
電話:<input type="test" name="Tel" value="<? echo $myrow["Tel"] ?>"><br>
郵箱:<input type="test" name="Email" value="<? echo $myrow["Email"] ?>"><br>
<input type="Submit" name="submit" value="輸入信息">
</form>
<?
}
} else {
echo "沒(méi)有ID的情況:<br>";
$result = mysql_query("select * from Profile",$db);
if ($myrow = mysql_fetch_array($result)){
do {
printf ("<a href=\"%s?ID=%s\">%s %s %s %s %s</a><br>\n",$PATH_INFO, $myrow["ID"],$myrow["Name"],$myrow["Produce"],$myrow["Lianluo"],$myrow["Tel"],$myrow["Email"]);
} while ($myrow = mysql_fetch_array($result));
} else {
echo "對(duì)不起，沒(méi)有找到相關(guān)記錄！";
exit;
}
}
?>
delete.php:
<title>刪除一條記錄</title><?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!";
?>
