[B! mdb2] AJYAã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

AJYA id:AJYA

mdb2ã«é–¢ã™ã‚‹AJYAã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã‚¯ã‚¨ãƒª
Description PEAR MDB2 ã§ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«å¯¾ã™ã‚‹ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã« ã„ãã¤ã‹ã®ãƒ¡ã‚½ãƒƒãƒ‰ã‚’ç”¨æ„ã—ã¦ã„ã¾ã™ã€‚ã„ã¡ã°ã‚“ç›´æŽ¥çš„ãªãƒ¡ã‚½ãƒƒãƒ‰ã¯ query() ã§ã™ã€‚ã“ã‚Œã¯ã€SQL ã‚¯ã‚¨ãƒªæ–‡å—åˆ—ã‚’å¼•æ•°ã¨ã—ã¦å—ã‘å–ã‚Šã¾ã™ã€‚è¿”ã‚Šå€¤ã«ã¯äºŒé€šã‚Šã®å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ çµæžœã‚’è¿”ã™ã‚¯ã‚¨ãƒª (SELECT ãªã©) ãŒæˆåŠŸã—ãŸå ´åˆã«ã¯æ–°ã—ã„ MDB2_Result ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã€å¤±æ•—ã—ãŸå ´åˆã«ã¯ MDB2_Error ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’è¿”ã—ã¾ã™ã€‚ ã“ã®ãƒ¡ã‚½ãƒƒãƒ‰ã¯ã€ãƒ‡ãƒ¼ã‚¿ã‚’æ“ä½œã™ã‚‹ã‚ˆã†ãªæ–‡ (INSERT ãªã©) ã«å¯¾ã—ã¦ä½¿ç”¨ã—ã¦ã¯ã„ã‘ã¾ã›ã‚“ã€‚ <?php //Â ã¾ãšãƒ—ãƒã‚°ãƒ©ãƒ ã®æœ€åˆã«ã€$mdb2Â ã¨ã„ã†åå‰ã® //Â MDB2Â ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆã—ã¾ã™ require_onceÂ 'MDB2.php'; $mdb2Â =&Â MDB2::connect('pgsql://usr:pw@localhost/
AJYA 2011/01/07
setLimit

pear

mdb2
ãƒªãƒ³ã‚¯
Pear::MDB2ã‚’è©¦ã™ - railtownã®æ—¥è¨˜
LAMPç’°å¢ƒã§ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚’ä½œã‚‹ã¨ãã¯ã»ã¼ã™ã¹ã¦ã§Pear:DBã‚’åˆ©ç”¨ã—ã¦ã¾ã—ãŸãŒã€ãªã‚“ã‹æ°—ä»˜ã„ãŸã‚‰ã€ŒPear::DBã¯ã‚‚ã†å¤ã„ã‹ã‚‰ã€Pear:MDB2ã‚’ä½¿ãˆã€ã¨ã„ã†æµã‚Œã«ãªã£ã¦ãã¦ã‚‹ã‚ˆã†ã§ã™ã€‚ ã™ã§ã«Pear::DBã¯é–‹ç™ºã‚‚ã‚¹ãƒˆãƒƒãƒ—ã—ã¦ãƒã‚°ãƒ•ã‚£ãƒƒã‚¯ã‚¹ãã‚‰ã„ã—ã‹è¡Œã‚ã‚Œãªã„ãã†ã§ã€ã˜ã‚ƒã‚é¢å€’ã ã‘ã©MDB2ã‚’è©¦ã—ã¦ã¿ã‚ˆã†ã‹ã€ã£ã¦ã“ã¨ã§åŒæ–¹ã‚’æ¯”è¼ƒã—ãªãŒã‚‰ä½¿ã£ã¦ã¿ã¾ã—ãŸã€‚ â—†ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« # pear install MDB2 # pear install MDB2_Driver_mysql # pear install MDB2_Driver_sqlite ä½¿ã†RDBMSã«å¿œã˜ã¦ãƒ‰ãƒ©ã‚¤ãƒã‚’å…¥ã‚Œã‚‹å¿…è¦ãŒã‚ã‚‹ã¿ãŸã„ã§ã™ã€‚ ã¨ã‚Šã‚ãˆãšMySQLã¨SQLiteã‚’å…¥ã‚Œã¨ãã¾ã—ãŸã€‚ â—†DSN DSNã®è¨˜è¿°æ–¹æ³•ã¯DBã‚‚MDB2ã‚‚åŒã˜ã€‚ è‡ªåˆ†ã¯ã“ã‚“ãªæ„Ÿã˜ã«ã—ã¦ã¾ã™ã€‚ define('DSN', 'mysql:/
AJYA 2011/01/07
setLimit

pear

