I’ve always wanted to try this “awesome” PDO thing, everyone is talking about it, it was like a miracle came from nothing, They are saying that mysql extension is getting deprecated, Bullshit !
Yes, the Old fashioned MySQL extension is planned to be deprecated but in a long term, so why bother with this new PDO thing ? you should, because it is cross-database, which means the same code works perfectly with all supported databases (well maybe few changes but it is ofcourse way better than rewriting every code in the project).
That made me try it, only that, and I got disappointed and I’m feeling bad for the wasted time :(
The main issue I’ve had is that you can do ONE operation on each query, which means if you want to organize an array from your SELECT query after checking if there are rows or not is not possible, you have to re-query again, which is plain bad.
another thing is lack of SQL error reporting, if the query fails, it returns FALSE, and doesn’t return an error or something, which is again Bad, you have to look for the error yourself.
I’ve had other problems like server crashing twice, “too many connections to the server” “MySQL gone away” and that is enough !
I’ll not go back to PDO again, NEVER, Until they deprecate the OLD fashioned MySQL extension, I’ll move to MySQLi or just use another database without bothering with too many retarded details