[B! MySQL] akzã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

akz id:akz

MySQLã«é–¢ã™ã‚‹akzã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (11)

${{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è£½ã®Webãƒ–ãƒ©ã‚¦ã‚¶ãƒ™ãƒ¼ã‚¹ã®DBã‚³ãƒ³ã‚½ãƒ¼ãƒ«Â·Uhura MOONGIFT
MySQLã‚’ä½¿ã£ãŸWebã‚·ã‚¹ãƒ†ãƒ ã®å ´åˆã€ãã®DBç®¡ç†ã«phpMyAdminã‚’ç”¨ã„ã‚‹ã“ã¨ãŒå¤šã„ã®ã§ã¯ãªã„ã ã‚ã†ã‹ã€‚ã§ã¯PostgreSQLã‚’åˆ©ç”¨ã™ã‚‹å ´åˆã¯ã©ã†ã ã‚ã†ã€‚ãã®å ´åˆã«ã¯phpPgAdminãŒã‚ã‚‹ã€‚ã•ã‚‰ã«Firebirdã®å ´åˆã¯ã©ã†ã ã‚ã†ã€‚ ã¾ã‚‹ã§GUIã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆã†ãªDBç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ ä¸€ã¤ã®DBå‘ã‘ã«é™ã‚‰ãšå¯¾å¿œã—ã¦ã„ã‚‹ã¨ã€æ“ä½œãŒåŒã˜ã§æ¸ˆã‚€ã®ã§ã¯æ··ä¹±ãŒå°‘ãªãã¦æ¸ˆã‚€ã€‚æ§˜ã€…ãªDBã‚’ä½¿ã„ã“ãªã™ãªã‚‰Uhuraã‚’ä½¿ã£ã¦ã¿ã¦ã¯ã©ã†ã ã‚ã†ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ãƒ»ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã¯Uhuraã€Webãƒ™ãƒ¼ã‚¹ã®DBã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã ã€‚ Uhuraã¯PHPã§ä½œã‚‰ã‚ŒãŸDBç®¡ç†ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã ã€‚ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã®ä¸€è¦§ã‚„ã€ãƒ†ãƒ¼ãƒ–ãƒ«ã®ä¸€è¦§ã€ãƒ“ãƒ¥ãƒ¼ã‚„ãƒˆãƒªã‚¬ãƒ¼ã®ä¸€è¦§ã‚’è¦‹ã‚‹ã“ã¨ãŒã§ãã‚‹ã€‚ã‚¤ãƒ³ã‚¿ãƒ•ã‚§ãƒ¼ã‚¹ã«ExtJSã‚’ç”¨ã„ã¦ã„ã‚‹ã®ã§ã€ã¾ã‚‹ã§GUIã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚ˆã†ãªç”»é¢æ§‹æˆã«ãªã£ã¦ã„ã‚‹ã€‚ æ§˜ã€…ãªã‚·ãƒ§ãƒ¼ãƒˆã‚«ãƒƒãƒˆã‚ãƒ¼ãŒ
akz 2009/06/14
DB

MySQL

PHP
ãƒªãƒ³ã‚¯
Konsultan IT , Software Developer, Sistem Integrator, IT Solution Provider | Professional Web Designer | Web Developer Jakarta Tangerang Banten | Gaivo Integrasi Solusindo
Solusi IT Terbaik untuk Kemajuan Bisnis Anda Jangan biarkan perusahaan Anda tertinggal! Temukan solusi IT terbaik yang akan membawa bisnis Anda ke puncak kesuksesan bersama kami. Sudah Punya Website Tapi... Situs web yang tidak dioptimalkan membuat pelanggan potensial meninggalkan halaman sebelum sempat mengeksplorasi apa yang Anda tawarkan. Situs yang lambat, tidak responsif, dan tampilan yang ti
akz 2006/07/25
PHP

MySQL
ãƒªãƒ³ã‚¯
del.icio.us ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç°¡å˜ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ— : mysqlicious:phpspoté–‹ç™ºæ—¥èªŒ
MySQLicious - del.icio.us to MySQL Mirroring [ nanovivid MySQLicious is a tool for mirroring del.icio.us bookmarks into a MySQL database. Note that MySQLicious does not provide a mechanism for displaying bookmarks after they're in your database. That part is up to you, though there is some sample code in the tutorial to get you started. del.icio.us ã®ãƒ‡ãƒ¼ã‚¿ã‚’ç°¡å˜ã«MySQLã«ãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã§ãã‚‹mysqliciousã®ç´¹ä»‹ã€‚ PHP4(cURL)
akz 2006/07/17
ã‚‚ã£ã¨æ—©ãçŸ¥ã£ã¦ã„ã‚Œã°â€¦ã€‚

del.icio.us

PHP

MySQL
ãƒªãƒ³ã‚¯
activeCollab - Project Management and Collaboration Tool
Productivity and collaboration workspace for your growing service business. From a task to an invoice. Just like that.
akz 2006/07/07
ã€ŒactiveCollab is an easy to use, web based, open source collaboration and project management tool.ã€

webapp

PHP

MySQL
ãƒªãƒ³ã‚¯
MySQL Cheat Sheet
Selecting a database: mysql> USE database; Listing databases: mysql> SHOW DATABASES; Listing tables in a db: mysql> SHOW TABLES; Describing the format of a table: mysql> DESCRIBE table; Creating a database: mysql> CREATE DATABASE db_name; Creating a table: mysql> CREATE TABLE table_name (field1_name TYPE(SIZE), field2_name TYPE(SIZE)); Ex: mysql> CREATE TABLE pet (name VARCHAR(20), sex CHAR(1), bi
akz 2006/05/18
ã„ã¤ã‹å½¹ã«ç«‹ã¤ã‹ã‚‚ã€‚

MySQL
ãƒªãƒ³ã‚¯
ãƒŸã‚¯ã‚·ã‚£ã®CTOãŒèªžã‚‹ã€Œmixiã¯ã„ã‹ã«ã—ã¦å¢—ãˆç¶šã‘ã‚‹ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã«å¯¾å‡¦ã—ã¦ããŸã‹ã€ï¼šITpro
ãƒŸã‚¯ã‚·ã‚£ã®CTOãŒèªžã‚‹ã€Œmixiã¯ã„ã‹ã«ã—ã¦å¢—ãˆç¶šã‘ã‚‹ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã«å¯¾å‡¦ã—ã¦ããŸã‹ã€ YAPC::Asia 2006 Tokyo æ±äº¬éƒ½å¤§ç”°åŒºã§é–‹å‚¬ã•ã‚Œã¦ã„ã‚‹Perl æŠ€è¡“è€…å‘ã‘ã‚«ãƒ³ãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ã€ŒYAPC::Asia 2006 Tokyoã€ã§2006å¹´3æœˆ29æ—¥ï¼Œæ—¥æœ¬æœ€å¤§ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ»ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚ãƒ³ã‚°ãƒ»ã‚µã‚¤ãƒˆï¼ˆSNSï¼‰ã§ã‚ã‚‹ã€Œmixiã€ã‚’é‹å–¶ã™ã‚‹ãƒŸã‚¯ã‚·ã‚£ã®Batara Kesumaï¼ˆãƒã‚¿ãƒ©ãƒ»ã‚±ã‚¹ãƒžï¼‰å–ç· å½¹æœ€é«˜æŠ€è¡“è²¬ä»»è€…ï¼ˆCTOï¼‰ãŒï¼Œå¢—ãˆç¶šã‘ã‚‹è†¨å¤§ãªãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã«ã©ã®ã‚ˆã†ã«å¯¾å‡¦ã—ã¦ããŸã®ã‹ã«ã¤ã„ã¦è¬›æ¼”ã—ãŸã€‚ã‚«ã‚®ã¨ãªã‚‹ã®ã¯ã€Œãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹åˆ†å‰²ã€ã§ã‚ã‚‹ã€‚ mixiã®ã‚·ã‚¹ãƒ†ãƒ ã¯ã‚‚ã¨ã‚‚ã¨Bataraæ°ãŒ1äººã§ä½œã‚Šä¸Šã’ãŸã‚‚ã®ã ã€‚2003å¹´å½“æ™‚ï¼Œç±³å›½ã§Friendsterãªã©ã®SNSãŒã¯ã‚„ã£ã¦ãŠã‚Šï¼ŒåŒæ°ãŒä¼šç¤¾ï¼ˆç¾åœ¨ã®ãƒŸã‚¯ã‚·ã‚£ï¼Œå½“æ™‚ã¯ã‚¤ãƒ¼ãƒ»ãƒžãƒ¼ã‚ãƒ¥ãƒªãƒ¼ï¼‰ã«SNSã‚’ä½œã‚ŠãŸã„ã¨ææ¡ˆã—ãŸã¨ã“ã‚èªã‚ã‚‰ã‚ŒãŸã¨ã„ã†ã€‚åŒæ°ãŒ
akz 2006/03/30
mixi

Perl

MySQL
ãƒªãƒ³ã‚¯
phpMyFAQ - ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ã‚ˆã‚‹ITæˆ¦ç•¥æ”¯æ´
ç°¡æ˜“ã‚«ãƒ©ãƒ¼ãƒ”ãƒƒã‚«ãƒ¼ ãƒ¬ãƒ“ãƒ¥ãƒ¼ èµ·å‹• HTML Applicationsï¼ˆ*.htaï¼‰ç‰ˆã§ã™ã€‚ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) å‹•ä½œä¾‹ ã‚¹ãƒ©ã‚¤ãƒ€ãƒ¼ã«ã‚ˆã‚‹è‰²èª¿æ•´ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) HEXã«å€¤å…¥åŠ› ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) ã‚µãƒ³ãƒ—ãƒ«ãƒ†ã‚ã‚¹ãƒˆå¤‰æ›´ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) ã‚»ãƒ¬ã‚¯ãƒˆãƒœãƒƒã‚¯ã‚¹ã®è‰²é¸æŠž ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) Firefoxä¸Šã§åˆ©ç”¨ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) å…¨ãå•é¡Œã‚ã‚Šã¾ã›ã‚“ã€‚ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) ãƒ†ã‚ã‚¹ãƒˆå¤‰æ›´ ï¼ˆã‚¯ãƒªãƒƒã‚¯ã™ã‚‹ã¨æ‹¡å¤§ã—ã¾ã™) ç°¡æ˜“ã‚«ãƒ©ãƒ¼ãƒ”ãƒƒã‚«ãƒ¼ ç´¹ä»‹ã¯ã“ã¡ã‚‰
akz 2006/03/26
webapp

