I know this may be a can of worms but I got to ask.
In my process of learning and expanding on PHP, I have gone through three very helpful books. But when it came to database instructions, two of them guided me using mysqli() and one using PDO(). Don't get me wrong, I love learning new stuff. But this is just annoying. I guess I would like to get an overall opinion of the following:
How will I know which one to use?
Which is easier to migrate?
Which can be referred to more as "standard"?
What are the benefits of either/each one?
and of course,
Why must life be so complicated?