inserting links in mysql database table cell

Question

I have a notification system on my website where users will be notified of a certain event. The message of the notification will be stored in a MySQL database.

When I insert links into the message, it returns a MySQL error saying it cannot insert links.

How can I achieve that? I am using php.

MySQL won't complain that it can't insert links. Post your code - in all likelihood, it is incorrect string quoting or something of that nature. (or the code specifically locates and prohibits links) — Michael Berkowski
– Michael Berkowski, Commented Apr 9, 2012 at 17:51

Nathaniel Ford · Accepted Answer · 2012-04-09 18:04:12Z

1

Almost all links will include characters that will be interpreted by a sql database in an odd manner, leading to unpredictable results based on the varied input. You should ensure these characters are properly escaped:

$some_input = getInputFromWebPage();
$safe_input = mysql_real_escape_string($someInput);
insertIntoDB($safe_input);

That is just an example, and obviously not working code, but hopefully it heads you in the right direction. There are several functions that will add escape characters to strings for you.

answered Apr 9, 2012 at 18:04

Nathaniel Ford

21.3k20 gold badges98 silver badges112 bronze badges

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

Collectives™ on Stack Overflow

inserting links in mysql database table cell

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related