当前位置: 首页 > 图文教程 > 网络编程 > PHP > 图书管理程序（二）

PHP
php面向对象全攻略 （十五） 多态的应用
php面向对象全攻略 （十六） 对象的串行化
php面向对象全攻略 （十七） 自动加载类
PHP parse_url 一个好用的函数
PHP 字符串分割和比较
全世界最小的php网页木马一枚 附PHP木马的防范方法
PHP 日期加减的类，很不错
PHP 日期时间函数的高级应用技巧
PHP获取163、gmail、126等邮箱联系人地址【已测试2009.10.10】
Ha0k 0.3 PHP 网页木马修改版
PHP iconv 函数转gb2312的bug解决方法
关于页面优化和伪静态
使用zend studio for eclipse不能激活代码提示功能的解决办法
PHP 身份验证方面的函数
基于OpenCV的PHP图像人脸识别技术
用mysql触发器自动更新memcache的实现代码
php 数学运算验证码实现代码
PHP网站开发方案实例
PHP教程:挖掘细节提升网站性能
搜索引擎技术核心揭密(PHP)

No. « 167 168 169 170 »

技术文章搜索

关键字

PHP 中的 图书管理程序（二）

出处:互联网   整理: 软晨网（RuanChen.com）   发布: 2009-09-13   浏览: 176 ::
收藏到网摘: n/a

图书目录输入部分：
<?
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>";
}
*/
?>
<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 = "a_first2" TYPE = "text" VALUE="" SIZE = "6" maxlength=20>
名<INPUT NAME = "a_last2" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR>
<TR><TD align=center>作者<TD>姓<INPUT NAME = "a_first3" TYPE = "text" VALUE="" SIZE = "6" maxlength=20>
名<INPUT NAME = "a_last3" TYPE = "text" VALUE="" SIZE = "6" maxlength=20></TD></TR>
<TD>编著方式</TD>
<TD>
<SELECT size="1" name="author_type" TYPE = "int" default=11>
<OPTION selected value="11"> 著 </OPTION>
<OPTION selected value="12"> 编著 </OPTION>
<OPTION value="13"> 主编</OPTION>
<OPTION value="14">副主编</OPTION>
<OPTION value="15"> 参编</OPTION>
<OPTION value="16"> 注 </OPTION>
<OPTION value="17"> 编 </OPTION>
<OPTION value="18"> 选 </OPTION>
<OPTION value="19"> 评 </OPTION>
<OPTION value="20"> 其他</OPTION>
</SELECT>
定价<INPUT NAME = "b_price_a" TYPE = "text" VALUE="" SIZE = "3">.<INPUT NAME = "b_price_b" TYPE = "text" VALUE="" SIZE = "2">元
</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">
<TR><TD rowspan=5>有关书的说明</TD>
<!--/TR><TR-->
<TD rowspan=5><TEXTAREA wrap=on rows="5" cols="30" NAME = "b_comment" SIZE = "255">
</TEXTAREA></TD>
</TR>
</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.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\")";
$author_id="";
$resulta = @mysql_query($q_books_author);
}
}
}
echo"<BR><A HREF = $PHP_SELF>返回 </A>";
echo"</BODY></HTML>";
?>
<?
endif;
?>