10-4-2 ¸ê®ÆÀx¦s»Pª¬ºAÅã¥Ü

¤p»x

10-4-2   ¸ê®ÆÀx¦s»Pª¬ºAÅã¥Ü
Àx¦s³ø¦WªÌ¸ê®Æªºaddpeople.phpµ{¦¡ºô­¶¨ä¥ô°È¦³¤T¶µ¡G
1.ÀËÅç¬ã°Q·|ªº¸ê®Æªí¬O§_¦s¦b¡A¦pªG¸Ó¬ã°Q·|¸ê®Æªí¤£¦s¦b¡A«h«Ø¥ß·sªº¬ã°Q·|¸ê®Æªí¡C
2.±N³ø¦WªÌ¸ê®Æ¼g¤J¸ê®Æ®w¡C
3.Åã¥Ü³ø¦Wª¬ºA»P°Ñ¥[ªÌ²M³æ¦Cªí³sµ²¡C

ª`·N¡G§O§Ñ¤F¥ý¦bMySQL Server¤¤«Ø¤@­Ó¦W¬°¡uAutoAct¡vªº¸ê®Æ®w³á¡I

¤p»x

ÀËÅç¸ê®Æªí¬O§_¦s¦b
¦b³ø¦WªÌ¸ê®Æ¼g¤J¬Y­Ó¬ã°Q·|¸ê®Æªí¤§«e¡A§Ú­Ì¥²¶·¥ý§PÂ_¤@¤U¸Ó¸ê®Æªí¬O§_¦s¦b¡A¦pªG¦s¦b´N¥i¥H±N³ø¦WªÌ¸ê®Æª½±µ¼g¤J¹ïÀ³ªº¸ê®Æªí¤¤¡A­Y¸Ó¸ê®Æªí¤£¦s¦b¡A«h¥²¶·¨Ï¥ÎSQL¤¤ªºDML«ü¥O«Ø¥ß¤@­Ó·s¬ã°Q·|¸ê®Æªí¡C

ÁÙ°O±o§Ú­Ì¬ã°Q·|¸ê®Æªíªº³W®æ§a¡]ªí10-1¡^¡I«Ø¥ß¸ê®ÆªíªºDML«ü¥O±Ô­z¦p¤U¡G

1. CREATE TABLE [¬ã°Q·|¸ê®Æªí¦W] (
   
2.         Name varchar (10) NOT NULL ,
   
3.         Email varchar (50) NULL ,
   
4.         Company varchar (50) NULL ,
   
5.         Tel varchar (20) NOT NULL
   
6. )

½Æ»s¥N½X

¦Óªí³æ¤¤ªº¤U©ÔÄæ¦ì¡yactname¡z©Ò¶Ç»¼ªº¸ê®Æ´N¬O«¥­Ì¬ã°Q·|ªº¸ê®Æªí¦WºÙ¡A©Ò¥H¦bPHPµ{¦¡¤¤§Ú­Ì±NDML«ü¥O±Ô­z²Õ¦X¦p¤U¡G

1.     $SQL="Create Table " .
   
2.     $¬ã°Q·|¸ê®Æªí¦W .
   
3.     " (" .
   
4.     "Name varchar(10) Not NULL," .
   
5.     "Email varchar(50)," .
   
6.     "Company varchar(50)," .
   
7.     "Tel varchar(20) Not NULL" .
   
8.     ")";

½Æ»s¥N½X

¤p»x

·s¬ã°Q·|¸ê®Æªíªº«Ø¥ß»P§_¡A¨ú¨M©ó¸ê®Æ®w¤¤ªº¦³µL¸Ó¬ã°Q·|¸ê®Æªíªº¦s¦b¡A­nÀËÅç¸ê®Æªí¬O§_¦s¦b¥i§Q¥Îmysql_list_tables()»Pmysql_tablename()¨ç¼Æ¡C
mysql_list_tables()¡G¦C¥X¸ê®Æ®w¤¤¥þ³¡ªº¸ê®Æªí¡C

1. int mysql_list_tables ( string database_name [, int link_identifier])

½Æ»s¥N½X

• database_name¡G«ü©w§Ú­Ì­n¾Þ§@ªº¸ê®Æ®w¦WºÙ¡C
  
• link_identifier¡G³s½u¥N¸¹¡Amysql_list_tables()¨ç¼Æ¥u­t³d¨ú¦^§@¥Î¤¤¸ê®Æ®w¤ºªº¸ê®Æªí¦Cªí¡A¨Ã¨S¦³³sµ²¸ê®Æ®wªº¯à¤O¡A¦]¦¹¡Amysql_list_tables()¨ç¼Æ¥²¶·³z¹L¬Y­Ó¤w«Ø¥ß¨Ã§¹¦¨¸ê®Æ®w³sµ²ªº¡u³s½u¥N¸¹¡v¡A³o­Ó¡u³s½u¥N¸¹¡v¬O¥Ñmysql_connect()¨ç¼Æ©Ò«Ø¥ßªº¡A³o­Ó°Ñ¼Æ¥i¥H¤£«ü©w¡A¦bmysql_list_tables()¨ç¼Æ°õ¦æ®É·|¦Û°Ê§ä´M³Ìªñ¥Ñmysql_connect()¨ç¼Æ©Ò«Ø¥ßªº³s½u¡C
  

mysql_list_tables()¨ç¼Æ¨Ï¥Î°}¦C¶°¦Xªº¤è¦¡¨Ó¦Cªí¨ú¦^ªº¸ê®Æªí¦WºÙ¡C
mysql_tablename()¨ç¼Æ¡G¨ú¥Xµ²ªG¶°¤¤ªº¸ê®Æ®w©Î¸ê®Æªí¦WºÙ¡C

1. int mysql_ tablename ( int result_identifier, int i)

½Æ»s¥N½X

• int result_identifier¡Gmysql_list_tables()¡Bmysql_list_dbs()¨ç¼Æ©Ò¶Ç¦^¨Óªºµ²ªGID¡]µ²ªG¶°¡^¡C
  
• i¡G¨ç¼Æ©Ò¶Ç¦^¨Óªºµ²ªGID¸Ìªº¯Á¤Þ¡C
  

1. //ÀËÅç¸ê®Æªí¬O§_¦s¦b
   
2. $testrs=mysql_list_tables("AutoAct");      
   
3. if (!($Actname==mysql_tablename($testrs,$Actname)))
   
4.    {
   
5.     //¸ê®Æªí¤£¦s¦b«h«Ø¥ß
   
6. //¥H¤U²¤

½Æ»s¥N½X

¤p»x

¥²¶ñÄæ¦ì¬O§_¦³¸ê®Æ¿é¤J
¦b¸ê®Æªí³W¹º®É¡A§Ú­Ì§â©m¦W¡]Name¡^»PÁpµ¸¹q¸Ü¡]Tel¡^Äæ¦ì³]©w¬°¤@©w­n¦³¸ê®Æ¿é¤JªºÄæ¦ì¡]Not NULL¡^¡A¤]´N¬O»¡³ø¦W°Ñ¥[¬ã°Q·|ªÌ¤@©w­n¿é¤J¥Lªº©m¦W»P³sµ¸¹q¸Ü¡A¦pªG¨S¦³¸ê®Æ¿é¤Jªº¸Ü·|³y¦¨·s¼W¸ê®Æ¿ý®Éµo¥Í¿ù»~¡A©Ò¥H§Ú­Ì¥[¤J¤U¦Cªº§PÂ_±Ô­z¡G

1. <?
   
2. //§PÂ_¥²¶ñÄæ¦ì¸ê®Æ¬O§_¬°ªÅ¥Õ
   
3. //­Y¥²¶ñÄæ¦ì¸ê®ÆªÅ¥Õ«hªð¦^³ø¦W­¶
   
4. if (empty($_REQUEST["Name"]))
   
5. {
   
6. header("Location: index.php?msg=±z­è­è©m¦W¥¼¶ñ!!");
   
7. exit();
   
8. }
   
9. else if(empty($_REQUEST["Tel"]))
   
10. {
    
11. header("Location: index.php?msg=±z­è­èÁpµ¸¹q¸Ü¥¼¶ñ!!");
    
12. exit();
    
13. }
    
14. else
    
15. {
    
16. //±µ¦¬¨Ó¦Ûªí³æ¤¤ªº¥²¶ñÄæ¦ì¸ê®Æ
    
17. $Name = $_REQUEST["Name"];
    
18. $Tel = $_REQUEST["Tel"];
    
19. }

½Æ»s¥N½X

¦pªG¥²¶·¿é¤J¸ê®ÆªºÄæ¦ì¨S¦³¿é¤J¸ê®Æ¡A«h±Nºô­¶Âà¦V¦^³ø¦W­º­¶index.php¡A¦P®É¶Ç»¼¿ù»~°T®§¡C

¤U¸ü (40.89 KB)

2011-4-22 03:11

¹Ï10-24  ³ø¦W­º­¶Åã¥Ü¿ù»~°T®§¡C

¤p»x

¬d¬Ý¤w°Ñ¥[¤H­ûªº³sµ²³]­p¦P¼Ë¬O±Ä¥Î¡uªí³æ¡v¤è¦¡«Ø¥ß¡A³o­Óµ§ªÌ´N¤£¦A¦h»¡¤F¡A°O±o±NFORM¼ÐÅÒ¤¤ªºactionÄݩʳ]©w¬°listpeople.php§Y¥i¡C
addpeople.php

1. <?
   
2. //§PÂ_¥²¶ñÄæ¦ì¸ê®Æ¬O§_¬°ªÅ¥Õ
   
3. //­Y¥²¶ñÄæ¦ì¸ê®ÆªÅ¥Õ«hªð¦^³ø¦W­¶
   
4. if (empty($_REQUEST["Name"]))
   
5. {
   
6. header("Location: index.php?msg=±z­è­è©m¦W¥¼¶ñ!!");
   
7. exit();
   
8. }
   
9. else if(empty($_REQUEST["Tel"]))
   
10. {
    
11. header("Location: index.php?msg=±z­è­èÁpµ¸¹q¸Ü¥¼¶ñ!!");
    
12. exit();
    
13. }
    
14. else
    
15. {
    
16. //±µ¦¬¨Ó¦Ûªí³æ¤¤ªº¥²¶ñÄæ¦ì¸ê®Æ
    
17. $Name = $_REQUEST["Name"];
    
18. $Tel = $_REQUEST["Tel"];
    
19. }
    
20. 
    
21. //§PÂ_«D¥²¶ñÄæ¦ì'¤½¥q'¸ê®Æ¬O§_¬°ªÅ¥Õ
    
22. if (empty($_REQUEST["Company"]))
    
23. {
    
24. $Company="";
    
25. }
    
26. else
    
27. {
    
28. $Company = $_REQUEST["Company"];
    
29. }
    
30. //§PÂ_«D¥²¶ñÄæ¦ì'E-Mail'¸ê®Æ¬O§_¬°ªÅ¥Õ
    
31. if (empty($_REQUEST["Email"]))
    
32. {
    
33. $Email="";
    
34. }
    
35. else
    
36. {
    
37. $Email = $_REQUEST["Email"];
    
38. }
    
39. 
    
40. $Actname=$_REQUEST["Actname"];
    
41. 
    
42. //³sµ²SQL Server
    
43.     $conn = mysql_connect("localhost", "root", "12345a");
    
44. //¿ï¾Ü¸ê®Æ®w
    
45.     mysql_select_db("AutoAct", $conn);  
    
46. //«ü©w´£¨ú¸ê®Æªº®Õ¹ï¦r¤¸ªí
    
47.     mysql_query("set character set big5");
    
48. //ÀËÅç¸ê®Æªí¬O§_¦s¦b
    
49. $testrs=mysql_list_tables("AutoAct");      
    
50. if (!($Actname==mysql_tablename($testrs,$Actname)))
    
51.    {
    
52.     //¸ê®Æªí¤£¦s¦b«h«Ø¥ß
    
53.     $SQL="Create Table " .
    
54.     $Actname .
    
55.     " (" .
    
56.     "Name varchar(10) Not NULL," .
    
57.     "Email varchar(50)," .
    
58.     "Company varchar(50)," .
    
59.     "Tel varchar(20) Not NULL" .
    
60.     ")";
    
61.     mysql_query($SQL);
    
62.    }
    
63.          
    
64. //«Ø¥ß¬d¸ß¦r¦ê¥Î¥H§PÂ_¬O§_­«½Æ³ø¦W
    
65. $SQL="Select name From " . $Actname . " Where name='" . $Name . "'";
    
66. $RS=mysql_query($SQL);
    
67. 
    
68. if (!mysql_fetch_array($RS))
    
69. {
    
70. //¦pªG©|¥¼³ø¦W«h¼g¤J³ø¦WªÌ¸ê®Æ
    
71. $sql = "Insert Into " . $Actname . " (name, Email, company, tel) Values ('";
    
72. $sql = $sql . $Name . "','";
    
73. $sql = $sql . $Email . "','";
    
74. $sql = $sql . $Company . "','";
    
75. $sql = $sql . $Tel . "')";
    
76. mysql_query($sql);
    
77. $msg="§A¤w¸g¶¶§Q§¹¦¨<font color=#FF3300>" . $Actname . "</font>¬ã°Q·|³ø¦W";
    
78. }
    
79. else  //­«½Æ³ø¦W
    
80. {
    
81. $msg="§A¤w¸g³ø¦W¹L<font color=#FF3300>" . $Actname . "</font>¬ã°Q·|";
    
82. }
    
83. 
    
84. mysql_close();
    
85. ?>
    
86. 
    
87. <html>
    
88. <head>
    
89. <meta http-equiv="Content-Type" content="text/html; charset=big5">
    
90. <title>½u¤W³ø¦W</title>
    
91. </head>
    
92. <body>
    
93. <p align="center"><img border="0" src="tit.gif" width="231" height="40"></p>
    
94. <p align="center"><?=$msg;?></p>
    
95. <hr width="80%" color="#FF9900">
    
96. <form method="POST" action="listpeople.php">
    
97. <p align="center">
    
98. <input type="hidden" value="<?=$Actname;?>" name="Actname">
    
99. <input type="submit" value="¬d¬Ý¤w°Ñ¥[¤H­û"
    
100. style="background-color: #008000; color: #FFFFFF; border-style: groove">
     
101. </p></form>
     
102. </body>
     
103. </html>

½Æ»s¥N½X

¤p»x

¬ã°Q·|³ø¦W¤H­û²M³æºô­¶¡Glistpeople.php

1. <?
   
2. //±µ¦¬¬d¸ß¬ã°Q·|¸ê®Æ
   
3.     $Actname=$_REQUEST["Actname"];
   
4. //³sµ²SQL Server
   
5.     $conn = mysql_connect("localhost", "root", "12345a");
   
6. //¿ï¾Ü¸ê®Æ®w
   
7.     mysql_select_db("AutoAct", $conn);
   
8. //«ü©w´£¨ú¸ê®Æªº®Õ¹ï¦r¤¸ªí
   
9.     mysql_query("set character set big5");  
   
10. //«Ø¥ßSQL©R¥O¦r¦ê
    
11.     $SQL="Select * From " . $Actname;
    
12. //±N¦^¶Çµ²ªG¦s©ñ©óÅܼƤ¤
    
13.     $datalist=mysql_query($SQL);
    
14. //¨ú±oÄæ¦ì¼Æ¶q
    
15.     $fieldnum=mysql_num_fields($datalist);
    
16. ?>
    
17. 
    
18. <HTML>
    
19. <head>
    
20. <meta http-equiv="Content-Type" content="text/html; charset=big5">
    
21. <title><?=$Actname;?>¬ã°Q·|³ø¦W¤H­û²M³æ</title>
    
22. </head>
    
23. <BODY>
    
24. <p align="center">
    
25. <img border="0" src="../tit.gif">
    
26. <p Align="Center">
    
27. <font color="#FF9900"><?=$Actname;?>¬ã°Q·|³ø¦W¤H­û²M³æ</font></p>
    
28. <div align="center">
    
29.   <center>
    
30. <TABLE Border=1 Cellspacing=1 bordercolor="#800000">
    
31.      
    
32. <?
    
33. //¦C¥XÄæ¦ì©ïÀY
    
34. echo "<tr>";     
    
35.       for ($x=0 ;$x<$fieldnum;$x++)
    
36.          {
    
37.           echo "<td>" . mysql_field_name($datalist,$x) . "</td>";
    
38.          }
    
39. echo "</tr>";   
    
40. //¦C¥XÄæ¦ì¸ê®Æ
    
41.       //±N¸ê®Æ¿ýÂà´«¬°Äæ¦ì°}¦C¶°¦X
    
42.       while ($fielddatas=mysql_fetch_array($datalist))
    
43.           {
    
44.              //¿é¥XÄæ¦ì¸ê®Æ
    
45.              echo "<tr>";
    
46.              for ($x=0;$x<$fieldnum;$x++)
    
47.                 {
    
48.                  echo "<td>" . $fielddatas[$x] . "</td>";
    
49.                 }
    
50.              echo "</tr>";  
    
51.           }
    
52. ?>
    
53. 
    
54. </TABLE>   
    
55.   </center>
    
56. </div>
    
57. <p align="center"><font size="2">
    
58. <a href="index.php">ªð¦^µn¿ý­¶</a></font></p>
    
59. </html>

½Æ»s¥N½X

shadow0924

§A¦n, ¤p»xª©¥D, ²{¦b§Ú¥Î¤FPHP6¤§«á, addpeople.php
ªº"$testrs=mysql_list_tables("AutoAct"); " ¤§«á§Ú¦b
©x¤èPHP«ü¥Ü§ï¤Fmysql_list_tables()¦p¤U:
$autoact='autoact';
$SQL="SHOW TABLES FROM $autoact";
$testrs=mysql_query($SQL);

¦ý°õ¦æ«á¥X¤F
Warning: mysql_tablename() [function.mysql-tablename]: Unable to jump to row 0 on MySQL result index 4 in C:\AppServ\www\addpeople.php on line 50

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\AppServ\www\addpeople.php on line 66

·Q½Ð±Ð¤p»xª©¥D¤j¤j§Ú¸Ó«ç¼Ë¿ì©O?

shadow0924

¤w¸g¸Ñ¨M¤F, ­ì¨Ó¬O§Ú"¼g¤J³ø¦WªÌ¸ê®Æ"º|¤F¤@¨Ç²Å¸¹, ÁÂÁÂ!