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

akiraki id:akiraki

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

Zend Frameworkï¼‹MySQLã®æ–‡å—åŒ–ã‘å¯¾ç– - ã‚«ã‚¤ã‚¸ã®ãƒ—ãƒã‚°ãƒ©ãƒžãƒ¼æ—¥è¨˜
PHP5 ï¼‹ Zend Framework 1.9.2 ï¼‹ MySQL5 ã§ã€DBã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã—ãŸã¨ãã«æ–‡å—åŒ–ã‘ã™ã‚‹ã®ã‚’é˜²ãæ–¹æ³•ã«ã¤ã„ã¦ã€‚ ä»¥ä¸‹ã®ã‚ˆã†ã«ã€Œset names utf8ã€ã‚’å…ˆã«ç™ºè¡Œã—ã¦ãŠã‘ã°æ–‡å—åŒ–ã‘ã¯é˜²ã’ã‚‹ãŒã€æ±Žç”¨çš„ãª Zend_Db ã‚’ä½¿ã£ã¦ã„ã‚‹ä»¥ä¸Šã€ã‚„ã¯ã‚Š MySQL ç‰¹æœ‰ã®ã‚³ãƒžãƒ³ãƒ‰ã¯ä½¿ã„ãŸããªã„ã—SQLã‚¤ãƒ³ã‚¸ã‚§ã‚¯ã‚·ãƒ§ãƒ³ã‚’å¼•ãèµ·ã“ã™å¯èƒ½æ€§ãŒã‚ã‚Šã¾ã™ã€‚ï¼ˆå‚è€ƒã€€SET NAMESã¯ç¦æ¢ï¼šhttp://blog.ohgaki.net/set_namesa_mcb_ascï¼‰ $db = Zend_Db::factory('Pdo_Mysql', array( 'host' => 'xxx.xxx.xxx.xxx', 'username' => 'xxx', 'password' => 'xxx', 'dbname' => 'xxx' )); $db->query("set n
akiraki 2010/10/11
mysql

zend
ãƒªãƒ³ã‚¯
mysql_real_escape_string - SQL æ–‡ä¸ã§ç”¨ã„ã‚‹æ–‡å—åˆ—ã®ç‰¹æ®Šæ–‡å—ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã™ã‚‹
string mysql_real_escape_string ( string $unescaped_string [, resource $link_identifier = NULL ] ) ç¾åœ¨ã®æŽ¥ç¶šã®æ–‡å—ã‚»ãƒƒãƒˆã§ unescaped_string ã®ç‰¹æ®Šæ–‡å—ã‚’ã‚¨ã‚¹ã‚±ãƒ¼ãƒ—ã—ã€ mysql_query() ã§å®‰å…¨ã«åˆ©ç”¨ã§ãã‚‹å½¢å¼ã«å¤‰æ›ã—ã¾ã™ã€‚ãƒã‚¤ãƒŠãƒªãƒ‡ãƒ¼ã‚¿ã‚’æŒ¿å…¥ã—ã‚ˆã†ã¨ã—ã¦ã„ã‚‹å ´åˆã€ å¿…ãšã“ã®é–¢æ•°ã‚’åˆ©ç”¨ã—ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ mysql_real_escape_string() ã¯ã€MySQL ã®ãƒ©ã‚¤ãƒ–ãƒ©ãƒªé–¢æ•° mysql_real_escape_string ã‚’ã‚³ãƒ¼ãƒ«ã—ã¦ã„ã¾ã™ã€‚ ã“ã‚Œã¯ä»¥ä¸‹ã®æ–‡å—ã«ã¤ã„ã¦å…ˆé ã«ãƒãƒƒã‚¯ã‚¹ãƒ©ãƒƒã‚·ãƒ¥ã‚’ä»˜åŠ ã—ã¾ã™ã€‚ \x00, \n, \r, \, ', " ãã—ã¦ \x1a. ãƒ‡ãƒ¼ã‚¿ã®å®‰å…¨æ€§ã‚’ç¢ºä¿ã™ã‚‹ãŸã‚ã€MySQL ã¸ã‚¯ã‚¨ãƒªã‚’é€ä¿¡ã™ã‚‹å ´åˆã«ã¯ ï¼ˆã‚ãšã‹
akiraki 2010/07/15
mysql

php

ã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰(MySQL) - Fedoraã§è‡ªå®…ã‚µãƒ¼ãƒãƒ¼æ§‹ç¯‰
[root@fedora ~]# /etc/rc.d/init.d/mysqld startã€€â†ã€€MySQLèµ·å‹• Starting mysqld (via systemctl): [ OK ] [root@fedora ~]# chkconfig mysqld onã€€â†ã€€MySQLè‡ªå‹•èµ·å‹•è¨å®š [root@fedora ~]# mysql_secure_installationã€€â†ã€€MySQLåˆæœŸè¨å®š NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MySQL SERVERS IN PRODUCTION USE! PLEASE READ EACH STEP CAREFULLY! In order to log into MySQL to secure it, we'll need the current passw
akiraki 2009/12/25
Linux

