Book catalog input part:
if(!$UploadAction):
?>
//This program is designed for inputting book title, author and publisher information.
//Editor: Kong Xiuxiang. Date: 2001/3/24
/*
session_start();
if (!isset($auth_passed)) {
echo "This function can only be used by authorized users.";
return -1;
}
if(isset ($u_name)) {
session_name($u_name);
//echo "
".session_name().": This program will serve you wholeheartedly.n";
//echo "
";
}
*/
?>
圖書目錄輸入
|
|
TABLE>
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_m
$date_pub=trim($p_year)."-".trim($p_month)."-01" ;
$UploadAction=0;
$repeat=0; //Is it repeated?
$TimeLimit=0; //Set the timeout limit to 30 seconds by default. When set to 0, it is unlimited
set_time_limit($TimeLimit );
@MYSQL_CONNECT($hostname,$dbusername,$dbpassword) OR DIE("Cannot connect to database!");
@mysql_select_db("$dbname") or die("Cannot select database!");
//$ 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.author_id=author.author_id";
$b_name=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_pub,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{
?????? $msg="The book title is required, Others: If the ISBN is empty, the author's first and last name, and the publisher are required.
Please check if you meet the requirements.
publisher.publisher_name
books.ISBN,
books.price,
books.date_pub,
books.pages
*/
$r = @mysql_query($q);
// ???????????????????????????????????????
//??????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????? ????????????????????????????????????????????? ——???????????? —— as been been been more ($r)){
if(trim($isbn)!=""){
echo "Data is repeated.
";
????????????????????????????? exit;
";
??????????echo trim($a_first1);
??????????echo trim($count[2]);
??????????echo trim($a_first1)==trim($count[2]);
??????????echo "
";
??????????echo trim($a_last1)==trim($count[3]);
??????????echo "
";
??????????echo trim($p_name)==trim($count[4]);
??????????echo "
";
??????????*/
????if( trim($a_first1)==trim($count[2]) && trim($a_last1)==trim($count[3]) && trim($p_name)==trim($count[4])){
????????$data_exist+=1;
????????$books_id=$count[0];
????????$books_name=$count[1];?????
????????$first_name=$count[2];
????????$last_name=$count[3];
????????$repeat=1;
????????echo "本書已經(jīng)在數(shù)據(jù)庫中。
";?????
????????echo "書名:".$books_name;
????????echo "
作者:".$first_name.$last_name;
????????echo "
國標標準書號:".$count[5];
????????echo "
書價:".$count[6]."元";
????????echo "
出版日期:".substr($count[7],0,4)."年".substr($count[7],5,2)."月";
????????if($count[8])
??????????echo "頁碼:".$count[8]."頁";
????????echo"
返回 ";
????????//$repeat=0;
????????exit;
//????????break;
????}
}//while($count=mysql_fetch_array($r)){??
}//if(mysql_num_rows($r){
//if(!$repeat){
if($p_name!=""){
????$p_name=trim($p_name);
????$address=trim($address);
????$zipcode=trim($zipcode);
????$teleph
????$telefax=trim($telefax);
????$email=trim($email);
????$s_publisher="select publisher_id from publisher where publisher_name="$p_name"";
???????$results1 = @mysql_query($s_publisher);
???????$count1=mysql_fetch_array($results1);
???????if(mysql_num_rows($results1)<1){
??????????$q_publisher="INSERT INTO publisher (publisher_name, address, zipcode, telephone, telefax, email) VALUES ("$p_name", "$address", "$zipcode", "$telephone", "$telefax", "$email")";
????????$result2 = @mysql_query($q_publisher);
????????if($result2){
???????????????????$publisher_id= mysql_insert_id();
??????????}
????}
????else
????????$publisher_id= $count1[0];
}
if($b_name==""){
????echo"書名不能為空。";
????exit;
}
else{
????$b_name=trim($b_name);
????$publisher_id=trim($publisher_id);
//????$date_pub=trim($date_pub);
????$type=trim($type);
????$pages=trim($pages);
//????$b_price=trim();
????$isbn=trim($isbn);
????$s_books="select books_id from books where books_name="$b_name" ";
????$results3 = @mysql_query($s_books);
????$count3=mysql_fetch_array($results3);
????if(mysql_num_rows($results3)<1){
????????$q_books="INSERT INTO books (books_name, publisher_id, date_pub, type, pages, price,ISBN) VALUES ("$b_name", "$publisher_id", "$date_pub", "$type", "$pages", "$b_price","$isbn")";???????
????????$result3 = @mysql_query($q_books);
????????if($result3){
????????????$books_id= mysql_insert_id();
????????}
????}
????else
????????$books_id=$count3[0];
}
if(($a_first1=="")||($a_last1=="")){
????echo"第一作者的姓名不能為空。";
????//exit;
}
else{
????$a_first1=trim($a_first1);
????$a_last1=trim($a_last1);
????$address=trim($address);
????$zipcode=trim($zipcode);
????$teleph
????$email=trim($email);
???????$s_author="select author_id from author where first_name="$a_first1" and last_name="$a_last1"";
???????$results = @mysql_query($s_author);
???????$count2=mysql_fetch_array($results);
???????if(mysql_num_rows($results)<1){
????????$q_author="INSERT INTO author (first_name, last_name, address, zipcode, telephone, email) VALUES ("$a_first1", "$a_last1", "$address",??"$zipcode", "$telephone", "$email")";
????????$result1 = @mysql_query($q_author);
????????if($result1){
???????????????????$author_id= mysql_insert_id();
??????????}
????}
????else
????????$author_id =$count2[0];
????if($books_id!=""||$author_id!=""){
???????????$s_ba="select id from books_author where books_id="$books_id" and author_id="$author_id"";
???????????$resulta = @mysql_query($s_ba);
???????????//$counta=mysql_fetch_array($resulta);
???????????if(mysql_num_rows($resulta)<1){
????????????$q_books_author="INSERT INTO books_author (books_id, author_id, author_type) VALUES ("$books_id", "$author_id", "$author_type")";
????????????$author_id="";
????????????$resulta = @mysql_query($q_books_author);
????????}
????}
}
if(($a_first2!="")||($a_last2!="")){
????$a_first2=trim($a_first2);
????$a_last2=trim($a_last2);
???????$s_author2="select author_id from author where first_name="$a_first2" and last_name="$a_last2"";
???????$results5 = @mysql_query($s_author2);
???????$count5=mysql_fetch_array($results5);
???????if(mysql_num_rows($results5)<1){
????????$q_author2="INSERT INTO author (first_name, last_name, address, zipcode, telephone, email) VALUES ("$a_first2", "$a_last2", "$address",??"$zipcode", "$telephone", "$email")";
????????$result2 = @mysql_query($q_author2);
????????if($result2){
???????????????????$author_id= mysql_insert_id();
??????????}
????}
????else
????????$author_id =$count5[0];
????if($books_id!=""||$author_id!=""){
???????????$s_ba="select id from books_author where books_id="$books_id" and author_id="$author_id"";
???????????$resulta = @mysql_query($s_ba);
???????????//$counta=mysql_fetch_array($resulta);
???????????if(mysql_num_rows($resulta)<1){
????????????$q_books_author="INSERT INTO books_author (books_id, author_id, author_type) VALUES ("$books_id", "$author_id", "$author_type")";
????????????$author_id="";
????????????$resulta = @mysql_query($q_books_author);
????????}
????}
}
if(($a_first3!="")||($a_last3!="")){
????$a_first3=trim($a_first3);
????$a_last3=trim($a_last3);
???????$s_author3="select author_id from author where first_name="$a_first3" and last_name="$a_last3"";
???????$results6 = @mysql_query($s_author3);
???????$count6=mysql_fetch_array($results6);
???????if(mysql_num_rows($results6)<1){
????????$q_author3="INSERT INTO author (first_name, last_name, address, zipcode, telephone, email) VALUES ("$a_first2", "$a_last2", "$address",??"$zipcode", "$telephone", "$email")";
????????$result3 = @mysql_query($q_author3);
????????if($result3){
???????????????????$author_id= mysql_insert_id();
??????????}
????}
????else
????????$author_id =$count6[0];
????if($books_id!=""||$author_id!=""){
???????????$s_ba="select id from books_author where books_id="$books_id" and author_id="$author_id"";
???????????$resulta = @mysql_query($s_ba);
???????????//$counta=mysql_fetch_array($resulta);
???????????if(mysql_num_rows($resulta)<1){
????????????$q_books_author="INSERT INTO books_author (books_id, author_id, author_type) VALUES ("$books_id", "$author_id", "$author_type")";
????????????$author_id="";
????????????$resulta = @mysql_query($q_books_author);
????????}
????}
}
echo"
返回 ";
echo"