hands_on_4.PDF

Size: px

Start display at page:

Download "hands_on_4.PDF"

かずきすみだ
5 years ago
Views:

1 PHPMySQL 4 PC LAN

2 2 () ()

3 SQLDBMS DBMS DataBase Management System mysql DBMS SQL Structured Query Language SQL DBMS 3

4 DBMS DataBase Management System B Table 3 Table 2 Table 1 a 1 a 2 a 3 A SQLStructured Query Language Table 1 a 1 a 2 a 3 Table 2 4

5 PHPmySQL mysql hideki B Table 3 Table 2 A Table 1 a 1 Table 2 a 2 a 3 Table 1 a 1 a 2 a 3 localhost matsui $my_con = mysql_connect($hostname,$yourname,$password) OK A mysql_select_db($db_name,$my_con); mysql_query($query); php mysql_close($my_con) 5

6 SQL SELECT FROM WHERE CREATE DATABASE DROP DATABASE USE CREATE TABLEDROP TABLE INSERTUPDATEDELETE SELECT FROMWHEREORDER BYGROUP BY JOIN 4SQL 6

7 MySQL Web MySQLPHP MySQL PHP MySQL 7

8 Web phpdev 8

9 9 DOS Mysql localhost root mysql matsui hideki matsui localhost sample_db mysql

10 sample_db sample_db DB sample_db 10

11 record 8 id INT AUTO_INCREMENT, id registdata timestamp, registdata sample_db record record 11

12 12 record 1 name answer1 0 answer2 1 id registdata record id registdata

13 index.php form.php confirm.php insert.php show.php 13

14 index.php show.php index.php delete_input.php delete.php 14

15 operate_db.php <?php // function myopen(){ global $my_con,$hostname; $hostname="localhost"; $yourname="matsui"; $password="hideki"; $db_name="sample_db"; // MYSQL if(!$my_con = mysql_connect($hostname,$yourname,$password)){ print "${hostname} "; exit; } // mysql_select_db($db_name,$my_con); } // function myclose(){ global $my_con,$hostname; print "${hostname} "; } }?> 15

16 showf.php <?php // // "operate_db.php" myopen()myclose() function show(){ // $result $result = mysql_query("select * from record ");?> <table border ="1"> <tr><td><b> </b></td><td><b> </b></td><td><b> </b></td><td></b> </b></td><td><b> <?php // while ($row = mysql_fetch_array($result)) {?> </tr> <tr> <td><?= $row["name"]?></td> <td><?= $row["answer1"]?></td> <td><?= $row["answer2"]?></td> <td><?= $row["id"]?></td> <td><?= $row["registdata"]?></td> </tr> <?php } }?> 16

17 index.php   <head> <form action="show.php" method="post"> <mete http-equiv="content-type" <td> <br> content="text/html;charset=shift_jis"> </td><td><input type="submit" value=" <title> </title> "></td> </head> </form> <body bgcolor="#ffefd5" text="#696969"> </tr> <tr> <h2><br>  <form action="delete_input.php" method="post"> <hr> <td> <br> </h2> </td><td><input type="submit" value=" "></td>   <form action="form.php" method="post"> <table border="1"> <tr> <td> <br> </td><td><input type="submit" value=" "></td> </form> </tr> </tr> </table> </form> <pre> Copyright (C) 2003 yuzuru soga. All Rights Reserved </pre> </body> </html> 17

18 form.php <html> <head> <mete http-equiv="content-type" content="text/html;charset=shift_jis"> <title> </title> </head> <body bgcolor="#ffefd5" text="#696969"> <h2> </h2> <hr> <br> <br> <form action="confirm.php" method="post"> <?php /* */ $question=array(" "," "); /* */ for($ans_cnt=0;$ans_cnt<3;$ans_cnt++){ $answer[$ans_cnt]=array(" "," "," ","poor"); } global $question,$answer; function disp(){ global $question,$answer; print ("<p> <br><input type= "text " name= "yourname "></p>"); for($q_num=0;$q_num<2;$q_num++){ print ("<p>$question[$q_num]<br>"); for($i=0;$i<4;$i++){ print("<input type = "radio " name= "$q_num " value= "$i "ckecked>{$answer[0][$i]}"); } } print ("</p>"); print ("<p><input type= "submit " name= "submit " value= " "></p>"); print ("</form>"); } disp();?> </form> <pre> Copyright (C) 2003 yuzuru soga. All Rights Reserved </pre> 18 </body> </html>

