[B! HTML][å‚è€ƒ] syuntaeharaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

syuntaehara id:syuntaehara

HTMLã¨å‚è€ƒã«é–¢ã™ã‚‹syuntaeharaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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ã€€MySQLã€€ãƒšãƒ¼ã‚¸ãƒ³ã‚°å‡¦ç†
#3ã§ã™ã€‚ ã‚‚ã†ä¸€åº¦èªã¿ç›´ã—ãŸã®ã§ã™ãŒã€ã€ ï¼žå‰æ¬¡ï¼‘ï¼’ï¼“ï¼”ï¼•ãƒ»ãƒ»ãƒ» ã¯ï¼‘ã‚’ã‚¯ãƒªãƒƒã‚¯ã—ãŸå ´åˆã©ã“ã¸é£›ã¶ã®ã§ã—ã‚‡ã†ã‹ã€‚ ç¾åœ¨1ãƒšãƒ¼ã‚¸ç›®ãŒè¡¨ç¤ºã•ã‚Œã¦ã„ã‚‹ã¨ã™ã‚Œã°å‰ã¨ã„ã†è¡¨ç¤ºã‚‚ã‚ã‚‹ã¨ãŠã‹ã—ã„ã®ã§ã€ æ¬¡ï¼’ï¼“ï¼”ï¼•ï¼–ãƒ»ãƒ»ãƒ» ã¨ãªã‚‹ã®ã§ã¯ãªã„ã§ã—ã‚‡ã†ã‹ï¼Ÿ 2ãƒšãƒ¼ã‚¸ä»¥é™ã‚’è¡¨ç¤ºã—ã¦ã„ã‚‹ã¨ã—ã¦ã‚‚ï¼‘ã¨ã„ã†ã®ã¯ã©ã†ã„ã†çŠ¶æ³ã§ãªã‚‰è¡¨ç¤ºã™ã‚‹ã®ã‹ãŒæ€ã„æµ®ã‹ã³ã¾ã›ã‚“ã§ã—ãŸã€‚ã€‚ ãã®è¾ºãŒæ°—ã«ãªã£ãŸã®ã§ã™ãŒã¨ã‚Šã‚ãˆãšè‡ªåˆ†ã®è§£é‡ˆã®å‰æã§èª¬æ˜Žã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚å‚è€ƒç¨‹åº¦ã«ç›®ã‚’é€šã—ã¦ãã ã•ã„ã€‚ ã©ã“ã¾ã§å‡ºæ¥ã¦ã„ã‚‹ã®ã‹ã¡ã‚‡ã£ã¨ã‚ã‹ã‚‰ãªã„ã®ã§ã©ã“ã‹ã‚‰èª¬æ˜Žã—ãŸã‚‰ã‚ˆã„ã®ã‹ã‚‚ã‚ã‹ã‚Šã¾ã›ã‚“ãŒã€ç§ã¯SQLã«LIMITã‚’ã‹ã‘ã¦å‡¦ç†ã‚’ã™ã‚‹æ–¹æ³•ã‚’æ™®æ®µä½¿ã£ã¦ã„ã¾ã™ã€‚ æœ€åˆã®ãƒšãƒ¼ã‚¸ã‹ã‚‰ã‚¹ã‚¿ãƒ¼ãƒˆã—ãŸå ´åˆç§ã®å ´åˆãªã‚‰ æ¬¡ã€€ï¼’ã€€ï¼“ã€€ï¼”ã€€ï¼•ã€€ï¼–ã€€ãƒ»ãƒ»ãƒ» ã¨ã„ã†è¡¨ç¤ºã«ã—ã¾ã™ã€‚ æ¬¡ã¨ï¼’ã¯åŒã˜ãƒªãƒ³ã‚¯ãŒå¼µã‚‰ã‚Œã¾ã™ã€‚ 10ä»¶ãšã¤è¡¨ç¤ºã™ã‚‹ã“ã¨ã‚’å‰æã«ã€ LIMITã«ä½¿ã†ã‚ªãƒ•ã‚»
syuntaehara 2011/08/15
SQL

manual

è€ƒãˆæ–¹

html

PEAR

hp

å‚è€ƒ

ãƒšãƒ¼ã‚¸ãƒ³ã‚°

mysql

PHP
ãƒªãƒ³ã‚¯
Vim ã§ XML/HTML ã®é–‰ã˜ã‚¿ã‚°ã‚’è‡ªå‹•è£œå®Œã™ã‚‹ã‚ˆã†ã«ã—ãŸ - babie, you're my home
ã€ŒVim-users.jp - Hack #22: XMLã®é–‰ã˜ã‚¿ã‚°ã‚’è£œå®Œã™ã‚‹ã€ã‚’å‚è€ƒã«ã—ã¦ã€HTML/XML ã®é–‰ã˜ã‚¿ã‚°ã‚’ </ ãŒå…¥åŠ›ã•ã‚ŒãŸã¨ãã«è‡ªå‹•çš„ã«è£œå®Œã™ã‚‹ã‚ˆã†ã«ã—ãŸã€‚ ~/.vimrc ã«ä»¥ä¸‹ã‚’è¿½è¨˜ï¼š augroup MyXML autocmd! autocmd Filetype xml inoremap <buffer> </ </<C-x><C-o> autocmd Filetype html inoremap <buffer> </ </<C-x><C-o> autocmd Filetype eruby inoremap <buffer> </ </<C-x><C-o> augroup END Rails ã‚’ä½¿ã†ã“ã¨ãŒå¤šã„ã®ã§ã€eruby ãƒ•ã‚¡ã‚¤ãƒ«ã«ã‚‚é©ç”¨ã•ã‚Œã‚‹ã‚ˆã†ã«ã—ãŸã€‚
syuntaehara 2011/08/15
html

