2014年5月¥¢¡¼¥«¥¤¥Ö

ÆÃÄê¤Î¿Í¤À¤±¡¢IE¤«¤é¥Õ¥¡¥¤¥ë¥¢¥Ã¥×¥í¡¼¥É¤¬½ÐÍè¤Ê¤¤¡£

º£²ó¤Î¾ì¹ç¡¢¸¶°ø¤ÏIE¤Çjpeg¥Õ¥¡¥¤¥ë¤Ï¡¢MIME-Type¤¬"image/pjpeg"¤È¤·¤Æ°·¤ï¤ì¤ë¤¿¤á¤À¤Ã¤¿¡£

jpeg¤·¤«¥¢¥Ã¥×¤Ç¤­¤Ê¤¤¤è¤¦¤ËÀ©¸Â¤·¤Æ¤¤¤¿¤È¤³¤í¤òpjpeg¤âÄ̤ë¤è¤¦¤Ë¤·¤¿¡£
($_FILES["photo"]["type"] == "image/jpeg" or $_FILES["photo"]["type"] == "image/pjpeg")

¾®³Ø¹»Äã³Øǯ¤«¤é30ºÐ¤¹¤®¤Þ¤Ç¡¢¡ÖÀ®Ä¹ÄˡפËǺ¤Þ¤µ¤ì¤¿¡£
ÄˤߤÀ¤¹¤È¡¢ÌëÃæ¤ËÌܤ¬³Ð¤á¡¢¤¢¤Þ¤ê¤Î¶ìÄˤËÎÞ¤¬¤Ç¤Æ30ʬ¤«¤é1»þ´Ö¼å·Ð²á¸å¡¢¾Ã¤¨¤ë¡£
Äˤµ¤Ï¹ü¤Î¿Ä¤¬Éå¤Ã¤Æ¤¤¤¯Íͤʴ¶¤¸¡£¤È¤¤¤Ã¤¿¤éµÓ¤¬Éå¤Ã¤¿»ö¤¢¤ó¤Î¤«¤È¸À¤ï¤ì¤¿»ö¤â¤¢¤ë¤±¤ì¤É¡¢¤½¤ì¤Ï¤Ò¤É¤¤ÆßÄˤǤ¹¡£
¾®¤µ¤¤º¢¤Ï°å¼Ô¤Ë²¿ÅÙ¤«¸À¤Ã¤¿»ö¤¬¤¢¤ë¤±¤ì¤É¡¢¥Þ¥Ã¥µ¡¼¥¸¥¯¥ê¡¼¥à¤ÎÍͤʤâ¤Î¤ò¤À¤µ¤ì¤Æ¤ª½ª¤¤¤À¤Ã¤¿¡£¤À¤«¤é¤º¤Ã¤È¥Þ¥Ã¥µ¡¼¥¸¤·¤Æʶ¤é¤ï¤·¤Æ¤¤¤¿¡£

²æ¤¬Ì¼¤¬¡¢Æ±¤¸¾É¾õ¤Ç¶ì¤·¤ó¤Ç¤¤¤ë¡£
£²ºÐº¢¤«¤é½Ð»Ï¤á¤Æ¡¢Æ±¤¸¤¯°å¼Ô¤ËÏ¢¤ì¤Æ¹Ô¤Ã¤¿¤é¡¢À®Ä¹Äˤϱê¾É¤òµ¯¤³¤·¤Æ¤¤¤ë¤«¤éÎä¤ä¤¹¤È¤¤¤¤¤È¸À¤ï¤ì¤Þ¤·¤¿¡£