PHP

MySQL
ãƒªãƒ³ã‚¯
MOONGIFT - phpMyBackupPro - ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã«ã‚ˆã‚‹ITæˆ¦ç•¥æ”¯æ´ -
ãƒªãƒ¢ãƒ¼ãƒˆåˆ©ç”¨ã®ãŠæ‰‹è»½ãƒ¡ãƒ¼ãƒ©ãƒ¼ ãƒ¡ãƒ¼ãƒ«ã®ã‚„ã‚Šå–ã‚ŠãŒå¢—ãˆã‚‹ã«ã¤ã‚Œã€å¤–å‡ºå…ˆã‚„å…±ç”¨ã®PCã§ãƒ¡ãƒ¼ãƒ«ã‚’ãƒã‚§ãƒƒã‚¯ã™ã‚‹äº‹ãŒã‚ã‚‹ã€‚ãã‚“ãªæ™‚ã«ã¯nPOPã‚’ä½¿ã£ã¦ãƒ‡ãƒ¼ã‚¿ã®æ•£åœ¨ã‚’é˜²ã”ã†ã€‚ ãƒªãƒ¢ãƒ¼ãƒˆåˆ©ç”¨ã®ãŠæ‰‹è»½ãƒ¡ãƒ¼ãƒ©ãƒ¼ æœ€è¿‘ã€ãƒ¡ãƒ¼ãƒ©ãƒ¼ã¯GMailã°ã‹ã‚Šã«ãªã£ã¦ã„ã‚‹ã€‚@moongift.jpå®›ã®ãƒ¡ãƒ¼ãƒ«ã¯å…¨ã¦è»¢é€ã—ã€ã‚¹ãƒ‘ãƒ ãƒ•ã‚£ãƒ«ã‚¿ãƒ¼ã‚’é€šã—ãŸå¾Œã€åˆ¥ãªã‚¢ãƒ‰ãƒ¬ã‚¹ã«è»¢é€ã™ã‚‹ã¨è¨€ã£ãŸå…·åˆã ï¼ˆãƒãƒƒã‚¯ã‚¢ãƒƒãƒ—ã‚’ã‹ãã¦ï¼‰ã€‚ ã¨ã¯è¨€ãˆã€å¸¸ã«ãƒ–ãƒ©ã‚¦ã‚¶ã‹ã‚‰ã‚¢ã‚¯ã‚»ã‚¹ã§ãã‚‹ã¨ã¯é™ã‚‰ãªã„ã€‚ãã®ç‚¹ã€GMailã¯POPæŽ¥ç¶šã‚’ã‚µãƒãƒ¼ãƒˆã—ã¦ã„ã‚‹ã®ã§ã‚ã‚ŠãŒãŸã„ã€‚ãƒ‡ãƒ¼ã‚¿ã‚’åˆ†æ•£ã•ã›ã‚‹ã“ã¨ãªãã€ãŠæ‰‹è»½ã«POPãƒ¡ãƒ¼ãƒ©ãƒ¼ã‚’ä½¿ã†ãªã‚‰ã“ã‚ŒãŒè‰¯ã„ã€‚ ä»Šå›žç´¹ä»‹ã™ã‚‹ãƒ•ãƒªãƒ¼ã‚¦ã‚§ã‚¢ã¯nPOPã€ã‚µãƒ¼ãƒä¸Šã®ãƒ¡ãƒ¼ãƒ«ã‚’è¡¨ç¤ºã—ã¦ãã‚Œã‚‹POPãƒ¡ãƒ¼ãƒ©ãƒ¼ã ã€‚ nPOPãŒåˆ©ç”¨ã™ã‚‹ã®ã¯ã€Beckyãªã©ã§è¨€ã†æ‰€ã®ãƒªãƒ¢ãƒ¼ãƒˆãƒ¡ãƒ¼ãƒ«ã ã€‚æ‰‹å…ƒã«ä¿å˜ã—ãªã„ã®ã§ç°¡æ˜“çš„ãªåˆ©ç”¨æ³•ãŒè€ƒãˆã‚‰ã‚Œã‚‹ã€‚ä»°ã€…ã—ããªã„ã®ãŒè‰¯ã„ã€‚ n
akz 2006/03/26
webapp

