将URL插入MySQL数据库

Question

I'm having troubles with an insert query with MySQL. Here's what I want to do:

in one of the fields in my table, I want to insert a bunch of URLs and their respective titles. I build up this query like so:

?content=<title of webpage>%%<url of webpage>%%<title of webpage>%%<url of webpage>%%

and so on, depending how many URLs there are.

The problem is if the URL contains something like "?var=somevalue" then my query breaks there since MySQL will think that I am declaring a new variable.

How can I achieve this?

Answer 1

I think that you should escape the sequence with a \

If you are using PHP an option is to use the following command (it has multiple forms):

• Procedural style

  string mysqli_real_escape_string ( mysqli $link , string $escapestr )
  

• Object oriented style

  string mysqli::escape_string ( string $escapestr )
  
  string mysqli::real_escape_string ( string $escapestr )