So I'm in the middle of designing my first "website" in the sense that I'm a noob with PHP/MySQL, I've never used them before and as such have taken it upon myself to learn them, thankfully some of my previous programming skills are semi-transferable as I feel more or less "up to speed" with PHP. Earlier I had a slight issue where I couldn't format the output from a mysql query correctly and so hit google to find a solution, I didn't (I figured it out anyway), I found more questions than I did answers
As such my questions are as followed:
What is the current method of connecting/performing computations on a MySQL DB? I've been using MySQL_*, but it appears MySQLi_* would be more efficient.
The php.net website further indicates that mysql_* is deprecated and the way to go is some mystical mumbo jumbo called PDO (PHP Data Objects), is this; A) Correct & B) Future proof?
Besides this: http://uk1.php.net/manual/en/book.pdo.php
Can you recommend an good resources/tutorials geared at/containing PDO?
Thanks.
PS:The mystical bit was a joke, it was funny, ha-ha