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

proto_jp id:proto_jp

phpã¨mysqlã«é–¢ã™ã‚‹proto_jpã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (14)

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

ã€Œæ–°å…¥ç¤¾å“¡ã®ãŸã‚ã®å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ é–‹ç™ºå…¥é–€ ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç·¨ã€ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å…¬é–‹ã—ã¾ã—ãŸï½œæŠ€è¡“ãƒ–ãƒã‚°ï½œåŒ—æµ·é“æœå¹Œå¸‚ãƒ»å®®åŸŽçœŒä»™å°å¸‚ã®VRãƒ»ã‚²ãƒ¼ãƒ ãƒ»ã‚·ã‚¹ãƒ†ãƒ é–‹ç™º ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—
ã€Œæ–°å…¥ç¤¾å“¡ã®ãŸã‚ã®å¤§è¦æ¨¡ã‚²ãƒ¼ãƒ é–‹ç™ºå…¥é–€ ã‚µãƒ¼ãƒã‚µã‚¤ãƒ‰ç·¨ã€ã®ã‚¹ãƒ©ã‚¤ãƒ‰ã‚’å…¬é–‹ã—ã¾ã—ãŸ matsuiã§ã™ã€‚ å…ˆé€±æœ«ã®2014å¹´6æœˆ13æ—¥ï½ž14æ—¥ã«ã€æœå¹Œã§ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ 2014 HokkaidoãŒè¡Œã‚ã‚Œã¾ã—ãŸã€‚ å¼Šç¤¾ã‚¤ãƒ³ãƒ•ã‚£ãƒ‹ãƒƒãƒˆãƒ«ãƒ¼ãƒ—ã‚‚ã‚¹ãƒãƒ³ã‚µãƒ¼ã¨ã—ã¦ã€ã‚»ãƒŸãƒŠãƒ¼ã®ç™ºè¡¨ã‚’1ã‚³ãƒžã¨ã€ãƒ–ãƒ¼ã‚¹ã‚’å‡ºã•ã›ã¦ã„ãŸã ãã¾ã—ãŸã€‚ ãã®éš›ã«ä½¿ç”¨ã—ãŸã‚¹ãƒ©ã‚¤ãƒ‰è³‡æ–™ã‚’å…¬é–‹ã—ã¾ã—ãŸã®ã§ã€ã©ã†ãžã”è¦§ä¸‹ã•ã„ã€‚ ãŠã‹ã’ã•ã¾ã§æº€å¸ã§ã—ãŸã€‚æ¥ã¦é ‚ã„ãŸæ–¹ã‚ã‚ŠãŒã¨ã†ã”ã–ã„ã¾ã™ã€‚ è¬›å¸«ã®ä½ã€…æœ¨ã€ãªãœã‹ç™½è¡£ã§ã™ï¼ˆç†ç§‘ã®å…ˆç”Ÿã«æ†§ã‚Œã¦ã‚‹ã‚‰ã—ã„ï¼‰ã€‚ ãƒ–ãƒ¼ã‚¹ã¯ã“ã®ã‚ˆã†ãªæ„Ÿã˜ã§ã™ã€‚ æ–°ä½œã‚²ãƒ¼ãƒ ã§ã‚ã‚‹ã€Œå‹‡è€…ã¨1000ã®é”çŽ‹ã€ã¨ã€Androidç”¨ã®ã‚¿ã‚¤ãƒ ã‚«ãƒ¼ãƒ‰ã‚¢ãƒ—ãƒªã§ã‚ã‚‹ã€Œã‹ã–ã—ã¦ã‚·ãƒ¥ã‚ãƒ¼ãƒ³ã€ã‚’å±•ç¤ºã—ã¾ã—ãŸã€‚ ãƒ„ã‚¤ãƒ¼ãƒˆ
proto_jp 2014/06/16
game

php

db

sql

