2009 Web B012-1

Size: px

Start display at page:

Download "2009 Web B012-1"

れいがはなだて
4 years ago
Views:

1 2009 Web B012-1

2 Web Web Web Web YubaEE Web

3 PHP YubaEE

4 1 Web YubaEE YubaEE 1 [1] YubaEE Web YubaEE YubaEE 1.1 Web Web Web Web Web Web 2.1 Web Web 1.2 Web Web Web

5 2 Web YubaEE Web Web Web 2.1 Web Web [3] 2.2 Web Web Web Web Web Web Twitter

2.1: Twitter SNS SNS sorcial networking service Web SNS mixi 2 2.

6 2.1: Twitter SNS SNS sorcial networking service Web SNS mixi mixi Web mixi mixi Wiki Wiki Web Web HTML Wiki Web wiki wiki Web <strong>wiki</strong> 2 6

7 2.2: mixi Web 7

8 3 Web Visual Programming Language VPL VPL VPL VPL VPL 3.2 VPL 8

9 3.1:

10 3.2: 3.3 a, b, c, d, (a + b) (c + d) 10

11 3.3: 11

13 4.1: 4.3: 4.2: 4.4: 4.5: 13

14 5 YubaEE Web (page transition data flow model) Web Web Web Web Web Web Web Web??

15 5.1: 5.2: 5.3 Web Web 5.3: 15

16 5.4: (replace datalabel) 5.4 [[labelname]] Label labelname Web 5.2 Web

17 5.5: node

18 5.6: 5.7: 18

19 (switch)

20 5.8: 5.9: Web Web Web Web Web 20

21 5.10: Web Web Web 5.10 Web 5.11 Web 5.12 Web Web 21

22 5.11: 5.12: 22

23 5.13: = Web 23

24 5.14: 5.15: 24

25 5.4.2 Web Google 5.16 Google 2 Google Google Ajax (Asynchronous JAvascript + Xxm) Ajax Web 5.16: Google

26 6 Web YubaEE (Yuba Eagle eye Edition) YubaEE Web Web YubaEE Web (creator) Web : YubaEE 26

27 PC Eclipse.org Eclipse 1 PC 2 PC YubaEE Web YubaEE Web Web YubaEE Web OS Web Web YubaEE Web YubaEE YubaEE Web Web 6.2 YubaEE Web YubaEE Web Web Windows 27

28 6.2: YubaEE 28

29 6.3: 6.4: 6.3 HTML Wysiwyg 3 29

30 6.5: 6.6: red tomato ff0000 ff6347 RGB 32bit ff0 f64 RGB 16bit 6.6 YubaEE 6.7 HTML YubaEE 3 Wysiwyg What you see is what you get 30

31 6.7: 6.8: 6.9: 6.10: 6.11: 6.8 Web YubaEE [[fortune]] [[average]] 6.10 Wysiwyg Wisysig Wysiwyg Wysiwyg YubaEE 31

32 6.12: Wysiwyg 6.13: 6.14: Wysiwyg 6.13 Wysiwyg Wysiwyg YubaEE Web YubaEE 32

33 6.15: 6.16: key 33

34 6.17: 6.18: 6.5 (project designer) (project) Web,,

35 6.19: 6.20: Web 6.23 (switch) 35

36 6.21: 6.22: 6.23: 6.24: (input terminal) (output terminal)

6.25: 6.26: 6.5.3 Web Web The Apache Software

6.1 (database designer) (database) 5 http://httpd.

37 6.25: 6.26: Web Web The Apache Software Foudation HTTP Server 5 Web index.html 6 YubaEE (database designer) (database) dir.html 37

38 6.27: Web YubaEE Web Web

39 6.28: 6.29: : 39

40 6.31: 6.32: : 40

41 6.34: 6.35: Web YubaEE (style sheet)

42 6.36:?? title, name, body YubaEE 6.37: 42

43 6.38: 6.39: 43

44 6.40: 44

45 7 YubaEE PHP Web YubaEE Web 7.1 Web PHP YubaEE 45

46 7.1: 46

47 7.1.2 PHP PHP bbs.php <?php // $connection "localhost", "root", "test" ); if(!$connection or!@mysql_select_db( "yubaee", $connection ) ){ // print( " " ); exit; } print <<<DOC_END <HTML> <HEAD> <TITLE> </TITLE> <meta http-equiv="charset" value="utf-8"> </HEAD> <BODY> <H3> </H3> <HR/> <FORM action="write.php" method="post"> <p> <input type="text" name="author"/> <p> <input type="text" name="subject"></p> <p> </P> <p><textarea cols=80 rows=7 name="content"></textarea></p> <p><input type="submit" value=" "></p> </FORM> <hr/> DOC_END; // $SQL = "select * from bbs order by id desc"; $articles = mysql_query( $SQL ); while( $rows = mysql_fetch_array( $articles ) ){ // $id = $rows["id"]; $author = htmlspecialchars( $rows["author"] ); $subject = htmlspecialchars( $rows["subject"] ); $content = preg_replace( /\r\n \r \n/s, "<BR>", htmlspecialchars( $rows["content"] ) ); $timestamp = $rows["timestamp"]; print "<p>$id : <b>$subject</b></p>"; print "<p><font color=\"gray\"> </font>$author <font color=\"gray\"> </font>$timestamp</p>"; print "<p>$content</p><hr/>"; } print<<<doc_end </body> </html> DOC_END;?> 47

48 write.php <?php $connection "localhost", "root", "test" ); if(!$connection or!@mysql_select_db( "yubaee", $connection ) ){ // print( " " ); exit; } // if( $_POST["author"]=="" $_POST["subject"]=="" $_POST["content"]==""){ print <<<DOC_END <HTML> <HEAD> <TITLE> </TITLE> <meta http-equiv="charset" value="utf-8"> </HEAD> <BODY> <p> <form action="bbs.php"><input type="submit" value=" "></form> </BODY> </HTML> DOC_END; printf($_post["author"]); }else{ $author= mysql_real_escape_string( $_POST["author"] ); $subject= mysql_real_escape_string( $_POST["subject"] ); $content= mysql_real_escape_string( $_POST["content"] ); $timestamp = date("y-m-d H:i:s"); $SQL =<<<DOC_END insert into bbs (author, subject, content, timestamp) values ("$author", "$subject", "$content", "$timestamp") DOC_END; mysql_query($sql); header("http/ Moved Permanently"); header("location: }?> 48

49 7.3: bbs 7.2: bbs YubaEE YubaEE 7.2 bbs bbs bbs

50 7.4: bbs 7.5: 50

51 7.6: 7.7: id id

52 7.8: 7.9 bbs 7.10 id subject auther timestamp content id PHP YubaEE 52

53 7.9: 53

54 7.10: PHP YubaEE YubaEE YubaEE 54

55 8 YubaEE Web 55

56 OB OB. 56

57 [1] :, 2007, [2] : web 2008, [3] : Vol.24 No.4P Web,, [4] : Vol.49 No11 P WebWare : WebWare,, [5] : Vol.26,No3 P69-77 Web Web,, [6] XSL Transformations Vertion 1.0, ( ). [7] Gustabo Alonso, Fabio Casati, Harumi Kuno, Vijay Machiraju, Web Services Concepts, Architectures and Applications, Springer, [8] John Hughes, Why Functional Programming Matters, rjmh/papers/whyfp.html( ). [9] R., P., :,, [10] : ER,, [11] : Java+MySQL+Tomcat Web,,

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