圖書目錄輸入部份：
if(!$UploadAction):
?>
//本程式是輸入書名，作者、出版社資料而設。
//編者：孔秀祥。日期：2001/3/24
/*
session_start();
if (!isset($auth_passed)) {
echo "此功能只有授權使用者才能使用。";
return -1;
}
if(isset($u_name)) {
session_name($u_name);
//echo "
".session_name ().":本程式將竭誠為您服務。n";
//echo "
";
}
*/
?>
書籍目錄輸入 BODY>
else:
session_start();
require "config.php3";
$b_price=trim($b_price_a).". ".trim($b_price_b);
if(strlen($p_month)==1)
$p_m
if($p_m
$$p_$ ."-".trim($p_month)."-01";
$UploadAction=0;
$repeat=0; //是不是重複了。逾時限制時間缺省時間為30秒設定為0時為不限時
set_time_limit($TimeLimit);
@MYSQL_CONNECT($hostname,$dbusername,$dbpassword) OR DIE("無法連接資料庫！") ;
@mysql_select_db("$dbname") or die("不能選擇資料庫！");
//$q="select books.books_id, books.books_name,author.first_name,author.last_name,publisher .publisher_name from books,author,books_author,publisher where books.books_name="$b_name" and books.publisher_id=publisher.publisher_id and books.books_id=books_author.books_id and books_author.hor_hor; =trim($b_name);
$sele="select books.books_id, books.books_name,author.first_name,author.last_name,publisher.publisher_name,books.ISBN,books.price,books.date_pubbook,books.pages. ";
$fro=" from books,author,books_author,publisher ";
if(trim($isbn)!="")
$whe="where books.ISBN="$isbn" ";
elseif(trim($a_first1)!="" && trim($a_last1)!="" && trim($p_name)!="")
$whe=" where books.books_name=" $b_name" and books.publisher_id=publisher.publisher_id and books.books_id=books_author.books_id and books_author.author_id=author.author_id"; else{
為空，則作者的姓、名，出版社為必填。
請檢查是否符合要求。 ";
xueroom_error_exit($msg,$PHP_SELF);
}
$q="$sele$fro$whe";
/*
books.books$fro$whe";
/*
books.books$books
author.first_name,
author.last_name,
publisher.publisher_name
books.ISBN,
books.price,
books.date_pubbooks.date_pubbook. 🎜>*/
$r = @mysql_query($q);
// $count=@mysql_fetch_row($r); ";
if(!$r){
echo "查詢無效
";
exit;
}
if(mysql_num_rows($exit;
}
if(mysql_num_rows($r)){
} > if(trim($isbn)!=""){
echo "且資料重複。
";
exit;
}
else
while($count echo "while。
";
迴聲修剪($a_first1);
$count[2]);
echo "
";
echo trim($a_last1)==trim($count[3]); echo "
"
*/
*/
1) $ trim($count[3]) && trim($p_name)==trim($count[4])){
$data_exist+=1
=$count[1]; $first_name=$count[2];
$last_name=$count[3];
";
echo "書名：".$books_name;
font>".$first_name.$last_name;
echo "
國標標準書號：".$count[5]; 書價：".$count[6]."元";
echo "
發佈日期： ".substr($count[7],0,4)."年".substr($count [7],5,2).「月」;
if($count[8])
echo "頁碼：".$count[8]."頁";
echo"
返回";
//$repeat=0;
退出;
// ){
}// if(mysql_num_rows($r){
//if(!$repeat){
if($p_name!=""){
$p_name=trim($p_name);
$p_name=trim($p_name); $zipcode=trim($zipcode); $teleph
$telefax=trim($telefax); $; results1 = @mysql_query($s_publisher);
if(mysql_num_rows($results1) $q_publisher="INSERT INTO 發表者(publisher_name, 地址) 、郵遞區號、電話、傳真、電子郵件）VALUES ("$p_name", "$address", "$zipcode", "$zgephone ", "$telefax", "$email")";
$result2 = @ mysql_query($q_publisher); $publisher_id= mysql_insert_id();
}
}
else
$publisher_id= $count1[0]; 🎜> >if($bbname=="")";
退出;
}
else{
$b_name=trim($b_name);
$date_pub);
$type=trim($type);
$pages=trim($pages);
// $b_price=trim() =");
$results3 = @mysql_query($s_books);
$count3=mysql_fetch_array($results3); if(mysql_num_rows($results3) $q_books="插入圖書 (books_name、publisher_id、date_pub、類型、頁數、價格、ISBN) VALUES ("$7_7, "$7/$7("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$pub), date_pub", "$type", "$pages", "$b_price","$isbn")";
$result3 = @mysql_query($q_books)
if($result
}
}
其他
$books_id=$count3[0];
}
if(($a_first1=="")| |($a_last1=="")){
echo"第一作者姓名不能為空。";
//退出;
}
else{
$a_first1=trim($a_first1);
$address);
$zipcode=trim($zipcode);
$teleph
$email=trim($email); $results = @mysql_query($s_author);
_num_rows($results) $q_author="插入作者（姓名、姓氏、地址、郵遞區號、電話、電子郵件）值("$a_first1"、"$a_last1"、"$address"、 "$zipcode"、"$telephone" , "$email")";
$result1 = @mysql_query($q_author);
$author_id= mysql_insert_id();
}
}
else
$author_id =$count2[0];
if($books_id!=""||$author_id!=""){
$s_ba="從books_author 中選擇id，其中books_id ="$ books_id" 及author_id="$author_id""
$resulta = @mysql_query($s_ba);
. if(mysql_num_rows($resulta) $q_books_author="INSERT INTO books_author (books_id,author_id,author_type) VALUES (pbooks_id", "$authoraut."$author_type) VALU $author_id="";
$resulta = @mysql_query($q_books_author);
}
2!="")){
$a_first2=trim($a_first2);
$a_last2=trim($a_last2);
p.$ last2" ";
$results5 = @mysql_query($s_author2);
$count5=mysql_fetch_array($results5);
$q_author2="INSERT INTO作者(名字、姓氏、地址、郵遞區號、電話、電子郵件) 值("$a_first2", "$a_last2", "$地址", "$郵遞區號", "$電話", "$電子郵件") ";
$result2 = @mysql_query($q_author2);
= mysql_insert_id();
}
}
其他
$author_id =$count5[0];
if($books_id!=""||$author_id!=""){
$s_ba="從 books_authorhor 中選擇 id，其中 book_hors;
$resulta = @mysql_query($s_ba);
//$counta=mysql_fetch_array($resulta);
if(mysql_num_rows($resulta) , "$author_id", "$author_type")" ;
$author_id="";
$resulta = @mysql_query($q_books_author);
}
}
}
if(($a_first3!="")||($a_last3!="")){
$a_last3=trim($a_last3);
$s_author3="從作者中選擇author_id，其中first_name="$a_first3" 和last_name="$a_last3"";
$results6 = @mysql_query($s_author3);
$count6=mysql_fetch_array($results6);
if(mysql_num_rows($results6) $q_author3="INSERT INTO 作者 (姓名、姓氏、編號( "$地址", "$郵遞區號", "$電話", "$電子郵件")";
$result3 = @mysql_query($q_author3);
if($result3){
$sql.id= my $
}
}
其他
if($books_id!=""||$author_id!=""){
$s_ba="從 books_authorhor 中選擇 id，其中 book_hors;
$resulta = @mysql_query($s_ba);
//$counta=mysql_fetch_array($resulta);
if(mysql_num_rows($resulta) , "$author_id", "$author_type")" ;
$author_id="";
$resulta = @mysql_query($q_books_author);
}
}
}
echo"
回 ";
迴音「
