📄 chaxun.php

📁 ＰＨＰ备份主要用于与ＳＱＬＳＥＲＶＥＲ数据库进行连接　维护
💻 PHP
字号:
<?php
    @$c_name=$_POST['c_name'];
    @$c_author=$_POST['c_author'];
	@$c_number=$_POST['c_number'];
	@$hl=$_POST['hl'];
	@$hll=$_POST['hll'];
	
	
	if($hll)
	{    echo "<script language='javascript'>";
	   	 echo "window.location='inde.php'";
		 echo "</script>";
	 }
	
	
	if($hl)
  { #只有书名
       if(($c_author=="")&&($c_number=="")&&($c_name==""))
	   { echo "<script language='javascript'>";
	   	 echo "alert(\"您输入的信息不全\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
	   }
	   else
	   {
	   
	   
	   if(($c_author=="")&&($c_number==""))
 	   
	   {
	    $cn=mysql_connect('localhost','root','');
        $strsql="SELECT * FROM `book` WHERE `书名` = '$c_name' ";
        $result=mysql_db_query("yonghu",$strsql,$cn);
        $user=mysql_fetch_array($result);
	    if(empty($user))
	    { mysql_close();
         echo "<script language='javascript'>";
	   	 echo "alert(\"没有您要查找的书\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
		}if(!empty($user))
	   {  
	    $bb_name=$user['书名'];
		$bb_author=$user['作者'];
		$bb_number=$user['书号'];
		$bb_class=$user['类型'];
		$bb_charge=$user['价格'];
	    $str="INSERT INTO `cheek` (`b_name`, `b_author`, `b_number`, `b_class`, `b_charge`) VALUES ('$bb_name', '$bb_author', '$bb_number', '$bb_class', '$bb_charge');";
	    mysql_db_query("yonghu",$str,$cn);
		mysql_close();
		header("location:buy.php");
	    }}
	  #只有书号
	  
	  
	   else  if(($c_author=="")&&($c_name==""))
       {
	    $cn=mysql_connect('localhost','root','');
        $strsql="SELECT * FROM `book` WHERE `书号` = '$c_number' ";
        $result=mysql_db_query("yonghu",$strsql,$cn);
        $user=mysql_fetch_array($result);
	    if(empty($user))
	    { mysql_close();
         echo "<script language='javascript'>";
	   	 echo "alert(\"没有您要查找的书\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
		}if(!empty($user))
	   {  
	    $bb_name=$user['书名'];
		$bb_author=$user['作者'];
		$bb_number=$user['书号'];
		$bb_class=$user['类型'];
		$bb_charge=$user['价格'];
	    $str="INSERT INTO `cheek` (`b_name`, `b_author`, `b_number`, `b_class`, `b_charge`) VALUES ('$bb_name', '$bb_author', '$bb_number', '$bb_class', '$bb_charge');";
	    mysql_db_query("yonghu",$str,$cn);
		mysql_close();
		header("location:buy.php");
	    }}
	#只有作者
	 else  if(($c_number=="")&&($c_name==""))
	
	{
	    $cn=mysql_connect('localhost','root','');
        $strsql="SELECT * FROM `book` WHERE `作者` = '$c_author' ";
        $result=mysql_db_query("yonghu",$strsql,$cn);
        $user=mysql_fetch_array($result);
	    if(empty($user))
	    { mysql_close();
         echo "<script language='javascript'>";
	   	 echo "alert(\"没有您要查找的书\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
		}if(!empty($user))
	   {  
	    $bb_name=$user['书名'];
		$bb_author=$user['作者'];
		$bb_number=$user['书号'];
		$bb_class=$user['类型'];
		$bb_charge=$user['价格'];
	    $str="INSERT INTO `cheek` (`b_name`, `b_author`, `b_number`, `b_class`, `b_charge`) VALUES ('$bb_name', '$bb_author', '$bb_number', '$bb_class', '$bb_charge');";
	    mysql_db_query("yonghu",$str,$cn);
		mysql_close();
		header("location:buy.php");
	    }}
	
	
	#同时有作者和书名
	else  if($c_number=="")
	
	{
	    $cn=mysql_connect('localhost','root','');
        $strsql="SELECT * FROM `book` WHERE `作者` = '$c_author' AND `书名` = '$c_name'";
        $result=mysql_db_query("yonghu",$strsql,$cn);
        $user=mysql_fetch_array($result);
	    if(empty($user))
	    { mysql_close();
         echo "<script language='javascript'>";
	   	 echo "alert(\"没有您要查找的书\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
		}if(!empty($user))
	   {  
	    $bb_name=$user['书名'];
		$bb_author=$user['作者'];
		$bb_number=$user['书号'];
		$bb_class=$user['类型'];
		$bb_charge=$user['价格'];
	    $str="INSERT INTO `cheek` (`b_name`, `b_author`, `b_number`, `b_class`, `b_charge`) VALUES ('$bb_name', '$bb_author', '$bb_number', '$bb_class', '$bb_charge');";
	    mysql_db_query("yonghu",$str,$cn);
		mysql_close();
		header("location:buy.php");
	    }}
	
	
	
	
	#同时有作者和书号
	else  if($c_name=="")
	
	{
	    $cn=mysql_connect('localhost','root','');
        $strsql="SELECT * FROM `book` WHERE `作者` = '$c_author' AND `书号` = '$c_number'";
        $result=mysql_db_query("yonghu",$strsql,$cn);
        $user=mysql_fetch_array($result);
	    if(empty($user))
	    { mysql_close();
         echo "<script language='javascript'>";
	   	 echo "alert(\"没有您要查找的书\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
		}if(!empty($user))
	   {  
	    $bb_name=$user['书名'];
		$bb_author=$user['作者'];
		$bb_number=$user['书号'];
		$bb_class=$user['类型'];
		$bb_charge=$user['价格'];
	    $str="INSERT INTO `cheek` (`b_name`, `b_author`, `b_number`, `b_class`, `b_charge`) VALUES ('$bb_name', '$bb_author', '$bb_number', '$bb_class', '$bb_charge');";
	    mysql_db_query("yonghu",$str,$cn);
		mysql_close();
		header("location:buy.php");
	    }}
	
	
	
	
	#同时有书名和书号
	else  if($c_author=="")
	
	{
	    $cn=mysql_connect('localhost','root','');
        $strsql="SELECT * FROM `book` WHERE `书名` = '$c_name' AND `书号` = '$c_number'";
        $result=mysql_db_query("yonghu",$strsql,$cn);
        $user=mysql_fetch_array($result);
	    if(empty($user))
	    { mysql_close();
         echo "<script language='javascript'>";
	   	 echo "alert(\"没有您要查找的书\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
		}if(!empty($user))
	   {  
	    $bb_name=$user['书名'];
		$bb_author=$user['作者'];
		$bb_number=$user['书号'];
		$bb_class=$user['类型'];
		$bb_charge=$user['价格'];
	    $str="INSERT INTO `cheek` (`b_name`, `b_author`, `b_number`, `b_class`, `b_charge`) VALUES ('$bb_name', '$bb_author', '$bb_number', '$bb_class', '$bb_charge');";
	    mysql_db_query("yonghu",$str,$cn);
		mysql_close();
		header("location:buy.php");
	    }
		if($hl)
	{
	       echo "<script language='javascript'>";
           echo "window.location='index.php'";
           echo "</script>";
	
	}
		
		
		
		
		
		}
	
	
	
	
	
	
	#同时有书名和书号和作者
	else  
	
	{
	    $cn=mysql_connect('localhost','root','');
        $strsql="SELECT * FROM `book` WHERE `书名` = '$c_name' AND `书号` = '$c_number'AND `作者` = '$c_author'";
        $result=mysql_db_query("yonghu",$strsql,$cn);
        $user=mysql_fetch_array($result);
	    if(empty($user))
	    { mysql_close();
         echo "<script language='javascript'>";
	   	 echo "alert(\"没有您要查找的书\");";
		 echo "window.location='chaxun.php'";
		 echo "</script>";
		}if(!empty($user))
	   {  
	    $bb_name=$user['书名'];
		$bb_author=$user['作者'];
		$bb_number=$user['书号'];
		$bb_class=$user['类型'];
		$bb_charge=$user['价格'];
	    $str="INSERT INTO `cheek` (`b_name`, `b_author`, `b_number`, `b_class`, `b_charge`) VALUES ('$bb_name', '$bb_author', '$bb_number', '$bb_class', '$bb_charge');";
	    mysql_db_query("yonghu",$str,$cn);
		mysql_close();
		header("location:buy.php");
	    }}
}}
	
 ?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>

