[B! SQL] KouJustinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

KouJustin id:KouJustin

SQLã«é–¢ã™ã‚‹KouJustinã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (15)

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

CakePHPã§MySQLã®BETWEENã‚’ä½¿ã† | æ ªå¼ä¼šç¤¾LIG(ãƒªã‚°)ï½œDXæ”¯æ´ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™ºãƒ»Webåˆ¶ä½œ
CakePHPã§DBã‹ã‚‰ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã—ãŸã‚Šé€†ã«å…¥åŠ›ã—ãŸã‚Šã™ã‚‹éš›ã«ã¯findã‚„saveã¨ã„ã†ãŠæ‰‹è»½ãªãƒ¡ã‚½ãƒƒãƒ‰ãŒã‚ã‚‹ã®ã§ã¨ã¦ã‚‚ä¾¿åˆ©ã€‚ ã ã‘ã©ã€çµæ§‹è¤‡é›‘ãªã‚¯ã‚¨ãƒªãƒ¼ã‚’æŠ•ã’ãªãã‚ƒã„ã‘ãªã„ã¨ãªã‚‹ã¨ã€ã©ã†æ›¸ã‘ã°è‰¯ã„ã®ã‹åˆ†ã‹ã‚‰ãªããªã‚‹å ´åˆã‚‚æ„å¤–ã¨ã‚ã£ãŸã‚Šã™ã‚‹ã€‚findã®æ¡ä»¶æŒ‡å®šã®ã¨ãã¨ã‹ã€‚BETWEENã¨ã‹LIKEãªã‚“ã‹ã‚‚ã€ä¸€åº¦çŸ¥ã£ã¦ã—ã¾ãˆã°ãŸã„ã—ãŸã“ã¨ã¯ãªã„ã®ã ã‘ã©ã€çŸ¥ã‚‰ãªã„ã¨ã‚ã‚Šã¨æ‚©ã‚€ã€‚å°‘ãªãã¨ã‚‚è‡ªåˆ†ã¯æ‚©ã¿ã¾ã—ãŸã€‚ ã©ã†ã—ã¦ã‚‚å›°ã£ãŸã‚‰$this->query()ã§ç›´æŽ¥SQLæ–‡ã‚’æ›¸ã„ã¡ã‚ƒãˆã°è‰¯ã„ã®ã ã‚ã†ã‘ã©ã€WHEREå¥ã§BETWEENã‚’ä½¿ã†å ´åˆã®è¨˜è¿°ã§ã¡ã‚‡ã£ã¨é¢ç™½ã„æ›¸ãæ–¹ã‚’ç™ºè¦‹ã—ãŸã®ã§ã€ã“ã“ã§ã¯ãã‚Œã§é ‘å¼µã£ã¦ã¿ã‚‹ã€‚ ã˜ã‚ƒã‚ãŸã¨ãˆã°ã€idãŒ10ã‹ã‚‰20ã®é–“ã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–å¾—ã™ã‚‹ã¨ã—ã¾ã—ã‚‡ã†ã€‚ $params = array('conditions' => array('id BETWEEN ? AND
KouJustin 2013/12/22
cakephp

SQL

MySQL
ãƒªãƒ³ã‚¯
CakePHPã§ã‚µãƒ–ã‚¯ã‚¨ãƒªã‚’ä½¿ã† - hiroaki's Lab
ã¾ãšã€modelã‚¯ãƒ©ã‚¹ã«ã‚ã‚‹queryãƒ¡ã‚½ãƒƒãƒ‰ã‚’ä½¿ç”¨ã™ã‚‹æ–¹æ³•ã§ã™ã€‚ ä¸‹è¨˜ã‚³ãƒ¼ãƒ‰ã®ã‚ˆã†ã«SQLæ–‡ã‚’queryãƒ¡ã‚½ãƒƒãƒ‰ã®ãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã¨ã—ã¦æ¸¡ã™ã ã‘ã§ã™ã€‚ã“ã‚Œã§ç›®çš„ã®ãƒ‡ãƒ¼ã‚¿ãŒå–å¾—ã§ãã¾ã™ã€‚ã“ã®æ–¹æ³•ãŒä¸€ç•ªæ‰‹ã£å–ã‚Šæ—©ãã‚ã‹ã‚Šã‚„ã™ã„ã¨æ€ã„ã¾ã™ã€‚ class FruitsController extends AppController { public $name = 'Fruits'; public function index() { $sql = 'SELECT Fruit.id, Fruit.name, Fruit.price, (SELECT SUM(F2.price) FROM fruits F2 WHERE Fruit.id >= F2.id) AS sum_price FROM fruits Fruit ORDER BY Fruit.id ASC'; $results = $this->F
KouJustin 2013/12/22
CakePHP

model

SQL
ãƒªãƒ³ã‚¯
CakePHPã®Viewä»¥å¤–ã§å®Ÿè¡Œã•ã‚ŒãŸSQLã‚’è¦‹ã‚‹æ–¹æ³• #cakephp | Webã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ©ã‚¤ãƒ•
CakePHPã®Shellã‚’ä½œã£ã¦ã„ã‚‹æ™‚ã«å®Ÿè¡Œã•ã‚ŒãŸSQLã‚’è¦‹ãŸã„ãªãƒ¼ã¨æ€ã£ã¦èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ 1è¡Œã§æ›¸ã‘ã‚‹ã®ã§è¦šãˆã¦ãŠãã¨ä¾¿åˆ©ã§ã™ã€‚ ã•ã£ããã§ã™ãŒã€SQLã®å®Ÿè¡Œçµæžœã‚’è¦‹ã‚‹ã«ã¯ã€ä»¥ä¸‹ã®ã‚ˆã†ã«æ›¸ãã¾ã™ã€‚ debug($this->{Model}->getDataSource()->getLog()); getLog()ãŒè‚ã§ã™ã€‚ å®Ÿéš›ã®ä½¿ç”¨ä¾‹ $this->User->find('all', array( 'contain' => array( 'Post' => array( 'fileds' => array( 'Post.id', 'Post.title', 'Post.body' ), 'conditions' => array( 'Post.created <=' => '2012-12-31' ), ) ), 'fileds' => array( 'User.id', 'Use
KouJustin 2013/12/18
cakephp

SQL

ãƒã‚°
ãƒªãƒ³ã‚¯
Perl Tips | MySQL ã§ã€ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã‚’æŒ‡å®šã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹æ–¹æ³•
MySQL ã§ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ãƒ†ã‚ã‚¹ãƒˆãƒ‡ãƒ¼ã‚¿ã«ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆï¼ˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ï¼‰ã™ã‚‹æ–¹æ³•ã¯ã€mysqldump ã‚³ãƒžãƒ³ãƒ‰ã‚’ä½¿ãˆã°ã‚ˆã„ã€‚ä»¥ä¸‹ã®ã‚ˆã†ã«ã™ã‚‹ã€‚ # mysqldump -u root -p your_database_name > your_database_name.sql ã•ã¦ã€ã“ã‚Œã‚’å…ƒã«æˆ»ã™ã¨ãã«ã€ # mysql -u root -p your_database_name < your_database_name.sql â€» your_database_name ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸èº«ã¯ç©ºã§ã‚ã‚‹ã“ã¨ã€‚ ã®ã‚ˆã†ã«ã™ã‚Œã°ç°¡å˜ã«ã‚¤ãƒ³ãƒãƒ¼ãƒˆã§ãã‚‹ã®ã ãŒã€ã‚¨ã‚¯ã‚¹ãƒãƒ¼ãƒˆï¼ã‚¤ãƒ³ãƒãƒ¼ãƒˆã™ã‚‹ãã‚Œãžã‚Œã®ãƒžã‚·ãƒ³ã§é•ã†è¨å®šã® MySQL ãŒå‹•ã„ã¦ã„ãŸã‚Šã™ã‚‹ã¨ã€ã‚¤ãƒ³ãƒãƒ¼ãƒˆã—ã¦ã¿ãŸã‚‰ãƒ‡ãƒ¼ã‚¿ãŒæ–‡å—åŒ–ã‘ã—ã¦ãŸãƒ»ãƒ»ãƒ»ãªã‚“ã¦ã“ã¨ãŒå®Ÿéš›ã«ã‚ã£ãŸã€‚ your_database_name.sql ã®ã‚ãƒ£ãƒ©ã‚¯ã‚¿ã‚»ãƒƒãƒˆã¯
KouJustin 2013/10/15
MySQL

SQL

ã‚¤ãƒ³ãƒãƒ¼ãƒˆ

æ–‡å—ã‚³ãƒ¼ãƒ‰
ãƒªãƒ³ã‚¯
WordPress SQLã®ã‚¨ãƒ©ãƒ¼å‡ºåŠ›ã‚’è‡ªå‹•åŒ– - 130å˜ä½
WordPressã§SQLã®ã‚¨ãƒ©ãƒ¼å‡ºåŠ›ã‚’(è‡ªå‹•ã§)è¡Œã†æ–¹æ³•ã‚’èª¿ã¹ã¦ã„ã¾ã—ãŸã€‚ã–ã£ã¨ä»¥ä¸‹ã®ã‚ˆã†ãªæ„Ÿã˜ã«ãªã£ã¦ã„ã¾ã—ãŸã€‚ ã™ã¹ã¦ã®SQLã¯wpdb#query()ã‚’é€šã‚‹ wpdb#query()ã§ã‚¨ãƒ©ãƒ¼ãŒç™ºç”Ÿã™ã‚‹ã¨ã€wpdb#print_error()ãŒå‘¼ã°ã‚Œã‚‹ æ¡ä»¶ã«ã‚ˆã£ã¦3ç¨®é¡žã®å‡ºåŠ›ãŒã‚ã‚‹ (â€»WordPress MU 2.8.4a) ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›ãã®1 å‡ºåŠ›æ¡ä»¶ $wpdbã®show_errorsãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚’trueã«ã—ã¦ãŠã å®šæ•°'ERRORLOGFILE'ã§ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å®šç¾©ã—ã¦ãŠã ç”»é¢å‡ºåŠ›+å®Ÿè¡Œä¸æ– å‡ºåŠ›æ¡ä»¶ $wpdbã®show_errorsãƒ—ãƒãƒ‘ãƒ†ã‚£ã‚’trueã«ã—ã¦ãŠã å®šæ•°'DIEONDB ERROR'ã‚’trueã§å®šç¾©ã—ã¦ãŠã ãƒã‚°ãƒ•ã‚¡ã‚¤ãƒ«å‡ºåŠ›ãã®2 å‡ºåŠ›æ¡ä»¶ PHPã®è¨å®š'error_log'ã«ãƒ•ã‚¡ã‚¤ãƒ«ã‚’å®šç¾©ã—ã¦ãŠã ã“ã¡ã‚‰ã¯ã‚¨ãƒ©ãƒ¼å†…å®¹ã ã‘ã§ãªãã¦ã‚¨ãƒ©ãƒ¼æ™‚ã®SQLã‚‚å‡ºåŠ›
KouJustin 2013/02/19
wordpress

tips

DB

SQL
ãƒªãƒ³ã‚¯
CASEå¼ã®ã‚¹ã‚¹ãƒ¡ / ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ»ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸–ç•Œ
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
KouJustin 2012/12/01
case

SQL

TIPS
ãƒªãƒ³ã‚¯
è¡Œåˆ—å¤‰æ› - ã“ã‚Œã§ã‚‚â€¦
ç›¸å¤‰ã‚ã‚‰ãšSQLå†å…¥é–€ã€‚ ä»Šåº¦ã¯åˆ—ã¨è¡Œå…¥ã‚Œæ›¿ãˆã‚‹ã®ã§æ‚©ã¿ã¾ã—ãŸã€‚ [m_c] member_id color 1 èµ¤ 1 ç™½ 2 é’ 2 ç™½ 3 ç™½ ã“ã‚Œã‚’ ãƒ¡ãƒ³ãƒãƒ¼ID èµ¤ é’ ç™½ 1 â—‹ â—‹ 2 â—‹ â—‹ 3 â—‹ ã“ã‚“ãªæ„Ÿã˜ã«ã—ãŸã„ã€‚ ãã‚“ãªæ™‚ã¯ä»¥ä¸‹SQL select member_id as 'ãƒ¡ãƒ³ãƒãƒ¼ID' , CASE WHEN SUM(CASE WHEN color = 'èµ¤' THEN 1 ELSE NULL END) = 1 THEN 'â—‹' ELSE '' END AS "èµ¤" , CASE WHEN SUM(CASE WHEN color = 'é’' THEN 1 ELSE NULL END) = 1 THEN 'â—‹' ELSE '' END AS "é’" , CASE WHEN SUM(CASE WHEN color = 'ç™½' THEN 1 ELSE NULL EN
KouJustin 2012/12/01
SQL

TIPS

case
ãƒªãƒ³ã‚¯
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã›
ã‚µãƒ¼ãƒ“ã‚¹çµ‚äº†ã®ãŠçŸ¥ã‚‰ã› ã„ã¤ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”åˆ©ç”¨ã„ãŸã ãèª ã«ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ ãŠå®¢æ§˜ãŒã‚¢ã‚¯ã‚»ã‚¹ã•ã‚ŒãŸã‚µãƒ¼ãƒ“ã‚¹ã¯æœ¬æ—¥ã¾ã§ã«ã‚µãƒ¼ãƒ“ã‚¹ã‚’çµ‚äº†ã„ãŸã—ã¾ã—ãŸã€‚ ä»Šå¾Œã¨ã‚‚Yahoo! JAPANã®ã‚µãƒ¼ãƒ“ã‚¹ã‚’ã”æ„›é¡§ãã ã•ã„ã¾ã™ã‚ˆã†ã€ã‚ˆã‚ã—ããŠé¡˜ã„ã„ãŸã—ã¾ã™ã€‚
KouJustin 2012/12/01
DB

having

SQL

*èªã¿ç‰©
ãƒªãƒ³ã‚¯
MySQLã§AUTO_INCREMENTã®å€¤ã‚’ãƒã‚§ãƒƒã‚¯ã€åˆæœŸå€¤å¤‰æ›´
ã‚ˆãä½¿ã†ã‘ã©ä½¿ã†ãŸã³å¿˜ã‚Œã‚‹ã®ã§ãƒ¡ãƒ¢ AUTO_INCREMENTã®å€¤ã‚’ç¢ºèªã™ã‚‹ SHOW TABLE STATUS LIKE 'ãƒ†ãƒ¼ãƒ–ãƒ«å'; AUTO_INCREMENTã®å€¤ã‚’å¤‰æ›´ã™ã‚‹ ALTER TABLE ãƒ†ãƒ¼ãƒ–ãƒ«å AUTO_INCREMENT=æ•°å—; æŒ‡å®šã—ãŸæ•°å—ãŒæ¬¡ã«æŒ¯ã‚‰ã‚Œã‚‹ç•ªå·ã«ãªã‚‹
KouJustin 2012/09/23
MySQL

SQL

AUTO_INCREMENT
ãƒªãƒ³ã‚¯
ã‚µã‚¤ã‚ªãƒ³ã‚³ãƒŸãƒ¥ãƒ‹ã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚ºæ ªå¼ä¼šç¤¾ â€” æ²–ç¸„çœŒã§ã®ã‚³ãƒ¼ãƒ«ã‚»ãƒ³ã‚¿ãƒ¼ã€ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã€ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º Â» ç¬¬21å›ž MySQLã¨PHPã«ãŠã‘ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç–ã«ã¤ã„ã¦
ã‚„æ£è¦è¡¨ç¾ã‚’ä½¿ã£ãŸé–¢æ•°ç‰ã‚’ä½¿ç”¨ã™ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ã§ã¯å°‘ã—ä½¿ã£ã¦ã¿ã¾ã—ã‚‡ã†ã€‚ <?php $num = 28; $str = "28"; $float = 28.0; $mb_str = "SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³"; print "check1:"; if (is_numeric($num)) { print "true n"; } else { print "false n"; } print "check2:"; if (is_numeric($str)) { print "true n"; } else { print "false n"; } print "check3:"; if (is_int($num)) { print "true n"; } else { print "false n"; } print
KouJustin 2011/12/11
php

MySQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

SQL

DB
ãƒªãƒ³ã‚¯
PHP- SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ - Manual
Getting Started Introduction A simple tutorial Language Reference Basic syntax Types Variables Constants Expressions Operators Control Structures Functions Classes and Objects Namespaces Enumerations Errors Exceptions Fibers Generators Attributes References Explained Predefined Variables Predefined Exceptions Predefined Interfaces and Classes Predefined Attributes Context options and parameters Su
KouJustin 2011/12/11
SQL

php

SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³

DB

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ä»Šå¤œåˆ†ã‹ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³å¯¾ç– â€• ï¼ IT
ã€é–¢é€£è¨˜äº‹ã€‘ æœ¬å†…å®¹ã«ã¤ã„ã¦ã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆè¨˜äº‹ã‚’å…¬é–‹ã—ã¦ã„ã¾ã™ã€‚ã‚ã‚ã›ã¦ã”ç¢ºèªãã ã•ã„ï¼ˆç·¨é›†éƒ¨ï¼‰ Security&Trustã‚¦ã‚©ãƒƒãƒï¼ˆ60ï¼‰ ä»Šå¤œã“ãã‚ã‹ã‚‹å®‰å…¨ãªSQLã®å‘¼ã³å‡ºã—æ–¹ ï½ž é«˜æœ¨æµ©å…‰æ°ã«èžã„ã¦ã¿ãŸ http://www.atmarkit.co.jp/fsecurity/column/ueno/60.html Webã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã«å¯¾ã™ã‚‹æ”»æ’ƒæ‰‹æ³•ã®1ã¤ã§ã‚ã‚‹SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®å˜åœ¨ã¯ã€ã‹ãªã‚ŠåºƒãçŸ¥ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ãŸã€‚ã—ã‹ã—ã€ãã®å¯¾ç–ã¯ã¾ã æœ¬å½“ã«ç†è§£ã•ã‚Œã¦ã„ãªã„ã‚ˆã†ã«æ€ãˆã‚‹ã€‚ãƒ•ã‚©ãƒ¼ãƒ ã‹ã‚‰æ¸¡ã•ã‚ŒãŸå€¤ã®ç‰¹æ®Šæ–‡å—ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ãŸã‚Šã€PHPã®magic_quotes_gpcã¨ã„ã£ãŸè‡ªå‹•ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—æ©Ÿèƒ½ã‚’ã‚ªãƒ³ã«ã™ã‚‹ã ã‘ã§å¯¾ç–ã—ãŸã¤ã‚‚ã‚Šã«ãªã£ã¦ã„ãªã„ã ã‚ã†ã‹ã€‚ åŸºæœ¬ã¯ã‚‚ã¡ã‚ã‚“ã€ã‚»ã‚«ãƒ³ãƒ‰ã‚ªãƒ¼ãƒ€ãƒ¼SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚„ãƒžãƒ«ãƒãƒã‚¤ãƒˆæ–‡å—ã‚’åˆ©ç”¨ã—ãŸSQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã®æ”»æ’ƒãƒ‘ã‚¿ãƒ¼ãƒ³ã‚„ã€ãã®å¯¾
KouJustin 2011/12/11
SQL

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£

DB

ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°
ãƒªãƒ³ã‚¯
[php]pdoã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ã‚¯ãƒ©ã‚¹ï¼ˆO/Rãƒžãƒƒãƒ‘ã®ã‚¹ãƒ¼ãƒ‘ãƒ¼ã‚¯ãƒ©ã‚¹ï¼‰
PDOã‚’ä½¿ã£ãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¢ã‚¯ã‚»ã‚¹ã‚¯ãƒ©ã‚¹ã®ä¸€ä¾‹ã§ã™ã€‚ O/Rãƒžãƒƒãƒ‘ã‚’ä½¿ã£ãŸå ´åˆã®ã‚¹ãƒ¼ãƒ‘ãƒ¼ã‚¯ãƒ©ã‚¹ã«ãªã‚Šã¾ã™ã€‚ ååˆ†ãªæ¤œè¨¼ã¯ã—ã¦ã„ã¾ã›ã‚“ã®ã§ã‚ãã¾ã§å‚è€ƒã«ã€‚ <?php /** *Â DatabaseÂ AccessÂ Class * *Â @packageÂ lib */ classÂ DBO { /** *Â PDOã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆ */ protectedÂ $dbÂ =Â null; /** *Â ãƒ†ãƒ¼ãƒ–ãƒ«å */ protectedÂ $tablenameÂ =Â ''; /** *Â å®šæ•° */ constÂ ORDERBY_DESCÂ =Â 0; constÂ ORDERBY_ASCÂ Â =Â 1; constÂ PAGE_LIMITÂ Â Â =Â 5; /** *Â PDOã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’æ ¼ç´ */ functionÂ __construct($tablename) { //Â PDOã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’ç”Ÿæˆ tryÂ { $dnsÂ =Â DB_T
KouJustin 2011/11/26
PHP

PDO

SQL

DB
ãƒªãƒ³ã‚¯
JavaScriptã®åŸºç¤Žã‹ã‚‰ã¯ã˜ã‚ã‚ˆã† - JavaScriptè¬›åº§
å¤‰æ•°ã¯ä»¥ä¸‹ã®ã‚ˆã†ã«å€¤ã‚’ä»£å…¥ã—ãŸã‚Šå‡ºåŠ›ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ # å¤‰æ•°ã«æ–‡å—åˆ—ã‚’ä»£å…¥ $value = "ãƒ†ã‚¹ãƒˆã§ã™"; # å¤‰æ•°ã‚’å‡ºåŠ› print $value; ã€å‚ç…§ãƒšãƒ¼ã‚¸ã€‘ å¤‰æ•° é…åˆ— è¤‡æ•°ã®å€¤ã‚’1ã¤ã®å¤‰æ•°ã§ç®¡ç†ã—ãŸã„å ´åˆã¯ã€ã€Žé…åˆ—ã€ã¨ã„ã†å¤‰æ•°ãŒæœ€é©ã§ã™ã€‚ é…åˆ—ã‚’åˆæœŸåŒ–ã™ã‚‹å ´åˆã¯ï½¤è¦ç´ ã‚’ã‚«ãƒƒã‚³ã§å›²ã¿ï½¤å„è¦ç´ æ¯Žã«ã‚«ãƒ³ãƒžã§åŒºåˆ‡ã‚Šã¾ã™ï½¡ @week = ('æ—¥æ›œ', 'æœˆæ›œ', 'ç«æ›œ', 'æ°´æ›œ', 'æœ¨æ›œ', 'é‡‘æ›œ', 'åœŸæ›œ'); é…åˆ—ã¯ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’ä½¿ã£ã¦å‚ç…§ã—ã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ 0ã‹ã‚‰å§‹ã¾ã‚‹ã®ã§æ³¨æ„ã—ã¦ãã ã•ã„ã€‚ãŸã¨ãˆã°1ç•ªç›®ã®ãƒ‡ãƒ¼ã‚¿ "æ—¥æ›œ" ã‚’å‘¼ã³å‡ºã™ã¨ãã¯ã€$week[0]ã€"æœˆæ›œ"ãªã‚‰ $week[1] ã¨ã—ã¾ã™ã€‚ # é…åˆ— @week ã®1ç•ªç›®ã®è¦ç´ ã‚’è¡¨ç¤º print $week[0], "\n"; > æ—¥æ›œ # é…åˆ— @week ã®2ç•ªç›®ã®è¦ç´ ã‚’è¡¨ç¤º print $
KouJustin 2011/05/22
SQL

æ¼”ç®—å
ãƒªãƒ³ã‚¯
æ¼”ç®—å - 2éƒ¨ Perlè¨€èªžä»•æ§˜ - [SMART]
1.æ¼”ç®—åã®æ¦‚è¦ æ¼”ç®—åã¯ã€ç®—è¡“æ¼”ç®—åã«ä»£è¡¨ã•ã‚Œã‚‹ã‚ˆã†ã«ã€å¤‰æ•°ã‚„ãƒªãƒ†ãƒ©ãƒ«ãªã©ã®å€¤ã«å¯¾ã—ã¦æ¼”ç®—ã‚’è¡Œã†ãŸã‚ã®è¨˜å·ã§ã™ã€‚ æ¼”ç®—åã®ä¸ã§ã‚‚æœ‰åãªã®ãŒã€åŠ ç®—æ¼”ç®—åã‚„æ¸›ç®—æ¼”ç®—åãªã©ã®ç®—è¡“æ¼”ç®—åã§ã™ã€‚ Perl ã®çµ„ã¿è¾¼ã¿æ¼”ç®—åã¯ã€æ¼”ç®—ã®å¯¾è±¡ã¨ãªã‚‹å€¤ã€ã€Žã‚ªãƒšãƒ©ãƒ³ãƒ‰ã€ã®å€‹æ•°ã«ã‚ˆã£ã¦å˜æ•°æ¼”ç®—åã€äºŒé …æ¼”ç®—åã€ä¸‰é …æ¼”ç®—åã«åˆ†é¡žã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã¾ãŸã€é–“å€¤æ¼”ç®—åã‹å‰ç½®æ¼”ç®—åã‹ã€æ•°å€¤ã€æ–‡å—åˆ—ã€ãƒ•ã‚¡ã‚¤ãƒ«ãªã©æœæŸ»å¯¾è±¡ã«ã‚ˆã£ã¦ã‚‚åˆ†é¡žã§ãã¾ã™ã€‚ãŸã ã—ã€ã“ã‚Œã‚‰ã®åˆ†é¡žã¯ãƒ—ãƒã‚°ãƒ©ãƒŸãƒ³ã‚°ã™ã‚‹ä¸Šã§ã‚ã¾ã‚Šé‡è¦ã§ã¯ãªãã€ä¸€ã¤ä¸€ã¤ã®æ¼”ç®—åã‚’ç†è§£ã™ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ ç”¨èªž ã‚ªãƒšãƒ©ãƒ³ãƒ‰ æ¼”ç®—ã®å¯¾è±¡ã¨ãªã‚‹å€¤ã€‚æ¼”ç®—å†…å®¹ã‚’ã‚ã‚‰ã‚ã™è¨˜å·ã¯æ¼”ç®—åã¨å‘¼ã³ã¾ã™ã€‚ä¾‹ãˆã° 10+X ã¨ã„ã†å¼ã§ã¯ã€10 ã¨ X ãŒã‚ªãƒšãƒ©ãƒ³ãƒ‰ã§ã€+ ãŒã‚ªãƒšãƒ¬ãƒ¼ã‚¿ã§ã™ã€‚ æ¼”ç®—åã®å„ªå…ˆé †ä½ æ¼”ç®—åã«ã¯çµåˆæ€§ã¨å„ªå…ˆé †ä½ãŒã‚ã‚Šã¾ã™ã€‚ æ¼”ç®—åã®ä¸€è¦§ æ¼”ç®—å çµåˆæ€§ è§£èª¬
KouJustin 2011/03/02
SQL

TIPS
ãƒªãƒ³ã‚¯
1