How can I avoid the quote when getting a record from the database?

Question

I am adding records to my database with the $wpdb

following:

$title = 'test url';
$content = '<a href="#">test</a>'
$wpdb->insert($db_name, array(
   "title" => $title,
   "content" => $content
), '%s');

when i check the database i can see that the content is accepting a backslash with quotes like this: <a href=\"#\">test</a>

I tried to get the record from the database using stripcslashes()

, but dosnt work.

Is there a way to do this for security reasons too?

+3

php mysql wordpress

Drwhite May 22 '15 at 21:51

source to share

2 answers

try it

$title = 'test url';
$content = "'<a href=\"#\">test</a>'"
$wpdb->insert($db_name, array(
   "title" => $title,
   "content" => $content
), '%s');

0

ben jarman May 22 '15 at 22:34

source to share

Joe_Tz · Accepted Answer · 2015-05-22T22:51:11+0000

Please get the record from the database and pass it to this function

$without_slashes = stripslashes($row['coln']);