PHP – PDO database use

[fooman]

I am still using good ol’ mysql in order to access databases. It’s served me well, and I can use it pretty well without issue.

I know it’s depreciated so I should be moving on, so I read up about PDO and mysqli.
[PDO DB Access Tutorial](http://net.tutsplus.com/tutorials/php/php-database-access-are-you-doing-it-correctly/ “PDO DB Access Tutorial”)

It stresses prepared statements. This brings me to my question:
I use HTMLPurifier, so what does preparing statements do that I will benefit from? Can I dump HTMLPurifier?

Thanks for any guidance!

[pmac627]

That’s a very good question. I tend to open the connection right before I begin my first query, then close it after the last one. I figured opening a new connection for each operation would increase server processes, but I’ve never actually verified if that would be the case.

[Author]

Posts