mysql
ãƒªãƒ³ã‚¯
CentOS 6.4ã§Nginx, php-fpï½, MySqlã§Wordpressã‚’ã„ã¡ã‹ã‚‰è¨å®šã™ã‚‹æ‰‹é † - ã‚³ãƒ³ãƒ¦ã‚¦ãƒ¡ãƒ¢ @kon_yu
ä½¿ã†ã®ã•ãã‚‰ã®VPS ã¡ã‚‡ã£ã¨OSã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚ŒãŸçŠ¶æ…‹ã‹ã‚‰è¨å®šã™ã‚‹æ©Ÿä¼šãŒã‚ã£ãŸã‹ã‚‰ä½œæ¥å·¥ç¨‹ã‚’ãƒ¡ãƒ¢ ãƒ¦ãƒ¼ã‚¶ã®ä½œæˆã‹ã‚‰ã€SSHã®è¨å®šã—ã¦wordpressèµ·å‹•ã¾ã§ã€‚MySQLã‚„Nginxã®èª¿æ•´ã¯ã—ã¦ãªã„ã€‚ æŠ€è¡“çš„ã«ã™ã”ã„ã“ã¨ã¯ã—ã¦ãªã„ã‘ã©ã€ã“ã‚Œç³»ã¯å¿˜ã‚ŒãŒã¡ã ã—åˆå¿ƒè€…æ§˜ã®ãŠå½¹ã«ç«‹ã¦ã‚Œã°ã¨æ€ã†ã€‚ ã¡ãªã¿ã«centOSã®ãƒãƒ¼ã‚¸ãƒ§ãƒ³ç¢ºèªã¯ã“ã† > cat /etc/redhat-release CentOS release 6.4 (Final) ãƒ¦ãƒ¼ã‚¶ä½œæˆ > useradd xxx ãƒ¦ãƒ¼ã‚¶ã®ãƒ‘ã‚¹ãƒ¯ãƒ¼ãƒ‰ä½œæˆ wheelã‚°ãƒ«ãƒ¼ãƒ—ã«è¿½åŠ > passwd xxx > usermod -G wheel xxx # ã‚°ãƒ«ãƒ¼ãƒ—ã«è¿½åŠ ã•ã‚Œã¦ã„ã‚‹ã‹ç¢ºèª > cat /etc/group |grep xxx #ãƒã‚°ã‚¢ã‚¦ãƒˆã—ã¦sshã§ãƒã‚°ã‚¤ãƒ³ã§ãã‚‹ã“ã¨ã‚’ç¢ºèª wheelã®ãƒ¦ãƒ¼ã‚¶ãƒ¼ã ã‘suã§ãã‚‹ã‚ˆã†ã«ã™ã‚‹ >emac
proto_jp 2014/03/07
nginx

mysql

php
ãƒªãƒ³ã‚¯
ã•ãã‚‰VPS(CentOS6)ã«Nginx+PHP5.5+MySQL5.6ã®ç’°å¢ƒã‚’æ§‹ç¯‰ã™ã‚‹(ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ç·¨) - atijust's blog
ã•ãã‚‰VPSï¼ˆCentOS6ï¼‰ã«Nginx+PHP5.5+MySQL5.6ã®ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¦Laravelã‚’å‹•ã‹ã™ã¾ã§ã®è¨˜éŒ²ã‚’å‚™å¿˜éŒ²ã¨ã—ã¦æ®‹ã—ã¦ãŠãã¾ã™ã€‚ Nginxã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« å…¬å¼ã‚µã‚¤ãƒˆã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã®èª¬æ˜Žã«å¾“ã£ã¦ã€å…¬å¼ã®yumãƒªãƒã‚¸ãƒˆãƒªã‹ã‚‰Stableç‰ˆã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ ã¾ãšã¯CentOS6ç”¨ã®yumãƒªãƒã‚¸ãƒˆãƒªã®ã‚»ãƒƒãƒˆã‚¢ãƒƒãƒ—ã€‚ ãƒ¬ãƒã‚¸ãƒˆãƒªã®è¨å®šãƒ•ã‚¡ã‚¤ãƒ«ã¨PGPã‚ãƒ¼ãŒã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã•ã‚Œã¾ã™ã€‚ # rpm -ivh http://nginx.org/packages/centos/6/noarch/RPMS/nginx-release-centos-6-0.el6.ngx.noarch.rpm æ¬¡ã«yumã§nginxã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã€‚ # yum install nginx ãƒãƒ¼ã‚¸ãƒ§ãƒ³ã¨ãƒ“ãƒ«ãƒ‰ã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³ã‚’ç¢ºèªã—ã¾ã™ã€‚ # nginx -V nginx version:
proto_jp 2014/02/27
sakuraVPS

