CD
1 1 1.......................... 1 2.......................... 2 2 5 1........................... 5 2................... 7 3..................... 8 4......................... 13 5 CD................. 14 6 Excel SQL.................. 14 7...................... 16 3 19 1.................... 19 2......................... 22 3........................... 22
1 1 Unix PHP MySQL BeatJam 1 CD itunes 2 CD itunes CD World Fork CD Classical Unclassifiable 3-1 -
2 PHP MySQL i Web Access Access Excel Excel Web - 2 -
Web Web ii MySQL MySQL MySQL (RDBMS) C C++ Java Perl PHP Python Rudy API Web SJIS EUC DB MyODBC ODBC Windows UNIX OS ( / MySQL P.20 ) MySQL Web - 3 -
PHP Web MySQL iii PHP PHP MySQL PHP PHP Hypertext Preprocessor HTML MySQL PHP ( / MySQL P.166 ) PHP PHP PHP HTML iv CGI PHP CGI PHP CGI PHP CGI ( PHP MySQL - 4 -
P.10 ) CGI Web CGI v Apache HTTP Apache Apache NCSA httpd (patch) Apache Web Web (IT e-words 4 ) Apache UNIX OS Windows Web 2 1 music.sql( ) - 5 -
music.html ichiran1.php( ) seach.php( ) insert.php( ) delete.php( ) delete d.php( ) PHP MySQL PHP MYSQL ID CD music.sql( ) music.html ichiran1.php( ) search.php( ) insert.php( ) update.php( ) update d.php( ) delete.php( ) delete d.php( ) - 6 -
ID 1 music.sql ID int auto increment primary key, shift jis knoppix euc jp sjis2euc ( ) euc2sjis ( ) *.* ( ) 2 ( ) ( ) - 7 -
CD CD CD 3 itunes ID - 8 -
( ) classical Unclassifiable itunes CD CD CD itunes ID (CD) CD 1 CD 2 ID CD 1-9 -
CD itunes 1. 01. ( ) 2. 02. ( ) 3. ( ) 1. 3:03 2. 3:25 3. 3:14 Unclassifiable 0 5 1 ( )2005/11/25 DB ID 161 178 11 CD 1 18 1. - 10 -
2. 3. 1. 2. 3. itunes 1 2 01. 02. Unclassifiable( ) CD BACH SACRED MASTERPIECES itunes 1. Chor (Chorus I/II) Kommt, ihr Tochter. helft mir klagen 2. Rezitativ (Evangelist,Jesus) Da Jesus diese Rede vollendet hatte 1. 9:52 2. 1:03-11 -
Karl Richter J.S.Bach: Matthaus Passion Classical 0 5 1 ( )2005/11/25 DB ID 676 704 60 CD BACH SACRED MASTERPIECES 1 29 1. St.Matthew Passion BWV224 Anointing in Bethzny Chorus: Kommt, ihr Tochter, helft mir klagen with Chorale: O Lamm Gottes, unschudin 2. St.Matthew Passion BWV224 Anointing in Bethzny Reciative: Da Jesus diese Rede vollendet hatte J.S. KARL RICHTER MUNCHENER BACH-CHOR/MUNCHENER BACH- ORCHESTER itunes - 12 -
CD 4 itunes CD CD (recnumber) CD CD CD CD - 13 -
RDBMS( ) 5 CD Excel CD 2 3 ( ) Excel 2 3 ( ) ( ) 6 Excel SQL CD Excel music.sql Excel ( ) 1 2 1 music.sql music.sql music.sql insert into cd1 (recnumber,title,composer) values( 1 ( 1) ˆ ( ) - 14 -
insert into cd1 (recnumber,title,composer) values( 1 J.S, \t ( ) $ ( ) ); insert into cd1 (recnumber,title,composer) values( 1,, J.S ); music.sql 2 music.sql drop database music; create database music; use music; create table cd1 ( ID int auto increment primary key, recnumber int, title varchar(100), composer varchar(100) ); create table cd2 ( ID int auto increment primary key, recnumber int, tracknumber int, - 15 -
kyokumei varchar(200), composer varchar(100), janru varchar(100), conduct varchar(100), player varchar(100) ); 7 i music.html Web PHP CGI HTML input name= value= <form action= insert.php method= post > <tr> <td bgcolor= #99FFCC ><input type= submit value= > </td> - 16 -
<td> CD <input type= text name= insert title size= 40 ><br> <input type= text name= insert tracknumber size= 40 ><br> <input type= text name= insert kyokumei size= 40 ><br> <input type= text name= insert composer size= 20 ><br> <input type= text name= insert janru size= 20 ><br> <input type= text name= insert conduct size= 40 ><br> <input type= text name= insert player size= 40 ><br> </td> </tr> </form> ii ichiran1.php $connect = mysql connect( localhost, root, semi ) mysql connect() MySQL ID = mysql connect(,, ) mysql select db( music, $connect); mysql select db() music SQL $sql = selectcd2.id,cd1.title,cd2.tracknumber, cd2.kyokumei,cd2.composer,cd2.janru,cd2.conduct,cd2.player from cd1,cd2 where cd1.recnumber = cd2.recnumber ; - 17 -
cd1 recnumber cd2 recnumber iii seach.php seach.php PHP % ( ) if ($search ID == && $search recnumber == && $search title == && $search tracknumber == && $search kyokumei == && $search composer == && $search janru == && $search conduct == && $search player == ) and iv insert.php insert.php mysql query() $query = insert into cd1(recnumber,title) values(\ $insert recnumber\, \ $insert title\ ) ; mysql query($query); (cd2 ) SQL \ - 18 -
v delete.php delete d.php ID delete.php delete d.php delete.php $query = select * from cd1,cd2 where cd1.recnumber = cd2.recnumber and cd2.id = \ $delete ID\ ; ID SQL $query <input type= hidden name= delete ID value= <?= $delete ID?> > ID HTML delete d.php 3 1-19 -
1 (CD ) ( ) 2 3 ( G G ) 1 % - 20 -
4 TOP TOP - 21 -
2 CD CD CD 3-22 -
CD - 23 -
1 http://www.justsystem.co.jp/beatjam/ 2 http://www.apple.com/jp/itunes/overview/ 3 http://www.nextftp.com/swlabo/m0 pctech/hp classicdb/cdb 00 to p.htm 4 http://e-words.jp/w/apache.html 2001 / 2003 MySQL 2003 PHP MySQL - 24 -