PHP

MySQL
ãƒªãƒ³ã‚¯
Cheat Sheets - Added Bytes
The second version of the Regular Expressions Cheat Sheet, a quick reference guide for regular expressions, including symbols, ranges, grouping, assertions and some sample patterns to get you started.
akz 2006/03/24
å„ç¨®ãƒãƒ¼ãƒˆã‚·ãƒ¼ãƒˆã€‚ã“ã‚Œã¯ä¾¿åˆ©ã‹ã‚‚ã€‚

ãƒ¦ãƒ¼ãƒ†ã‚£ãƒªãƒ†ã‚£

PHP

CSS

MySQL

JavaScript
ãƒªãƒ³ã‚¯
ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ï¼ˆScuttleï¼‰ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•:phpspoté–‹ç™ºæ—¥èªŒ
ã‚ªãƒ¼ãƒ—ãƒ³ã‚½ãƒ¼ã‚¹ã®ã‚½ãƒ¼ã‚·ãƒ£ãƒ«ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯æä¾›ç”¨ãƒ—ãƒã‚°ãƒ©ãƒ Scuttleã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã‚’ç¤ºã—ã¾ã™ã€‚ Scuttleã¯PHP+MySQLç”¨ã«æ›¸ã‹ã‚Œã¦ã„ã¦ãƒ¬ãƒ³ã‚¿ãƒ«ã‚µãƒ¼ãƒãªã©ã«ã‚‚è¨ç½®ã§ãã‚‹ã¨æ€ã„ã¾ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ã€PHPã¨MySQLã®æ§‹æˆã§ã®ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã‚’è¡Œã„ã¾ã™ã€‚ 1. Scuttleãƒ‘ãƒƒã‚±ãƒ¼ã‚¸ã‚’ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰å¾Œã€è§£å‡ã™ã‚‹ 2. æ¬¡ã®SQLæ–‡ã§MySQLãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚’ä½œæˆã™ã‚‹. CREATE database scuttle 3. æ¬¡ã«å¿…è¦ãªãƒ†ãƒ¼ãƒ–ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ è§£å‡å¾Œã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸å†…ã«ã‚ã‚‹ /tables.sql å†…ã®SQLæ–‡ã‚’å®Ÿè¡Œã™ã‚‹ã“ã¨ã§å¿…è¦ãªãƒ†ãƒ¼ãƒ–ãƒ«ãŒä½œæˆã§ãã¾ã™ã€‚ â€»XAMPPä¸Šã®phpmyadminã§ç¢ºèª 4. configãƒ•ã‚¡ã‚¤ãƒ«ã®ä½œæˆ æ¬¡ã«è§£å‡å¾Œã®ãƒ‘ãƒƒã‚±ãƒ¼ã‚¸å†…ã«ã‚ã‚‹ã€/config.inc.php.sample ãƒ•ã‚¡ã‚¤ãƒ«ã‚’/config.inc.phpã«åå‰ã‚’å¤‰æ›´ã—ã€æ¬¡ã®DBã®ã‚¢
akz 2005/12/12
webapp

