[B! mysql][php] Kiskeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

Kiske id:Kiske

mysqlã¨phpã«é–¢ã™ã‚‹Kiskeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (9)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

MySQL ã‚’ PDO ã§ä½¿ã†ã¨ãã¯ ATTR_EMULATE_PREPARES ã‚’è¨å®šã—ã‚ˆã† : DSASé–‹ç™ºè€…ã®éƒ¨å±‹
ã€ŒDSAS for Social ã‚’æ”¯ãˆã‚‹æŠ€è¡“ã€ ã¨ã„ã†ãƒã‚¿ã§advent calendar ã«æŒ‘æˆ¦ã—ã¾ã™ã€‚ methane ã§ã™ã€‚ PDOã§ MySQL ã‚’ä½¿ã†ã¨ãã¯ã€ã¿ãªã•ã‚“ $stmt = $con->prepare("..."); ã—ã¦ $stmt->execute($values); ã¨ã‹ã—ã¦ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹ã¨æ€ã„ã¾ã™ã€‚ å®Ÿã¯ã€ã“ã®ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹çš„ã«ã¯ã‚ã¾ã‚Šè‰¯ãã‚ã‚Šã¾ã›ã‚“ã€‚1ã¤ã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã«ã€ãƒ—ãƒ¬ãƒ¼ã‚¹ãƒ›ãƒ«ãƒ€ä»˜ãã®ã‚¯ã‚¨ãƒªã‚’æŠ•ã’ãŸå¾Œã«ã€ãã‚Œã«å€¤ã‚’ãƒã‚¤ãƒ³ãƒ‰ã—ã¦å®Ÿè¡Œã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ã‚’æŠ•ã’ã‚‹ã®ã§ã€1å›žã®ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ã®ã«2å¾€å¾©ã®é€šä¿¡ãŒå¿…è¦ã«ãªã‚‹ã®ã§ã™ã€‚ ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã«ã¯ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã®åˆ©ç‚¹ï¼ˆåŒã˜ã‚¯ã‚¨ãƒªã‚’ä½•åº¦ã‚‚ç™ºè¡Œã™ã‚‹ã¨ãã«DBã‚µãƒ¼ãƒãƒ¼ãŒã‚¯ã‚¨ãƒªã®è§£æžã‚’ç¹°ã‚Šè¿”ã•ãªã„ã§ã‚‚ã™ã‚€ï¼‰ã¨ã„ã†ã‚‚ã®ã¨ã€SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«ãªã‚‹ï¼ˆæ£
Kiske 2011/12/02
mysql

php
ãƒªãƒ³ã‚¯
HandlerSocket Plugin for MySQLã®PHPã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’å…¬é–‹ã—ã¾ã—ãŸ
takada-atã§ã™ã€‚HandlerSocketPlugin for MySQLã®PHPã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã‚’å…¬é–‹ã—ã¾ã—ãŸã€‚ ãƒªãƒã‚¸ãƒˆãƒªã«ã¯ã€OpenPearã§ã‚¢ã‚¯ã‚»ã‚¹ã§ãã¾ã™ã€‚ http://openpear.org/package/Net_HandlerSocket pure PHPã§æ›¸ã„ã¦ã¾ã™ãŒã€ä½¿ã„æ–¹ã¯ã€ä»Šã®ã¨ã“ã‚perlã‚¯ãƒ©ã‚¤ã‚¢ãƒ³ãƒˆã«åˆã‚ã›ã¦ã‚ã‚Šã¾ã™ã€‚ HandlerSocketPlugin for MySQLã¯MySQLã‚’é«˜é€ŸãªNoSQLã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã¨ã—ã¦åˆ©ç”¨ã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹MySQLãƒ—ãƒ©ã‚°ã‚¤ãƒ³ã§ã™ã€‚è©³ã—ãã¯githubã®ãƒªãƒã‚¸ãƒˆãƒªãªã©ã‚’å‚ç…§ã—ã¦ã¿ã¦ãã ã•ã„ã€‚ http://github.com/ahiguti/HandlerSocket-Plugin-for-MySQL
Kiske 2010/10/30
mysql

