图书目录输入部分：
``` ".session_name().":本程序将竭诚为您服务。 ``` \n"; //echo " `````` "; } */ ?> ```
``` "; if(!$r){ echo "查询无效 ```
``` "; exit; } if(mysql_num_rows($r)){ if(trim($isbn)!=""){ echo "数据重复。 ```
``` "; exit; } else while($count=mysql_fetch_array($r)){ /* echo "while。 ```
``` "; 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 "本书已经在数据库中。 ```
``` "; 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); $telephone=trim($telephone); $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); $telephone=trim($telephone); $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" "; ?>