storing javascript in a database

[Styles2304]

I was trying to update my database with this block of info for my church that requires some javascript however the quotes are throwing me off. Can you tell me how to fix that?

 

Here's the link:

 

<a href="javascript:void(0)" onclick="changePage('randompage.html');" class="announcements">here</a>

 

 

[gurroa]

You wish to store this block of data into the database?

If so

$data = '<a href="..." onclick=" ('som..')">Here</a>';
mysql_query(sprintf("update table set field = '%s' where id = 1",
  htmlspecialchars($data, ENT_QUOTES)
));

[Styles2304]

Is there a way to do it outside of a custom PHP form? I'm trying to enter it directly into the database using phpMyAdmin

[fenway]

Is there a way to do it outside of a custom PHP form? I'm trying to enter it directly into the database using phpMyAdmin

 

No idea if phpmyadmin does automatic quote escaping.