bookmarks

PHP

MySQL

del.icio.us
ãƒªãƒ³ã‚¯
XAMPP - é–‹ç™ºç’°å¢ƒä¸€æ‹¬ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« - phpspot
Apache HTTPD 2.0.52 MySQL 4.1.8 PHP 5.0.3 + 4.3.10 + PEAR + Switch MiniPerl 5.8.3 mod_ssl 2.0.51 Openssl 0.9.7e PHPMyAdmin 2.6.0 pl3, Webalizer 2.01-10 Mercury Mail Transport System fur Win32 und NetWare Systems v4.01a FileZilla FTP Server 0.9.4d SQLite 2.8.15 ADODB 4.52 Zend Optimizer 2.5.7 XAMPP Security â€»é’å—ã¯PHPé–‹ç™ºã«é–¢ã‚ã£ã¦ãã‚‹ã‚‚ã®ã§ã™ XAMPPã¯ApacheFriendsã«ã‚ˆã£ã¦é–‹ç™ºï¼†æä¾›ã•ã‚Œã¦ã„ã¾ã™ã€‚ (MacOS/Linux/Solarisã«ã‚‚å¯¾å¿œã—ã¦ã„ã¾ã™ãŒã€å½“ã‚µã‚¤ãƒˆ
akz 2005/09/15
XAMPPã®ã‚ã‹ã‚Šã‚„ã™ã„ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«æ–¹æ³•ã€‚ãŒã€å°‘ã€…æƒ…å ±ãŒå¤ã„ã€‚

PHP

MySQL

XAMPP
ãƒªãƒ³ã‚¯
1