第14週 PHP與MySQL結合之一

<?php
 
  include "config.php";
  $command=$_POST["command"];
  $PHP_SELF=$_SERVER["PHP_SELF"];
  if ($command==null) {
      display_first_page($conn); 
      display_whole_data($conn); 
  }

  if ($command=="查詢") {
 
 
  }
  if ($command=="新增") {
      $student_no=$_POST["student_no"];
      $sql="insert into stmd values('$no')";
      $result=mysql_query($sql,$conn);
      display_first_page($conn);
      display_whole_data($conn);
  }
 
  function display_first_page($conn) {
     echo "<center><table border=1 bordercolor='#ff0000'>
               <form method='post' action='$PHP_SELF'>
               <tr><td>學號</td>
               <td><input type=text name=no size=10></td>
               <td><input type=submit name=command value='查詢'>
               <input type=submit name=command value='新增'></td></tr>
               </table> </form><hr>
            " ;
  }
 
  function display_whole_data($conn) {
      $sql="select * from stmd order by student_no";
      $result=mysql_query($sql,$conn);
      echo "<center>
                <table border=1 bordercolor='#ff0000' >
                <tr><td>學號</td></tr>
                ";
      while ($myrow=mysql_fetch_array($result)) {
           $student_no=$myrow["student_no"];
           echo "<tr><td>$student_no</td></tr>";
       }
       echo "</table>";
  }

  
?>
 

全部共 0則留言
留言...
登入帳號密碼代表遵守學術網路規範