//// $sql = 'SELECT * ' . ' FROM `db` ' . ' WHERE art_name' . ' LIKE \'%name%\' OR name_1' . ' LIKE \'%name%\' OR name_2' . ' LIKE \'%name%\' OR name_3' . ' LIKE \'%name%\' OR name_end' . ' LIKE \'%name%\' OR date1' . ' LIKE \'%name%\''; 改成: $str="select * from db where art_name like '".$name."' or name_1 like '".$name."' or name_2 ..... ..... like '".$name."'";
$sql = "SELECT * FROM `db` WHERE art_name LIKE '%$name%' OR name_1 LIKE '%$name%' OR name_2 LIKE '%$name%' OR name_3 LIKE '%$name%' OR name_end LIKE '%$name%' OR date1 LIKE '%$name%'";
$sql = 'SELECT * '
. ' FROM `db` '
. ' WHERE art_name'
. ' LIKE \'%name%\' OR name_1'
. ' LIKE \'%name%\' OR name_2'
. ' LIKE \'%name%\' OR name_3'
. ' LIKE \'%name%\' OR name_end'
. ' LIKE \'%name%\' OR date1'
. ' LIKE \'%name%\'';
改成:
$str="select * from db
where art_name like '".$name."' or name_1
like '".$name."' or name_2
.....
.....
like '".$name."'";
FROM `db`
WHERE art_name LIKE '%$name%'
OR name_1 LIKE '%$name%'
OR name_2 LIKE '%$name%'
OR name_3 LIKE '%$name%'
OR name_end LIKE '%$name%'
OR date1 LIKE '%$name%'";
如果不能就是php设置的问题了。php心版本中自动全局变量是关闭的,所以要从上一页面取得提交过来得变量要使用$_GET['name'],$_POST['name'],$_SESSION['name']来得到
当然也可以修改自动全局变量为开(php.ini改为register_globals = On);