圖書管理程序(三)

圖書查詢部分:
<?
if(!$UploadAction):
?>
<?
//本程序是為輸出書名,作者、出版社資料而設。
//編者:孔秀祥。日期:2001/3/25
?>
<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 = “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”>

</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.php(做為現在的主流開發語言)3″;

$b_price=$b_price_a.”.”.$b_price_b;

$UploadAction=0;
$repeat=0;      //是不是重復瞭。
$TimeLimit=0; //設置超時限制時間缺省時間為 30秒設置為0時為不限時
set_time_limit($TimeLimit);
@MySQL(和PHP搭配之最佳組合)_CONNECT($hostname,$dbusername,$dbpassword) OR DIE(“不能連接數據庫!”);
@MySQL(和PHP搭配之最佳組合)_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”;
if($b_name!=””)
    $bn=”books.books_name=”$b_name” and “;
if($p_name!=””)
    $pn=”publisher.publisher_name=”$p_name” and “;
if($a_first1!=””)
    $af=”author.first_name=”$a_first1″ and “;
if($a_last1!=””)
    $al=”author.last_name=”$a_last1″ and “;
if($p_year!=””){
    $date_p=”books.date_pub rlike ^$p_year.* and “;
    }
if($isbn!=””)
    $is=”books.ISBN=”$isbn” and “;
$q=”select books.books_id, books.books_name,author.first_name,author.last_name,publisher.publisher_name from books,author,books_author,publisher  

發佈留言

發佈留言必須填寫的電子郵件地址不會公開。 必填欄位標示為 *