19 confirm.php <table border ="1"> <tr><td> </td><td> </td><td> </td></tr> <html> <tr><td><?php print $name;?></td><td><?php <head> print $answer1;?></td><td><?php print <mete http-equiv="content-type" $answer2;?></td></tr> content="text/html;charset=shift_jis"> </table> <title> </title>  <body bgcolor="#ffefd5" text="#696969"> <form action="insert.php" method="post"> <input type="submit" name="submit" value=" "> <h2> </h2> <input type="hidden" name="name" value="<?php <hr> print $name;?>"> <br> <input type="hidden" name="answer1" value="<?php print $answer1;?>"> <br> <input type="hidden" name="answer2" value="<?php print $answer2;?>">  </form><br> <?php $name = $_POST[yourname];  $answer2 = $_POST[1]; <form action="form.php" method="post"><input?> type="submit" name="submit" value="  Copyright (C) 2003 yuzuru soga. All Rights Reserved </pre> 19 </body></html>

20 insert.php  //SQL <html> $query = "insert into record(name,answer1,answer2) <head> values( "$name ", "$answer1 ", "$answer2 ")"; <mete http-equiv="content-type" mysql_query($query); content="text/html;charset=shift_jis"> <title> </title> //MYSQLmyclose() </head> "operate_db.php" <body bgcolor="#ffefd5" text="#696969"> myclose(); <h2> <br>?> </h2> <hr> <br><br> <?php <br> //confirm.php $name = $_POST[name]; <!-- index.php $answer1 = $_POST[answer1]; show.php -- $answer2 = $_POST[answer2]; > <form action="index.php" method="post"><input //"operate_db.php" type="submit" name="submit" value=" "></form> include "operate_db.php"; <form action="show.php" method="post"><input type="submit" name="submit" value=" //MYSQL "></form> myopen()"operate_db.php" myopen(); <pre> Copyright (C) 2003 yuzuru soga. All Rights Reserved 20 </pre></body></html>

21 show.php <html> <head> <mete http-equiv="content-type" content="text/html;charset=shift_jis"> <title> </title> </head> <body bgcolor="#ffefd5" text="#696969"> <h2> </h2> <hr> <?php include "showf.php"; include "operate_db.php"; myopen(); show(); myclose();?> <form action="index.php" method="post"><input type="submit" name="submit" value=""></form> <pre> Copyright (C) 2003 yuzuru soga. All Rights Reserved </pre> </body> </html> 21

22 delete_input.php  <html> <head> <mete http-equiv="content-type" content="text/html;charset=shift_jis"> <title> </title> </head> <body bgcolor="#ffefd5" text="#696969"> <h2> </h2> <hr> delete_id delete.php --> <form action="delete.php" method="post"> <table border ="1"> <tr> <td> <br>( )</td><td><input type="int" name="delete_id" size = "5"></td> </tr> <tr><td></td><td><input type="submit" value=" <?php "></td></tr> //"operate_db.php" "showf.php"</table> </form> include "showf.php"; include "operate_db.php";  //MYSQL myopen()"operate_db.php" myopen(); <form action="index.php" method="post"><input type="submit" name="submit" value=" "></form> // show() "showf.php" show(); //MYSQLmyclose() "operate_db.php" myclose();?> <pre> Copyright (C) 2003 yuzuru soga. All Rights Reserved </pre> </body> </html> 22

23 delete.php  $query = "delete from record where id = "$id ""; <html> mysql_query($query); <head> <mete http-equiv="content-type" // show() content="text/html;charset=shift_jis"> "showf.php" <title> </title> show(); </head> <body bgcolor="#ffefd5" text="#696969"> //MYSQLmyclose() "operate_db.php" <h2> </h2> myclose(); <hr>?> <form action="index.php" method="post"><input <?php type="submit" name="submit" value=" //"operate_db.php" "showf.php""></form> include "showf.php"; <pre> include "operate_db.php"; Copyright (C) 2003 yuzuru soga. All Rights //MYSQL Reserved myopen()"operate_db.php" myopen(); </pre> //delete_input.php delete_id $id = $_POST[delete_id]; </body> </html> 23

24 MySQL phpdev mysql GUI 24

PHP と Postgresql を用いた図書館管理システムの構築裘彬濱 Qiu Binbin 南山大学情報理工学部

PHP と Postgresql を用いた図書館管理システムの構築裘彬濱 Qiu Binbin 南山大学情報理工学部 PHP と Postgresql を用いた図書館管理システムの構築裘彬濱 Qiu Binbin 南山大学情報理工学部 1: 要求分析要求として以下の 3 つを挙げる PHP と postgresql を用いた図書管理システムを構築したい本の追加削除貸出返却未返却会員情報検索といった5つの機能を欲しいこの 3 つの点からデータベースとウエブ 2 つの面に分けて考える [1] データベースに対する要求分析