Thursday, June 20, 2019

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";
//...

No comments:

Post a Comment

plot explanation - Why did Peaches' mom hang on the tree? - Movies & TV

In the middle of the movie Ice Age: Continental Drift Peaches' mom asked Peaches to go to sleep. Then, she hung on the tree. This parti...