图书管理程序（二）
author：一佰互联 2019-05-01 click：166
图书目录输入部分： <? if(!$UploadAction): ?> <? //本程序是为输入书名，作者、出版社资料而设。 //编者：孔秀祥。日期：2001/3/24 /* session_start(); if (!isset($auth_passed)) { echo "本功能只有授权用户才能使用。"; return -1; } if(isset($u_name)) { session_name($u_name); //echo "<center><font color="red">".session_name().":本程序将竭诚为您服务。</font></center>"; //echo "<hr>"; } */ ?> <HTML><HEAD> <TITLE>图书目录输入 </TITLE> </HEAD> <BODY><TABLE align=CENTER> <FORM ENCTYPE= "multipart/form-data" NAME = "SubmitForm" ACTION= "<? $PHP_SELF ?>" METHOD = "POST"> <INPUT TYPE= "hidden" NAME = "MAX_FILE_SIZE" VALUE ="20000000"> <INPUT TYPE= "hidden" NAME = "UploadAction" VALUE = "1"> <!--TR><TD>文件名<TD><INPUT NAME = "UploadFile" TYPE = "file" VALUE="" SIZE = "30"></TR--> <TR><TD align=center>著作名<TD><INPUT NAME = "b_name" TYPE = "text" VALUE="" SIZE = "30" maxlength=100></TD></TR> <TR><TD align=center>作者<TD>姓<INPUT NAME = "a_first1" TYPE = "text" VALUE="" SIZE = "6" maxlength=20> 名<INPUT NAME = "a_last1" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR> <TR><TD align=center>作者<TD>姓<INPUT NAME = "a_first2" TYPE = "text" VALUE="" SIZE = "6" maxlength=20> 名<INPUT NAME = "a_last2" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR> <TR><TD align=center>作者<TD>姓<INPUT NAME = "a_first3" TYPE = "text" VALUE="" SIZE = "6" maxlength=20> 名<INPUT NAME = "a_last3" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR> <TD>编著方式</TD> <TD> <SELECT size="1" name="author_type" TYPE = "int" default=11> <OPTION selected value="11"> 著 </OPTION> <OPTION selected value="12"> 编著 </OPTION> <OPTION value="13"> 主编</OPTION> <OPTION value="14">副主编</OPTION> <OPTION value="15"> 参编</OPTION> <OPTION value="16"> 注 </OPTION> <OPTION value="17"> 编 </OPTION> <OPTION value="18"> 选 </OPTION> <OPTION value="19"> 评 </OPTION> <OPTION value="20"> 其他</OPTION> </SELECT> 定价<INPUT NAME = "b_price_a" TYPE = "text" VALUE="" SIZE = "3">.<INPUT NAME = "b_price_b" TYPE = "text" VALUE="" SIZE = "2">元 </TR> <TR><TD align=center>出版社<TD><INPUT NAME = "p_name" TYPE = "text" VALUE="" SIZE = "30" maxlength=100></TD></TR> <TR><TD>出版日期<TD><INPUT NAME = "p_year" TYPE = "text" VALUE="" SIZE = "4">年 <INPUT NAME = "p_month" TYPE = "text" VALUE="" SIZE = "2">月 <TR><TD>ISBN<TD><INPUT NAME = "isbn" TYPE = "text" VALUE="" SIZE = "25"> <TR><TD rowspan=5>有关书的说明</TD> <!--/TR><TR--> <TD rowspan=5><TEXTAREA wrap=on rows="5" cols="30" NAME = "b_comment" SIZE = "255"> </TEXTAREA></TD> </TR> </TABLE> <TABLE align=center> <TR><TD align=center> <INPUT NAME = "submit" VALUE = "提交" TYPE = "submit"> <TD><INPUT NAME = "reset" VALUE = "重置" TYPE = "reset"> </TD></TR> </FORM></CENTER></TABLE></BODY> </HTML> <? else: session_start(); require "config.php3"; $b_price=trim($b_price_a).".".trim($b_price_b); if(strlen($p_month)==1) $p_month="0".trim($p_month); if($p_month=="") $p_month="01"; $date_pub=trim($p_year)."-".trim($p_month)."-01"; $UploadAction=0; $repeat=0; //是不是重复了。 $TimeLimit=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.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="书名为必填，其他如果ISBN为空，则作者的姓、名，出版社为必填。<BR>请检查是否符合要求。"; xueroom_error_exit($msg,$PHP_SELF); } $q="$sele$fro$whe"; /* books.books_id, books.books_name, author.first_name, author.last_name, publisher.publisher_name books.ISBN, books.price, books.date_pub, books.pages */ $r = @mysql_query($q); // $count=@mysql_fetch_row($r); // echo "书名".$count[1]."<BR>"; if(!$r){ echo "查询无效 <BR>"; exit; } if(mysql_num_rows($r)){ if(trim($isbn)!=""){ echo "数据重复。<BR>"; exit; } else while($count=mysql_fetch_array($r)){ /* echo "while。<BR>"; echo trim($a_first1); echo trim($count[2]); echo trim($a_first1)==trim($count[2]); echo "<BR>"; echo trim($a_last1)==trim($count[3]); echo "<BR>"; echo trim($p_name)==trim($count[4]); echo "<BR>"; */ 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 "本书已经在数据库中。<BR>"; echo "<font color="red">书名：</font>".$books_name; echo "<BR><font color="blue">作者：</font>".$first_name.$last_name; echo "<BR><font color="red">国标标准书号：</font>".$count[5]; echo "<BR><font color="blue">书价：</font>".$count[6]."元"; echo "<BR><font color="red">出版日期：</font>".substr($count[7],0,4)."年".substr($count[7],5,2)."月"; if($count[8]) echo "<font color="blue">页码：</font>".$count[8]."页"; echo"<BR><A HREF = $PHP_SELF>返回 </A>"; //$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"<BR><A HREF = $PHP_SELF>返回 </A>"; echo"</BODY></HTML>"; ?> <? endif; ?>
