[B! PDO] ono_matopeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ono_matope id:ono_matope

PDOã«é–¢ã™ã‚‹ono_matopeã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (6)

${{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}}

PDOã€PEAR::DBã€MySQLé–¢æ•°ã®é€Ÿåº¦æ¯”è¼ƒ
ã‚µãƒ¼ãƒãƒ¼å´ã®å•é¡Œã‚‚ã‚ã‚‹ã®ã§ã€æ¯Žå›žå®‰å®šã—ãŸå‡¦ç†çµæžœã¯å¾—ã‚‰ã‚Œã¾ã›ã‚“ã§ã—ãŸãŒã€å¤§ä½“ä¸Šè¡¨ã®ã‚ˆã†ãªçµæžœã«ãªã‚Šã¾ã—ãŸã€‚ ã‚„ã¯ã‚Šãƒã‚¤ãƒ†ã‚£ãƒ–é–¢æ•°ã¯é€Ÿãã€mysqlié–¢æ•°ãŒä¸€ç•ªé€Ÿã„çµæžœã«ãªã‚Šã¾ã—ãŸã€‚ ç¶šã„ã¦åŒã˜ããƒã‚¤ãƒ†ã‚£ãƒ–é–¢æ•°ã®mysqlé–¢æ•°ãŒç¶šãã€ãã®æ¬¡ã«PDOã¨ã„ã†çµæžœã«ãªã‚Šã¾ã—ãŸã€‚ PDOã§ã¯ã€ãƒ—ãƒªãƒšã‚¢ãƒ‰ã‚¹ãƒ†ãƒ¼ãƒˆãƒ¡ãƒ³ãƒˆã‚’ç”¨ã„ã¦SQLã‚’ç™ºè¡Œã—ãŸãŸã‚ã€2å›žç›®ã®SQLã®ç™ºè¡Œã§ã¯ã‚ãƒ£ãƒƒã‚·ãƒ¥ãŒåŠ¹ãã€åŠ‡çš„ãªé€Ÿã•ã«ãªã£ã¦ã„ã¾ã™ã€‚ ä¸€ç•ªé…ã‹ã£ãŸã®ã¯äºˆæƒ³é€šã‚Šã€PEAR::DBã§ã—ãŸã€‚ ãƒã‚¤ãƒ†ã‚£ãƒ–é–¢æ•°ã‚ˆã‚Šã‚‚2ã€œ3å€é…ãã€PDOã‚ˆã‚Šã‚‚2å€è¿‘ãé…ã„çµæžœã¨ãªã‚Šã¾ã—ãŸã€‚ PHPç”¨ã‚¢ã‚¯ã‚»ãƒ©ãƒ¬ãƒ¼ã‚¿ã‚’å°Žå…¥ã—ã¦ã„ãªã‘ã‚Œã°ã€PEAR::DBã¯ã‚‚ã£ã¨é…ããªã£ãŸã ã‚ã†ã¨è€ƒãˆã‚‰ã‚Œã¾ã™ã€‚ ã¾ã¨ã‚ PHP5ã‚’åˆ©ç”¨ã—ã¦ã„ã¦ã€DBã®æŠ½è±¡åŒ–ã‚’è¡Œã„ãŸã„ã®ã§ã‚ã‚Œã°ã€PEARç³»ã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¯ã‚„ã‚ã¦PDOã«ã—ãŸæ–¹ãŒè‰¯ã„ã¨è¨€ãˆã¾ã™ã€‚ å˜ç´”ãªSELECTæ–‡ã®çµæžœã§ã•
ono_matope 2008/05/20
PHP

mysql

PDO

æ¯”è¼ƒ

performance
ãƒªãƒ³ã‚¯
PDO->query()
ono_matope 2006/12/31
foreach ($conn->query($sql) as $row)

