How To Insert The Apostrophe Character MySQL database
- How To Insert The Apostrophe Character MySQL database
I Am Trying To Insert The Post Data From My Php Form Into Mysql Db To Insert Special Characters, Like The "apostrophe" Read The Section On String , Last Updated: Sun Jul 05, 2020
Mon Jan 11, 2010
How do you insert text with apostrophe into a mysql table? I am using PHP and MySQL table to insert data into my database, but when i submit the HTML form, it works except the problem happens when i try to enter the apostrophe (') charater into the SQL database. so how do i dela with insterting apostrophe's characters.
i have tried all the tricks, but none seem to work. although, i must say that i am new to php and mysql so if you can show me how to sql insert string apostrophe using php mysql to insert apostrophe that would be great. i will try to learn more about sql server and how to insert apostrophes. i do have a little expirience in oracle sql insertion but never run into a problem with apostrophe, only with quotes, i did but i was able to use the htmlentities() function, and that worked. but now its the sql insert with apostrophe issue.