[SOLVED] Mysqli vs Mysql

[PHPTOM]

Hi,

I have always used MySQL, but I might switch to MySQLi. I'm planning a new application I am making but I don't know whether to use MySQLi or MySQL. How do you do things like mysql_fetch_array with mysqli? Is this how you do a query? :

$query = $mysqli->query("SELECT * FROM `table`");

I do understand some of it, like $mysqli would have to be a

$mysqli = new Mysqli;

something like that.

 

Thanks a lot

 

----------------

Now playing: Chris Brown - Forever

via FoxyTunes

[effigy]

They are similar, but MySQLi opens you up to newer features of MySQL and the world of OOP, which is extremely useful. A query and fetch is demonstrated here.

[PHPTOM]

Yes I use OOP that's why I though MySQL would be better. Can I just stick a while on that then? like the same way I can do with mysql_fetch_array()?

while($row = $result->fetch_array(MYSQLI_ASSOC)){
echo $row[username]; //for example
}

 

----------------

Now playing: Deep Purple - Smoke On The Water

via FoxyTunes

[effigy]

Yes.

[PHPTOM]

Fatal error: Class 'mysqli' not found in /home/mysite/public_html/city/inc/db.php on line 6

 

Looks like I need to enable mysqli extension?