php
ãƒªãƒ³ã‚¯
symfony:sfmysqlsessionstorage [type33 wiki]
Kiske 2008/03/11
sfMysqlSessionStorageã®ã‚µãƒ³ãƒ—ãƒ«

php

symfony

mysql
ãƒªãƒ³ã‚¯
Knowledge Databaseï½œãƒŠãƒ¬ãƒƒã‚¸ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹.
This domain may be for sale!
Kiske 2007/12/19
symfonyã®æƒ…å ±ãŒå¤šã„ã€‚ä½¿ã£ã¦ã‚‹ã®ã‹ãªï¼Ÿ

php

symfony

mysql
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
å¹³ç´ ã‚ˆã‚Šã€ŒPHPãƒ—ãƒï¼ã€ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ 2006å¹´ã‚ˆã‚Šé‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€ŒPHPãƒ—ãƒï¼ã€ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚’é‘‘ã¿ã¾ã—ã¦ã€2018å¹´9æœˆ25æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã¾ã—ã¦ã€2018å¹´8æœˆ28æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’æŒã¡ã¾ã—ã¦ã€æ–°è¦ä¼šå“¡ç™»éŒ²ãªã‚‰ã³ã«Q&AæŽ²ç¤ºæ¿ã¸ã®æ–°ãŸãªè³ªå•ã€å›žç”ã®æŠ•ç¨¿ã‚’åœæ¢ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãªãŠã€ã”ç™»éŒ²ã„ãŸã ã„ãŸçš†æ§˜ã®å€‹äººæƒ…å ±ã«ã¤ãã¾ã—ã¦ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†å¾Œã€å¼Šç¤¾ãŒè²¬ä»»ã‚’ã‚‚ã£ã¦æ¶ˆåŽ»ã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¤šãã®çš†æ§˜ã«ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã€çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ã“ã¨ã€å¿ƒã‚ˆã‚ŠãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚ æœ¬ä»¶ã«é–¢ã™ã‚‹ãŠå•ã„åˆã‚ã›ã¯ã“ã¡ã‚‰ã‚ˆã‚ŠãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kiske 2007/07/10
PHP

MySQL
ãƒªãƒ³ã‚¯
MySQLã®ã‚¯ã‚¨ãƒªã‚’æœ€é©åŒ–ã™ã‚‹10ã®Tips - PHPãƒ—ãƒï¼ãƒ‹ãƒ¥ãƒ¼ã‚¹
å¹³ç´ ã‚ˆã‚Šã€ŒPHPãƒ—ãƒï¼ã€ã‚’ã”æ„›é¡§ã„ãŸã ãã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ 2006å¹´ã‚ˆã‚Šé‹å–¶ã—ã¦ã¾ã„ã‚Šã¾ã—ãŸã€ŒPHPãƒ—ãƒï¼ã€ã§ã™ãŒã€ã‚µãƒ¼ãƒ“ã‚¹ã®åˆ©ç”¨çŠ¶æ³ã‚’é‘‘ã¿ã¾ã—ã¦ã€2018å¹´9æœˆ25æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’ã‚‚ã¡ã¾ã—ã¦ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã•ã›ã¦ã„ãŸã ãã“ã¨ã«ãªã‚Šã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã¾ã—ã¦ã€2018å¹´8æœˆ28æ—¥ï¼ˆç«æ›œæ—¥ï¼‰ã‚’æŒã¡ã¾ã—ã¦ã€æ–°è¦ä¼šå“¡ç™»éŒ²ãªã‚‰ã³ã«Q&AæŽ²ç¤ºæ¿ã¸ã®æ–°ãŸãªè³ªå•ã€å›žç”ã®æŠ•ç¨¿ã‚’åœæ¢ã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ ãªãŠã€ã”ç™»éŒ²ã„ãŸã ã„ãŸçš†æ§˜ã®å€‹äººæƒ…å ±ã«ã¤ãã¾ã—ã¦ã¯ã€ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†å¾Œã€å¼Šç¤¾ãŒè²¬ä»»ã‚’ã‚‚ã£ã¦æ¶ˆåŽ»ã„ãŸã—ã¾ã™ã€‚ ã“ã‚Œã¾ã§å¤šãã®çš†æ§˜ã«ã”åˆ©ç”¨ã‚’ã„ãŸã ãã¾ã—ã¦ã€èª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã—ãŸã€‚ ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã«ä¼´ã„ã€çš†æ§˜ã«ã¯ã”ä¸ä¾¿ã‚’ãŠã‹ã‘ã„ãŸã—ã¾ã™ã“ã¨ã€å¿ƒã‚ˆã‚ŠãŠè©«ã³ç”³ã—ä¸Šã’ã¾ã™ã€‚ æœ¬ä»¶ã«é–¢ã™ã‚‹ãŠå•ã„åˆã‚ã›ã¯ã“ã¡ã‚‰ã‚ˆã‚ŠãŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
Kiske 2007/04/11
database

