Hello Larry and Hello Community,
I bought book php and mysql for dynamic web sites in english from USA since i didn't see it in my native language.
I gave a look all book for make general feeling and then i will read better and careful example and teching suggestions.
Book is very very good in my opinion.
My question is about what is best techinque to store html inside mysql database.
I'm studying a bit how work CKeditor, but i think many html editor work more or less in same way, and it use a textarea to collect the html, so what you really need to do after a submit or similar processes is simply get the value of texarea and use php to store html in database.
I'm asking how handle security, quote and double symbols or other problems.
If i have understand i can use directly mysql_real_escape when i get textarea, simply before send html inside mysql or i can use prepared statement and in this case i think i can't use mysql_real_escape so i need pheraps to use htmlentities.
I'm a little confuse about conflict you could have use both htmlentities, prepared statement, mysql_real_escape, etc..
I'm not exactly sure how i is best way general speaking in term of 100% secutiry and in term or not ruin html inside mysql and also i'm not sure what is procedure to make the contrary, i mean get html from mysql and serve i in page.
Thanks very much.
Andrea