PHP5.4-Myql 5+ – APOSTROPHES, how to allow them in file names
Allow an apostrophe in a file name during the upload of a file.
This line is taking the data from within a page. Meaning, I already passed the data, but before I insert it into MySql, I want to deal and allow the apostrohpe.
From a FORM Post we can also grab and deal with that apostrophe.
Insert into a mysql DB:
$mysql = INSERT into Table (file_name) VALUES (‘$file_name’);
In conclusion, we are using the mysqli real escape string to clean up the data from the user input.