图书管理程序（二）_php教程-查字典教程网

图书管理程序（二）

摘要：图书目录输入部分：

图书目录输入部分：

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>";

}

<TITLE>图书目录输入 </TITLE>

</HEAD>

<FORM ENCTYPE= "multipart/form-data" NAME = "SubmitForm"

ACTION= "<? $PHP_SELF ?>" METHOD = "POST">

名<INPUT NAME = "a_last1" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR>

名<INPUT NAME = "a_last2" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR>

名<INPUT NAME = "a_last3" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR>

<TD>

</SELECT>

定价<INPUT NAME = "b_price_a" TYPE = "text" VALUE="" SIZE = "3">.<INPUT NAME = "b_price_b" TYPE = "text" VALUE="" SIZE = "2">元

</TR>

<TR><TD>出版日期<TD><INPUT NAME = "p_year" TYPE = "text" VALUE="" SIZE = "4">年

<INPUT NAME = "p_month" TYPE = "text" VALUE="" SIZE = "2">月

<TR><TD rowspan=5>有关书的说明</TD>

</TEXTAREA></TD>

</TR>

</TABLE>

</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")";