mysql

è‡ªå®…ã‚µãƒ¼ãƒ
ãƒªãƒ³ã‚¯
PHPã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - Mac OSX ã‚’ã„ã˜ã‚‹
akiraki 2009/07/09
mysql

mac

php
ãƒªãƒ³ã‚¯
MacOSXã«PHP5,MySQL5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
MacOSX 10.4ã«MySQL5,Apache2,PHP5ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ï¼ˆMacPortsã‚’ä½¿ç”¨ï¼‰ MacOSX10.4ã«æœ€åˆã‹ã‚‰å…¥ã£ã¦ã„ã‚‹ã®ã¯ã€Apache1.xã‚„PHP4.xã¨å¤ã„ã€‚ï¼ˆMySQLã¯å…¥ã£ã¦ã„ãªã‹ã£ãŸã¯ãšï¼‰ ãã“ã§ã€MacPortsã§ã€MacOSX10.4ã«ã€MySQL5ã€Apache2ã€PHP5ã‚’å…¥ã‚Œã€å‹•ã‹ã™æ–¹æ³•ã‚’ã„ã‚ã„ã‚ãƒãƒƒãƒˆã‚„æœ¬ã§èª¿ã¹ã¦ã¾ã¨ã‚ã¦ã¿ãŸã€‚ é–“é•ã£ã¦ã„ã‚‹éƒ¨åˆ†ã‚’ã”æŒ‡æ‘˜ã„ãŸã ã‘ã‚Œã°ã‚ã‚ŠãŒãŸã„ã€‚ MacPortsã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã‚„ä½¿ã„æ–¹ã¯ã€ã“ã¡ã‚‰ã‚’å‚è€ƒã«ã—ãŸã€‚ http://d.hatena.ne.jp/hakobe932/20061208/1165646618 ã‚½ãƒ•ãƒˆè‡ªä½“ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯ã“ã¡ã‚‰ã‚’å‚è€ƒã«ã—ãŸã€‚ http://einekatze.jp/mt/archives/2006/08/mac_prodarwinports.html â– /etc/profi
akiraki 2009/07/09
mysql

MacPorts

mac

php
ãƒªãƒ³ã‚¯
Mac OS X 10.5 Leopardã®Railsç’°å¢ƒ ãã®2ï¼šApacheã€PHPã€MySQLã€Webminã€phpMyAdmin: Cyber Support
Railsã‚’ä½¿ã†ãŸã‚ã«ã€MySQLã‚’å…¥ã‚Œã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ã™ã‚‹ã¨ã€ãã‚Œã‚’å‹•ã‹ã™ãŸã‚ã«phpMyAdminãŒã‚ã£ãŸæ–¹ãŒä¾¿åˆ©ã§ã™ã€‚ã¨ã„ã†ã“ã¨ã¯ã€Apacheã¨PHPãŒå¿…è¦ã¨ãªã‚Šã¾ã™ã€‚ãã‚Œã‚‰ã‚’è¨å®šã™ã‚‹ã®ã«Webminã‚‚ã‚ã‚‹ã¨ä¾¿åˆ©ã§ã™ã€‚ ã¨ã„ã†æ„Ÿã˜ã§ã€ã„ã‚ã„ã‚å…¥ã‚Œã¦ã¿ã¾ã—ãŸãŒã€çµæ§‹ã¯ã¾ã£ã¦1æ—¥ã‹ã‹ã£ã¦ã—ã¾ã„ã¾ã—ãŸã€‚ ã“ã‚Œã‚‰ã‚’å…¥ã‚Œã‚‹æ–¹æ³•ã¯MacPortsã‚„Finkã«ã‚ˆã‚‹ã¾ã¨ã‚ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€å„ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã®å€‹åˆ¥ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€ãã—ã¦Mac OS X Leopardæ¨™æº–ã®ã‚‚ã®ã€ã¨ã„ãã¤ã‹ã‚ã‚Šã¾ã™ã€‚ ä»Šå›žRailsã‚’Leopardæ¨™æº–ã®ã‚‚ã®ã¨ã—ãŸã®ã§ã€ ãƒ»åŒæ§˜ã«Leopardã«æ¨™æº–ã§å…¥ã£ã¦ã„ã‚‹ã‚‚ã®ã¯ãã®ã¾ã¾ä½¿ã† ãƒ»ä¸è¶³ã™ã‚‹ã‚‚ã®ã¯Finkã§è¿½åŠ ã™ã‚‹ ã¨ã„ã†æ–¹é‡ã§ã‚„ã£ã¦ã¿ã¾ã—ãŸã€‚å€‹åˆ¥ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¯å¾Œã§ç®¡ç†ãŒå¤§å¤‰ã«ãªã‚‹ã®ã§ã€æ¨™æº–ã¾ãŸã¯ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ç®¡ç†ã‚½ãƒ•ãƒˆï¼ˆFinkã‚„MacPortsï¼‰ã«ä»»ã›ã¦ã—ã¾ã„ãŸã„ã¨ã„ã†ç†ç”±ã§ã™
akiraki 2009/07/09
mac

