php new hosting with double quote error

I have just change my hosting, before all my PHP scripts worked fine

but now i get many mysql error like this:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near column = 'value' 

it seems that there is a double quote in some script

there is a way to resolve without update all my PHP scripts?

EDIT: example of PHP code

function test( $table,$column, $where ){

if( get_magic_quotes_gpc() ) { $where = strip_tags( trim( $where ) ); }
else{  $where = strip_tags( mysql_real_escape_string( trim( $where ) ) ); }

$where = "AND id = '" . $where . "' ";

$query = "SELECT " . $column . " FROM " . $table . " WHERE 1 " . $where . " LIMIT 1";
//...

---

您必须传递$table变量或将其声明为全局变量（如果在外部定义的话）。

function test( $column, $where ){
global $table;    

if( get_magic_quotes_gpc() ) { $where = strip_tags( trim( $where ) ); }
else{  $where = strip_tags( mysql_real_escape_string( trim( $where ) ) ); }

$where = "AND id = '" . $where . "' ";

$query = "SELECT " . $column . " FROM " . $table . " WHERE 1 " . $where . " LIMIT 1";

---

如果你的功能看起来如此，会发生什么？

function test( $table,$column, $where ){
    $where=stripslashes($where);
    $where = strip_tags(mysql_real_escape_string(trim( $where )));
    $where = "AND id = '" . $where . "' ";
    $query = "SELECT " . $column . " FROM " . $table . " WHERE 1 " . $where . " LIMIT 1";
}

链接地址: http://www.djcxy.com/p/69556.html

上一篇: 在链接工具中使用单引号而不是双引号

下一篇: PHP新的托管与双引号错误