Hi Larry,
I am progressively updating all my websites to use PDO for database actions rather than escape_data/mySQLi.
Can you please recommend the safest way to store HTML links in a database table using PDO.
Do they first need to be urlencoded, say, and/or quoted?
I have searched via Google but have not found clear guidance (for my aged brain anyway).
My code sequence is:
1) create a new PDO
2) create (say) SELECT with placeholders
3) prepare
4) bind parameters and values (one by one for clarity)
5) execute
6) check for successful execution
all within a try/catch block
then null the PDO.
Looking forward to your advice.
Cheers from Oz.