[php] Inserting HTML into mySQL

[Danny159]

Hi,

 

I am trying to add HTML into a mySQL database... The script is saying its gone it but its not in the database, however sometimes it works and sometimes it doesnt work.

 

Anyone have any idea how I can fix this maybe I need some code to tell the mysql its html?

 

Dan

[contink]

Can you output your table structure and highlight the fieldname you're storing the HTML in...

 

It may simply be the incorrect choice of field type... You'll also be wanting to escape any input to avoid the SQL suffering a syntax error...

[soveryapt]

What sort of HTML as well would be useful .. i.e. a web address or something more complicated to run, say, a CMS?

 

From memory (and it has been a while) wrapping the field in " " tends to allow it in there better, but as contink said...

 

Can you output your table structure and highlight the fieldname you're storing the HTML in...

[SteveBentley]

Certainly worth running the input through addslashes() and use stripslashes() when you retrieve it to escape characters that could cause you grief.

[Danny159]

This worked thanks for you help again guys

 

Dan