nginx

php

mysql
ãƒªãƒ³ã‚¯
2/3 MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’Excelã®æ›¸é¡žã¨ã—ã¦å‡ºåŠ› [ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹] All About
MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’Excelã®æ›¸é¡žã¨ã—ã¦å‡ºåŠ›(2ãƒšãƒ¼ã‚¸ç›®)MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†…å®¹ã‚’PEARã®ãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã€ŒSpreadsheet_Excel_Writerã€ã‚’ä½¿ç”¨ã—ã¦Excelã®æ›¸é¡žã¨ã—ã¦å‡ºåŠ›ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã‚’ç´¹ä»‹ã—ã¾ã™ 1. MySQLã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å†…å®¹ã‚’Excelã®æ›¸é¡žã¨ã—ã¦å‡ºåŠ›ã™ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ (myphp14.php)ã‚’ä½œæˆ ä¸‹è¨˜ã®å†…å®¹ã‚’ãƒ†ã‚ã‚¹ãƒˆã‚¨ãƒ‡ã‚£ã‚¿ã«ã‚³ãƒ”ãƒ¼ã—ã€ãƒ•ã‚¡ã‚¤ãƒ«åã‚’ã€Œmyphp14.phpã€ã¨ã—ã¦ ã€ŒC:\xampp\htdocs\testã€å†…ã«ä¿å˜ã—ã¾ã™ã€‚ ï¼Šæ³¨æ„ ---ã€Œmyphp14.phpã€ãƒ•ã‚¡ã‚¤ãƒ«ã®æ–‡å—ã‚³ãƒ¼ãƒ‰ã¯ã€ŒSJISã€ã‚’æŒ‡å®šã—ã¦ä¿å˜ã—ã¦ãã ã•ã„ã€‚ PHPã‚¨ãƒ‡ã‚£ã‚¿ã‚„ ã‚µã‚¯ãƒ©ã‚¨ãƒ‡ã‚£ã‚¿ãªã©æ–‡å—ã‚³ãƒ¼ãƒ‰ã‚’æŒ‡å®šã§ãã‚‹ã‚¨ãƒ‡ã‚£ã‚¿ã‚’ä½¿ã†ã¨ä¾¿åˆ©ã§ã™ã€‚ <?php //ã‚¨ã‚¯ã‚»ãƒ«ã‚·ãƒ¼ãƒˆä½œæˆã«å¿…è¦ãªãƒ¢ã‚¸ãƒ¥ãƒ¼ãƒ«ã‚’ä¸€åº¦ã ã‘èªã¿è¾¼ã‚€ require_once("Spreadsheet/Ex
proto_jp 2013/10/31
php

excel

