Database abstraction and php tinkering

[mudmin]

I'm glad you're enjoying it.

We're currently working on storing these sorts of options in the database itself which will make the modifications a TON easier. We definitely don't want you to have to modify our code just to decide where someone redirects.

The DB stuff is super easy. I'm working on new documentation, but the current stuff explains it.

Regardless of whether you are updating or inserting, you want to put all of your data into an array before you do your query.

Code:

$fields=array('fname'=>$fname, 'lname'=>'$lname'); //column_name=>entry

Then, if you are INSERTING a new record, all you need is the table you are trying to insert into

So, it would be

Code:

$db->insert('users',$fields); //users is the name of the table in this example

If you are UPDATING, you need to know what record you are updating, so you need to give it that id.

Code:

$db->update('table_name',5,$fields);

To DELETE, you only really need to know the table and some form of logic. So do you want to delete when the username is “bob” or delete when the “id” equals 4. Whatever you want to do, just choose the table name and the logic.

Code:

$db->delete(‘table_name’,array(‘id’,’=’,4));

Pretty much everything you do is just a longer version of that. Does that make sense?

Here is the documentation. I'm happy to help if you need it for any other queries. Once you get it, you'll realize it's so simple and so much faster than doing things procedurally.
http://userspice.org/documentation-db-class-2/