PDO CRUD

<?php

// Creds go out to Kevin Waterson
// http://www.phpro.org/classes/PDO-CRUD.html
// http://phpro.org/tutorials/Easy-Access-With-PDO-CRUD.html


class crud{

    private $db;

    /**
     *
     * Set variables
     *
     */
    public function __set($name, $value){
        switch ($name) {
            case 'username':
                $this->username = $value;
                break;

            case 'password':
                $this->password = $value;
                break;

            case 'dsn':
                $this->dsn = $value;
                break;

            default:
                throw new Exception("$name is invalid");
        }
    }

    /**
     *
     * @check variables have default value
     *
     */
    public function __isset($name){
        switch ($name) {
            case 'username':
                $this->username = null;
                break;

            case 'password':
                $this->password = null;
                break;
        }
    }

    /**
     *
     * @Connect to the database and set the error mode to Exception
     *
     * @Throws PDOException on failure
     *
     */
    public function conn(){
        isset($this->username);
        isset($this->password);
        if (!$this->db instanceof PDO) {
            $this->db = new PDO($this->dsn, $this->username, $this->password);
            $this->db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        }
    }


    /***
     *
     * @select values from table
     *
     * @access public
     *
     * @param string $table The name of the table
     *
     * @param string $fieldname
     *
     * @param string $id
     *
     * @return array on success or throw PDOException on failure
     *
     */
    public function dbSelect($table, $fieldname = null, $id = null){
        $this->conn();
        $sql  = "SELECT * FROM `$table` WHERE `$fieldname`=:id";
        $stmt = $this->db->prepare($sql);
        $stmt->bindParam(':id', $id);
        $stmt->execute();
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }


    /**
     *
     * @execute a raw query
     *
     * @access public
     *
     * @param string $sql
     *
     * @return array
     *
     */
    public function rawSelect($sql){
        $this->conn();
        return $this->db->query($sql);
    }

    /**
     *
     * @run a raw query
     *
     * @param string The query to run
     *
     */
    public function rawQuery($sql){
        $this->conn();
        $this->db->query($sql);
    }


    /**
     *
     * @Insert a value into a table
     *
     * @acces public
     *
     * @param string $table
     *
     * @param array $values
     *
     * @return int The last Insert Id on success or throw PDOexeption on failure
     *
     */
    public function dbInsert($table, $values){
        $this->conn();
        /*** snarg the field names from the first array member ***/
        $fieldnames = array_keys($values[0]);
        /*** now build the query ***/
        $size       = sizeof($fieldnames);
        $i          = 1;
        $sql        = "INSERT INTO $table";
        /*** set the field names ***/
        $fields     = '( ' . implode(' ,', $fieldnames) . ' )';
        /*** set the placeholders ***/
        $bound      = '(:' . implode(', :', $fieldnames) . ' )';
        /*** put the query together ***/
        $sql .= $fields . ' VALUES ' . $bound;

        /*** prepare and execute ***/
        $stmt = $this->db->prepare($sql);
        foreach ($values as $vals) {
            $stmt->execute($vals);
        }
                return $this->db->lastInsertId();
    }

    /**
     *
     * @Update a value in a table
     *
     * @access public

     *
     * @param string $table
     *
     * @param string $fieldname, The field to be updated
     *
     * @param string $value The new value
     *
     * @param string $pk The primary key
     *
     * @param string $id The id
     *
     * @throws PDOException on failure
     *
     */
    public function dbUpdate($table, $fieldname, $value, $pk, $id){
        $this->conn();
        $sql  = "UPDATE `$table` SET `$fieldname`='{$value}' WHERE `$pk` = :id";
        $stmt = $this->db->prepare($sql);
        $stmt->bindParam(':id', $id, PDO::PARAM_STR);
        $stmt->execute();
    }


    /**
     *
     * @Delete a record from a table
     *
     * @access public
     *
     * @param string $table
     *
     * @param string $fieldname
     *
     * @param string $id
     *
     * @throws PDOexception on failure
     *
     */
    public function dbDelete($table, $fieldname, $id){
        $this->conn();
        $sql  = "DELETE FROM `$table` WHERE `$fieldname` = :id";
        $stmt = $this->db->prepare($sql);
        $stmt->bindParam(':id', $id, PDO::PARAM_STR);
        $stmt->execute();
    }


        function makePermalink($str, $replace=array(), $delimiter='-') {
            setlocale(LC_ALL, 'en_US.UTF8');
            if( !empty($replace) ) {
                $str = str_replace((array)$replace, ' ', $str);
            }

            $clean = iconv('UTF-8', 'ASCII//TRANSLIT', $str);
            $clean = preg_replace("/[^a-zA-Z0-9\/_|+ -]/", '', $clean);
            $clean = strtolower(trim($clean, '-'));
            $clean = preg_replace("/[\/_|+ -]+/", $delimiter, $clean);

            return $clean;
        }

}
/*** end of class ***/

?>

<?php
/*
How to use
*/

  include 'crud.class.php';

    /*** a new crud object ***/
    $crud = new crud();

    /*** The DSN ***/
    $crud->dsn = "mysql:dbname=animals;host=localhost";

    /*** MySQL username and password ***/
    $crud->username = 'username';
    $crud->password = 'password';


    /*** array of values to insert ***/
    $values = array(
            array('animal_name'=>'bruce', 'animal_type'=>'dingo'),
            array('animal_name'=>'bruce', 'animal_type'=>'wombat'),
            array('animal_name'=>'bruce', 'animal_type'=>'kiwi'),
            array('animal_name'=>'bruce', 'animal_type'=>'kangaroo')
            );
    /*** insert the array of values ***/
    $crud->dbInsert('animals', $values);

    /*** select all records from table ***/
    $records = $crud->rawSelect('SELECT * FROM animals');

    /*** fetch only associative array of values ***/
    $rows = $records->fetchAll(PDO::FETCH_ASSOC);

    /*** display the records ***/
    foreach($rows as $row)
    {
        foreach($row as $fieldname=>$value)
        {
            echo $fieldname.' = '.$value.'<br />';
        }
        echo '<hr />';
    }

    /*** update the kiwi ***/
    $crud->dbUpdate('animals', 'animal_name', 'troy', 'animal_id', 3);

    /*** delete the second record ***/
    $res = $crud->dbSelect('animals', 'animal_id', 3 );

    /*** show the results ***/
    foreach($res as $row)
    {
        echo $row['animal_name'].' = '.$row['animal_type'].'<br />';
    }
?>