圖書管理系統需求分析 圖書管理程式（二）

圖書目錄輸入部份：

if(!$UploadAction):
?>

//本程式是輸入書名，作者、出版社資料而設。
//編者：孔秀祥。日期：2001/3/24
/*
session_start();
if (!isset($auth_passed)) {
echo "此功能只有授權使用者才能使用。";
return -1;
}
if(isset($u_name)) {
  session_name($u_name);
//echo "

".session_name ().":本程式將竭誠為您服務。n";
//echo "

---

";
}
*/
?>

ACTION= " $PHP_SELF ?>"方法=“發佈”>



<br>

表>

BODY>


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_$ ."-".trim($p_month)."-01";
$UploadAction=0;
$repeat=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.hor_hor; =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_pubbook,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{
 為空，則作者的姓、名，出版社為必填。
請檢查是否符合要求。 ";
    xueroom_error_exit($msg,$PHP_SELF);
}
$q="$sele$fro$whe";
/*
books.books$fro$whe";
/*
books.books$booksauthor.first_name,
author.last_name,
publisher.publisher_name
books.ISBN,
books.price,
books.date_pubbooks.date_pubbook. 🎜>*/
$r = @mysql_query($q);
//             $count=@mysql_fetch_row($r); ";
if(!$r){
    echo "查詢無效
";
    exit;
}
if(mysql_num_rows($exit;
}
if(mysql_num_rows($r)){
} >    if(trim($isbn)!=""){
        echo "且資料重複。
";
        exit;
    }
    else
while($count   echo "while。
";
          迴聲修剪($a_first1);
           $count[2]);
          echo "
";
          echo trim($a_last1)==trim($count[3]);           echo "
"
          */
         */
 1) $ trim($count[3]) && trim($p_name)==trim($count[4])){
        $data_exist+=1
    =$count[1];        $first_name=$count[2];
        $last_name=$count[3];
 
";     
        echo "書名：".$books_name;
   font>".$first_name.$last_name;
        echo "
國標標準書號：".$count[5]; 書價：".$count[6]."元";
        echo "
發佈日期： ".substr($count[7],0,4)."年".substr($count [7],5,2).「月」;
        if($count[8])
echo "頁碼：".$count[8]."頁";
        echo"
返回";
        //$repeat=0;
        退出;
//       ){  
}// if(mysql_num_rows($r){
//if(!$repeat){
if($p_name!=""){
    $p_name=trim($p_name);
   $p_name=trim($p_name);     $zipcode=trim($zipcode); $teleph
    $telefax=trim($telefax);        $; results1 = @mysql_query($s_publisher);
    if(mysql_num_rows($results1)          $q_publisher="INSERT INTO 發表者(publisher_name, 地址) 、郵遞區號、電話、傳真、電子郵件）VALUES ("$p_name", "$address", "$zipcode", "$zgephone ", "$telefax", "$email")";
        $result2 = @ mysql_query($q_publisher);             $publisher_id= mysql_insert_id();
         }
    }
    else
        $publisher_id= $count1[0]; 🎜> 🠎>if($bbname=="")";
    退出;
}
else{
    $b_name=trim($b_name);
   $date_pub);
    $type=trim($type);
    $pages=trim($pages);
//    $b_price=trim() =");
    $results3 = @mysql_query($s_books);
    $count3=mysql_fetch_array($results3); if(mysql_num_rows($results3)        $q_books="插入圖書 (books_name、publisher_id、date_pub、類型、頁數、價格、ISBN) VALUES ("$7_7, "$7/$7("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$7), "$pubES ("$pub), date_pub", "$type", "$pages", "$b_price","$isbn")";       
        $result3 = @mysql_query($q_books)
        if($result 
        }
    }
    其他
        $books_id=$count3[0];
}
if(($a_first1=="")| |($a_last1=="")){
    echo"第一作者姓名不能為空。";
    //退出;
}
else{
    $a_first1=trim($a_first1);
 $address);
    $zipcode=trim($zipcode);
    $teleph
    $email=trim($email);        $results = @mysql_query($s_author);
     _num_rows($results)        $q_author="插入作者（姓名、姓氏、地址、郵遞區號、電話、電子郵件）值("$a_first1"、"$a_last1"、"$address"、  "$zipcode"、"$telephone" , "$email")";
        $result1 = @mysql_query($q_author);
        $author_id= mysql_insert_id();
          }
    }
else
        $author_id =$count2[0];
    if($books_id!=""||$author_id!=""){
           $s_ba="從books_author 中選擇id，其中books_id ="$ books_id" 及author_id="$author_id""
           $resulta = @mysql_query($s_ba);
 .           if(mysql_num_rows($resulta)             $q_books_author="INSERT INTO books_author (books_id,author_id,author_type) VALUES (pbooks_id", "$authoraut."$author_type) VALU   $author_id="";
            $resulta = @mysql_query($q_books_author);
        }
2!="")){
    $a_first2=trim($a_first2);
    $a_last2=trim($a_last2);
    p.$ last2" ";
       $results5 = @mysql_query($s_author2);
       $count5=mysql_fetch_array($results5);
        $q_author2="INSERT INTO作者(名字、姓氏、地址、郵遞區號、電話、電子郵件) 值("$a_first2", "$a_last2", "$地址",  "$郵遞區號", "$電話", "$電子郵件") ";
        $result2 = @mysql_query($q_author2);
        = mysql_insert_id();
          }
    }
    其他
        $author_id =$count5[0];
    if($books_id!=""||$author_id!=""){
           $s_ba="從 books_authorhor 中選擇 id，其中 book_hors;
           $resulta = @mysql_query($s_ba);
           //$counta=mysql_fetch_array($resulta);
           if(mysql_num_rows($resulta)           , "$author_id", "$author_type")" ;
            $author_id="";
            $resulta = @mysql_query($q_books_author);
        }
    }
}
if(($a_first3!="")||($a_last3!="")){

    $a_last3=trim($a_last3);
       $s_author3="從作者中選擇author_id，其中first_name="$a_first3" 和last_name="$a_last3"";
       $results6 = @mysql_query($s_author3);
       $count6=mysql_fetch_array($results6);
       if(mysql_num_rows($results6)        $q_author3="INSERT INTO 作者 (姓名、姓氏、編號( "$地址",  "$郵遞區號", "$電話", "$電子郵件")";
        $result3 = @mysql_query($q_author3);
        if($result3){
                   $sql.id= my         $
          }
    }
    其他
       
    if($books_id!=""||$author_id!=""){
           $s_ba="從 books_authorhor 中選擇 id，其中 book_hors;
           $resulta = @mysql_query($s_ba);
           //$counta=mysql_fetch_array($resulta);
           if(mysql_num_rows($resulta)           , "$author_id", "$author_type")" ;
            $author_id="";
            $resulta = @mysql_query($q_books_author);
        }
    }
}
echo"
回 ";
迴音「