Mysql or Mysqli ??

[duncan2010]

I'm sure this is asked a million times, so if it annoys you then just don' answer. I have searched the forums before asking this, but as a newbie to code I see the forum as a quick way to gain knowledge, rather than put all the ground work in from scratch.

 

That said, my question is wheather it's best to learn mysql or mysqli? (in your opinion of course) What is most widely used in the industry? I know that mysqli is newest and supports OO programming, but it would seem that many people still use mysql and therefore procedural style. Any good advice is always welcomed. I don't want to spend ages learning one only to find that later on it will not be as useful.

 

Thanks.

[JAY6390]

It can't hurt to learn both, since they're very similar with the way in which they work, however you should strive to use mysqli as it's name clearly tells you it's IMPROVED so it's better than the original. Note that the original version of mysql for php was procedural code and that mysqli is object oriented (OOP)

[Buddski]

Just a little note to add to what JAY6390 said about mysqli.

mysqli is not just OOP it also has procedural versions of its functions

[duncan2010]

Thankyou guys. Very useful info. Is the general trend in industry towards mysqli then? Is Mysql being outdated or is it still widely used and just a matter or preference? I originally learnt java so am used to the OO aproach.