这两句有什么区别吗
$sql="select * from `task` where `$sort`=".$text."";
$sql="select * from `task` where `$sort`='$text'";
where后面还可以跟什么样的格式?
searchresult.php主要部分.
<?
require_once("config.php");
require_once("db.php");
$sort=$_POST["sort"];
$text=$_POST["text"];
$sql="select * from `task` where `$sort`=".$text."";
$db=new data($db_server,$db_user,$db_pass,$db_name);
$result=$db->execute($sql);?>
db.php中的主要为data类.
class data{
var $conn;
function data($db_server,$db_user,$db_pass,$db_name)
{
$this->conn=@ mysql_connect($db_server,$db_user,$db_pass) or die (mysql_error());
mysql_select_db($db_name,$this->conn);
}
function execute($sql){
mysql_query("set names utf8");
return mysql_query($sql,$this->conn);
}
function getArray($sql){
$result=$this->execute($sql,$this->conn);
return mysql_fetch_array($result);
}
function getCount($sql){
$result=$this->execute($sql,$this->conn);
$a=mysql_fetch_row($result);
return $a[0];
}
function close(){
mysql_close();
}
}希望各位能指点,谢谢
$sql="select * from `task` where `$sort`=".$text."";
$sql="select * from `task` where `$sort`='$text'";
where后面还可以跟什么样的格式?
searchresult.php主要部分.
<?
require_once("config.php");
require_once("db.php");
$sort=$_POST["sort"];
$text=$_POST["text"];
$sql="select * from `task` where `$sort`=".$text."";
$db=new data($db_server,$db_user,$db_pass,$db_name);
$result=$db->execute($sql);?>
db.php中的主要为data类.
class data{
var $conn;
function data($db_server,$db_user,$db_pass,$db_name)
{
$this->conn=@ mysql_connect($db_server,$db_user,$db_pass) or die (mysql_error());
mysql_select_db($db_name,$this->conn);
}
function execute($sql){
mysql_query("set names utf8");
return mysql_query($sql,$this->conn);
}
function getArray($sql){
$result=$this->execute($sql,$this->conn);
return mysql_fetch_array($result);
}
function getCount($sql){
$result=$this->execute($sql,$this->conn);
$a=mysql_fetch_row($result);
return $a[0];
}
function close(){
mysql_close();
}
}希望各位能指点,谢谢
改成
$sql="select * from `task` where ".$sort."=".$text;
试试
改成
$sql="select * from `task` where ".$sort."=".$text;还是不行后来只能$sql="select * from `task` where `$sort`like '%$text%' ";
不过我就奇怪,为什么用“=”就不行呢