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

kanariia id:kanariia

mysqlã«é–¢ã™ã‚‹kanariiaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (7)

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

PHPã¨jQueryã®çµ„ã¿åˆã‚ã›ã§ajaxãªPOSTã‚’MySQLã«æ ¼ç´ã—ã¦ã¿ãŸ
ã“ã‚“ã«ã¡ã¯ ã‹ãã—ã‚@pinkrootã§ã™ã€‚ æ˜¨æ—¥ã¯ä¹…ã—ã¶ã‚Šã«PHPã§ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã‚’è¡Œã„ã¾ã—ãŸã€‚ å–ã‚Šçµ„ã‚“ã ã®ã¯PHPã¨jQueryã‚’çµ„ã¿åˆã‚ã›ã¦ã€ã‚ã‚‹ãƒœã‚¿ãƒ³ãŒæŠ¼ã•ã‚ŒãŸã¨ãã«ajaxãªPOSTã‚’é£›ã°ã—ã¦ã€ãã®é£›ã‚“ã§ã„ã£ãŸãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‚’MySQLã«æ ¼ç´ã™ã‚‹ã€ã¨ã„ã†æ–‡å—ã§ã®èª¬æ˜ŽãŒé›£ã—ã„å‡¦ç†ã§ã™(ç¬‘) ã‚¤ãƒ¡ãƒ¼ã‚¸ã¨ã—ã¦ã¯ã€ãƒœã‚¿ãƒ³ã‚’æŠ¼ã—ã¦ã‚‚ç”»é¢ãŒãƒªãƒãƒ¼ãƒ‰(æ›´æ–°)ã•ã‚Œãšã€å‡¦ç†ã®è£å´ã§DBã¸ã®ãƒ‡ãƒ¼ã‚¿æ ¼ç´ã‚’è¡Œãªã£ã¦ã„ã‚‹ã€ã¨ã„ã†æ„Ÿã˜ã€‚ å‚™å¿˜éŒ²çš„ã«ã‚„ã‚Šæ–¹ã‚’ã¾ã¨ã‚ã¾ã™ã€‚ HowTo è‡ªåˆ†ã§ä½œæˆã™ã‚‹ãƒ•ã‚¡ã‚¤ãƒ«ã¯ä»¥ä¸‹ã®3ã¤ã€‚ ãƒ¦ãƒ¼ã‚¶ãŒé–²è¦§ã—ã¦ãƒœã‚¿ãƒ³ã‚’æŠ¼ã™ç”»é¢(index.html) ãƒœã‚¿ãƒ³ãŒæŠ¼ã•ã‚ŒãŸã‚‰å‘¼ã³å‡ºã•ã‚Œã‚‹javascriptãƒ•ã‚¡ã‚¤ãƒ«(post.js) ãƒãƒƒã‚¯ãƒœãƒ¼ãƒ³ã§å‹•ä½œã—ã€MySQLã§ãƒ‡ãƒ¼ã‚¿ã‚’æ ¼ç´ã™ã‚‹PHPãƒ•ã‚¡ã‚¤ãƒ«(post.php) ä¸Šè¨˜ãƒ•ã‚¡ã‚¤ãƒ«ã®ä»–ã«ã€ajaxã‚’ä½¿ã†ãŸã‚ã«jQueryã®ãƒ•ã‚¡ã‚¤ãƒ«ãŒå¿…è¦ã¨ãªã‚Š
kanariia 2012/08/13
jquery

php

ajax

