mysql php phpmyadmin使用法 -...
TRANSCRIPT
2009/11/18
1
MySQL+PHPphpMyAdmin使用法
江見圭司
MySQLAdminを起動しよう
2009/11/18
2
• databaseの中にtableがある。
product
product
department
productdepartment
まずはdatabaseを作成する
2009/11/18
3
product department productdepartment
department
2009/11/18
4
department
product
2009/11/18
5
product
productdepartment
2009/11/18
6
productdepartment
product
2009/11/18
7
department
productdepartment
2009/11/18
8
まずはdatabaseを作成する
2009/11/18
9
PHPからMySQLへ
• 9-4PD.php
<HTML><HEAD><TITLE>用PHP从表中读取数据</TITLE></HEAD><BODY><?php$id=mysql_connect("localhost","root",""); mysql_select_db("product",$id);mysql_query("SET CHARACTER SET utf8");$query="SELECT * FROM productdepartment";$result=mysql_query($query,$id);echo "<table border=1
width=200><tr><td>ProductID</td><td>DepartmentID</td></tr>";$datanum=mysql_num_rows($result);echo "表ProductDepartment中共有".$datanum."条数据<br>"; for($i=1;$i<=$datanum;$i++){$info=mysql_fetch_array($result,MYSQL_ASSOC);echo "<tr><td>".$info['ProductID']."</td>";echo "<td>".$info['DepartmentID']."</td></tr>";}
echo "</table>";mysql_close($id);
?></BODY></HTML>
productdepartment
• mysql_connect(IP adress, user name, passwd)
• Mysql_select_db(database name, $id)
$id=mysql_connect("localhost","root",""); mysql_select_db("product",$id);
mysql_query("SET CHARACTER SET utf8");
product
2009/11/18
10
• $query• $result=mysql_query($query,$id); 問い合わせ結果を代入する
$query="SELECT * FROM productdepartment";$result=mysql_query($query,$id);
productdepartment
echo "<table border=1 width=200><tr><td>ProductID</td><td>DepartmentID</td></tr>";
2009/11/18
11
• mysql_num_rows(問い合わせ結果) データベースのレコード数を取得する
$datanum=mysql_num_rows($result);
echo "表ProductDepartment中共有".$datanum."条数据<br>";
• mysql_close($id); データベースを閉じる
for($i=1;$i<=$datanum;$i++){
$info=mysql_fetch_array($result,MYSQL_ASSOC);echo "<tr><td>".$info['ProductID']."</td>";echo "<td>".$info['DepartmentID']."</td></tr>";}echo "</table>";
2009/11/18
12
以下のtableのデータを取得するphpを書いてみよう。
• 9-4P.php
• 9-4D.phpproduct
department
DBは以下のところにあります。• ProductファルダをUSBメモリに入れて持って帰ろう。 E:¥xampplite¥mysql¥data¥product
2009/11/18
13
9-4D.php department
echo "<tr><td>".$info['DepartmentID']."</td>";
echo "<td>".$info['DepartmentName']."</td>";
echo "<td>".$info['DepartmentDescription']."</td>";
echo "<td>".$info['DepartmentImage']."</td></tr>"
• <img src=”./Images/pop.jpg”>
• echo "<td> <img src =”./Images/pop.jpg”> </td></tr>";
• echo "<td> <img src =”./Images/pop.jpg”> </td></tr>";
• ".$info['DepartmentImage']."
• echo "<td> <img src =”./Images/ ".$info['DepartmentImage']."”> </td></tr>";
• echo "<td> <img src =¥”./Images/ ".$info['DepartmentImage'].“¥”> </td></tr>";
Escape sequence
¥”
2009/11/18
14
9-4D.php department
echo "<tr><td>".$info['DepartmentID']."</td>";
echo "<td>".$info['DepartmentName']."</td>";
echo "<td>".$info['DepartmentDescription']."</td>";
echo "<td><img src=¥"./Images/".$info['DepartmentImage']."¥"></td></tr>";