mysql
ãƒªãƒ³ã‚¯
MySQLã®INSERTæ–‡ï¼ˆæ–¹æ³•ã”ã¨ã®å‡¦ç†æ™‚é–“æ¯”è¼ƒï¼‰
å¤§é‡ã®ãƒ‡ãƒ¼ã‚¿ã‚’INSERTã™ã‚‹å ´é¢ãŒã‚ã£ã¦ãªã‚“ã¨ã‹é«˜é€ŸåŒ–ã§ããªã„ã‹ã¨æ€ã£ã¦ã€ ä»¥ä¸‹ã®æ‰‹æ³•ã‚’æ¯”è¼ƒã—ã¦ã¿ãŸã€‚ 1ä»¶ãšã¤INSERTã™ã‚‹ ãƒˆãƒ©ãƒ³ã‚¶ã‚¯ã‚·ãƒ§ãƒ³ã‚’ä½¿ç”¨ã™ã‚‹ 1ã‚¯ã‚¨ãƒªã§ã¾ã¨ã‚ã¦INSERTã™ã‚‹ ãƒ†ã‚¹ãƒˆç’°å¢ƒã¯ä»¥ä¸‹ã®é€šã‚Šã€‚ MySQL 5.1 ãƒ†ãƒ¼ãƒ–ãƒ«ã¯InnoDBã€AUTO_INCREMENTä»˜ãï¼ˆinnodb_autoinc_lock_mode=1ï¼‰ PHP 5.3.6 1000ä»¶ã€3000ä»¶ã€5000ä»¶ã€10000ä»¶ã¨ä»¶æ•°ã‚’å¢—ã‚„ã—ãªãŒã‚‰ãã‚Œãžã‚Œ5å›žãšã¤è©¦è¡Œã—ã¦å¹³å‡ã‚’å–ã£ã¦ã„ã‚‹ã€‚ ä½¿ç”¨ã—ãŸã‚³ãƒ¼ãƒ‰ã¯æœ€å¾Œã«ã€‚ çµæžœ æ‰‹æ³• 1,000ä»¶ 3,000ä»¶ 5,000ä»¶ 10,000ä»¶ 1ä»¶ãšã¤INSERTã™ã‚‹
proto_jp 2012/03/12
mysql

sql

php
ãƒªãƒ³ã‚¯
ãƒˆãƒƒãƒ—ãƒšãƒ¼ã‚¸|Scuttle-ja
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã‚·ã‚¹ãƒ†ãƒ ã€ŒScuttleã€æ—¥æœ¬èªžç‰ˆã®ã‚µãƒãƒ¼ãƒˆã‚µã‚¤ãƒˆã§ã™ã€‚ â€»æ˜Žã‘ã¾ã—ã¦ãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™ã€‚ã¾ã ç«‹ã¡ä¸Šã’ãŸã°ã‹ã‚Šã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§ã™ãŒã€ã‚ˆã‚ã—ããŠé¡˜ã„ã—ã¾ã™ã€‚ ãƒ‡ãƒ¢ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã®ä»•æ–¹ ä½¿ã„æ–¹ ãŸã¾ãŸã¾ã“ã®ã‚µã‚¤ãƒˆã‚’è¦‹ã¤ã‘ã¦æ¥ã‚‰ã‚ŒãŸæ–¹ã¸ http://code.google.com/p/scuttle-ja/source/list ä¸Šè¨˜ã®ã‚ˆã†ãªä½œæ¥ã‚’ã—ã¦ã¾ã™ã€‚ä½•ã‹ã®å‚è€ƒã«ãªã‚Œã°ã¨ã€‚ æ˜Žã‘ã¾ã—ã¦ãŠã‚ã§ã¨ã†ã”ã–ã„ã¾ã™ã€‚ã“ã“ã¾ã§ä»•ä¸Šã’ã¦ãŠã„ã¦ä»Šã•ã‚‰æ°—ã¥ã„ãŸã®ã§ã™ãŒã€SemanticScuttleãªã‚‹ã‚‚ã®ãŒã™ã§ã«ã‚ã‚‹ã‚‰ã—ãã€‚ã“ã‚Œã‹ã‚‰èª¿æŸ»ã—ã¾ã™ (1/4) ãƒ‡ãƒ¢ãƒ³ã‚¹ãƒˆãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’è¨ç½®(12/31) ãƒžãƒ¼ã‚¸å®Œäº†ã—ã¾ã—ãŸã€‚ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™(12/30) ä»Šæ—¥å‡ºãŸã°ã‹ã‚Šã®0.9.0ã®ãƒžãƒ¼ã‚¸ã¯ã‚ã¨ã§è¡Œãªã„ã¾ã™(12/29)
proto_jp 2011/07/04
@php