mdb2
ãƒªãƒ³ã‚¯
MDB2 çµæžœã®è¡Œæ•°å–å¾—numRows() Â« macaroniworks
AJYA 2010/12/14
pear

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

mdb2

php
ãƒªãƒ³ã‚¯
midoff.com
This domain may be for sale!
AJYA 2007/01/12
php

pear

mdb2
ãƒªãƒ³ã‚¯
ã€ãƒã‚¦ãƒ„ãƒ¼ã€‘Agileã¨ã„ãˆã°PHP - PEARã®ä½¿ã„æ–¹ãã‚‰ã„ã¯çŸ¥ã£ã¦ãŠãã¾ã—ã‚‡ã† (1) å¼·åŠ›ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹é€£æº - MDB2 (MYCOMã‚¸ãƒ£ãƒ¼ãƒŠãƒ«)
AgileãªWebé–‹ç™ºã®ç¾å ´ã§é•·ã‚‰ãä½¿ã„è¾¼ã¾ã‚Œã€ä¸€æ—¥ã®é•·ã®ã‚ã‚‹è¨€èªžãŒPHPã€‚ãã—ã¦ã€ãã®Agilityã‚’å¼·åŠ›ã«æ”¯ãˆã¦ãã‚Œã‚‹APIã‚’æä¾›ã—ã¦ã„ã‚‹ã®ãŒPEARã¨å‘¼ã°ã‚Œã‚‹ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸é›†ã ã€‚PEARã¯ã€PHPã‚’ä½¿ã£ãŸWebã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®é–‹ç™ºã«æ¬ ã‹ã›ãªã„é‡è¦ãªæ©Ÿèƒ½ã‚„ã‚ˆãä½¿ç”¨ã•ã‚Œã‚‹æ©Ÿèƒ½ãªã©ã‚’ã«ã¾ã¨ã‚ãŸãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã§ã€é–‹ç™ºã®ç¾å ´ã§åºƒãæŽ¡ç”¨ã•ã‚Œã¦ã„ã‚‹ã€‚ ç¾åœ¨ã®PEARã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¯8æœˆ16æ—¥(å”å®šä¸–ç•Œæ™‚)ã«å…¬é–‹ã•ã‚ŒãŸ1.4.11ã€‚The PHP License, version 3.0ã®ã‚‚ã¨ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã€‚PEARãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®ä¸ã«å„ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ãŒå«ã¾ã‚Œã‚‹ã“ã¨ã«ãªã‚‹ã®ã ãŒã€ãã‚Œã‚‰ã¯å¿…ãšã—ã‚‚åŒã˜ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã®ã‚‚ã¨ã§å…¬é–‹ã•ã‚Œã¦ã„ã‚‹ã¨ã„ã†ã‚ã‘ã§ã¯ãªã„ã€‚ãƒ‡ãƒ™ãƒãƒƒãƒ‘ã¯å„ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®ãƒ©ã‚¤ã‚»ãƒ³ã‚¹ã«å¾“ã†ã“ã¨ã§ã€ã“ã‚Œã‚‰ã‚’åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ æœ¬ç¨¿ã§ã¯ã€PEARã®ä¸ã§ã‚‚æ¯”è¼ƒçš„åˆ©ç”¨ä¾¡å€¤ãŒé«˜ãã†ã ã¨æ€ã‚ã‚Œã‚‹ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ã„ãã¤ã‹ç´¹ä»‹
AJYA 2007/01/12
php

pear