mysql

performance

tips

programming

php

sql
ãƒªãƒ³ã‚¯
Windowsã«PHPã¨MySQLã‚’ä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ç„¡å„Ÿãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã€ŒXAMPPã€ï¼Œæ—¥æœ¬èªžåŒ–ã•ã‚Œ24æ™‚é–“ã‚µãƒãƒ¼ãƒˆã‚‚é–‹å§‹
ã‚¨ã‚°ã‚¶ã‚¯ã‚½ãƒ³ã¯12æœˆ1æ—¥ï¼Œã€ŒXAMPPã€ã®24æ™‚é–“ã‚µãƒãƒ¼ãƒˆã‚’é–‹å§‹ã—ãŸã€‚XAMPã¯Windowsã‚„Linuxã«Apacheï¼ŒMySQLï¼ŒPHPã‚’ä¸€æ‹¬ã—ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼Œç®¡ç†ã§ãã‚‹ç„¡å„Ÿã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã€‚ã‚¶ãƒ³ãƒ—ï¼Œã¾ãŸã¯ã‚¨ã‚°ã‚¶ãƒ³ãƒ—ã¨èªã‚€ã€‚éžå–¶åˆ©çµ„ç¹”ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆApache friendsãŒé–‹ç™ºï¼Œé…å¸ƒã—ã¦ãŠã‚Šï¼Œ11æœˆ27æ—¥ã«å…¬é–‹ã•ã‚ŒãŸXampp1.5.5ã‹ã‚‰ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚„ç®¡ç†ãƒ„ãƒ¼ãƒ«ãŒæ—¥æœ¬èªžåŒ–ã•ã‚ŒãŸã€‚ Windowsã§ã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚’èµ·å‹•ã—ã¦ï¼Œãƒ‡ã‚£ãƒ¬ã‚¯ãƒˆãƒªã‚’ãªã©ã‚’æŒ‡å®šã™ã‚‹ã ã‘ã§Apacheï¼ŒMySQLï¼ŒPHPã‚’ä¸€åº¦ã«ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ï¼ŒWindowsã®ã‚µãƒ¼ãƒ“ã‚¹ã«ç™»éŒ²ã§ãã‚‹ã€‚ã¾ãŸã‚³ãƒ³ãƒˆãƒãƒ¼ãƒ«ãƒ‘ãƒãƒ«ã¨å‘¼ã¶GUIãƒ„ãƒ¼ãƒ«ã«ã‚ˆã‚Šï¼ŒApacheï¼ŒMySQLãªã©ã‚’èµ·å‹•ï¼Œåœæ¢ã§ãã‚‹ã€‚ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ©ã‚‚ä»˜å±žã—ï¼Œä¸€æ‹¬ã—ã¦ã‚¢ãƒ³ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã§ãã‚‹ã€‚Linuxã§ã¯ã‚·ã‚§ãƒ«ã‚¹ã‚¯ãƒªãƒ—ãƒˆã«ã‚ˆã‚Šä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨èµ·å‹•ï¼Œåœæ¢ãŒå¯èƒ½ã€‚ phpmyad
Kiske 2006/12/04
php

