首页 php教程 php手册 图书管理程序(二)_php基础

图书管理程序(二)_php基础

May 17, 2016 am 09:07 AM

图书目录输入部分:

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 ?>" METHOD = "POST">














著作名
作者
作者
作者
编著方式

  定价.


出版社
出版日期
月  
ISBN

有关书的说明













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为空,则作者的姓、名,出版社为必填。
请检查是否符合要求。";
    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]."
";
if(!$r){
    echo "查询无效
";
    exit;
}
if(mysql_num_rows($r)){
    if(trim($isbn)!=""){
        echo "数据重复。
";
        exit;
    }
    else
while($count=mysql_fetch_array($r)){  
/*
          echo "while。
";
          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);
    $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)          $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);
    $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)        $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"
本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn

热AI工具

Undresser.AI Undress

Undresser.AI Undress

人工智能驱动的应用程序,用于创建逼真的裸体照片

AI Clothes Remover

AI Clothes Remover

用于从照片中去除衣服的在线人工智能工具。

Undress AI Tool

Undress AI Tool

免费脱衣服图片

Clothoff.io

Clothoff.io

AI脱衣机

AI Hentai Generator

AI Hentai Generator

免费生成ai无尽的。

热门文章

R.E.P.O.能量晶体解释及其做什么(黄色晶体)
2 周前 By 尊渡假赌尊渡假赌尊渡假赌
仓库:如何复兴队友
4 周前 By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒险:如何获得巨型种子
4 周前 By 尊渡假赌尊渡假赌尊渡假赌

热工具

记事本++7.3.1

记事本++7.3.1

好用且免费的代码编辑器

SublimeText3汉化版

SublimeText3汉化版

中文版,非常好用

禅工作室 13.0.1

禅工作室 13.0.1

功能强大的PHP集成开发环境

Dreamweaver CS6

Dreamweaver CS6

视觉化网页开发工具

SublimeText3 Mac版

SublimeText3 Mac版

神级代码编辑软件(SublimeText3)