USlegacies

Thank you for responding. I am not sure exactly what you are suggesting, however the form we are setting up is NOT for the public to view, search or edit. Rather it is designed for individuals to "Fill in the form" with data that only office staff can read. The only person that will have access to edit any data will be the db designer. So, basically, all we are trying to do is escape or find a way to deal with the errors we are receiving when someone uses an apostrophe when they enter in their name or as part of a text field, for the php version we are using.

Below is a sample code that I need help on. I am trying to allow certain elderly non-computer savvy individuals to use a cell phone or computer to fill out an online form. My problem is when they try to insert an apostrophe into the form, it displays an error. As an extremely elderly individual myself with no formal computer training in php or mysql, I get lost very easy when trying to sort through so many outdated replies in search engines. Therefore I am hoping someone can give me a simple example of code that will work with the particular version of php and mysql that I am using. I am using multiple html, css and php pages for the form and db connection. The php version I am using is 7.4 and mysql 8.0.31 I am trying to avoid using a higher version of php for now, due to having multiple programs running on the server that could cause problems if I went to php 8.0 Below is an example of the code I have been using and it works great, except for the apostrophe errors. So if anyone can give me an example of the code I need to use, I would be greatly appreciative. I will also add that anyone filling this form out, will need to be a registered member of a private website, so that adds a bit of security to it. There are around 60 different fields in the database, so whatever code it used may have to be repeated often. help_needed.txt