sbm

socialbookmark

webservice

php

mysql
ãƒªãƒ³ã‚¯
åŸºç¤Žã‹ã‚‰ç†è§£ã™ã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ã—ãã¿ï¼ˆ5ï¼‰ï¼šITpro
SQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹éš›ã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã«å¤§ããªå½±éŸ¿ã‚’åŠã¼ã™ã‚‚ã®ã¨ã—ã¦ï¼Œã‚‚ã†ä¸€ã¤ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ãŒã‚ã‚Šã¾ã™ã€‚ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã«ã¤ã„ã¦ã¯ï¼Œã©ã†å®šç¾©ã™ã¹ãã‹ã¨ã„ã†ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹è¨è¨ˆä¸Šã®å•é¡Œã¨ï¼Œã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’æœ‰åŠ¹ã«ä½¿ã†ãŸã‚ã®SQLæ–‡ã‚’ã©ã†æ›¸ãã¹ãã‹ã¨ã„ã†ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ä¸Šã®å•é¡ŒãŒã‚ã‚Šã¾ã™ã€‚ ã“ã“ã§ã¯ãƒ†ãƒ¼ãƒ–ãƒ«è¨è¨ˆä¸Šã®å•é¡Œã‚’ä¸»ã«å–ã‚Šä¸Šã’ã¾ã™ã€‚SQLæ–‡ã®ã‚³ãƒ¼ãƒ‡ã‚£ãƒ³ã‚°ã«ã¤ã„ã¦ã¯å›²ã¿è¨˜äº‹ã€ŒSQLæ–‡ã‚’æœ€é€Ÿã«ã™ã‚‹11ã®ãƒã‚¤ãƒ³ãƒˆã€ã‚’å‚ç…§ã—ã¦ãã ã•ã„ã€‚ ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã¯ï¼Œãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¤œç´¢é€Ÿåº¦ã‚’å‘ä¸Šã•ã›ã‚‹ãŸã‚ã®ã‚‚ã®ã§ã™ã€‚ãã‚Œãžã‚Œã®SQLæ–‡ã«å¯¾ã—ã¦æœ€é©ãªã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹ã®ãŒç†æƒ³çš„ã§ã™ãŒï¼Œå®Ÿéš›ã«ã¯ã‚ã‚‹ç¨‹åº¦é™ã‚‰ã‚ŒãŸã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã§ï¼Œå¿…è¦ãªãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹è¦ä»¶ã‚’æº€ãŸã™ã‚ˆã†ã«ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã™ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚åŠ ãˆã¦ï¼Œã©ã‚“ãªSQLæ–‡ãŒå®Ÿéš›ã«ç™ºè¡Œã•ã‚Œã‚‹ã®ã‹ãŒã‚ã‚‰ã‹ã˜ã‚ã‚ã‹ã£ã¦ã„ãªã„å ´åˆã¯ï¼Œé©å½“ãªæƒ³å®šã«åŸºã¥ã„ã¦ã‚¤ãƒ³ãƒ‡ãƒƒã‚¯ã‚¹ã‚’å®šç¾©ã—ã¦ãŠã‹ãªãã¦ã¯
proto_jp 2011/01/24
sql

mysql

php
ãƒªãƒ³ã‚¯
PHPã§32æ–‡å—16é€²æ•°ã®ãƒ¦ãƒ‹ãƒ¼ã‚¯IDã®ä½œæˆã™ã«ã¯ï¼Ÿ - motooLogue
proto_jp 2010/11/15
@php