<table width="632" border="1">
  <tr>
    <td width="84" height="77">言情小说:</td>
    <td width="532"><table width="100%" cellpadding="0" cellspacing="0">
      <tr>
        <td width="33%">[言情] <a href="book1.php">越夜越狂野 </a></td>
        <td width="33%">[言情] <a href="book2.php">三国恋 </a></td>
        <td width="33%">[言情]<a href="book3.php"> 绝望的牢笼 </a></td>
      </tr>
      <tr>
        <td width="33%"> [言情] <a href="book2.php">非常规之恋 </a></td>
        <td width="33%">[言情]<a href="book3.php"> 预约幸福 </a></td>
        <td width="33%">[言情] <a href="book1.php">拒婚小亲亲 </a></td>
      </tr>
      <tr>
        <td width="33%">[言情] <a href="book3.php">契约新娘 </a></td>
        <td width="33%"> [言情] <a href="book1.php">牵着你就不怕 </a></td>
        <td width="33%">[言情] <a href="book2.php">动动歪脑筋 </a></td>
      </tr>
      <tr>
        <td width="33%">[言情] <a href="book1.php">42度呛辣爱 </a></td>
        <td width="33%">[言情]<a href="book2.php"> 将计就计 </a></td>
        <td width="33%">[言情]<a href="book3.php"> 蝴蝶 </a></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="66">武侠小说:</td>
    <td><table width="99%" cellpadding="0" cellspacing="0">
      <tr>
        <td width="33%">[武侠] <a href="book1.php">绝命谷 </a></td>
        <td width="33%">[武侠] <a href="book2.php">点与线 </a></td>
        <td width="33%">[武侠] <a href="book3.php">最寒冷的冬天 </a></td>
      </tr>
      <tr>
        <td width="33%">[武侠] <a href="book2.php">矫龙惊蛇录 </a></td>
        <td width="33%"> [武侠] <a href="book3.php">别让老婆上网 </a></td>
        <td width="33%">[武侠] <a href="book1.php">水上的声音 </a></td>
      </tr>
      <tr>
        <td width="33%">[武侠] <a href="book3.php">到处都是我们 </a></td>
        <td width="33%">[武侠] <a href="book1.php">爱人有罪 </a></td>
        <td width="33%">[武侠] <a href="book2.php">别人的爱情 </a></td>
      </tr>
      <tr>
        <td width="33%">[武侠] <a href="book1.php">欲望之路 </a></td>
        <td width="33%">[武侠] <a href="book2.php">摇摆女生1 </a></td>
        <td width="33%">[武侠]<a href="book2.php"> 摇摆女生2</a><a href="xd/4_13002_39188.html"> </a></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td height="75">现代小说:</td>
    <td><table width="99%" cellpadding="0" cellspacing="0">
      <tr>
        <td width="33%">[现代] <a href="book1.php">出卖真心的女 </a></td>
        <td width="33%">[现代] <a href="book2.php">出卖真心的女 </a></td>
        <td width="33%">[现代] <a href="book1.php">仲夏夜之恋1 </a></td>
      </tr>
      <tr>
        <td width="33%">[现代] <a href="book2.php">泯灭 </a></td>
        <td width="33%">[现代] <a href="book3.php">老虎帅呆了2 </a></td>
        <td width="33%">[现代]<a href="book2.php"> 卧薪尝胆</a><a href="xd/4_12986_39146.html"> </a></td>
      </tr>
      <tr>
        <td width="33%">[现代] <a href="book3.php">大明王朝15 </a></td>
        <td width="33%">[现代] <a href="book1.php">老虎帅呆了 </a></td>
        <td width="33%">[现代] <a href="book2.php">nini棒棒 </a></td>
      </tr>
      <tr>
        <td width="33%">[现代] <a href="book1.php">G小调进行曲 </a></td>
        <td width="33%">[现代] <a href="book1.php">G小调进行曲 </a></td>
        <td width="33%">[现代] <a href="book3.php">恶魔之吻2 </a></td>
      </tr>
    </table></td>
  </tr>
</table>



<form name="form1" method="post" action="">

<p>按书名查询:
  <input name="c_name" type="text" id="c_name">
</p>
<p>按作者查询:
  <input name="c_author" type="text" id="c_author">
</p>
<p>按书号查询:
  <input name="c_number" type="text" id="c_number">
</p>
<p>
 
  <input type="submit" name="hl" value="提交">
  <input type="reset" name="Submit2" value="重置">
  <input type="submit" name="hll" value="退出">
</form>


  
</p>

<p>&nbsp;</p>
</body>
</html>
💿 文件大小 19 K
👤 上传用户 A15117704533
📂 所属分类 Internet/网络编程
🏷️ 相关标签

#备份 #数据库 #连接
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -