PHP PDO Basics! Escaping/Unescaping Special Characters
Im just starting out with PDO methods and have managed to create a table
and insert 10 test records from a .csv file. I checked the table in
phpMyAdmin and noticed that fields containing speech marks (in the csv
file) were completely enclosed with double quotes like "ORIGINAL CSV VALUE
""WOULD"" BE SOMETHING LIKE THIS" - is this correct or have I done
something wrong?
If thats correct, how do I make the output display normally without the
extra double quotes?
I hope that makes sense? I have read loads of Q&A's similar to this
problem but none of them were explaining what should actually be happening
in the DB itself and subsequently how I pull the data back out and display
it properly when special characters are involved. I can pull it out and
display it - but only with the extra quotes present. Help! Please!
Thanks Scott
No comments:
Post a Comment