mysql
ãƒªãƒ³ã‚¯
WordPressã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ç›´æŽ¥ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹
ã‚¿ã‚¤ãƒˆãƒ«ã‚’å–ã‚Šå‡ºã—ãŸã„ã®ã§ã€Œpost_titleã€ã¨ã„ã†ãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã§ã™ãã€‚ è¤‡æ•°è¡Œã®ãƒ¬ã‚³ãƒ¼ãƒ‰ã‚’å–ã‚Šå‡ºã™å ´åˆã¯ã€Œget_resultsã€é–¢æ•°ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ SQLæ–‡ã¯ã€Œget_resultsã€ã®å¼•æ•°ã«è¨˜è¿°ã—ã¾ã™ã€‚ é€šå¸¸ã®MySQLã®ã‚ˆã†ã«ã€ŒFROM ãƒ†ãƒ¼ãƒ–ãƒ«åã€ã¨è¨˜è¿°ã—ã¦ã‚‚ã„ã„ã®ã§ã™ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«åã®ã€Œwp_ã€ã¨ã„ã†æŽ¥é è¾žã¯ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ™‚ã«å¤‰æ›´ã§ãã‚‹ãŸã‚æŸ”è»Ÿãªãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã‚’ä½œæˆã™ã‚‹ãªã‚‰ç›´æŽ¥æŒ‡å®šã—ãªã„æ–¹ãŒè‰¯ã„ã‚ˆã†ã§ã™ã€‚ Wordpressã§ã¯ä»£ã‚ã‚Šã«å„ãƒ†ãƒ¼ãƒ–ãƒ«ã«å¯¾å¿œã—ãŸãƒ—ãƒãƒ‘ãƒ†ã‚£åã§æŒ‡å®šã—ã¾ã™ã€‚ ãƒ—ãƒãƒ‘ãƒ†ã‚£åã¯åŸºæœ¬çš„ã«ãƒ†ãƒ¼ãƒ–ãƒ«åã‹ã‚‰æŽ¥é è¾žï¼ˆãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯wp_ï¼‰ã‚’é™¤ã„ãŸã‚‚ã®ã«ãªã‚Šã¾ã™ã€‚ã€Œwp_postsã€ãªã‚‰ã€Œpostsã€ã§ã™ãã€‚ ã§ã¯ã€ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆã®é©å½“ãªãƒ•ã‚¡ã‚¤ãƒ«ã«ä¸‹è¨˜ã‚’è¨˜è¿°ã—ã¦å®Ÿè¡Œã—ã¦ãã ã•ã„ã€‚ WordPress ãƒ†ãƒ³ãƒ—ãƒ¬ãƒ¼ãƒˆãƒ•ã‚¡ã‚¤ãƒ« $results = $wpdb->get_resul
kanariia 2012/04/24
wordpress

phpmyadmin

MySQL
ãƒªãƒ³ã‚¯
mysqldump ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã—ãŸã‚Šè»¢é€ã—ãŸã‚Šã™ã‚‹ã‚³ãƒžãƒ³ãƒ‰ä¾‹ | ãƒã‚·ãƒ£ãƒã‚°ã€‚
ã¡ã‚‡ã£ã¨é…ã‚ã®å¤ä¼‘ã¿ã‚’ã‚‚ã‚‰ã£ã¦å…«ä¸ˆå³¶ã«è¡Œã£ã¦ãã¾ã—ãŸ nakamura ã§ã™ï¼ã„ã„æ‰€ã™ãŽã¦å±ã†ããã®ã¾ã¾ç§»ä½ã™ã‚‹ã¨ã“ã‚ã§ã—ãŸã€‚ ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ç§»è¡Œã‚’ã™ã‚‹éš›ã¿ãªã•ã‚“ã©ã‚“ãªæµã‚Œã§ä½œæ¥ã—ã¦ã„ã‚‹ã§ã—ã‚‡ã†ã‹ã€‚ã‚³ãƒžãƒ³ãƒ‰ãƒ©ã‚¤ãƒ³ã§ãƒ€ãƒ³ãƒ—ã‚’å–ã£ã¦ã€ã‚µã‚¤ã‚ºãŒå¤§ãã‹ã£ãŸã‚‰ gzip ã§åœ§ç¸®ã—ã¦ã€WinSCP ã§ãã‚Œã‚’ãƒãƒ¼ã‚«ãƒ«ã«è½ã¨ã—ã¦ãã¦ã€ãã‚Œã‚’ã¾ãŸåˆ¥ã®ã‚µãƒ¼ãƒã«ã‚¢ãƒƒãƒ—ãƒãƒ¼ãƒ‰ã—ã¦ãƒ»ãƒ»ãƒ»ãƒ»ãªã‚“ã¦äº‹ã—ã¦ãŸã‚Šã—ã¾ã›ã‚“ã‹ï¼Ÿ ã‚·ã‚§ãƒ«ã®ãƒ‘ã‚¤ãƒ—ã‚„ãƒªãƒ€ã‚¤ãƒ¬ã‚¯ãƒˆã‚’ã†ã¾ãä½¿ã£ã¦ã‚ã’ã‚Œã°ã€ã“ã®è¾ºã‚Šã¯ã‚³ãƒžãƒ³ãƒ‰ä¸€ç™ºã§ã„ã‘ã¡ã‚ƒã£ãŸã‚Šã™ã‚‹ã®ã§ã™ã€‚ä»Šæ—¥ã¯ãã‚“ãªã‚³ãƒžãƒ³ãƒ‰ä¾‹ã®ã”ç´¹ä»‹ã§ã™ã€‚ å®Ÿéš›ã«ã‚ˆãä½¿ã†ã‚³ãƒžãƒ³ãƒ‰ã®ä¾‹ã‚’ç®‡æ¡æ›¸ãã§ã€‚ ã¨ã‚Šã‚ãˆãšãƒ€ãƒ³ãƒ—ã®çµæžœã‚’ãã®ã¾ã¾åœ§ç¸®ã™ã‚‹ã€‚ mysqldump -udb_user db_name -pdb_pass | gzip > db_name.dump.sql.gz ç‰¹å®šã®æ–‡å—åˆ—ã‚’ç½®æ›ã—ãŸä¸Šã§åœ§ç¸®ã™ã‚‹ã€‚ MT
kanariia 2012/03/30
mysql

