After scouring the net for a while, and watching all of these awesome PHP videos, I found the PHP function mysql_real_escape_string() which escapes any characters which may have been entered into the field that you want to show up as regular text. This includes escaping the ' character which I'm sure many people use when describing the 'nature' of something.
In the example below, I have used POST to send text input by the user to the $_POST variable. Once the submit button is pressed, the user is redirected and the data can then be picked up again by $_POST[text_input_name] and assigned to a variable. What must be added, is the mysql_real_escape_string() function which sort of modifies the input text. So instead of just using:
$identification=$_POST['identification'];
You can get around the problem using:
$identification=mysql_real_escape_string($_POST['identification']);
Lastly, when you go to INSERT the escaped input into your database, you need to add some extra characters, not entirely sure why. Instead of just your '$variable' wrapped in single quotes, you need to add a double quote on either end as well as a full stop. So that when you INSERT INTO your table, the PHP script will look something like this:
$query="INSERT INTO table (identification) VALUES '".$introduced."' ";This is no doubt one of many PHP functions which I am yet to learn. But this will solve many problems in the near future, I'm sure. If I remember, I will add the Frog database link for all to browse :D.
Until next time, adios!
