大家好,我是一个PHP新手~现在碰到个问题不知道如何解决,寻求帮助!!!在同一个文件夹下有key.php和mysql_class.php我现在在浏览的是key.php代码如下:<?php /**Createdon2010-6-16*...
大家好,我是一个PHP新手~现在碰到个问题不知道如何解决,寻求帮助!!!
在同一个文件夹下有key.php 和 mysql_class.php 我现在在浏览的是key.php
代码如下:
/*
* Created on 2010-6-16
*
* To change the template for this generated file go to
* Window - Preferences - PHPeclipse - PHP - Code Templates
*/
include('mysql_class.php');
$db=new mysql('localhost','root','','keysearch','GBK');
$db ->connect();
if($_GET[key]){
// $sql="SELECT * FROM `test` WHERE content like '%$_GET[key]%'";
$sql="SELECT * FROM test WHERE content LIKE '%$_GET[key]%'";
echo $sql;
$q=$db->query($sql);
//$q=$db->query($sql);
//while($r=$db=>fetch_array($q)){
//echo $r[content]."
";
//}
echo $q;
while($r=$db->fetch_row($q)){
echo $r[content]."
";
}
}
?>
关健字:
mysql_class.php里面的代码如下:
class mysql{
private $host;
private $name;
private $pass;
private $table;
private $ut;
function __construct($host,$name,$pass,$table,$ut){
$this->host=$host;
$this->name=$name;
$this->pass=$pass;
$this->table=$table;
$this->ut=$ut;
$this->connect();
}
function connect(){
$link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());
mysql_select_db($this->table,$link) or die("没该数据库:".$this->table);
mysql_query("SET NAMES '$this->ut'");
}
function query($sql, $type = '') {
if(!($query = mysql_query($sql))) $this->show('Say:', $sql);
return $query;
}
function show($message = '', $sql = '') {
if(!$sql) echo $message;
else echo $message.'
'.$sql;
}
function affected_rows() {
return mysql_affected_rows();
}
function result($query, $row) {
return mysql_result($query, $row);
}
function num_rows($query) {
return @mysql_num_rows($query);
}
function num_fields($query) {
return mysql_num_fields($query);
}
function free_result($query) {
return mysql_free_result($query);
}
function insert_id() {
return mysql_insert_id();
}
function fetch_row($query) {
return mysql_fetch_row($query);
}
function version() {
return mysql_get_server_info();
}
function close() {
return mysql_close();
}
//==============
function fn_insert($table,$name,$value){
$this->query("insert into $table ($name) value ($value)");
}
}
//$db = new mysql('localhost','root','','keysearch',"GBK");
// $db->fn_insert('keysearch','id,title,content,time',"'','我插入的信息','学习PHP',now()");
?>
数据库名:keysearch
表名:test
字段:id title content time
现在就是想在 key页面里完成全站搜索(搜索content)的功能.
在此谢过了~
我现在在key.php里面echo 出$q 显示出现Resource id #4
展开