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 Query Language Table 1 a 1 a 2 a 3 Table 2 4
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
SQL SELECT FROM WHERE CREATE DATABASE DROP DATABASE USE CREATE TABLEDROP TABLE INSERTUPDATEDELETE SELECT FROMWHEREORDER BYGROUP BY JOIN http://www.rfs.jp/sitebuilder/sql/index.html 4SQL 6
MySQL Web MySQLPHP MySQL PHP MySQL 7
Web phpdev 8
9 DOS Mysql localhost root mysql matsui hideki matsui localhost sample_db mysql
sample_db sample_db DB sample_db 10
record 8 id INT AUTO_INCREMENT, id registdata timestamp, registdata sample_db record record 11
12 record 1 name answer1 0 answer2 1 id registdata record id registdata
index.php form.php confirm.php insert.php show.php 13
index.php show.php index.php delete_input.php delete.php 14
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; if(! @mysql_close($my_con)){ print "${hostname} "; } }?> 15
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
index.php <!-- <tr> --> <!-- show.php <html> --> <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> <!-- delete_input.php --> <form action="delete_input.php" method="post"> <hr> <td> <br> </h2> </td><td><input type="submit" value=" "></td> <!-- --> <!-- form.php--> <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
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>
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> <!-- insert.php </head> "name","answer1","answer2" --> <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.php --> </form><br> <?php $name = $_POST[yourname]; <!-- form.php $answer1 = $_POST[0]; --> $answer2 = $_POST[1]; <form action="form.php" method="post"><input?> type="submit" name="submit" value=" <!-- form.php "></form> MYSQL <pre> --> Copyright (C) 2003 yuzuru soga. All Rights Reserved </pre> 19 </body></html>
insert.php <!-- MYSQL --> //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>
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
delete_input.php <!-- id <!-- id --> <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"; <!-- index.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
delete.php <!-- delete_input.php //SQL --> $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
MySQL phpdev http://localhost/phpmyadmin/ mysql GUI 24