»ä¤Ïº£¡¢¾®³Ø¹»»þÂå¤ò²á¤´¤·¤¿¹»¶è¤Ë½»¤ó¤Ç¤¤¤Þ¤¹¡£
¤À¤«¤é¡¢Æ±¤¸°å¼Ô¤ËÏ¢¤ì¤Æ¹Ô¤Ã¤¿¤Î¤Ç¤¹¡£
»þÂ夬ÊѤï¤ë¤È¸À¤ï¤ì¤ë»ö¤âÊѤï¤ë¤Î¤«¤È»×¤¤¤Þ¤·¤¿¡£
³Î¤«¤Ë¡¢¼¾ÉÛ¤ÇÎä¤ä¤¹¤È¾¯¤·¥Þ¥·¤Ë¤Ê¤ëÍͤǤ¹¡£µ¤µÙ¤á¤«¤â¤·¤ì¤Þ¤»¤ó¤¬¡£

Îä¤ä¤·¤Æ³Ú¤Ë¤Ê¤ë¤Ê¤é»ä¤âÁ᤯ÃΤꤿ¤«¤Ã¤¿¡£
Âç¿Í¤Ë¤Ê¤ë¤È¡¢À®Ä¹ÄˤÎÉÑÅ٤ϲ¼¤¬¤Ã¤Æ¤¤¤­¤Þ¤·¤¿¤¬¡¢¤½¤ì¤Ç¤âǯ¤Ë¿ô²ó¤ÏÄˤ«¤Ã¤¿¡£
30¤¹¤®¤Æ¤Ê¤ë¤È¤¤¤¦¤³¤È¤Ï¡¢À®Ä¹ÄË¡©
¤Ê¤ó¤«°ã¤¦µ¤¤â¤¹¤ë¤±¤ì¤É¡¢¾É¾õ¤Ï¾®³ØÀ¸¤Îº¢¤«¤é¤º¤Ã¤È°ì½ï¤Ç¤¹¡£

¤½¤¦¤¤¤¦¤ï¤±¤Ç¡¢¼¾ÉÛÌô¤ò¾ïÈ÷¤·¡¢ÌëÃæ¤Ë¤¤¤Ä¤Ç¤â¤µ¤Ã¤ÈŽ¤ì¤ë¤è¤¦¤Ë¾®¤µ¤¤¥µ¥¤¥º¤Ë¥«¥Ã¥È¤·¤Æ¥Ù¥Ã¥È¥µ¥¤¥É¤Ë¥¹¥¿¥ó¥Ð¥¤¤·¤Æ¤¤¤Þ¤¹¡£
ÍÄÃÕ±à¤Îι¹Ô¤Ë¤â»ý¤¿¤»¡¢±ó½Ð¤¹¤ë¤È¤­¤Ïɬ¤º¼¾ÉÛ¤â»ý¤Á¤Þ¤¹¡£

Á°¤Ë¥Í¥Ã¥È¤ÇÄ´¤Ù¤Æ¤¿¤é¡¢¿Æ¤Î°¦¾ð¤¬Â­¤ê¤Ê¤¤¤«¤é½Ð¤ë¤È¤¤¤¦¤Î¤òÆɤߤޤ·¤¿¡£
¤â¤·¤«¤·¤¿¤é¤½¤¦¤Ê¤Î¤«¤â¤·¤ì¤Ê¤¤¡£
»ä¤â¾®¤µ¤¤º¢¤Ï¿Æ¤Ë¤Ù¤¿¤Ù¤¿¤Ò¤Ã¤Ä¤¤¤Æ´Å¤¨¤ë¤È¤¤¤¦µ­²±¤Ï̵¤¤¤·¡¢
»ä¼«¿È¡¢Ì¼¤ËÂФ·¤Æ¤½¤Î¤è¤¦¤ÊÀܤ·Êý¤Ï¤Ç¤­¤Æ¤¤¤Ê¤¤¡£

ºòÌë¤Ï¤¤¤È¤³¤¬Çñ¤Þ¤ê¤ËÍè¤Æ¤¤¤Æ¡¢Ì¼¤Ï¤¤¤È¤³²È²¤È°ì½ï¤ÎÉô²°¤Ç¿²¤Æ¤¤¤¿¡£
¤Þ¤¿À®Ä¹ÄˤǶ줷¤ó¤ÇÂçÊѤÀ¤Ã¤¿¤½¤¦¡£

