图书管理程序（二）

浏览：97日期：2023-11-14 19:04:49

图书目录输入部分： <? 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>n"//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 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; ?>;

PHP

上一条：图书管理程序（一）下一条：图书管理程序（三）