tips
ãƒªãƒ³ã‚¯
XAMPP for Windows ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«
XAMPP for Windows ã¨ã¯ï¼Œä»¥ä¸‹ã®ã‚½ãƒ•ãƒˆã‚’ä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã‚½ãƒ•ãƒˆã‚¦ã‚¨ã‚¢ã§ã™ï¼Ž Apache 2.2.9 (Web ã‚µãƒ¼ãƒ) + OpenSSL 0.9.8i MySQL 5.0.67 (ãƒªãƒ¬ãƒ¼ã‚·ãƒ§ãƒŠãƒ«ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ç®¡ç†ã‚·ã‚¹ãƒ†ãƒ ) PHP 5.2.6 & PHP 4.4.9 phpMyAdmin 2.11.9.2 FileZilla FTP Server 0.9.27 Mercury Mail Transport System v4.52 â€» ã‚µãƒ¼ãƒã‚’å…¬é–‹ã™ã‚‹ã®ãªã‚‰ï¼Œã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ã®è¨å®šãŒå¿…è¦ã§ã™ã€‚ãã®å ´åˆã¯ï¼ŒXAMPP ã‚’ä½¿ã‚ãšã«ï¼Œ å„ã‚½ãƒ•ãƒˆã‚’å€‹åˆ¥ã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹æ–¹ãŒæ¥½ã§ã—ã‚‡ã†ï¼Ž ãã®å ´åˆã¯ï¼Œã€ŒApache, MySQL, phpMyAdmin ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã¨è¨å®šã€ã® Web ãƒšãƒ¼ã‚¸ã‚’è¦‹ã¦ãã ã•ã„ï¼Ž ã‚ã‚‰ã‹ã˜ã‚æ±ºã‚ã¦ãŠãäº‹é … MySQL ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹
kanariia 2010/07/16
PHPé–‹ç™ºç’°å¢ƒæ§‹ç¯‰ç”¨

xampp

php

apache