apache

MySQL
ãƒªãƒ³ã‚¯
PHPã¨ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã™ã‚‹5ã¤ã®å•é¡Œã€ã¨ãã®è§£æ±ºæ³• - GIGAZINE
IBMã®ã‚µã‚¤ãƒˆã«ã€PHPã‹ã‚‰æ“ä½œã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«é–¢ã—ã¦ã‚ˆãè¦‹ã‚‰ã‚Œã‚‹5ã¤ã®å•é¡Œç‚¹ã¨ãã®è§£æ±ºæ–¹æ³•ãŒæŽ²è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ãƒ‡ã‚¶ã‚¤ãƒ³ã‚’ã™ã‚‹éš›ã€ä¸€èˆ¬çš„ã«ç™ºç”Ÿã™ã‚‹å•é¡Œç‚¹ã«ã¤ã„ã¦ã®è§£èª¬ã§ã™ã€‚ ã§ã€è‚å¿ƒã®5ã¤ã®å•é¡ŒãŒä½•ã‹ã¨ã„ã†ã¨ã€ä»¥ä¸‹ã®é€šã‚Šã€‚ Five common PHP database probl ems 1ã¤ã‚ã¯å¤ã„PHPã®ã‚³ãƒ¼ãƒ‰ã§ã¯ç›´æŽ¥ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦ã„ã‚‹ã¨ã„ã†ã“ã¨ã€‚ã‚³ãƒ¬ã«ä»£ã‚ã‚‹æ‰‹æ®µã¨ã—ã¦ã¯ã€PEARã®DBãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ã†ã‹ã€ã‚ã‚‹ã„ã¯PHPãƒ‡ãƒ¼ã‚¿ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€PDOã®ã‚¯ãƒ©ã‚¹ã‚’ä½¿ãˆã€ã¨ã‚ã‚Šã¾ã™ã€‚ 2ã¤ã‚ã¯ã€ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’ä½¿ã‚ãªã„ã¨ã„ã†ã“ã¨ã€‚MySQLã¯åŸºæœ¬çš„ã«ãƒ¬ã‚³ãƒ¼ãƒ‰1ã¤ã«ã¤ã„ã¦ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã—ã¦ã„ã‚‹ã‚ã‘ã§ã™ãŒã€ã“ã‚Œã‚’æ´»ç”¨ã—ã¦ã„ãªã„ã¨ã„ã†ãƒ‘ã‚¿ãƒ¼ãƒ³ã€‚ã‚ªãƒ¼ãƒˆã‚¤ãƒ³ã‚¯ãƒªãƒ¡ãƒ³ãƒˆã‚’æœ‰åŠ¹ã«ä½¿ã£ã¦ã„ãªã„å ´åˆã€éžåŠ¹çŽ‡çš„ã§ã‚ã‚‹ã ã‘ã§ãªãã€è² è·ã‚‚é«˜ããªã‚‹ãã†ã§ã™ã€‚è§£
Kiske 2006/08/07
database

programming

php

æœ€é©åŒ–

mysql
ãƒªãƒ³ã‚¯
PHP Help: Creating a Membership System with PHP and MySQL
This tutorial deals with the various security issues a PHP developer, or any person who writes web applications, might face. The tutorial is aimed towards beginners, but other people may find some of the information the tutorial contains useful as well. Topics such as SQL injections, cross-site scripting, remote file inclusion attacks and session security are covered. The tutorial also covers how
Kiske 2006/06/28
php

mysql

programming
ãƒªãƒ³ã‚¯
1