php

db

mysql
ãƒªãƒ³ã‚¯
PHPã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’ç”Ÿæˆã™ã‚‹ï¼šuniqid() - kakakakakku blog
PHPã§ãƒ¦ãƒ‹ãƒ¼ã‚¯ãª(ä¸€æ„ãª)IDã‚’ç”Ÿæˆã—ãŸã„å ´åˆã«ã€Œuniqidã€ã¨ã„ã†é–¢æ•°ãŒåˆ©ç”¨ã§ãã‚‹ï¼Ž string uniqid ([ string $prefix [, bool $more_entropy ]] ) ãƒžã‚¤ã‚¯ãƒç§’å˜ä½ã®ç¾åœ¨æ™‚åˆ»ã«ã‚‚ã¨ã¥ã„ãŸã€æŽ¥é è¾žã¤ãã®ä¸€æ„ãª ID ã‚’å–å¾—ã—ã¾ã™ã€‚ PHP: uniqid - Manual $prefixãªã— $prefix(æŽ¥é è¾ž)ãªã—ã§åˆ©ç”¨ã™ã‚‹ã¨ï¼Œ13æ–‡å—ã®æ–‡å—åˆ—ãŒç”Ÿæˆã•ã‚Œã‚‹ï¼Ž [ä¾‹] 48f7146e6ea07 <?php echo uniqid(); echo uniqid(""); ?> $prefixã‚ã‚Š $prefixã«ä»»æ„ã®æ–‡å—åˆ—ã‚’æŒ‡å®šã™ã‚‹ã¨ï¼ŒæŽ¥é è¾žã®å¾Œã«13æ–‡å—ã®æ–‡å—åˆ—ãŒç”Ÿæˆã•ã‚Œã‚‹ [ä¾‹] UNIQ_48f718480b738 <?php echo uniqid("UNIQ_"); ?> $prefixã«ä¹±æ•°ã‚’æŒ‡å®šã™ã‚‹ ãƒžã‚¤ã‚¯ãƒç§’å˜
proto_jp 2010/11/15
@php

php

mysql