mysql
ãƒªãƒ³ã‚¯
phpMyAdminã®è¨ç½® | @niftyãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã‚µãƒ¼ãƒ“ã‚¹ : @nifty
HOME / ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« / ã‚¦ã‚§ãƒ–ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³è¨ç½®ãƒžãƒ‹ãƒ¥ã‚¢ãƒ« / phpMyAdminã®è¨ç½® è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä¿®æ£ã™ã‚‹ â– ãƒ•ã‚¡ã‚¤ãƒ«ã‚’è§£å‡ã™ã‚‹ ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã—ãŸã€ã€ŽphpMyAdmin-2.8.1.zipã€ã‚’è§£å‡ã—ã¾ã™ã€‚ åœ§ç¸®ã•ã‚ŒãŸãƒ•ã‚¡ã‚¤ãƒ«ã®è§£å‡ã«ã¯è§£å‡ã‚½ãƒ•ãƒˆã‚’ãŠä½¿ã„ãã ã•ã„ã€‚ â– è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã‚’ä½œæˆã™ã‚‹ ãƒ•ã‚¡ã‚¤ãƒ«ã®è§£å‡ãŒçµ‚ã‚ã£ãŸã‚‰ã€ã€Žlibrariesã€ãƒ•ã‚©ãƒ«ãƒ€ã®ä¸ã«ã‚ã‚‹è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã€Žconfig.default.phpã€ã‚’ã‚³ãƒ”ãƒ¼ã—ã¦ã€Žconfig.inc.phpã€ã¨ã„ã†åå‰ã§librariesãƒ•ã‚©ãƒ«ãƒ€ã®ã²ã¨ã¤ä¸Šã®ãƒ•ã‚©ãƒ«ãƒ€ã«ä¿å˜ã—ã¾ã™ã€‚ ä¿å˜ã—ãŸã€Žconfig.inc.phpã€ã‚’ãƒ¡ãƒ¢å¸³ç‰ã®ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã§é–‹ãã€ä»¥ä¸‹ã®ä¾‹ã«ãã£ã¦ç·¨é›†ã—ã¦ãã ã•ã„ã€‚ â€» ãƒ¡ãƒ¢å¸³ã§é–‹ã„ãŸå ´åˆã€æ”¹è¡Œã•ã‚Œãšä¸€è¡Œã§è¡¨ç¤ºã•ã‚Œã‚‹å ´åˆãŒã‚ã‚Šã¾ã™ã€‚ ãã®å ´åˆã¯ã€ä»–ã®ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ãƒ¼ã‚’åˆ©ç”¨ã—ã¦ãã ã•ã„ã€‚ ã‚ˆãåˆ†ã‹ã‚‰ãªã„ã‹
akiraki 2009/07/09
mysql

php
ãƒªãƒ³ã‚¯
MacPortsã‚’ä½¿ã£ã¦Macã«MySQLã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - æ‹¡å¼µç¾å®Ÿãƒ©ã‚¤ãƒ•
2024/12/27 ãƒ™ã‚¤ã‚¹ã‚¿ãƒ¼ã‚ºã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ã‚¿ãƒªãƒ¼æ˜ ç”»ã€Œå‹ã¡åˆ‡ã‚‹è¦šæ‚Ÿã€ã‚’è¦‹ãŸï¼ ã‚·ãƒ¼ã‚ºãƒ³çµ‚ç›¤ï½žæ—¥æœ¬ã‚·ãƒªãƒ¼ã‚ºå„ªå‹ã¾ã§ã®èˆžå°è£ã‚’æŠ‘ãˆãŸãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ã‚¿ãƒªãƒ¼ã§ã€ãƒ™ãƒ³ãƒè£ã§ã®æ˜ åƒãŒãƒ¡ã‚¤ãƒ³ã¨ãªã£ã¦ã„ã‚‹ã€‚ãƒŠãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã¯ç„¡ãã€èª¬æ˜ŽãŒã»ã¨ã‚“ã©ç„¡ã„ã®ã§ã€Œã„ã¤ä½•ãŒã‚ã£ãŸã‹ã€ãŒã‚ã‚‰ã‹ã˜ã‚ã‚ã‹ã£ã¦â€¦
akiraki 2009/07/08
MacPorts

mysql

mac
ãƒªãƒ³ã‚¯
http://www.adamrocker.com/blog/91/sakura_internet_mysql.html
akiraki 2009/07/06
ã•ãã‚‰ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆ

mysql
ãƒªãƒ³ã‚¯
1