What's the best way to input and store a url input in a web page in MySQL php?

Question

I'm struggling a bit figuring out the best way accept and store a url from a web page.

Here's my approach:

Does this make sense?

Where it should be urlencoded? On the server? After it's already got sent over the net? What's the point in it? why use strip_slashes on the input? what's so particular in storing urls, making it's processing different from whatever other data? — Your Common Sense
– Your Common Sense, Commented Jan 10, 2012 at 2:38
Maybe I'm just overthinking it. I saw an example site that strip_slashed everything. I guess it has something to do with escape characters being inserted by the browser. — Jack BeNimble
– Jack BeNimble, Commented Jan 10, 2012 at 3:05
stripslashes is never the correct tool to use. If you are encountering data that has slashes unexpectedly, then chances are that your server has magic_quotes enabled and you should find a competent host ASAP. — Charles
– Charles, Commented Jan 10, 2012 at 5:14

Roman Newaza · Accepted Answer · 2012-01-10 02:24:15Z

1

actually, you just need to validate, escape and trim a urls.

answered Jan 10, 2012 at 2:24

Roman Newaza

11.8k12 gold badges65 silver badges94 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Can you give an example of escaping it?

Depends on what extension you use. It could be mysql_real_escape_string() or prepared statements of PDO...

sh03 · Accepted Answer · 2012-01-10 02:40:07Z

1

Use PDO for the database. And just trim your url.

answered Jan 10, 2012 at 2:40

sh03

76.5k39 gold badges177 silver badges282 bronze badges