db
ãƒªãƒ³ã‚¯
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è³ªå• å†™çœŸå…±æœ‰ã‚µã‚¤ãƒˆã¨ã‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã¨ã‹ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã§ã¯ã€ï¼‘ã¤ã®å†™çœŸï¼ˆãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã€è¨˜äº‹ï¼‰ã”ã¨ã«ã‚¿ã‚°ã‚’ä»˜ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªâ€¦
ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®è³ªå• å†™çœŸå…±æœ‰ã‚µã‚¤ãƒˆã¨ã‹ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã¨ã‹ãƒ–ãƒã‚°ã‚µãƒ¼ãƒ“ã‚¹ã¨ã‹ã§ã¯ã€ï¼‘ã¤ã®å†™çœŸï¼ˆãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ã€è¨˜äº‹ï¼‰ã”ã¨ã«ã‚¿ã‚°ã‚’ä»˜ã‘ã‚‰ã‚Œã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã‚ˆãã€‚ ã€Œäººæ°—ã®ã‚¿ã‚°ã€ã‚„ã€Œæ³¨ç›®ã®ã‚¿ã‚°ã€ã¿ãŸã„ãªæ„Ÿã˜ã§æ¤œç´¢ã‚‚ã§ãã‚‹ã‚ˆã†ã«ãªã£ã¦ã„ã¾ã™ã‚ˆãã€‚ ã“ã®ã‚¿ã‚°ã¨ã„ã†ã®ã¯ã€ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã§ã¯ã©ã®ã‚ˆã†ãªå½¢ã§ãƒ‡ãƒ¼ã‚¿ã‚’æŒã£ã¦ã„ã‚‹ã®ã§ã—ã‚‡ã†ã‹ï¼Ÿ ä¾‹ãˆã°å†™çœŸå…±æœ‰ã‚µã‚¤ãƒˆã‚’ä½œã‚‹ã¨ã—ã¦ã€ï¼‘ã¤ã®å†™çœŸã”ã¨ã«ä»¥ä¸‹ã®å†…å®¹ã‚’ç™»éŒ²ã—ã¦ã‚‚ã‚‰ã†ã“ã¨ã«ã—ã¾ã™ã€‚ ãƒ»å†™çœŸã‚¿ã‚¤ãƒˆãƒ« ãƒ»ãƒ•ã‚¡ã‚¤ãƒ«å ãƒ»æ’®å½±è€…ï¼ˆåˆ©ç”¨ãƒ¦ãƒ¼ã‚¶ãƒ¼ï¼‰ ãƒ»ã‚¿ã‚°ï¼ˆè¤‡æ•°ã‚¿ã‚°ã®ç™»éŒ²å¯ï¼‰ ã“ã®å ´åˆã€ã©ã®ã‚ˆã†ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œã‚Œã°ã„ã„ã®ã§ã—ã‚‡ã†ï¼Ÿ ï¼ˆï¼‘ã¤ã®å†™çœŸã‚„è¨˜äº‹ã«å¯¾ã—ã¦è¤‡æ•°ã®ã‚¿ã‚°ãŒå…¥ã‚Œã‚‹ã“ã¨ãŒã§ãã¦ã€ãã‚Œã‚‰ã®ã‚¿ã‚°ã‚’ã‚ãƒ¼ã«ã—ã¦æ¤œç´¢ã‚„ã‚¿ã‚°ã®é›†è¨ˆã‚’ã©ã†ã‚„ã£ã¦ã„ã‚‹ã®ã‹ã‚’çŸ¥ã‚ŠãŸã„ã§ã™ã€‚ï¼‰
proto_jp 2010/11/07
websit

webservice

tag

database

php

sql

mysql

@php

db
ãƒªãƒ³ã‚¯
MySQLã¸ã®æŽ¥ç¶š
PHP ã§ã¯è‰²ã€…ãªãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã«ã‚¢ã‚¯ã‚»ã‚¹ã—ã¦åˆ©ç”¨ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ PHP ã‹ã‚‰ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€ã¤ã§ã‚ã‚‹ MySQL ã¸æŽ¥ç¶šã™ã‚‹æ–¹æ³•ã«ã¤ã„ã¦è§£èª¬ã—ã¾ã™ã€‚ â€» MySQL ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã‚„ã‚ˆã‚Šè©³ç´°ãªåˆ©ç”¨æ–¹æ³•ã«ã¤ã„ã¦ã¯ã€ŒMySQLã®ä½¿ã„æ–¹ã€ã‚’å‚ç…§ã—ã¦ä¸‹ã•ã„ã€‚
proto_jp 2010/08/31
@php

php

mysql

reference

@reference
ãƒªãƒ³ã‚¯
MySQLã§ INSERTæ™‚ã«é‡è¤‡ã™ã‚‹ KEYãŒæ—¢ã«å˜åœ¨ã™ã‚‹å ´åˆã®å‹•ä½œã®ã‚ªãƒ—ã‚·ãƒ§ãƒ³
â–º 2018 (1) â–º 1æœˆ (1) â–º 2017 (4) â–º 6æœˆ (3) â–º 5æœˆ (1) â–º 2016 (15) â–º 12æœˆ (4) â–º 11æœˆ (1) â–º 10æœˆ (2) â–º 7æœˆ (3) â–º 6æœˆ (1) â–º 5æœˆ (3) â–º 1æœˆ (1) â–º 2015 (13) â–º 12æœˆ (1) â–º 10æœˆ (1) â–º 9æœˆ (1) â–º 6æœˆ (1) â–º 5æœˆ (1) â–º 3æœˆ (2) â–º 2æœˆ (3) â–º 1æœˆ (3) â–º 2014 (11) â–º 12æœˆ (1) â–º 9æœˆ (2) â–º 8æœˆ (2) â–º 6æœˆ (1) â–º 4æœˆ (4) â–º 2æœˆ (1) â–º 2013 (15) â–º 12æœˆ (3) â–º 11æœˆ (3) â–º 8æœˆ (2) â–º 7æœˆ (4) â–º 5æœˆ (1) â–º 4æœˆ (2) â–º 2012 (7) â–º 10æœˆ (1) â–º 7æœˆ (1) â–º 4æœˆ (3) â–º 1æœˆ (2) â–º 20
proto_jp 2010/08/28
@php