PDO
ãƒªãƒ³ã‚¯
[ThinkIT] ç¬¬2å›žï¼šã‚¯ã‚¨ãƒªã®å®Ÿè¡Œ (1/3)
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®æŽ¥ç¶šãŒç¢ºç«‹ã—PDOã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒä½¿ç”¨å¯èƒ½ã«ãªã‚‹ã¨ã€æ§˜ã€…ãªé–¢æ•°ã‚’é€šã—ã¦å¤šãã®ã‚ªãƒšãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ãŒå®Ÿè¡Œã•ã‚Œã¾ã™ã€‚ ã“ã‚Œã‚‰ã®é–¢æ•°ã¯ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã™ã‚‹exec()ãƒ¡ã‚½ãƒƒãƒ‰ã‚’å«ã¿ã¾ã™ãŒã€ã“ã‚Œã‚‰ãŒãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’è¿”ã™ã“ã¨ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚ã“ã®ã‚¿ã‚¤ãƒ—ã®ã‚¯ã‚¨ãƒªã¯UPDATEã€INSERTã‚„DELETEãªã©ã®å‘½ä»¤æ–‡ã§ã™ã€‚ ã‚¯ã‚¨ãƒªã®å®Ÿè¡Œã«æˆåŠŸã™ã‚‹ã¨ã€exec()ãƒ¡ã‚½ãƒƒãƒ‰ã¯å‘½ä»¤æ–‡ã«ã‚ˆã£ã¦å–ã‚Šå‡ºã•ã‚ŒãŸ1è¡Œåˆ†ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¿”ã—ã¾ã™ã€‚ãƒ‡ãƒ¼ã‚¿ãŒãªã„å ´åˆã¯0ãŒè¿”ã•ã‚Œã€ã‚¯ã‚¨ãƒªãŒå¤±æ•—ã™ã‚‹ã¨FALSE ã‚’è¿”ã—ã¾ã™ã€‚ $rows_affected = $db->exec("INSERT INTO my_table (row1,row2) VALUES(1,2)"); if ($rows_affected === FALSE) { // query has failed $einfo = $db->errorInfo(); echo
ono_matope 2006/12/17
PHP

PDO
ãƒªãƒ³ã‚¯
PDOï¼ˆPHP Data Objectsï¼‰ã‚’è©¦ã—ã¦ã¿ã‚‹ - PDO_OCIã¯ä»Šã©ã‚“ãªæ„Ÿã˜ï¼Ÿ - Do You PHP?
PDO1.0ä»¥é™ã€å®šæ•°ãŒã€ŒPDO_xxxã€ã‹ã‚‰ã€ŒPDO::xxxã€ã«å¤‰æ›´ã«ãªã£ã¦ã„ã¾ã™ã®ã§ã€ãã‚Œä»¥å‰ã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã‚’ä½¿ç”¨ã—ã¦ã„ãŸæ–¹ã¯æ³¨æ„ãŒå¿…è¦ã§ã™ã€‚ 2005/06/10ä»˜ã‘ã§PHP5.1.0Î²1ãŒãƒªãƒªãƒ¼ã‚¹ã•ã‚Œã¾ã—ãŸãŒã€æ¨™æº–ã®æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã¨ã—ã¦PDOãŒå«ã¾ã‚Œã¦ãŠã‚Šã€configureæ™‚ã«ã€Œ--with-pdo-ociã€ã‚’ä»˜ã‘ã¦buildã™ã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ PHPã§DBã‚’æ‰±ã†éš›ã€æœ€ã‚‚ä¸€èˆ¬çš„ãªæ–¹æ³•ã¨ã—ã¦OCI8ã‚„pgsqlã€mysqlãªã©ã®æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä½¿ç”¨ã™ã‚‹æ–¹æ³•ãŒä¸Šã’ã‚‰ã‚Œã¾ã™ãŒã€DBã«ã‚ˆã£ã¦APIãŒç•°ãªã£ã¦ã—ã¾ã„ã¾ã™ã€‚ã“ã‚Œã‚’æŠ½è±¡åŒ–ã™ã‚‹ãŸã‚ã€ãƒ‡ãƒ¼ã‚¿æŠ½è±¡åŒ–ãƒ¬ã‚¤ãƒ¤ï¼ˆData Abstraction Layerï¼‰ã«ç›¸å½“ã™ã‚‹å„ç¨®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªãŒå¤šãã§å›žã£ã¦ã„ã¾ã™ã€‚ç¾æ™‚ç‚¹ã§å‡ºå›žã£ã¦ã„ã‚‹ãƒ©ã‚¤ãƒ–ãƒ©ãƒªã¨ã—ã¦ã¯ã€ãŠãã‚‰ããƒ‡ãƒ•ã‚¡ã‚¯ãƒˆã‚¹ã‚¿ãƒ³ãƒ€ãƒ¼ãƒ‰ã§ã‚ã‚‹ã¨æ€ã‚ã‚Œã‚‹PEAR::DBã‚„æ‹¡å¼µãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã®dbxã€æœ€è¿‘æµè¡Œï¼ˆ
ono_matope 2006/12/04
PHP

PDO

ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
ãƒªãƒ³ã‚¯
PHP5.1.0RC1ã§PDOã¨ADODBã€PEAR::DBã®ãƒ™ãƒ³ãƒãƒžãƒ¼ã‚¯ï¼ˆPostgreSQL&MySQLï¼‰
pgsql_native.php: <?php require_once("Benchmark/Timer.php"); $timer = new Benchmark_Timer(TRUE); $conn = pg_pconnect("dbname=funaki user=funaki"); if (!$conn) { die("cannot connect."); } $result = pg_query($conn, "select * from blog"); print_r(pg_fetch_all($result)); ?>pgsql_pdo.php: <?php require_once("Benchmark/Timer.php"); $timer = new Benchmark_Timer(TRUE); try { $dbh = new PDO('pgsql:host=loc
ono_matope 2006/12/04
PDOã¯PEAR::DBã®ï¼“å€ãã‚‰ã„é€Ÿã„ã‚‰ã—ã„

PHP

pear

PDO
ãƒªãƒ³ã‚¯
PDOã§ã‚µã‚¯ã‚µã‚¯DBé–‹ç™ºï¼šCodeZine
ã¯ã˜ã‚ã«ã€€PHPç•Œéšˆã§ã¯ç¾åœ¨ã€PHP 4ã‹ã‚‰PHP 5ã¸ã®ç§»è¡ŒãŒé€²ã‚“ã§ãã¦ãŠã‚Šã€ã“ã“æœ€è¿‘ã§ã¯PHP 5ã®æ©Ÿèƒ½ã‚’æ´»ç”¨ã—ãŸãƒ•ãƒ¬ãƒ¼ãƒ ãƒ¯ãƒ¼ã‚¯ã‚‚å¤šãå‡ºã¦ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚ã€€PHP 5ã¯ã€PHP 4ã«æ¯”ã¹ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæŒ‡å‘ã®ã‚µãƒãƒ¼ãƒˆã‚„é€Ÿåº¦é¢ã§ã®å‘ä¸Šãªã©ãŒå–ã‚Šä¸Šã’ã‚‰ã‚Œã‚‹ä¸ã€æœ€ã‚‚æ³¨ç›®ã™ã¹ãç‚¹ã§ã‚ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¸ã®ã‚¢ã‚¯ã‚»ã‚¹ã‚’æŠ½è±¡åŒ–ã—ãŸãƒ¬ã‚¤ãƒ¤ãƒ¼ã¨ã—ã¦PDOãŒç™»å ´ã—ã¾ã—ãŸã€‚ã€€ä»Šå›žã¯ãã®PDOã«æ³¨ç›®ã—ã€ã‚µãƒ³ãƒ—ãƒ«ã‚’äº¤ãˆã¦PDOã®ä½¿ã„æ–¹ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚å¯¾è±¡èªè€…PHP 5ã‚’ä½¿ã£ãŸã“ã¨ãŒã‚ã‚‹æ–¹ä»¥å‰PEAR::DBãªã©ã‚’ç”¨ã„ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½¿ã£ãŸã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä½œæˆã—ãŸã“ã¨ã®ã‚ã‚‹æ–¹ å¿…è¦ãªç’°å¢ƒã€€PDOã¯PHP 5.1ã‹ã‚‰æ¨™æº–ã§å°Žå…¥ã•ã‚Œã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸã€‚Windows/UNIXã‚’å•ã‚ãšåˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã‚ˆã£ã¦PHP 5.1ã®ç’°å¢ƒã¨ã€PDOã®å‹•ä½œã«å¿…è¦ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æ§‹ç¯‰ã‚’è¡Œã£ã¦ãã ã•ã„ã€‚PDOã¨ã¯ã€€PDOï¼ˆPHP
ono_matope 2006/12/04
PEAR::DBä»£æ›¿æŠ€è¡“?

PHP

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

SQLite

mysql

PDO
ãƒªãƒ³ã‚¯
1