MySQLi vs PDO?

[Sledmore]

Hey,

I want to try something but I heard not to use mysql_connect no more, so basically which one to go for out of MySQLI and PDO_MySQL? What are the pros and cons of each?

- Thanks.

 

[RastaLulz]

I personally use MySQLi.

The only differences that I know between the two is how you bind params during a query, other than that, I don't know anything major MySQL wise. However, PDO supports more than just MySQL, so that's a plus for people who use something else, but that's all I can think of.

 

[Sledmore]

I personally use MySQLi.

The only differences that I know between the two is how you bind params during a query, other than that, I don't know anything major MySQL wise. However, PDO supports more than just MySQL, so that's a plus for people who use something else, but that's all I can think of.

Thanks for the reply, I had a play with MySQLi a while ago after you posted your thread with the tutorial, thing that got me interested into PDO was PHPAcademy, lol. - I doubt I'd use PDO for more than just MySQL, so I guess I might go with MySQLi.

Anyone else before I decide? ;'D

 

[Kryptos]

Personally I think both are pretty good, although this can give you an idea. Extracted from

You must be registered for see links

So here basically you should go for MySQLi in my opinion, but a plus for PDO is that you can use it for almost any database driver ( Oracle, SQLite, MySQL, Ms SQL, PostGre, IBM ) which is pretty cool and neat.

So, it's up to you to decide - You can always go hardcore and use both ( So awesome, do it for Rev3 can explain you how on MSN )

 

[Sledmore]

Personally I think both are pretty good, although this can give you an idea. Extracted from

You must be registered for see links

So here basically you should go for MySQLi in my opinion, but a plus for PDO is that you can use it for almost any database driver ( Oracle, SQLite, MySQL, Ms SQL, PostGre, IBM ) which is pretty cool and neat.

So, it's up to you to decide - You can always go hardcore and use both ( So awesome, do it for Rev3 can explain you how on MSN )

Thanks, I guess I could go 'hardcore' and do both for some practice, as I'll only be needing one, - but meh, for now I'll just go MySQLi, but thanks, probably will endless nag you anyway, ;].

 

[lepos]

I've not much to comment on but seeing the above posts and doing my fair share of research I suppose you should go for MySQLi or do what

You must be registered for see links

said and go 'hardcore', though MySQLi is the best option by the looks of it

 

[iHarrison]

PDO all the way

 

[Livar]

In my opinion, use MySQLi, because to be honest, never actually tried PDO so I can't judge it

 

[Sledmur]

Gonna use mysqli, thanks Manuel for the help =)