<?php
$host="localhost";
$user="s00";
$pass="123";
$database="s00_db";

$link=mysql_connect($host,$user,$pass);// connect MySQL
if($link==False) echo "Connect failure";
else echo "Connect OK!";

$db=mysql_select_db($database,$link); // select DB
if($db==False) echo "Select $database failuer !<p>";
else echo "Select $database OK !<p>";

$q1="Select * From author";
$result=mysql_query($q1,$link);

$n=mysql_num_rows($result);
echo "There are $n records. <p>";

for($i=0;$i<$n;$i++)
{
$linedata=mysql_fetch_row($result);
echo "ID: $linedata[0] , Name: $linedata[1] , Tel: $linedata[2] <P>";
}

$elink=mysql_close($link); // close connection
if($elink== False) echo "Close failure !<p>";
else echo "Close OK !<p>";

?>

<form action="ex002b.php" method="post">
查詢單價超過
<input type ="text" name="price">
的書本,
<input type ="submit" value="送出">
</form>

<?php
$price=$_POST['price'];

$host="localhost";
$user="s00";
$pass="123";
$database="s00_db";

$link=mysql_connect($host,$user,$pass);// connect MySQL
if($link==False) echo "Connect failure";
else echo "Connect OK!";

$db=mysql_select_db($database,$link); // select DB
if($db==False) echo "Select $database failuer !<p>";
else echo "Select $database OK !<p>";

$q1="Select * From product where Product_Price > $price ";
$result=mysql_query($q1,$link);

$n=mysql_num_rows($result);
echo "There are $n records. <p>";

for($i=0;$i<$n;$i++)
{
$linedata=mysql_fetch_row($result);
echo "書名: $linedata[1] <P>";
}

$elink=mysql_close($link); // close connection
if($elink== False) echo "Close failure !<p>";
else echo "Close OK !<p>";

?>

新增作者資料表<p>

<form action="ex003b.php" method="post">

作者代號
<input type ="text" name="authorID">
(char(5))<p>
作者姓名
<input type ="text" name="authorNAME">
(char(20))<p>
作者電話
<input type ="text" name="authorTEL">
(char(10))<p>

<input type ="submit" value="新增">
</form>

<?php
$authorID=$_POST['authorID'];
$authorNAME=$_POST['authorNAME'];
$authorTEL=$_POST['authorTEL'];

$host="localhost";
$user="s00";
$pass="123";
$database="s00_db";

$link=mysql_connect($host,$user,$pass);// connect MySQL
if($link==False) echo "Connect failure";
else echo "Connect OK!";

$db=mysql_select_db($database,$link); // select DB
if($db==False) echo "Select $database failuer !<p>";
else echo "Select $database OK !<p>";

$q1="Insert Into author(Author_ID,Author_Name,Author_TEL) Values('$authorID','$authorNAME','$authorTEL')";
$result=mysql_query($q1,$link);

if($result==False) echo "Insert failuer !<p>";
else echo "Insert OK !<p>";

$elink=mysql_close($link); // close connection
if($elink== False) echo "Close failure !<p>";
else echo "Close OK !<p>";

?>

更新作者電話<p>

<form action="ex003b.php" method="post">

作者姓名
<input type ="text" name="authorNAME">
(char(20))<p>
<font color="#FF0000">更新後的作者電話</font>
<input type ="text" name="authorTEL">
(char(10))<p>

<input type ="submit" value="更新">
</form>

<?php
$authorNAME=$_POST['authorNAME'];
$authorTEL=$_POST['authorTEL'];

$host="localhost";
$user="s00";
$pass="123";
$database="s00_db";

$link=mysql_connect($host,$user,$pass);// connect MySQL
if($link==False) echo "Connect failure";
else echo "Connect OK!";

$db=mysql_select_db($database,$link); // select DB
if($db==False) echo "Select $database failuer !<p>";
else echo "Select $database OK !<p>";

$q1="Update author Set Author_TEL='$authorTEL' where Author_Name='$authorNAME'";
$result=mysql_query($q1,$link);

if($result==False) echo "Update failuer !<p>";
else echo "Update OK !<p>";

$elink=mysql_close($link); // close connection
if($elink== False) echo "Close failure !<p>";
else echo "Close OK !<p>";

?>

刪除作者相關資料<p>

<form action="ex005b.php" method="post">

作者姓名
<input type ="text" name="authorNAME">
(char(20))<p>

<input type ="submit" value="刪除">
</form>

<?php
$authorNAME=$_POST['authorNAME'];

$host="localhost";
$user="s00";
$pass="123";
$database="s00_db";

$link=mysql_connect($host,$user,$pass);// connect MySQL
if($link==False) echo "Connect failure";
else echo "Connect OK!";

$db=mysql_select_db($database,$link); // select DB
if($db==False) echo "Select $database failuer !<p>";
else echo "Select $database OK !<p>";

$q1="Delete From author where Author_Name='$authorNAME'";
$result=mysql_query($q1,$link);

if($result==False) echo "Delete failuer !<p>";
else echo "Delete OK !<p>";

$elink=mysql_close($link); // close connection
if($elink== False) echo "Close failure !<p>";
else echo "Close OK !<p>";

?>