hi there,

ive been working with php a little while now and have written some small basic CMS systems myself which have done their job as needed.

i use a certain amount of functions within the site (i.e. resizing images that have been uploaded, checking a valid admin user is logged in etc) but feel that i could be using them a lot more. especially with regards to areas of the CMS where i add/edit/delete mysql records as i am currently writing code for this several times over within the CMS.

i also see that people recommend using the use of classes wherever possible, such as to connect to the database and even some sites that say to use them when adding/editing/deleting mysql records too?

which is the route i should be taking? and if so, any suggestions or links to sites that show me or have samples of codes for class/functions how to do this?

many thanks

Simple rule:

If you have the same code more than once, make it a function (or a class)

thats what i thought too.

so with regards to when i add/delete/update a mysql record, am i best in using a class to do that?

i have managed to use a class to connect to the database sucessfully. i am now just looking for tutorials/sample code on how to use a class to add/delete/update the mysql database.

anyone know any nice easy to understand samples?

thanks

Here's are two simple static functions within a class I use as helpers when doing mysql selection:

PHP Code:

class wayfarer {
    public static function spoon($table, $sort="") {
        if(!empty($sort)) {
            $sort = " ORDER BY ".$sort;
        }
        $sql="SELECT * FROM ".$table.$sort;
        $result=self::sql($sql);
        return $result;
    }

    public static function sql($s) {
        if(!$result=mysql_query($s)) {
            die(SQL_MESSAGE.mysql_error());
        }
        return $result;
    }
} 


I call the first one "spoon" because it is like spoon-feeding content when selecting all of the content in a table, then optionally sorting it a certain way.

The wayfarer::spoon() uses the second one, wayfarer::sql(), which is the more flexible function. All it does is do my error checking for me so I can save a single line of code on other pages. SQL_MESSAGE is a predefined constant.