- Äɲ䵤줿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
- ºï½ü¤µ¤ì¤¿¹Ô¤Ï¤³¤Î¿§¤Ç¤¹¡£
2006-09-20¡Á
½ñÀÒ¤ÎWeb¥Ú¡¼¥¸~
http://www.gihyo.co.jp/books/syoseki.php/4-7741-1730-7
*chap3 [#vaa628b2]
http://localhost:50000/sample/WebDB-sample/chap3/sample1/index.html
**sample1 [#h1ef6370]
formÆþÎÏ¥Ú¡¼¥¸¢ª³Îǧ¥Ú¡¼¥¸¢ªÅÐÏ¿´°Î»¥Ú¡¼¥¸ ¤Î´ðËÜ~
ÆþÎÏÃͤΥÁ¥§¥Ã¥¯¤Ï̵¤·
+index.html ... formÆþÎÏ¥Ú¡¼¥¸
+confirm.php ... ³Îǧ¥Ú¡¼¥¸
++hidden¤òÍѤ¤¤¿ÆþÎÏÃͤμõ¤±ÅϤ·ÊýË¡
+regist.php ... ÅÐÏ¿´°Î»¥Ú¡¼¥¸
++MySQL¥¢¥¯¥»¥¹ÊýË¡
**sample2 [#n0ea3b22]
http://localhost:50000/sample/WebDB-sample/chap3/sample2/index.html
+index.html ... formÆþÎÏ¥Ú¡¼¥¸
+confirm.php ... ³Îǧ¥Ú¡¼¥¸
¼¡¤Î£²¥Õ¥¡¥¤¥ë¤òrequire¤·¤Æ¤¤¤Þ¤¹¡£
+function.php ... gpc_stripslashes, gpc_addslashes, secho¤ÎÄêµÁ
+check_values.php ... ³ÆpostÃͤò¥Á¥§¥Ã¥¯¤·¡¢¥¨¥é¡¼¤ÎÏ¢ÁÛÇÛÎó($error['fname']Åù)¤òºîÀ®¤¹¤ë½èÍý
Shift JIS¤ÇPHP¥³¡¼¥É¤ò½ñ¤¯¾ì¹ç¡¢
¡Ömb_regex_encoding("Shift_JIS"); ¡×¤È½ñ¤¤¤Æ¤ª¤«¤Ê¤¤¤È¡¢¡Ömb_ereg("^[¥¡-¥ö¡¼]+$", $fname)¡×¤È¤¤¤Ã¤¿Ê¸¤Ç¡¢
¡Ömbregex compile err: empty char-class¡×¤È¤¤¤Ã¤¿·Ù¹ð¤¬½Ð¤ë¾ì¹ç¤¬Í¤ë¡£
¡Ê¡Ö¡¼¡×¤ÎShift JIS¥³¡¼¥É¤Ï¡¢0x815B¤Ç¡¢¡Ö5B¡×¤¬¡Ö[¡×¤Î¤¿¤á·Ù¹ð¤¬½Ð¤ë¡Ë
+regist.php ... ÅÐÏ¿´°Î»¥Ú¡¼¥¸
++ºÆ¥Á¥§¥Ã¥¯¤Î¤¿¤á¡¢¾å¤Î£²¥Õ¥¡¥¤¥ë¤òrequire¤·¤Æ¤¤¤Þ¤¹¡£
++''¥Æ¥¥¹¥È¥Õ¥¡¥¤¥ë¤ò¥Æ¥ó¥×¥ì¡¼¥È''¤È¤·¤¿''¥á¡¼¥ëÁ÷¿®¥µ¥ó¥×¥ë''¤Ç¤¹¡£
+mail.txt ... regist.php¤«¤é»ÈÍѤµ¤ì¤ë¡¢ÅÐÏ¿´°Î»¥á¡¼¥ë¥Æ¥ó¥×¥ì¡¼¥È
+downlist.php ... ¥À¥¦¥ó¥í¡¼¥É²èÌÌ
++MySQL¤ÇÁí·ï¿ô¤òÄ´¤Ù¤Æ¡¢É½¼¨¤·¤Æ¤¤¤Þ¤¹¡£
++<a href="download.php?...">1-100<a>¤È¤¤¤Ã¤¿¡¢¤É¤ÎÈϰϤò¥À¥¦¥ó¥í¡¼¥É¤¹¤ë¤«¤òɽ¤¹¥ê¥ó¥¯¤Îµ½ÒÊýË¡¤¬Ê¬¤«¤ê¤Þ¤¹¡£
+download.php ... tabʬ³ä¥Ç¡¼¥¿¤Î¥À¥¦¥ó¥í¡¼¥É¥×¥í¥°¥é¥à
++¥Ö¥é¥¦¥¶¤Çtab¥Ç¡¼¥¿¤Î¥À¥¦¥ó¥í¡¼¥É¥À¥¤¥¢¥í¥°¤ò½Ð¤¹ÊýË¡¤¬Ê¬¤«¤ê¤Þ¤¹¡£
++MySQL¤Ç»ØÄêÈϰϤΥǡ¼¥¿¤ò¼èÆÀ¤¹¤ëÊýË¡¤¬Ê¬¤«¤ê¤Þ¤¹¡£
++
++
**sample3 [#y7857610]
http://localhost:50000/sample/WebDB-sample/chap3/sample3/index.html
*chap4 [#a3aadf37]
**sample1 [#kcb9fb31]
**sample2 [#w44b6970]
chap4.sql.txt
*chap5 [#g2bfce67]
**sample1 [#j4127bb1]
**sample2 [#uece8273]
**sample3 [#g3eeee64]
**sample4 [#yeb14265]
*ÊÙ¶¯¤·¤¿¤³¤È [#p09097c3]
+<input ... /><br />¤Î¤è¤¦¤Ë¡¢ÊĤ¸¤Ê¤¤¥¿¥°¤ÎºÇ¸å¤Ï¡¢É¬¤º¥¹¥é¥Ã¥·¥å¤òÆþ¤ì¤ë¡£
+PHP¤Ç¤Ïʸ»úÎó¤ÎÀÚ¤ìÌܤ¬Ê¬¤«¤ê¤Ë¤¯¤¤¤Î¤Ç¡¢Ê¸»úÎó¤òÏ¢·ë¤¹¤ë¥É¥Ã¥È¤ÎÁ°¸å¤Ï¡¢¥¹¥Ú¡¼¥¹¤òÆþ¤ì¤¿¤Û¤¦¤¬¸«¤ä¤¹¤½¤¦¡£