<form id="hz9zz"></form>
    • <form id="hz9zz"></form>
    

      

      <nobr id="hz9zz"></nobr>
      <form id="hz9zz"></form>
      3.   
          
      明輝手游網中心：是一個免費提供流行視頻軟件教程、在線學習分享的學習平臺！
                   
        
                           
        
                        		  
        
                 
              
                
      一個對數據庫進行設置的程序
                
                  發表時間：2024-06-03             來源：明輝站整理相關軟件相關文章人氣：          
              
      [摘要]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 "無法連結數據庫！";
            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="show.php">查看記錄</a></td>
        </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="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 ) {  // 當不是第一頁時
         echo "<A HREF=$PHP_SELF?Page=1>第一頁</A>";
         echo "<A HREF=$PHP_SELF?Page=" . ($Page-1) . ">上一頁</A>";
      }
      if ( $Page <> $Pages ) {  // 當不是最后一頁時
      　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>
      電話:<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 "沒有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 "對不起，沒有找到相關記錄！";
             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!";
      ?>




              
              
                 
              
                                            
                              		       
                          
                           		  
        
                            
      
日韩精品一区二区三区高清