¤À¤¤¤¿¤¤¡¢£²¡Á£³½µ´Ö¤Þ¤Ã¤¿¤¯¤Ê¤é¤Ê¤¤»þ¤â¤¢¤ë¤·¡¢£³¡¢£´Æü³¤±¤Æ¤Ê¤ë¤È¤­¤â¤¢¤ë¡£

Äˤµ¤òÃΤäƤ¤¤ë¤À¤±¤Ë¡¢¤Ê¤ó¤È¤«¤·¤Æ¤ä¤ê¤¿¤¤¤±¤ì¤É¡¢
¼«Ê¬¤â30ºÐ¤Þ¤Ç¤º¤Ã¤È¤¢¤Ã¤¿¤·¡¢¤É¤¦¤Ë¤â¤Ê¤é¤Ê¤¤¤Î¤«¤â¤·¤ì¤Ê¤¤¡£
¤¿¤À¡¢º£¤Ï¤Þ¤Ã¤¿¤¯µ¯¤³¤é¤Ê¤¤¤Î¤Ç¡¢¤Ê¤Ë¤«Â礭¤Êɵ¤¤Ç¤Ï¤Ê¤¤¤È»×¤¦¡£

Äˤߤ¬È¯À¸¤·¤¿¤é¤À¤¤¤¿¤¤30ʬ¤°¤é¤¤¤Ç¼ý¤Þ¤ë¤Î¤Ç¡¢
¼¾ÉÛ¤ò¤·¤Æ¥Þ¥Ã¥µ¡¼¥¸¤·¤Æ¤¤¤ë¤¦¤Á¤Ë¡¢¿²¤ë¤³¤È¤¬Â¿¤¤¡£


postgreSQL¤«¤émysql¤Ø¤Î°Ü¹Ô¤Çµ¤¤òÉÕ¤±¤¿¤¤ÅÀ

postgresql¤Ç¡¢¤¢¤ë¾®¤µ¤Ê¥·¥¹¥Æ¥à¤ò¹½ÃÛ½àÈ÷¤·¤Æ¤Þ¤·¤¿¡£
¸½¾õ¤¢¤ë¥·¥¹¥Æ¥à¤ò¤½¤Á¤é¤ËºÜ¤»ÊѤ¨¤ë¤È¤¤¤¦»ö¤Ç¡¢
´û¸¤Î¥Ç¡¼¥¿¤ò¤½¤Î¤Þ¤Þ»È¤¤¤¿¤¤¡£

ºÇ½é¤Ë³Îǧ¤·¤Æ¤ª¤±¤Ð¤¹¤ó¤À»ö¤À¤±¤É¡¢postgres¤ÎDB¥¨¥ó¥³¡¼¥É¤¬EUC¤Ç¡¢
Êѹ¹¤Ç¤­¤Ê¤¤»ö¤¬¥Ç¡¼¥¿¤Î°Ü¹Ô¥Æ¥¹¥È¤ÎÃʳ¬¤Ç¤ï¤«¤Ã¤¿¡£
¿·µ¬DBºîÀ®¤âµö²Ä¤µ¤ì¤Æ¤¤¤Ê¤«¤Ã¤¿¡£

¸µ¤Î¥·¥¹¥Æ¥à¤¬UTF8¤Ê¤Î¤Ç¡¢µ¡¼ï°Í¸´ÝÉÕ¤­Ê¸»ú¤¬¤Ð¤ó¤Ð¤ó»È¤ï¤ì¤Æ¤¤¤ë¡£
¤½¤ì¤ò¤½¤Î¤Þ¤Þ»È¤¨¤ë¤è¤¦¤Ë¤·¤¿¤¤¤·¡¢¿·¤·¤¤Æþ¤ìʪ¤ÏUTF8¤Ç¤Ê¤¤¤È¤¤¤±¤Ê¤¤¡£

