PHP查询数据库数据时出现异常

PHP查询数据库数据时出现错误
PHP 查询数据库books中的books表时出现以下错误！

Notice: Trying to get property of non-object in D:\wamp\Apache\htdocs\php\results.php on line 33

Fatal error: Call to a member function fetch_assoc() on a non-object in D:\wamp\Apache\htdocs\php\results.php on line 35


代码如下：

PHP code

    
Book-O-Rama Catalog Search
query($sql);        $num_result=$result->num_rows;        for ($i=0;$ifetch_assoc();            echo "
".($i+1)."title:";            echo htmlspecialchars(stripslashes($row['author']));            echo "Author:".stripslashes($row->newsauthor);            echo "ISBN:".stripslashes($row->newsISBN);            echo "price:".stripslashes($row->newsprice)."
";        }    }    $result->free();    $db->colse();?>    

上述问题那微微大虾能给个解决方案！

------解决方案--------------------

PHP code

$sql ="select * from books  where  ".$searchtype."  like  '%".$searchterm."%'";        if ($result=$db->query($sql)) {            $num_result=$result->num_rows;            for ($i=0;$ifetch_assoc();                echo "
".($i+1)."title:";                echo htmlspecialchars(stripslashes($row['author']));                echo "Author:".stripslashes($row->newsauthor);                echo "ISBN:".stripslashes($row->newsISBN);                echo "price:".stripslashes($row->newsprice)."
";            }        }else{            echo "fail.";            exit;        }

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容，请联系[e-mail]核实处理。
相关文章
相关视频

• 教你使用PHP数据库迁移工具“Phinx”
• 详解win10下PHP的安装配置（以php5.6为...
• php Swoole实现毫秒定时计划任务（详解）
• PHP安全配置_php技巧
• PHP查询数据库数据时出现异常

• HTML基础教程之<strong>和<em>
• HTML基础教程之<span>标签
• HTML基础教程之<meta>标签
• HTML <div> 和<span>
• JavaScript数组对象属性length和二维数组