Order Method

This is not an issue at all.
Can you add an "order method" like "where"?
For example:
$db -> order('type', 'ASC'); $db -> get('table');
Whithout this I need to work a lot with "rawquery method".
Otherwise, thanks for this class.

[zQueal]

For something such as this, using MySQLi (my opinion) would be outdated -- you should be using PDO prepared statements.

They're much more clean, and helpful.

[ThingEngineer]

Zachary of course has a point. But to answer your question directly, yes that can be added so I'll leave this open until it is.

[maan]

I extended it to support ORDER BY statements, check if you like. Thanks for the class!

[Gapz]

The method:
$db->order('type', 'ASC');
Would be a great feature!

[maan]

I added such a method some weeks ago. Syntax is:

$db->orderby('db_field', 'ASC');

Standard values are "position" for the database parameter and "ASC" for the order one. So one could write:

$db->orderby('db_field');

or

$db->orderby();

in case you want ascending order and your column is named "position".

[Gapz]

Hey maan,

Thanks for your reply!

It doesn't seem to work and I searched for orderby in the class and can't find anything.

Is there an updated class I should be downloading from somewhere?

[maan]

I forked it, you can find it here: https://github.com/maan/PHP-MySQLi-Database-Class

Put out a request to merge, too.

[Gapz]

Awesome!

Thanks so much, works great!