- PDF Free Download

Size: px

Start display at page:

Download "1 1 1.......................... 1 2.......................... 2 2 5 1........................... 5 2................... 7 3..................... 8 4.."

こうざぶろうあかさか
9 years ago
Views:

1 CD

2 CD Excel SQL

................ 14 6 Excel SQL.................. 14 7...................... 16 3 19 1.

3 1 1 Unix PHP MySQL BeatJam 1 CD itunes 2 CD itunes CD World Fork CD Classical Unclassifiable 3-1 -

4 2 PHP MySQL i Web Access Access Excel Excel Web - 2 -

5 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 -

6 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 -

7 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 -

8 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 -

9 ID 1 music.sql ID int auto increment primary key, shift jis knoppix euc jp sjis2euc ( ) euc2sjis ( ) *.* ( ) 2 ( ) ( ) - 7 -

10 CD CD CD 3 itunes ID - 8 -

11 ( ) classical Unclassifiable itunes CD CD CD itunes ID (CD) CD 1 CD 2 ID CD 1-9 -

12 CD itunes ( ) ( ) 3. ( ) 1. 3: : :14 Unclassifiable ( )2005/11/25 DB ID CD

13 itunes 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: :

14 Karl Richter J.S.Bach: Matthaus Passion Classical ( )2005/11/25 DB ID CD BACH SACRED MASTERPIECES 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

St.Matthew Passion BWV224 Anointing in Bethzny Chorus: Kommt, ihr Tochter, helft mir klagen with Chorale:

15 CD 4 itunes CD CD (recnumber) CD CD CD CD

16 RDBMS( ) 5 CD Excel CD 2 3 ( ) Excel 2 3 ( ) ( ) 6 Excel SQL CD Excel music.sql Excel ( ) music.sql music.sql music.sql insert into cd1 (recnumber,title,composer) values( 1 ( 1) ˆ ( )

17 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,

sql drop database music; create database music; use music; create table cd1 ( ID int auto increment

18 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>

html Web PHP CGI HTML input name= value= <form action= insert.

19 <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 ;

size= 40 ><br> </td> </tr> </form> ii ichiran1.

20 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 \

$search kyokumei == && $search composer == && $search janru == && $search conduct == && $search player == )

21 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

22 1 (CD ) ( ) 2 3 ( G G ) 1 %

23 4 TOP TOP

24 2 CD CD CD

25 CD

26 pctech/hp classicdb/cdb 00 to p.htm / 2003 MySQL 2003 PHP MySQL

hands_on_4.PDF

hands_on_4.PDF PHPMySQL 4 PC LAN 2 () () SQLDBMS DBMS DataBase Management System mysql DBMS SQL Structured Query Language SQL DBMS 3 DBMS DataBase Management System B Table 3 Table 2 Table 1 a 1 a 2 a 3 A SQLStructured