mdb2
ãƒªãƒ³ã‚¯
ã“ã®å…ˆç”Ÿãã®ã“ã‚‹ã«ã¯
PEARãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®æ›´æ–°ãƒªã‚¹ãƒˆã«ã‚„ãŸã‚‰ã§ã¦ãã‚‹æŠ½è±¡DBãƒ¬ã‚¤ãƒ¤ãƒ¼ãƒ©ã‚¤ãƒ–ãƒ©ãƒªMDB2ã€‚ PEAR::DBã¨æ¯”ã¹ã¦å…ˆé€²çš„ãªæ©Ÿèƒ½ãŒãŸãã•ã‚“ç››ã‚Šè¾¼ã¾ã‚Œã¦ã„ã‚‹ä¸Šã«å‘¨è¾ºãƒ©ã‚¤ãƒ–ãƒ©ãƒªã‚‚è±Šå¯Œãªã®ã§PEARå¤§å¥½ããªäººã¯ã¿ã‚“ãªèˆˆå‘³æ´¥ã€…ã ã¨æ€ã†ã®ã§ã™ãŒã€æ™®æ®µPEAR::DBã‚’ä½¿ã£ã¦ã„ã‚‹äººé–“ã«ã¨ã£ã¦ã¯ã€ã™ã§ã«ãã‚Œã§äº‹è¶³ã‚Šã¦ã„ãŸã‚Šã€PEAR::DBã¨DBã®æ“ä½œæ–¹æ³•ãŒé•ã†ç‚ºã«æ‰‹ã‚’å‡ºã™ã®ã‚’ãŸã‚ã‚‰ã£ãŸã‚Šã—ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ã€‚ã¨ã„ã†ã‹ç§ã¯æ‰‹ã‚’ã ã™ã®ã‚’ãŸã‚ã‚‰ã£ã¦ã„ã¾ã™ã€‚ ãã‚“ãªäººé”ã«ã‚ªã‚¹ã‚¹ãƒ¡ãªã®ãŒphpied.comã®DB-2-MDB2ã¨ã„ã†è¨˜äº‹ã€‚PEAR::DBã¨PEAR::MDB2ã‚’æ¯”è¼ƒã—ã¦ã€PEAR::DBã§ã§ãã‚‹äº‹ã‚’PEAR::MDB2ã§ã©ã†ã‚„ã‚‹ã‹ãŒè§£èª¬ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚ˆãã‚ã‚‹MDB2é–¢é€£ã®ã‚µã‚¤ãƒˆã¯ã€ŒMDB2ã¯ã“ãƒ¼ã‚“ãªä¾¿åˆ©ãªäº‹ãŒã§ãã¡ã‚ƒã†ã‚“ã§ã™ï¼ã€ã¨ã„ã†MDB2ç‹¬è‡ªã®ä¾¿åˆ©ãªæ©Ÿèƒ½ã‚’ä¸å¿ƒã«ç´¹ä»‹ã—ã¦ã„ã‚‹ç‚ºã€ä¾¿åˆ©ã ã¨ã„ã†
AJYA 2007/01/12
pear

php

mdb2
ãƒªãƒ³ã‚¯
PEAR :: Manual :: MDB2
ç›®æ¬¡å°Žå…¥Â --Â æ©Ÿèƒ½æ¦‚è¦DSNÂ --Â ãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹å (Data Source Name)æŽ¥ç¶šÂ --Â ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æŽ¥ç¶šãŠã‚ˆã³æŽ¥ç¶šã®è§£é™¤ã‚¯ã‚¨ãƒªÂ --Â ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œã‚¯ã‚©ãƒ¼ãƒˆãŠã‚ˆã³ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—Â --Â å€¤ã‚’é©åˆ‡ã«ã‚¯ã‚©ãƒ¼ãƒˆã—ã¦ã‚¯ã‚¨ãƒªã‚’ä½œæˆã™ã‚‹ãƒ‡ãƒ¼ã‚¿åž‹Â --Â ãƒ‡ãƒ¼ã‚¿åž‹ã®å‡¦ç†ã®æ¦‚è¦çµæžœÂ --Â ã‚¯ã‚¨ãƒªçµæžœã‹ã‚‰ã®ãƒ‡ãƒ¼ã‚¿ã®å–å¾—æº–å‚™ã¨å®Ÿè¡ŒÂ --Â ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³Â --Â ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã®å‡¦ç†ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«Â --Â ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®èªã¿è¾¼ã¿ã¨ã‚³ãƒ¼ãƒ«Manager ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«Â --Â ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’ç®¡ç†ã™ã‚‹ãŸã‚ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«Reverse ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«Â --Â ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹é€ ã‚’ç®¡ç†ã™ã‚‹ãŸã‚ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«autoPrepare & autoExecuteÂ --Â SQL æ–‡ã‚’è‡ªå‹•çš„ã«æº–å‚™ãƒ»å®Ÿè¡Œã™ã‚‹å¯æ¬æ€§Â --Â ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®å¯æ¬æ€§ã«é–¢ã™ã‚‹æ©Ÿèƒ½ã‚·ãƒ¼ã‚±ãƒ³ã‚¹Â --Â ã‚·ãƒ¼ã‚±ãƒ³ã‚¹ãŠã‚ˆã³è‡ªå‹•æŽ¡ç•ªFAQÂ --Â ã‚ˆãã‚
AJYA 2007/01/12
pear

mdb2

php
ãƒªãƒ³ã‚¯
phpied.com Â» Blog Archive Â» DB-2-MDB2
Intro Recently I had to move an existing project from using PEAR::DB to PEAR::MDB2 - the new database abstraction layer. I took notes on the parts of the code I needed to change, I hope they can benefit someone who's doing the same. Many thanks go to Lukas Smith, the lead developer, he was always responding very fast to my reports and questions in the PEAR mailing list. One thing to notice in MDB2
AJYA 2007/01/12
mdb2

pear

php
ãƒªãƒ³ã‚¯
1