圖書管理程式（二）_PHP教程

圖書目錄輸入部分：

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 ?>"方法=“發佈”>




著作名> ;
作者姓氏
名
作者姓氏
名
作者姓氏
名稱
編著方式


  著
 編著
 主編
副主編
 參編
  注選項>
  編
  選擇選項>
評
 其他
選擇>
  定價。 元
;

出版社
發布日期 年
月  
ISBN

有關書籍的說明

<br>

表格>






BODY>





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=publiidsher.publisher_id and books.book_horbook. =author.author_id";

$b_name=trim($b_name);
$sele="select books.books_id, books.books_name,author.first_name,author.last_name,publisherbook.publi_name,author.first_name,author.last_name,publisherbook.publi_name,publisherbook. .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_id and books.books_id=books_author.books_id and books_horhor.author_horse.; >    $msg="書名為必填，其他若ISBN為空，則作者的姓、名，出版社為必填。
請檢查是否符合要求。 ";
    xueroom_error_exit($msg,$PHP_SELF);

}
$q="$sele$fro$whe";

$q="$sele$fro$whe";

$q="$sele$fro$whe";

/book ,  
books.books_name,
author.first_name,
author.last_name,
publisher.publisher_name
books.ISBN,
books.price, books.pages
*/
$r = @mysql_query($q);
//             echo "書名".$ count[1]."
";
if(!$r){
    echo "查詢無效
";
    exit;
}
if(mysql_num_row(mysql_nums($ r)){
    if(trim($isbn)!=""){
        echo "資料重複。
";
        exit;
    }
    else
while($count   echo "while。
";
          迴聲修剪($a_first1);
           $count[2]);
          echo "
";
          echo trim($a_last1)==trim($count[3]);           echo "
";
          */ ";
          */
 =trim($count[3]) && trim($p_name)==trim($count[4])){
        $data_exist =1
     books_name=$count[1];        $first_name=$count[2];
        $last_name=$count[3]        $last_name=$15] 
";     
        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);
    $address=trim($address);修剪（$郵遞區號）;
    $電話=修剪（$電話）;
    $trim（$電話=修剪（$電話）;
    $trim（$$電話）;來自出版商的電子郵件）; publisher_id，其中publisher_name="$p_name"";
       $results1 = @mysql_query($s_publisher);
     (mysql_num_rows($results1)          $q_publisher="插入發佈者（發佈者名稱、地址、郵遞區號、電話、傳真、電子郵件）值("$p_name"、"$address"、"$zipcode"、"$telephone"、" $telefax ", "$email")";
        $result2 = @mysql_query($q_publisher);
         $publisher_id= mysql_insert_id(); }
    }
    else
        $publisher_id= $count1[0];
}

if($b_name==""){
 ";
    退出;
}
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);
    $telephone=trim($telephone);
    $email=trim($telephone);
    $email=trim($ename); ="$a_last1"";
       $results = @mysql_query($s_author);
       $count2=mysql_fetch_array($results); ){
        $ q_author="INSERT INTO 作者(名字、姓氏、地址、郵遞區號、電話、電子郵件) 值("$a_first1", "$a_last1", "$address",  "$zipcode ", "$電話", "$電子郵件")";
        $result1 = @mysql_query($q_author);
        if id= mysql_insert_id();    }
    }
    其他
$author_id =$count2[0];

    if($books_id!=""||$author_id!=""){
         $books_id" 與author_id="$author_id""；
           $resulta = @mysql_query($s_ba);             $q_books_author="INSERT INTO books_author (books_id,author_id,author_type) VALUES ("$books_id", "$authoraut."$author_type) VALU   $author_id="";
            $resulta = @mysql_query($q_books_author);
        }
 $p. ){
    $a_first2=trim($a_first2);
    $a_last2=trim($a_last2);
      $a_last2=trim($a_last2);
      ;
       $results5 = @mysql_query($s_author2);
       $count5=mysql_fetch_array($results5)         $q_author2="INSERT INTO 作者(名字、姓氏、地址、郵遞區號、電話、電子郵件) 值("$a_first2", "$a_last2", "$地址",  "$郵遞區號", "$電話", "$電子郵件")" ;
        $result2 = @mysql_query($q_author2);
        if($result2){ 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" 和@ mysql_query($s_author3);
       $count6=mysql_fetch_array($results6);
       ="INSERT INTO (姓名、姓氏、地址、郵遞區號)編碼、電話、電子郵件) Value ("$a_first2", "$a_last2", "$地址",  "$郵遞區號", "$電話", "$email")";
        $result3 = @ mysql_query($q_author3);
        if($result3){
               }

    }
    其他
        $author_id =$count6[ 0 ];
    if($books_id!=""||$author_id!=""){
           $s_ba="從books_author 選擇，其中選擇" ";
           $resulta = @mysql_query($s_ba);
            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"
回傳 ";
迴音「