mysql
ãƒªãƒ³ã‚¯
ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹PHPï¼‹MySQLã§æ§‹ç¯‰ã•ã‚ŒãŸã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚«ãƒ¼ãƒˆã‚·ã‚¹ãƒ†ãƒ ã€ŒZeuscartã€:phpspoté–‹ç™ºæ—¥èªŒ
Zeuscart ? Free GPL Ecommerce Shopping Cart Software | Ecommerce Solutions | Online PHP Shopping Carts | Storefront Software ãƒ•ãƒªãƒ¼ã§ä½¿ãˆã‚‹PHPï¼‹MySQLã§æ§‹ç¯‰ã•ã‚ŒãŸã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚«ãƒ¼ãƒˆã‚·ã‚¹ãƒ†ãƒ ã€ŒZeuscartã€ã€‚ Amazonã£ã½ã„ECã‚µã‚¤ãƒˆã®æ§‹ç¯‰ãŒã§ãã‚‹ä¸Šã«ç®¡ç†ç”»é¢ã‚‚ãªã‹ãªã‹å……å®Ÿã—ã¦ã„ã‚‹ã‚ˆã†ã§ã™ã€‚ æ§‹ç¯‰ã•ã‚ŒãŸã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚µã‚¤ãƒˆã€‚UIã‚‚ãªã‹ãªã‹ã‚«ãƒƒã‚³ã„ã„ã€‚ å®Ÿéš›ã«è¦‹ã¦ã¿ã‚‹å ´åˆã¯ã“ã¡ã‚‰ å•†å“è©³ç´°ãƒšãƒ¼ã‚¸ ç®¡ç†ç”»é¢ã§ã¯å£²ã‚ŒãŸã‚‚ã®ã®ã‚°ãƒ©ãƒ•æç”»æ©Ÿèƒ½ãªã‚“ã‹ãŒã¤ã„ã¦ã‚‹ã‚ˆã†ã§ã™ã€‚ ã‚¢ã‚¤ãƒ†ãƒ ç®¡ç†ç”»é¢ ï¼‘ã¤ã®é¸æŠžè‚¢ã¨ã—ã¦è¦šãˆã¦ãŠã„ã¦ã‚ˆã•ãã†ã§ã™ãã€‚ é–¢é€£ã‚¨ãƒ³ãƒˆãƒª PHPã§æ›¸ã‹ã‚ŒãŸæ¬¡ä¸–ä»£ã®ã‚·ãƒ§ãƒƒãƒ”ãƒ³ã‚°ã‚«ãƒ¼ãƒˆã‚·ã‚¹ãƒ†ãƒ ã€ŒTomatoCartã€ ã‚«ãƒ¼ãƒˆãŒç›®ç«‹ãŸãšã€ã„ã„æ„Ÿã˜ã«ã‚¹ãƒ©ã‚¤ãƒ‰ã—ã¦ãã‚Œ
kanariia 2010/07/14
php

ec

mysql
ãƒªãƒ³ã‚¯
çœŸé¢ç›®ã«ã‚¨ãƒã‚µã‚¤ãƒˆã‚’ä½œã£ã¦ã¿ãŸã€ãƒ—ãƒã‚°ãƒ©ãƒžç·¨ã€‘ - BLOGï½œASTRODEO
æ±äº¬éƒ½å°æ±åŒºã§é»™ã€…ã¨ã‚¦ã‚§ãƒ–ã§ã‚µãƒ¼ãƒ“ã‚¹ã‚’é–‹ç™ºã—ã¦ã„ã‚‹æ ªå¼ä¼šç¤¾ã‚¢ã‚¹ãƒˆãƒãƒ‡ã‚ªã®ãƒ›ãƒ¼ãƒ ãƒšãƒ¼ã‚¸ã§ã™ã€‚
kanariia 2010/02/18
php

programming

mysql

webservice

ã“ã‚Œã¯ã™ã”ã„
ãƒªãƒ³ã‚¯
ãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã«PHP+MySQL ã€WordPressæ§‹ç¯‰ã‚’å®Ÿç¾ã™ã‚‹BitNami - ã‹ã¡ã³ã¨.net
kanariia 2009/07/07
è¶…ç°¡å˜ã«ãƒãƒ¼ã‚«ãƒ«ç’°å¢ƒã§WordPressã‚’é‹å–¶ã€ æ§‹ç¯‰ã‚’å®Ÿç¾ã™ã‚‹ã‚½ãƒ•ãƒˆãŒæœ‰ã£ãŸã®ã§ã”ç´¹ä»‹ã€‚ä¹…ã—ã¶ã‚Šã«å‡„ã•ã«æ„Ÿå‹•ã—ã¾ã—ãŸã€‚

wordpress

server

tool

mysql

php
ãƒªãƒ³ã‚¯
1