vim

å‚è€ƒ
ãƒªãƒ³ã‚¯
webãƒšãƒ¼ã‚¸ã®ä¸€éƒ¨ã®ã¿ã®æ›´æ–°ã«ã¤ã„ã¦
JavaScriptåˆå¿ƒè€…ã§ã™ã€‚ PHPã¨XHTMLã§HPã‚’ä½œæˆä¸ã§ã™ãŒã€ã‚¿ã‚¤ãƒˆãƒ«ã«ã‚ã‚‹ã‚ˆã†ã«HPã®ä¸€éƒ¨ã®ã¿æ›´æ–°ã™ã‚‹ã“ã¨ãŒå¯èƒ½ã§ã—ã‚‡ã†ã‹ï¼Ÿ JavaScriptã§ä¸å¯èƒ½ãªå ´åˆã¯ã©ã®è¨€èªžã§å‡ºæ¥ã¾ã™ã‹? ã‚„ã‚ŠãŸã„ã“ã¨ã¯ã‚»ãƒ¬ã‚¯ãƒˆã§é¸æŠžã—ãŸã‚‰objectã§è¡¨ç¤ºä¸ã®ãƒšãƒ¼ã‚¸ã®ã¿å¤‰æ›´ã™ã‚‹äº‹ã§ã™ã€‚ åˆ†ã‹ã‚‰ãªã„ãªã‚Šã«ä½œã£ã¦ã¿ãŸã‚µãƒ³ãƒ—ãƒ«ã®çµæžœãŒã“ã‚Œã§ã™ã€‚ index.php ------------------------ <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dt â€¦ <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="ja" lang="ja"> <head> <meta http-e
syuntaehara 2011/06/19
server

Ajax

è¨˜äº‹

hp

å‚è€ƒ

test

html

javascript

PHP

Web
ãƒªãƒ³ã‚¯
DBã®å®¹é‡ã«ã¤ã„ã¦
ã‚ã£ã·ã‚ã£ã·ã«ãªã‚Šãã†ã§ã™ã€‚ã€‚ï¼ˆç¬‘ æ°—ã«ãªã£ãŸã®ã§èª¿ã¹ã¦ã¿ã¾ã—ãŸã€‚ MyIsamã«å¯¾ã—ã¦ã¯ã‚„ã¯ã‚Šã€OSã«ä¾å˜ã—ã¦ã„ã¾ã™ã€‚ ãŸã ã€ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆæ™‚ã«Row_sizeã‚’æ±ºã‚ã‚Œã‚‹ã‚ˆã†ã§ ãã‚Œã‚’æŒ‡å®šã—ã¦ã„ã‚Œã°ã€ã‚µã‚¤ã‚ºã«åˆ¶é™ãŒã‹ã‹ã£ã¦ã„ã‚‹ã®ã§ã¯ãªã„ã‹ã¨æ€ã„ã¾ã™ã€‚ å‚è€ƒURLã«è¨˜è¼‰ã•ã‚Œã¦ã„ã¾ã™ã€‚ ç¢ºèªã§ã™ãŒã€ show table status like 'TABLE_NAME' \G ã‚’å®Ÿè¡Œã™ã‚‹ã¨ã€Data_lengthãƒ»Max_data_length ãŒè¡¨ç¤ºã•ã‚Œã¾ã™ã€‚Data_lengthãŒç¾åœ¨ã§Maxãƒ»ãƒ»ãŒæœ€å¤§å€¤ã®ã¯ãšã§ã™ã€‚ã€‚ ãã‚ŒãŒã€ã©ã®çŠ¶æ…‹ã«ãªã£ã¦ã„ã¾ã™ã§ã—ã‚‡ã†ã‹ï¼Ÿ è¿‘ã„ã®ã§ã‚ã‚Œã°ã€Maxã‚’å¢—ã‚„ã•ãªã‘ã‚Œã°ãªã‚Šã¾ã›ã‚“ã€‚ ãã®å ´åˆã€alteræ–‡ã§ãƒ»ãƒ» alter table TABLE_NAME max_rows=ã“ã“ã«rowæ•°è¨˜å…¥; Avg_row_lengthã¨ã€max_rowsã§Max_da
syuntaehara 2011/06/04
mysql

å‚è€ƒ

db

html

Linux

Web

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

PC

SQL

star
ãƒªãƒ³ã‚¯
1