哪儿出错了？大家帮忙看下（特别是用过圣经书的人一定要进来）【php吧】

118.182.155.*

快试试吧，
可以对自己使用挽尊卡咯~

◆

我照着书编了一个搜索图书的php，结果测试时候不提示任何错误，还搜索不到任何图书怎么回事啊？
我最后没办法，我把图书源码原原本本用上，结果还是一样
我检查了，数据库用户密码肯定没错
而且还出现一个很奇怪的东西
本来源码是if (mysqli_connect_errno())

结果我改成if (!mysqli_connect_errno())

还是不出错误，另外说一下，我用的书是Php第四版那本书

这是程序源码：

search.html:<html>
<head>
   <title>Book-O-Rama Catalog Search</title>
</head>

<body>
   <h1>Book-O-Rama Catalog Search</h1>

   <form action="searchtype.php" method="post">
     Choose Search Type:<br />
     <select name="searchtype" style="border:0;">
       <option value="author">Author</option>
       <option value="title">Title</option>
       <option value="isbn">ISBN</option>
     </select>
     <br />
     Enter Search Term:<br />
     <input name="searchterm" type="text">
     <br />
     <input type="submit" value="Search">
   </form>

</body>
</html>

search.php:
<html>
<head>
   <title>Book-O-Rama Search Results</title>
</head>
<body>
<h1>Book-O-Rama Search Results</h1>
<?php
   // create short variable names
   $searchtype=$_POST['searchtype'];
   $searchterm=$_POST['searchterm'];

   $searchterm= trim($searchterm);

   if (!$searchtype || !$searchterm)
   {
      echo 'You have not entered search details.   Please go back and try again.';
      exit;
   }

   if (!get_magic_quotes_gpc())
   {
     $searchtype = addslashes($searchtype);
     $searchterm = addslashes($searchterm);
   }

   @ $db = new mysqli('localhost', 'bookorama', 'bookorama123', 'books');

   if (mysqli_connect_errno())
   {
      echo 'Error: Could not connect to database.   Please try again later.';
      exit;
   }

   $query = "select * from books where ".$searchtype." like '%".$searchterm."%'";
   $result = $db->query($query);

   $num_results = $result->num_rows;

   echo '<p>Number of books found: '.$num_results.'</p>';

   for ($i=0; $i <$num_results; $i++)
   {

118.182.155.*

快试试吧，
可以对自己使用挽尊卡咯~

◆

      $row = $result->fetch_assoc();
      echo '<p><strong>'.($i+1).'. Title: ';
      echo htmlspecialchars(stripslashes($row['title']));
      echo '</strong><br />Author: ';
      echo stripslashes($row['author']);
      echo '<br />ISBN: ';
      echo stripslashes($row['isbn']);
      echo '<br />Price: ';
      echo stripslashes($row['price']);
      echo '</p>';
   }

   $result->free();
   $db->close();

?>
</body>
</html>
<html><head>
   <title>Book-O-Rama Search Results</title>
</head>
<body>
<?php
$searchtype=$_POST['searchtype'];
$searchterm=$_POST['searchtype'];
$searchterm=trim($searchterm);
if(!$searchterm||!$searchtype){
     echo 'you have not enter search details,please go back and try again!';
     exit;
}
if(!get_magic_quotes_gpc())
{
     $searchterm=addcslashes($searchterm);
     $searchterm=addcslashes($searchtype);
}
@$db=new mysqli('localhost','root','1','books');
if(!mysqli_connect_error())
{
    echo 'wrong!don\'t connect database';
    exit;
}
$query="select * from books where ".$searchtype."like '%".$searchterm."%'";
$result=$db.query($query);
$num_result=$result->num_rows;
echo"numbers of books found".$num_result;
for($i=0;$i<$num_result;$i++)
{
     $row = $result->fetch_assoc();
     echo htmlspecialchars(stripslashes($row['title']));
      echo '</strong><br />Author: ';
      echo stripslashes($row['author']);
      echo '<br />ISBN: ';
      echo stripslashes($row['isbn']);
      echo '<br />Price: ';
      echo stripslashes($row['price']);
      echo '</p>';
   }

   $result->free();
   $db->close();

?>

数据库sql:
create table customers
( customerid int unsigned not null auto_increment primary key,
   name char(50) not null,
   address char(100) not null,
   city char(30) not null
);

create table orders
( orderid int unsigned not null auto_increment primary key,
   customerid int unsigned not null,
   amount float(6,2),
   date date not null
);

create table books
(   isbn char(13) not null primary key,
    author char(50),
    title char(100),
    price float(4,2)
);

create table order_items
( orderid int unsigned not null,
   isbn char(13) not null,
   quantity tinyint unsigned,

   primary key (orderid, isbn)

);
create table book_reviews
(
   isbn char(13) not null primary key,
   review text
);

第二个：use books;

insert into customers values
   (NULL, "Julie Smith", "25 Oak Street", "Airport West"),
   (NULL, "Alan Wong", "1/47 Haines Avenue", "Box Hill"),
   (NULL, "Michelle Arthur", "357 North Road", "Yarraville");

insert into orders values
   (NULL, 3, 69.98, "2000-04-02"),
   (NULL, 1, 49.99, "2000-04-15"),
   (NULL, 2, 74.98, "2000-04-19"),
   (NULL, 3, 24.99, "2000-05-01");

insert into books values
   ("0-672-31697-8", "Michael Morgan", "Java 2 for Professional Developers", 34.99),
   ("0-672-31745-1", "Thomas Down", "Installing Debian GNU/Linux", 24.99),
   ("0-672-31509-2", "Pruitt, et al.", "Teach Yourself GIMP in 24 Hours", 24.99),
   ("0-672-31769-9", "Thomas Schenk", "Caldera OpenLinux System Administration Unleashed", 49.99);

insert into order_items values
   (1, "0-672-31697-8", 2),
   (2, "0-672-31769-9", 1),
   (3, "0-672-31769-9", 1),
   (3, "0-672-31509-2", 1),
   (4, "0-672-31745-1", 3);

insert into book_reviews values
   ("0-672-31697-8", "Morgan's book is clearly written and goes well beyond
                      most of the basic Java books out there.");

124.134.217.*

快试试吧，
可以对自己使用挽尊卡咯~

◆

双枪

118.182.143.*

快试试吧，
可以对自己使用挽尊卡咯~

◆

问题已经解决，配置文件没有加载mysqli.php

http://www.dianm123.com

日	一	二	三	四	五	六

哪儿出错了？大家帮忙看下（特别是用过圣经书的人一定要进来）

扫二维码下载贴吧客户端