mysql¤Ê¤é¿·µ¬DB¤âºîÀ®¤Ç¤­¤ë¤·¡¢¤½¤â¤½¤âUTF8¤À¤Ã¤¿¤Î¤Ç¡¢
µÞĤ¯¤ê¤«¤¨¤ë¤³¤È¤Ë¤·¤¿¡£

¤½¤ÎºÝ¡¢¼ï¡¹¤ÎÌäÂ꤬ȯÀ¸¤·¤¿¤Î¤Ç³Ð¤¨½ñ¤­¤ò»Ä¤·¤Æ¤ª¤¯¡£

¢£¥Ç¡¼¥¿·¿
timestump·¿¤Ïdatetime·¿¤Ë¤¹¤ë¡£
¡ÊÊ£¿ô¥«¥é¥à¤¢¤ë¤¿¤á¡Ë

¢£php
´Ø¿ô̾¤ò¡Öpg_¡×¤«¤é¡Ömysql_¡×¤ËÃÖ´¹

mysql_fetch_object¤Ï¹ÔÈÖ¹æ»ØÄê¤Ç¼èÆÀ¤Ç¤­¤Ê¤¤¤Î¤Ç¡¢
mysql_data_seek¤Ç¥Ý¥¤¥ó¥¿°ÌÃÖ¤ò»ØÄꤹ¤ë¡£

¢£Ê¡Ì䤤¹ç¤ï¤»
¥µ¥Ö¥¯¥¨¥ê¤¬¤Þ¤ºÅ¸³«¤µ¤ì¤ë¤Î¤Ç¡¢¥µ¥Ö¥¯¥¨¥ê¤Ë̵ÍѤʷë²Ì¤¬´Þ¤Þ¤ì¤ë¤È
ÁíÅö¤¿¤ê¤È¤Ê¤ê¡¢ËÄÂç¤Ë¤Ê¤ë¡£¡ÊÈ¿±þÃÙ¤¤¡Ë
¥µ¥Ö¥¯¥¨¥ê¤ÎSELECTʸ¤Ï¤Ç¤­¤ë¤À¤±¾ò·ï¤òÆþ¤ì¤¿Êý¤¬Îɤ¤¡£

UPDATE a_table,(SELECT * FROM b_table)o_table SET a_table.name=o_table.oldname where a_table.code=o_table.code and o_table.num=1;
¢­
UPDATE a_table,(SELECT * FROM b_table where num=1)o_table SET a_table.name=o_table.oldname where a_table.code=o_table.code;

¢£mysql¤Ç¤ÏÀµµ¬É½¸½¤Ë¤è¤ëÃÖ´¹¤¬½ÐÍè¤Ê¤¤
¤³¤ì¤ÏÌÌÅݤÀ¤Ã¤¿¤·¡¢º£²ó¤Ïpostgres¤Ë»ý¤Ã¤Æ¤Ã¤Æ½èÍý¤·¤¿¡£
¤¢¤ëÆÃÄê¤Îʸ»ú¤Ë¶´¤Þ¤ì¤¿¿ôÃͥǡ¼¥¿¤ò¤È¤ê¤À¤·¤¿¤«¤Ã¤¿¤À¤±¤Ê¤Î¤Ç¡¢
¤½¤ì¤Ç¤¤¤±¤¿¤±¤ì¤É¡¢Ê¸»ú¥³¡¼¥É¤Ë±Æ¶Á¤µ¤ì¤ëÍͤÊʸ»úÎó¤À¤Ã¤¿¤é¤½¤ì¤Ï¤Ç¤­¤Ê¤¤¤·¡¢
¥¹¥Æ¥Ã¥×Ƨ¤à¤·¤«¤Ê¤¤¤«¤Ê¡£
php¤ÇREGEXP¤ÈREPLACE¤ò»È¤Ã¤ÆÃÖ´¹¤¹¤ëÊýË¡¤ò¤È¤ë¤È¤«¡£

°Ê¾å¡¢»ä¤Î¥á¥â½ñ¤­¡£
ÁǿͤʤΤÇɽ¸½¤äÊýË¡¤¬´Ö°ã¤Ã¤Æ¤ë¤«¤â¤·¤ì¤Þ¤»¤ó¡£


ÀΤϴÝÉÕ¤­Ê¸»ú¤Ê¤ó¤«¡¢ÍøÍѼԤÎÊý¤ËÀ©¸Â¤µ¤»¤Æ¡¢
ʸ»ú²½¤±¤·¤¿¤éÍøÍѼԤΤ»¤¤¤Ë¤¹¤ë¤È¤«ÉáÄ̤À¤Ã¤¿¤±¤É¡¢
º£¤Ï´ÝÉÕ¤­Ê¸»ú¤âµ¡¼ï°Í¸ʸ»ú¤â»È¤¦¤â¤ó¤Í¡£
»ä¤Ïº£¤â»È¤ï¤Ê¤¤¤±¤É¡£

¤³¤ì¤Þ¤Ç¡¢°ú¤Ã±Û¤·¤ÎºÝ¤Ëɬ¤º¿»Æ©ÌäÂꤦ¤ó¤Ì¤ó¤È¸À¤ï¤ì¤Æ¤¤¤¿¤±¤ì¤É¡¢
ɬ¤º¤·¤â¤½¤¦¤È¤Ï¸Â¤é¤Ê¤¤¡£
;͵¤¬¤¢¤ì¤Ð²óÈò¤Ç¤­¤ë¡£

1¡Ë¥Í¡¼¥à¥µ¡¼¥Ð¡¼¤¬Ê̤ξì¹ç

µì¥µ¡¼¥Ð¤Ë¤Æ¥É¥á¥¤¥ó´ÉÍý¡õ¥Í¡¼¥à¥µ¡¼¥Ð¤ò¥ì¥ó¥¿¥ë¤·¤Æ¤¤¤ë¡£
¢­
¥É¥á¥¤¥ó¤ò¿·¥µ¡¼¥Ð¤È¤ÏÀÚ¤êÎ¥¤·¤¿¥µ¡¼¥Ó¥¹¤Ë°Ü´É¡õ¥Í¡¼¥à¥µ¡¼¥Ð¥ì¥ó¥¿¥ë¡¢
µì¥µ¡¼¥Ð¸þ¤±¥¾¡¼¥ó¾ðÊó¤òÀßÄꤷ¡¢¿·¥Í¡¼¥à¥µ¡¼¥Ð¤ËÀÚ¤êÂؤ¨¤ë¡£
¢­
Ê¿¹Ô¤·¤Æ¿·¥µ¡¼¥Ð¤Ç¤Î¥³¥ó¥Æ¥ó¥Ä¤ä¥¢¥«¥¦¥ó¥È¤ÎÀßÄê¤ò½àÈ÷¤·¤Æ¤ª¤¯
¢­
¿·¤·¤¤¥Í¡¼¥à¥µ¡¼¥Ð¤Ë´°Á´¤ËÀÚ¤êÂؤï¤Ã¤¿¸å¡¢
ÅÔ¹ç¤ÎÎɤ¤Æü¤òÀßÄꤷ¡¢¥¾¡¼¥ó¾ðÊó¤ò¿·¥µ¡¼¥Ð¸þ¤±¤ËÀßÄê¡£

TTL¤òû¤á¤ËÀßÄꤷ¤Æ¤¤¤ì¤Ð¡¢¤¹¤°¤ËÀÚ¤êÂؤï¤ë¡£

TTL¤¬Ã»¤¹¤®¤ë¤È¥ê¥¹¥¯¤¬¤¢¤ëÍͤʤΤǡ¢
ÀÚ¤êÂؤï¤Ã¤¿¸å¡¢ÀßÄꤷľ¤¹Êý¤¬Îɤ¤¤Î¤«¤â¤·¤ì¤Ê¤¤¡£

