MySQL or MySQLi

[shane18]

• MySQL
  
• MySQLi(Object Oriented)
  
• MySQLi(Procedural)
  

 

I know how to use all three ways, but which way is the best?

[corbin]

Typically MySQLi is seen as better.  Slightly better performance, better API, so on.

 

As for OOP or procedural, I personally prefer OOP, but it depends a lot on the style of what ever application you're using MySQLi in.

[shane18]

Well, I really like MySQLi(Object Oriented)... but i hate having to have this extra line....

 

$USER = $DB->query("SELECT * FROM members WHERE id='$USER_ID'");
$USER = $USER->fetch_object();

 

Can I make that one line just like....

 

$USER = mysql_fetch_object(mysql_query("SELECT * FROM members WHERE id='$USER_ID'"));

[shane18]

To clear up my last post, is there anyway to make this code into one line?

 

$USER = $DB->query("SELECT * FROM members WHERE id='$USER_ID'");
$USER = $USER->fetch_object();

[trq]

Can I make that one line just like....

$USER = mysql_fetch_object(mysql_query("SELECT * FROM members WHERE id='$USER_ID'"));

 

That is terrible code. What if mysql_query() fails? You'll have a hard time tracking down your issue if you simply return false to mysql_fetch_object().

 

Terrible code.

[Mchl]

MySQLi whenever possible. First and foremost it gives you prepared statements: the ultimate way to protect yourself against SQL injections (although inability to fetch the results into an array is a bit of a bummer).

Also better support for transactions (mysqli_autocommit) and charsets (mysqli_set_charset). It even allows for asynchronous queries (since PHP5.3 and with mysqlnd driver).

 

 

 

That is terrible code. What if mysql_query() fails? You'll have a hard time tracking down your issue if you simply return false to mysql_fetch_object().

 

QFT

Each of these commands should be surrounded with error handling code.

 

 

[shane18]

can u show me how to properly fetch 1 row from the db, and how to properly fetch multiple rows? my way is crappy and lazy. Thanks for ur opinions they really helped.

[shane18]

BUMP

[Mchl]

Ther are pretty good examples in manual, for example here: mysqli_query or here: mysqli-result.fetch-assoc

 

For some short introduction to error handling, see here:

http://www.phpfreaks.com/blog/or-die-must-die

[shane18]

thanks