|
Ads by Google
|
|
- --/--/--(--) -
|
|
¿·¤·¤¤µ»ö¤ò½ñ¤¯»ö¤Ç¹¹ð¤¬¾Ã¤»¤Þ¤¹¡£ |
|
aaa ¥¢¥Ë¥á®Ê󡪡Ýaaakimonojetgirl
| ||||||||||
|
- 2007/08/06(Mon) -
| ||||||||||
|
º£Æü¸«¤Ä¤±¤¿youtubeư²è ¼¡¤Ï¤É¤ó¤Ê£Ù£Ï£Õ£Ô£Õ£Â£Å¤ò¾Ò²ð¤·¤è¤¦¤«¤Ê¡Ä
º£Æü¤Îµ¤¤Ë¤Ê¤ë¥¡¼¥ï¡¼¥É F1 ¤¬¤ó ±¢ÍÛ»Õ AAA ¥µ¥ó¥±¥¤¥¹¥Ý¡¼¥Ä Ìîµå¥²¡¼¥à ¥±¥í¥í·³Áâ ¤ª¤â¤·¤í¥à¡¼¥Ó¡¼ ¾®Àô ºåµÞ ¤Á¤ç¤Ã¤È> aaa¤Î¥¢¥Ë¥á¤ò¤·¤é¤Ù¤Æ¤ß¤Þ¤·¤¿ ¡¦PHP5¤ÎPEAR:AUTH¤Ë´Ø¤¹¤ë¼ÁÌä¤Ç¤¹ °Ê²¼¤Ïauth.php¤È¤¤.. PHP5¤ÎPEAR:AUTH¤Ë´Ø¤¹¤ë¼ÁÌä¤Ç¤¹°Ê²¼¤Ïauth.php¤È¤¤¤¦¥Õ¥¡¥¤¥ë¤Ç¤¹<?php function loginFunction($username, $status){¥æ¡¼¥¶¡¼ÄêµÁ¤Î¥í¥°¥¤¥ó¥Õ¥©¡¼¥à¡£»ú¿ô¤Î´Ø·¸¤Ç¥³¥áÍó¤Ë¡Ê¼ÁÌä¤È¤Ï´Ø·¸Ìµ¤¤¤È»×¤¤¤Þ¤¹¡Ë}$params = array("dsn" => "mysqli://aaa:aaa@localhost/test", "table" => "authtable", "usernamecol" => "username", "passwordcol" => "password");$authobj = new Auth("DB", $params, "loginFunction");$authobj->start();if ($authobj->getAuth()){echo '¥í¥°¥¤¥óºÑ¤ß';}else{echo '̤¥í¥°¥¤¥ó';}?>¤³¤ì¤òhtaccess¤«¤érequire¤¹¤ë¤ÈÀµ¾ï¤Ëºîư¤·¤Þ¤¹¡£¤½¤Î¾ì¹ç¤Ï¥í¥°¥¤¥ó¥Õ¥©¡¼¥à¤¬¥µ¥¤¥È¥³¥ó¥Æ¥ó¥Ä¤è¤ê¾å¤ËÍè¤ë¤Î¤Ç¼ÂºÝ¤Ï¥µ¥¤¥È¤Î¥³¥ó¥Æ¥ó¥ÄÆâ¡Ê¥µ¥¤¥É¥Ð¡¼¤Ê¤É¡Ë¤Ëɽ¼¨¤µ¤»¤¿¤¤¤Ç¤¹¡£¤½¤³¤Ç¥³¥ó¥Æ¥ó¥ÄÆâ¤Çrequire¤¹¤ë¤È¡ÖWarning: Cannot modify header information - headers already sent by¡× ¥¨¥é¡¼¤¬¤Ç¤Þ¤¹¡£Header½ÐÎϤÎÁ°¤Ë½ÐÎϤ¬¤¢¤ë¤«¤é¤Ç¤¹¡£¤³¤Î¾ì¹ç¤É¤¦¤¹¤ì¤Ð¤¤¤¤¤Ç¤·¤ç¤¦¤«¡£»ú¿ô¤Î´Ø·¸¤Ç¥³¥áÍó¤ËÄɵ¤·¤Þ¤¹¡£¤ß¤Ê¤µ¤ó¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£ ¡¦¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë¤¿¤á¤Î¥Ð¥Ã¥Á¥Õ¥¡¥¤¥ë¤ÎÃæ¿È¤Ï¡© .. ¥Õ¥¡¥¤¥ë¤òºï½ü¤¹¤ë¤¿¤á¤Î¥Ð¥Ã¥Á¥Õ¥¡¥¤¥ë¤ÎÃæ¿È¤Ï¡©°Ê²¼¤ò¤·¤¿¤¤¤È»×¤Ã¤Æ¤¤¤Þ¤¹¡£C:\AÆâ¤Î¥Õ¥¡¥¤¥ë¤ò¤¹¤Ù¤Æºï½üC:\AAA\B¥Õ¥©¥ë¥ÀÆâ¤Î°ìÉô¤Î¥Õ¥¡¥¤¥ë°Ê³°¤òºï½ü¡£ºï½üÂоݥե¡¥¤¥ë¤ÏÀèÆ¬¤Ëaaa¤¬ÉÕ¤¯¤È¤¹¤ë¡£¥Ð¥Ã¥Á¥Õ¥¡¥¤¥ë¤òµ¯Æ°¤·¤¿¤é¡¢³Îǧ¤Ï¤À¤µ¤Ê¤¤¤Î¤ò´üÂÔ¤·¤Þ¤¹¡£ ¡¦php¤Ç¡¢ÆÃÄê¤Î£Õ£Ò£Ì¤òÊÑ¿ô¤È¤·¤Æ¼õ¤±¼è¤ë¤È¡¢ ¤½¤Î£Õ.. php¤Ç¡¢ÆÃÄê¤Î£Õ£Ò£Ì¤òÊÑ¿ô¤È¤·¤Æ¼õ¤±¼è¤ë¤È¡¢¤½¤Î£Õ£Ò£Ì¤ÎºÇ¿¼¥Ç¥£¥ì¥¯¥È¥ê¤ò¼èÆÀ¤·¤¿¤¤¤Ç¤¹¡£Î㤨¤Ð¡¢http://www.hatena.ne.jp/aaa/bbb/ccc.htmlhttp://www.hatena.ne.jp/aaa/bbb/http://www.hatena.ne.jp/aaa/bbb/ccc.php¤Î£³¤Ä¤Î£Õ£Ò£Ì¤Î¥±¡¼¥¹¤Ç¤Ï¡¢http://www.hatena.ne.jp/aaa/bbb/¤ò¼èÆÀ¤·¤¿¤¤¤Ç¤¹¡£http://www.hatena.ne.jp/¤Î¾ì¹ç¤Ï¡¢http://www.hatena.ne.jp/¤ò¼èÆÀ¤·¤¿¤¤¤Ç¤¹¡£¼Â¸½¤Î»²¹Í¤Ë¤Ê¤ë¥µ¥¤¥È¤ä¡¢¥³¡¼¥É¤¬¤¢¤ê¤Þ¤·¤¿¤é¡¢¤ª´ê¤¤¤·¤Þ¤¹¡£ ¡¦¡ÚµÞ¤®¡ÛPHP¤Ç³°Éô¤ÎPHP¤òGETÁ÷¿®¤¹¤ëÊýË¡¤Ï¡© PHP¤Î.. ¡ÚµÞ¤®¡ÛPHP¤Ç³°Éô¤ÎPHP¤òGETÁ÷¿®¤¹¤ëÊýË¡¤Ï¡©PHP¤Î¥×¥í¥°¥é¥à¡Êwww.aaa.com/aaa.php¡Ë¤ÎÅÓÃæ¤Ç¡¢Ê̥ɥᥤ¥ó¤ÎPHP(www.bbb.com/bbb.php?s=100)¤òGET¤Ç¸Æ¤Ó¤¿¤¤¡Ê¸Æ¤Ö¤À¤±¡Ë¤·¤¿¤¤¤È»×¤¤¤Þ¤¹¡£·ë²Ì¤ò¼õ¤±¼è¤Ã¤¿¤ê¡¢Á«°Ü¤¹¤ëɬÍפϤʤ¯¡¢¸Æ¤Ö¤À¤±¤ò¤·¤¿¤¤¤Î¤Ç¤¹¡£¤É¤¦¤¹¤ì¤Ð¤¤¤¤¤Î¤Ç¤·¤ç¤¦¤«¡© ¡¦MySQL¤Îjoin¤Ç·ë¹ç¤·¤¿¥Æ¡¼¥Ö¥ë¤ò½¸·×¤·¤¿¤¤¤Î¤Ç¤¹¤¬.. MySQL¤Îjoin¤Ç·ë¹ç¤·¤¿¥Æ¡¼¥Ö¥ë¤ò½¸·×¤·¤¿¤¤¤Î¤Ç¤¹¤¬¡¢¾å¼ê¤¯¤Ç¤¤Þ¤»¤ó¡£// category¤Î¥Æ¡¼¥Ö¥ëÆâ+-----+-----+-----+|c_id | name|sort |+-----+------+----+|1¡¡¡¡|¥Æ¥¹¥È| 001 |+-----+------+------+// user¤Î¥Æ¡¼¥Ö¥ëÆâ+------+-------+------+| u_id | u_name| c_id |+------+-------+------+| 1 | aaa | 1 || 1 | bbb | 1 |+------+-------+------+// »î¤·¤¿SQLʸselect user.c_id,count(*) as cnt from category JOIN user on category.id=user.c_id ORDER BY sort GROUP BY user.c_id´õ˾¤¹¤ë·ë²Ì¤Ï¥Æ¥¹¥È(2)¤É¤Î¤è¤¦¤ÊSQL¤ò½ñ¤±¤Ð¤¤¤¤¤Î¤«¡¢¥¢¥É¥Ð¥¤¥¹¤¤¤¿¤À¤±¤ì¤Ð¤È»×¤¤¤Þ¤¹¡£ |
||||||||||
|
¥³¥á¥ó¥È |
|
¥³¥á¥ó¥È¤ÎÅê¹Æ |
¥È¥é¥Ã¥¯¥Ð¥Ã¥¯ |
|
¥È¥é¥Ã¥¯¥Ð¥Ã¥¯URL
¢ªhttp://newsnewsyoutube.blog101.fc2.com/tb.php/1260-f8534c4e |
|
| ¥á¥¤¥ó |
|