¥Í¡¼¥à¥µ¡¼¥Ð¤¬ÊÌ¥µ¡¼¥Ó¥¹¤Ç¤¢¤ë¤«¡¢¿·¥µ¡¼¥Ð¤Î¥¾¡¼¥óÀßÄê¤Î¼«Í³ÅÙ¤¬¹â¤¯¤Ê¤¤¤È¤Ç¤­¤Ê¤¤¡£

¥Í¡¼¥à¥µ¡¼¥Ð¤ÏÊ̤ËÍÑ°Õ¤·¤Æ¤ª¤¤¤Æ¤Ê¤ë¤Ù¤¯Êѹ¹¤·¤Ê¤¤¤È¤¤¤¦¤Î¤¬ÍýÁÛ¤«¤â¤·¤ì¤Ê¤¤¡£
web¥µ¡¼¥Ð¤ä¥á¡¼¥ë¥µ¡¼¥Ð¤Î°ú¤Ã±Û¤·¤ÎºÝ¡¢
¥Í¡¼¥à¥µ¡¼¥Ð¤ÎÊѹ¹¤¬Ìµ¤±¤ì¤Ð¡¢¥¾¡¼¥ó¾ðÊó¤Î½ñ¤­´¹¤¨¤À¤±¤ÇºÑ¤ß¡¢Áᤱ¤ì¤Ð¿ôʬ¤ÇÀÚ¤êÂؤï¤ë¡£

TTL¤ÎÀßÄê¤Ï¡¢¥µ¡¼¥Ó¥¹²ñ¼Ò¤Ë¤è¤Ã¤ÆÂбþ¤¬ÊѤï¤Ã¤Æ¤¯¤ë¡£
¼«Í³¤ËÀßÄê¤Ç¤­¤ë¼êÃʤ¬Ìµ¤±¤ì¤Ð¡¢¿½ÀÁ¤·¤Æ£²¡Á3±Ä¶ÈÆü¤È¤«¡¢²¿Ëü±ß¤È¤«¸À¤ï¤ì¤ë¾ì¹ç¤â¤¢¤ë¡£

¥É¥á¥¤¥ó¤Î´ÉÍý¤Ï¥Û¥¹¥Æ¥£¥ó¥°²ñ¼Ò¤ÎÉÕ°¥µ¡¼¥Ó¥¹¤òÍøÍѤ¹¤ë¤Î¤Ç¤Ï¤Ê¤¯¡¢
ÆÈΩ¤·¤Æ¤¤¤¿Êý¤¬Îɤ¤¤È¡¢¤Ä¤¯¤Å¤¯»×¤¤¤Þ¤·¤¿¡£

¥«¥Æ¥´¥ê

¥¦¥§¥Ö¥Ú¡¼¥¸

Powered by Movable Type 4.13

¤³¤Î¥¢¡¼¥«¥¤¥Ö¤Ë¤Ä¤¤¤Æ

¤³¤Î¥Ú¡¼¥¸¤Ë¤Ï¡¢2014年5月¤Ë½ñ¤«¤ì¤¿¥Ö¥í¥°µ­»ö¤¬¿·¤·¤¤½ç¤Ë¸ø³«¤µ¤ì¤Æ¤¤¤Þ¤¹¡£

Á°¤Î¥¢¡¼¥«¥¤¥Ö¤Ï2014年4月¤Ç¤¹¡£

¼¡¤Î¥¢¡¼¥«¥¤¥Ö¤Ï2014年6月¤Ç¤¹¡£

ºÇ¶á¤Î¥³¥ó¥Æ¥ó¥Ä¤Ï¥¤¥ó¥Ç¥Ã¥¯¥¹¥Ú¡¼¥¸¤Ç¸«¤é¤ì¤Þ¤¹¡£²áµî¤Ë½ñ¤«¤ì¤¿¤â¤Î¤Ï¥¢¡¼¥«¥¤¥Ö¤Î¥Ú¡¼¥¸¤Ç¸«¤é¤ì¤Þ¤¹¡£