NAME

login.cgi - ¥æ¡¼¥¶¡¼Ì¾¡¢¥Ñ¥¹¥ï¡¼¥É¤òweb¤Ç¼õ¤±ÉÕ¤±¤ë

³µÍ×

web²èÌ̤ˤƥ桼¥¶¡¼Ì¾¡¢¥Ñ¥¹¥ï¡¼¥É¤òÆþÎϤ·ÆþÎÏÃÍ¤Ë¤Æ ¥æ¡¼¥¶¡¼¥Æ¡¼¥Ö¥ë(user_tbl)¤ò¥Á¥§¥Ã¥¯¤·Â¸ºß¤·¤¿»þ¤Ë¤Ï¡¢ ¥»¥Ã¥·¥ç¥ó£É£Ä¤òºîÀ®¤·¥»¥Ã¥·¥ç¥ó¥Æ¡¼¥Ö¥ë(session)¤Ë ÅÐÏ¿¤·¥á¥Ë¥å¡¼²èÌÌ(menu.cgi)¤ò¥í¡¼¥É¤¹¤ë¡£

²èÌÌ

¥Ö¥é¥¦¥¶¤Î¼ïÎà¤òȽÃǤ·html¤«hdml¤òɽ¼¨¤¹¤ë¡£

html²èÌÌ

 +------------------------------------------------+
 |¤è¤¦¤³¤½¥·¥¹¥Æ¥à¤Ø                              |
 |                                                |
 |            ÍøÍѼԡ§[____________]              |
 |                                                |
 |      ¡¡¥Ñ¥¹¥ï¡¼¥É¡§[____________]              |
 |                                                |
 |¡¡¡¡¡¡¡¡¡¡[¥í¥°¥¤¥ó][¡¡½ªÎ»¡¡]                  |
 |                                                |
 +------------------------------------------------+

¥Ñ¥é¥á¡¼¥¿

login.cgi¤Î¥Ñ¥é¥á¡¼¥¿

userid

¥æ¡¼¥¶¡¼£É£ÄÆþÎÏÃͤǥ桼¥¶¡¼¥Æ¡¼¥Ö¥ë(user_tbl)¤Î¥æ¡¼¥¶¡¼£É£Ä(userid)¤È ¥Á¥§¥Ã¥¯¤ò¹Ô¤Ê¤¦¡£

passwd

¥æ¡¼¥¶¡¼¥Ñ¥¹¥ï¡¼¥ÉÆþÎÏÃͤǥ桼¥¶¡¼¥Æ¡¼¥Ö¥ë(user_tbl)¤Î¥Ñ¥¹¥ï¡¼¥É(password)¤È ¥Á¥§¥Ã¥¯¤ò¹Ô¤Ê¤¦¡£

action

action=½ªÎ»¤Ë¤ÆHomePage¤ò¥í¡¼¥É¤¹¤ë¡£

  Location: close.cgi

½èÍýÀâÌÀ

login

¥í¥°¥¤¥ó¤Î¥Á¥§¥Ã¥¯¤ò¹Ô¤Ê¤¦¡£

1 ÆþÎϥ桼¥¶¡¼Ì¾¡¢¥Ñ¥¹¥ï¡¼¥É¤Ç ¥æ¡¼¥¶¡¼¥Ç¡¼¥Ö¥ë¤ò»²¾È £È£É£Ô·ï¿ô¤¬£±·ï°Ê³°¤Ê¤é£Î£Ç¤ÇºÆÆþÎÏ

select count(*) from user_tbl where userid = ? and password = ?

2 ¥»¥Ã¥·¥ç¥ó£É£Ä¤òºîÀ®¤·¥»¥Ã¥·¥ç¥ó¥Æ¡¼¥Ö¥ë¤Ë ÅÐÏ¿¤·¥á¥Ë¥å¡¼²èÌ̤ò¥í¡¼¥É¤¹¤ë

$dbh->random_str¤Ë¤ÆÍð¿ô¤òºîÀ®¤·¥»¥Ã¥·¥ç¥ó¥Æ¡¼¥Ö¥ë(seeeion)¤Ë ¥»¥Ã¥·¥ç¥ó£É£Ä¡¢¥æ¡¼¥¶¡¼Ì¾¡¢¸½ºß»þ´Ö¤òÅÐÏ¿¤¹¤ë¡£

insert into session (sessionid,userid,upd_time) values (?,?,now())

form_display

final

½ªÎ»½èÍý

1 ¥Ç¡¼¥¿¡¼¥Ù¡¼¥¹¤ò¥¯¥í¡¼¥º¤¹¤ë

AUTHOR INFORMATION

 ;######################################################################
 ;#
 ;# login.cgi: Web Login CGI 
 ;#
 ;# Copyright (c) 2003 Masashi Hori <hori@japannet.co.jp>
 ;# JapanNet. All Rights Reserved.
 ;#
 ;#
 ;# ¥»¥Ã¥·¥ç¥ó¥Æ¡¼¥Ö¥ë(session)¤Ïcron ¤ÇŬÅö¤Ê»þ´Ö¤´¤È¤Ë
 ;# delete from session where upd_time < now() - timespan('2 hours');
 ;# ¤¯¤é¤¤¤Çºï½ü¤¹¤ë»ö
 ;######################################################################

SEE ALSO

<webdb.pm>

POD ERRORS

Hey! The above document had some coding errors, which are explained below:

Around line 8:

Non-ASCII character seen before =encoding in '¥æ¡¼¥¶¡¼Ì¾¡¢¥Ñ¥¹¥ï¡¼¥É¤òweb¤Ç¼õ¤±ÉÕ¤±¤ë'. Assuming CP1252

Around line 39:

'=item' outside of any '=over'

Around line 90:

You forgot a '=back' before '=head1'

Around line 104:

'=item' outside of any '=over'

Around line 216:

'=item' outside of any '=over'

Around line 225:

You forgot a '=back' before '=head1'