php

mysql
ãƒªãƒ³ã‚¯
XAMPPã®ä½¿ã„æ–¹
Apache ã‚„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã€ PHP ãªã©ã‚’ä¸€ã¤ä¸€ã¤ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¦è¨å®šã‚’è¡Œã£ã¦ã„ãäº‹ã¯ã“ã‚Œã‹ã‚‰åˆã‚ã¦é–‹ç™ºã‚’è¡ŒãŠã†ã¨ã—ã¦ã„ã‚‹äººã«ã¨ã£ã¦æ•·å±…ãŒé«˜ã„ã‚‚ã®ã§ã™ã€‚ XAMPP ã¯ã‚ˆãåˆ©ç”¨ã•ã‚Œã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã‚„ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚’ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã«ã¾ã¨ã‚ãŸã‚‚ã®ã§ã€ã¾ã¨ã‚ã¦ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ã€‚ã“ã“ã§ã¯ XAMPP ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•åŠã³å®Ÿéš›ã®ä½¿ã„æ–¹ã«ã¤ã„ã¦è§£èª¬ã—ã¦ã„ãã¾ã™ã€‚
proto_jp 2010/08/23
@php

mysql

xampp

php
ãƒªãƒ³ã‚¯
XMLHttpRequest ã§ PHP ã« POST ã—ã¦ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’æ›´æ–°ã—ã¦çµæžœã‚’JavaScriptã«è¿”ã™ - Vosegus Sakura
ä½œæˆæ—¥ : 2009å¹´09æœˆ13æ—¥ æ›´æ–°æ—¥ : 2010å¹´05æœˆ30æ—¥ Vosegus Labs åŸºæœ¬è¨è¨ˆ SQLã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆ XMLã®è¨è¨ˆ HTML JavaScript PHP åŸºæœ¬è¨è¨ˆ ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã§ã¯ç¾åœ¨ã®æƒ…å ±ã‚’GETã—è¡¨ç¤º æ›´æ–°ã¯form elementã«ãƒ‡ãƒ¼ã‚¿ã‚’å…¥åŠ› å…¥åŠ›ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã«ã—ã¦XMLHttpRequestã§PHPã«POSTã™ã‚‹ PHPãŒãƒ‘ãƒ©ãƒ¡ãƒ¼ã‚¿ã‹ã‚‰SQLã‚’ä½œæˆã—ã¦é€ä¿¡ ã‚¯ã‚¨ãƒªãŒé€šã£ãŸã‚‰ã€æ›´æ–°ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ã‚’å–å¾— æ›´æ–°ã•ã‚ŒãŸãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®æƒ…å ±ã‚’XMLå½¢å¼ã§JavaScriptã¸æ¸¡ã™ JavaScriptã¯å—ã‘å–ã£ãŸãƒ‡ãƒ¼ã‚¿ã‚’HTMLã§è¡¨ç¤º SQLã‚¹ã‚ãƒ¼ãƒžã®è¨è¨ˆ CREATE TABLE rex( rex_id SMALLINT UNSIGNED AUTO_INCREMENT, rex_year YEAR, rex_month VARCHAR(2), re
proto_jp 2010/08/12
@php

@javascript

javascript

php

database

sql

mysql
ãƒªãƒ³ã‚¯
1