PHP MYSQL：使用PHP在MYSQL中插入“+”符号

Question

when i insert let say:

mysql_query("insert into table1 (title) values (\"date + book\")");

the "+" sign is converted to a space. so it became "date   book" not "date + book"

what should i do to insert it as it is. but if i directly query this to MYSQL it accept it as it is.. please clear my confusion.. thanks

"UPDATE campus_bookinfo SET categoryid = ".$category.", bookversion = bookversion+1, 
iAmount = \"".str_replace(",","",$price)."\", lectureName = '".$tag."', eStatus = 3 WHERE idx_campus_bookinfo = ".$id_bookinfo;

Answer 1

Try like this:

mysql_query("insert into table1 (title) values ('date + book')")

or if it is a variable:

mysql_query("insert into table1 (title) values ('$somevariable')")