Library Management System Requirements Analysis Library Management Program (2)

Book catalog input part:

if(!$UploadAction):
?>

//This program is designed for inputting book title, author and publisher information.
//Editor: Kong Xiuxiang. Date: 2001/3/24
/*
session_start();
if (!isset($auth_passed)) {
echo "This function can only be used by authorized users.";
return -1;
}
if(isset ($u_name)) {
session_name($u_name);
//echo "

".session_name().": This program will serve you wholeheartedly.n";
//echo "

---

";
}
*/
?>




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

著作名
作者	姓 名
作者	姓 名
作者	姓 名
编著方式	著  编著  主编 副主编  参编   注   编   选   评  其他   定价.元
出版社
出版日期	年 月
ISBN
有关书的说明	<br>

TABLE>


else:
session_start();
require "config.php3";
$b_price=trim($b_price_a).".".trim($ b_price_b);
if(strlen($p_month)==1)
$p_m
if($p_m
$p_m
$date_pub=trim($p_year)."-".trim($p_month)."-01" ;
$UploadAction=0;
$repeat=0; //Is it repeated?
$TimeLimit=0; //Set the timeout limit to 30 seconds by default. When set to 0, it is unlimited
set_time_limit($TimeLimit );
@MYSQL_CONNECT($hostname,$dbusername,$dbpassword) OR DIE("Cannot connect to database!");
@mysql_select_db("$dbname") or die("Cannot select database!");
//$ 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="The book title is required, Others: If the ISBN is empty, the author's first and last name, and the publisher are required.
Please check if you meet the requirements.

publisher.publisher_name
books.ISBN,
books.price,
books.date_pub,
books.pages
*/
$r = @mysql_query($q);
//                                        
//                                                                                                                                                                                          ——             —— as been been been more ($r)){
if(trim($isbn)!=""){
echo "Data is repeated.
";
                              exit;
";
          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);
    $teleph
    $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)          $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)        $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);
    $teleph
    $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)        $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)            $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)        $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)            $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)        $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)            $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"