Carview!

CARVIEW

MOTORHOMES

Select Language

HTTP/2 302 server: nginx date: Sat, 17 Jan 2026 01:49:21 GMT content-type: text/plain; charset=utf-8 content-length: 0 x-archive-redirect-reason: found capture at 20101230143737 location: https://web.archive.org/web/20101230143737/https://codeigniter.com/forums/viewthread/90181 server-timing: captures_list;dur=0.540945, exclusion.robots;dur=0.047421, exclusion.robots.policy;dur=0.037788, esindex;dur=0.009843, cdx.remote;dur=9.470823, LoadShardBlock;dur=301.146459, PetaboxLoader3.resolve;dur=65.467413, PetaboxLoader3.datanode;dur=154.819883 x-app-server: wwwb-app222-dc8 x-ts: 302 x-tr: 336 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 set-cookie: wb-p-SERVER=wwwb-app222; path=/ x-location: All x-as: 14061 x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() HTTP/2 200 server: nginx date: Sat, 17 Jan 2026 01:49:22 GMT content-type: text/html; charset=utf-8 x-archive-orig-date: Thu, 30 Dec 2010 14:37:36 GMT x-archive-orig-server: Apache x-archive-orig-x-powered-by: PHP/5.3.2-1ubuntu4.2 x-archive-orig-set-cookie: bb2_screener_=1293719856+174.129.228.67; path=/ x-archive-orig-set-cookie: exp_last_activity=1293741456; expires=Fri, 30-Dec-2011 14:37:36 GMT; path=/; domain=.codeigniter.com x-archive-orig-set-cookie: exp_tracker=a%3A5%3A%7Bi%3A0%3Bs%3A25%3A%22%2Fforums%2Fviewthread%2F90181%2F%22%3Bi%3A1%3Bs%3A28%3A%22%2Fforums%2Fviewthread%2F84689%2FP0%2F%22%3Bi%3A2%3Bs%3A25%3A%22%2Fforums%2Fviewthread%2F83215%2F%22%3Bi%3A3%3Bs%3A29%3A%22%2Fforums%2Fviewthread%2F82647%2FP15%2F%22%3Bi%3A4%3Bs%3A25%3A%22%2Fforums%2Fviewthread%2F82091%2F%22%3B%7D; path=/; domain=.codeigniter.com x-archive-orig-set-cookie: exp_forum_topics=a%3A5%3A%7Bi%3A82091%3Bi%3A1293741437%3Bi%3A82647%3Bi%3A1293741443%3Bi%3A83215%3Bi%3A1293741449%3Bi%3A84689%3Bi%3A1293741454%3Bi%3A90181%3Bi%3A1293741459%3B%7D; expires=Fri, 30-Dec-2011 14:37:36 GMT; path=/; domain=.codeigniter.com x-archive-orig-expires: Mon, 26 Jul 1997 05:00:00 GMT x-archive-orig-last-modified: Thu, 30 Dec 2010 14:37:36 GMT x-archive-orig-pragma: no-cache x-archive-orig-connection: close x-archive-orig-vary: Accept-Encoding, User-Agent x-archive-guessed-content-type: text/html x-archive-guessed-charset: utf-8 memento-datetime: Thu, 30 Dec 2010 14:37:37 GMT link: ; rel="original", ; rel="timemap"; type="application/link-format", ; rel="timegate" content-security-policy: default-src 'self' 'unsafe-eval' 'unsafe-inline' data: blob: archive.org web.archive.org web-static.archive.org wayback-api.archive.org athena.archive.org analytics.archive.org pragma.archivelab.org wwwb-events.archive.org x-archive-src: alexa-web-20110623084050-00002/51_19_20101230143712_crawl100.arc.gz server-timing: captures_list;dur=1.522638, exclusion.robots;dur=0.028091, exclusion.robots.policy;dur=0.012679, esindex;dur=0.014471, cdx.remote;dur=6.478253, LoadShardBlock;dur=141.351164, PetaboxLoader3.datanode;dur=95.456582, PetaboxLoader3.resolve;dur=68.408431, load_resource;dur=126.098792 x-app-server: wwwb-app222-dc8 x-ts: 200 x-tr: 516 server-timing: TR;dur=0,Tw;dur=0,Tc;dur=0 x-location: All x-as: 14061 x-rl: 0 x-na: 0 x-page-cache: MISS server-timing: MISS x-nid: DigitalOcean referrer-policy: no-referrer-when-downgrade permissions-policy: interest-cohort=() content-encoding: gzip DataMapper 1.6.0 | CodeIgniter Forums

1 of 101

Last »

DataMapper 1.6.0

stensi

Posted: 05 September 2008 09:32 AM

[ Ignore ]

Lab Assistant

Total Posts: 124

Joined 06-01-2008

UPDATE

10 December 2008 - Version 1.6.0 Released (Current version)
6 December 2008 - Version 1.5.4 Released
5 December 2008 - Version 1.5.3 Released
4 December 2008 - Version 1.5.2 Released
4 December 2008 - Version 1.5.1 Released
3 December 2008 - Version 1.5.0 Released
15 October 2008 - Version 1.4.5 Released
13 October 2008 - Version 1.4.4 Released
13 October 2008 - Version 1.4.3 Released
12 October 2008 - Version 1.4.2 Released
11 October 2008 - Version 1.4.1 Released
11 October 2008 - Version 1.4 Released
8 October 2008 - Version 1.3.4 Released
3 October 2008 - Version 1.3.3 Released
2 October 2008 - Version 1.3.2 Released
2 October 2008 - Version 1.3.1 Released
29 September 2008 - Version 1.3.0 Released
24 September 2008 - Version 1.2.1 Released
17 September 2008 - Version 1.2 Released
7 September 2008 - Version 1.0 Released

View the Change Log to see what’s changed.

____________________________________

My DataMapper is finished!

Ever since Michael Wales posted a sneak peak of the DataMapper ORM class he was working on, I was inspired to start making my own!

The concept of having your Database tables as objects, and being able to manipulate them and their relationships so easily was too appealing for me to wait. So, sorry if I’m stealing some of your thunder Michael

DataMapper

DataMapper is an Object Relational Mapper written in PHP for CodeIgniter. It is designed to map your Database tables into easy to work with objects, fully aware of the relationships between each other.

Features
* Everything is an object!
* Easy to setup, easy to use.
* Custom Validation on object properties.
* Lazy Loading (related objects are only loaded upon access).
* Relations and their integrity are automatically managed for you.
* One to One, One to Many, and Many to Many relations fully supported.

I went to a lot of trouble designing this and have even gone so far as to fully document it with a dedicated User Guide!

DataMapper Source Files
DataMapper User Guide

Enjoy

Signature

[ DataMapper | DataMapper Source Files | DataMapper User Guide ] - [ History | History Source Files | History User Guide ]

Profile

wiredesignz

Posted: 05 September 2008 10:14 AM

[ Ignore ] [ # 1 ]

Sr. Research Associate

Total Posts: 2891

Joined 06-10-2007

Wow man, you’ve done an awesome job there, documentation and all.

Excellent work.

Signature

URI Language Identifier | Modular Extensions - HMVC | View Object | Widget plugin | Access Control library

Profile

Jamie Rumbelow

Posted: 05 September 2008 10:35 AM

[ Ignore ] [ # 2 ]

Research Assistant

Total Posts: 689

Joined 02-24-2008

Well done!

Great library, and well documented. Keep up the good work

Signature

Jamie Rumbelow freelance developer / writer / speaker
+44 (0)7956 363875 jamie(at)jamierumbelow(dot)net
https://jamierumbelow.net

Profile

stensi

Posted: 06 September 2008 06:53 PM

[ Ignore ] [ # 3 ]

Lab Assistant

Total Posts: 124

Joined 06-01-2008

Thanks guys

In case people were wanting to see some examples in the thread instead, here’s a simple one.

First, we’ll setup a few DataMapper models:

User model

<?php

class User extends DataMapper {

    var $has_many = array('book' => 'books');
    var $has_one = array('country' => 'countries');

    var $validation = array(
        array(
            'field' => 'username',
            'label' => 'Username',
            'rules' => array('required', 'trim', 'unique', 'alpha_dash', 'min_length' => 3, 'max_length' => 20),
        ),
        array(
            'field' => 'password',
            'label' => 'Password',
            'rules' => array('required', 'trim', 'unique', 'min_length' => 6, 'encrypt'),
        ),
        array(
            'field' => 'confirm_password',
            'label' => 'Confirm Password',
            'rules' => array('encrypt', 'matches' => 'password'),
        ),
        array(
            'field' => 'email',
            'label' => 'Email Address',
            'rules' => array('required', 'trim', 'valid_email')
        )
    );

    function User()
    {
        parent::DataMapper();
    }

    function login()
    {
        // Create a temporary user object
        $u = new User();

        // Get this users stored record via their username
        $u->where('username', $this->username)->get();

        // Give this user their stored salt
        $this->salt = $u->salt;

        // Validate and get this user by their property values,
        // this will see the 'encrypt' validation run, encrypting the password with the salt
        $this->validate()->get();

        // If the username and encrypted password matched a record in the database,
        // this user object would be fully populated, complete with their ID.

        // If there was no matching record, this user would be completely cleared so their id would be empty.
        if (empty($this->id))
        {
            // Login failed, so set a custom error message
            $this->error_message('login', 'Username or password invalid');

            return FALSE;
        }
        else
        {
            // Login succeeded
            return TRUE;
        }
    }

    // Validation prepping function to encrypt passwords
    // If you look at the $validation array, you will see the password field will use this function
    function _encrypt($field)
    {
        // Don't encrypt an empty string
        if (!empty($this->{$field}))
        {
            // Generate a random salt if empty
            if (empty($this->salt))
            {
                $this->salt = md5(uniqid(rand(), true));
            }

            $this->{$field} = sha1($this->salt . $this->{$field});
        }
    }
}

/* End of file user.php */
/* Location: ./application/models/user.php */ 

Country model

<?php

class Country extends DataMapper {

    var $table = "countries";

    var $has_many = array("user" => "users");

    var $validation = array(
        array(
            'field' => 'name',
            'label' => 'Country',
            'rules' => array('required', 'trim', 'unique', 'alpha_dash', 'min_length' => 1, 'max_length' => 50),
        )

    function Country()
    {
        parent::DataMapper();
    }
}

/* End of file country.php */
/* Location: ./application/models/country.php */ 

Book model

<?php

class Book extends DataMapper {

    var $has_many = array("user" => "users");

    var $validation = array(
        array(
            'field' => 'title',
            'label' => 'Title',
            'rules' => array('required', 'trim', 'unique', 'alpha_dash', 'min_length' => 1, 'max_length' => 50),
        ),
        array(
            'field' => 'description',
            'label' => 'Description',
            'rules' => array('required', 'trim', 'alpha_slash_dot', 'min_length' => 10, 'max_length' => 200),
        ),
        array(
            'field' => 'year',
            'label' => 'Year',
            'rules' => array('required', 'trim', 'numeric', 'exact_length' => 4),
        )
    );

    function Book()
    {
        parent::DataMapper();
    }
}

/* End of file book.php */
/* Location: ./application/models/book.php */ 

UPDATE

Updated to reflect version 1.3.

Signature

[ DataMapper | DataMapper Source Files | DataMapper User Guide ] - [ History | History Source Files | History User Guide ]

Profile

stensi

Posted: 06 September 2008 06:53 PM

[ Ignore ] [ # 4 ]

Lab Assistant

Total Posts: 124

Joined 06-01-2008

And now the good part where you get to use your tables as objects.

Example controller

<?php

class Users extends Controller {

    function Users()
    {
        parent::Controller();
    }

    function index()
    {
        // Let's create a user
        $u = new User();
        $u->username = 'Fred Smith';
        $u->password = 'apples';
        $u->email = 'fred@smith.com';

        // And save them to the database (validation rules will run)
        if ($u->save())
        {
            // User object now has an ID
            echo 'ID: ' . $u->id . '<br />';
            echo 'Username: ' . $u->username . '<br />';
            echo 'Email: ' . $u->email . '<br />';

            // Not that we'd normally show the password, but when we do, you'll see it has been automatically encrypted
            // since the User model is setup with an encrypt rule in the $validation array for the password field
            echo 'Password: ' . $u->password . '<br />';
        }
        else
        {
            // If validation fails, we can show the error for each property
            echo $u->error->username;
            echo $u->error->password;
            echo $u->error->email;

            // or we can loop through the error's all list
            foreach ($u->error->all as $error)
            {
                echo $error;
            }

            // or we can just show all errors in one string!
            echo $u->error->string;

            // Each individual error is automatically wrapped with an error_prefix and error_suffix, which you can change (default: <p>error message</p>)
        }

        // Let's now get the first 5 books from our database
        $b = new Book();
        $b->limit(5)->get();

        // Let's look at the first book
        echo 'ID: ' . $b->id . '<br />';
        echo 'Name: ' . $b->title . '<br />';
        echo 'Description: ' . $b->description . '<br />';
        echo 'Year: ' . $b->year . '<br />';

        // Now let's look through all of them
        foreach ($b->all as $book)
        {
            echo 'ID: ' . $book->id . '<br />';
            echo 'Name: ' . $book->title . '<br />';
            echo 'Description: ' . $book->description . '<br />';
            echo 'Year: ' . $book->year . '<br />';
            echo '<br />';
        }

        // Let's relate the user to these books
        $u->save($b->all);

        // Yes, it's as simple as that! You can add relations in several ways, even different types of relations at the same time

        // Get the Country with an ID of 10
        $c = new Country();
        $c->where('id', 10)->get();

        // Get all Books from the year 2000
        $b = new Book();
        $b->where('year', 2000)->get();

        // Relate the user to them
        $u->save(array($c, $b->all));

        // Now let's access those relations from the user

        // First we'll get all related books
        $u->book->get();

        // You can just show the first related book
        echo 'ID: ' . $u->book->id . '<br />';
        echo 'Name: ' . $u->book->title . '<br />';
        echo 'Description: ' . $u->book->description . '<br />';
        echo 'Year: ' . $u->book->year . '<br />';

        // Or if you're expecting more than one, which we are, loop through all the books!
        foreach ($u->book->all as $book)
        {
            echo 'ID: ' . $book->id . '<br />';
            echo 'Name: ' . $book->title . '<br />';
            echo 'Description: ' . $book->description . '<br />';
            echo 'Year: ' . $book->year . '<br />';
            echo '<br />';

            // And there's no need to stop there,
            // we can see what other users are related to each book! (and you can chain the get() call if you don't want to do it on its own, before the loop)
            foreach ($book->user->get()->all as $user)
            {
                // Show user if it's not the original user as we want to show him the other users
                if ($user->id != $u->id)
                {
                    echo 'User ' . $user->username . ' also likes this book<br >';
                }
            }
        }

        // We know there was only one country so we'll access the first record rather than loop through $u->country->all

        // Get related country
        $u->country->get();

        echo 'User is from Country: ' . $u->country->name . '<br />';

        // One of the great things about related records is that they're only loaded when you access them!

        // Lets say the user no longer likes the first book from his year 2000 list, removing that relation is as easy as adding one!

        // This will remove the users relation to the first record in the $b object (supplying $b->all would remove relations to all books in the books current all list)
        $u->delete($b);

        // You can delete multiple relations of different types in the same way you can save them

        // Now that we're done with the user, let's delete him
        $u->delete();

        // When you delete the user, you delete all his relations with other objects. DataMapper does all the tidying up for you :)
    }

    // Continued below... 

UPDATE

Updated to reflect version 1.3.

Signature

[ DataMapper | DataMapper Source Files | DataMapper User Guide ] - [ History | History Source Files | History User Guide ]

Profile

stensi

Posted: 06 September 2008 06:53 PM

[ Ignore ] [ # 5 ]

Lab Assistant

Total Posts: 124

Joined 06-01-2008

// Continued from above...

     function register()
    {
        // Create user object
        $u = new User();

        // Put user supplied data into user object
        // (no need to validate the post variables in the controller,
        // if you've set your DataMapper models up with validation rules)
        $u->username = $this->input->post('username');
        $u->password = $this->input->post('password');
        $u->confirm_password = $this->input->post('confirm_password');
        $u->email = $this->input->post('email');

        // Attempt to save the user into the database
        if ($u->save())
        {
            echo '<p>You have successfully registered</p>';
        }
        else
        {
            // Show all error messages
            echo '<p>' . $u->error->string . '</p>';
        }
    }

    function login()
    {
        // Create user object
        $u = new User();

        // Put user supplied data into user object
        // (no need to validate the post variables in the controller,
        // if you've set your DataMapper models up with validation rules)
        $u->username = $this->input->post('username');
        $u->password = $this->input->post('password');

        // Attempt to log user in with the data they supplied, using the login function setup in the User model
        // You might want to have a quick look at that login function up the top of this page to see how it authenticates the user
        if ($u->login())
        {
            echo '<p>Welcome ' . $u->username . '!</p>';
            echo '<p>You have successfully logged in so now we know that your email is ' . $u->email . '.</p>';
        }
        else
        {
            // Show the custom login error message
            echo '<p>' . $u->error->login . '</p>';
        }
    }
}

/* End of file login.php */
/* Location: ./application/controllers/login.php */ 

In case people are wondering when the DataMapper models are actually loaded, I’ll explain.

To set it up is simply a matter of adding the main DataMapper model file to your model autoload array:


$autoload['model'] = array('datamapper');

That’s it. All your models that extend DataMapper are automatically loaded by it when you create or access them, which is why there’s no need to fill up your Controller’s constructor with bunches of $this->load->model(‘Object’); lines. DataMapper is smart enough to load them for you, as you ask for them.

UPDATE

Updated to reflect version 1.3.

Signature

[ DataMapper | DataMapper Source Files | DataMapper User Guide ] - [ History | History Source Files | History User Guide ]

Profile

Colin Williams

Posted: 07 September 2008 02:14 AM

[ Ignore ] [ # 6 ]

Sr. Research Associate

Total Posts: 2771

Joined 07-27-2006

Wonderful stuff.

Signature

Check out the Template Library
Oh yeah, I tweet, too (regarding CodeIgniter on occassion).

Profile

andyr

Posted: 09 September 2008 04:13 AM

[ Ignore ] [ # 7 ]

Summer Student

Total Posts: 4

Joined 04-03-2006

Great work stensi,

I am going to have a play with this now

The only thing that worries me is domain object knowing about the data mapper, in this case through inheritance. The domain object should not strictly know the data mapper and act as a layer that separates the in-memory objects from the database, which allows the transfer data between the two, while isolating them from each other.

For example,

https://www.martinfowler.com/eaaCatalog/dataMapper.html

I cant help but feel that the code examples above still feel like active record, as the data access logic is in the domain object and the object is open to carry both data and behaviour.

https://www.martinfowler.com/eaaCatalog/activeRecord.html

This is probably the just side effect of using inheritance between the domain object and data mapper, and not composition in order to keep things simple.

But anyhows, a mix between active record and data mapper is interesting.

Profile

stensi

Posted: 09 September 2008 05:15 PM

[ Ignore ] [ # 8 ]

Lab Assistant

Total Posts: 124

Joined 06-01-2008

Thanks andyr. I hear what you’re saying about the separation and yes, the Domain Object knowing about the DataMapper is simply a side effect of the inheritance. That’s where the straying from the pattern ends.

Strictly speaking I should have separated things to have a DomainObject class and the DataMapper class but for simplicity’s sake, and ease of use and implementation, I felt doing it the way I did resulted in the same functionality the DataMapper pattern provides, but with much less code than would otherwise have been required.

So yes, it still sticks to the DataMapper pattern, just a little loosely in that regard.

Hope you find it useful

Signature

[ DataMapper | DataMapper Source Files | DataMapper User Guide ] - [ History | History Source Files | History User Guide ]

Profile

steelaz

Posted: 11 September 2008 07:39 AM

[ Ignore ] [ # 9 ]

Lab Assistant

Total Posts: 229

Joined 02-16-2008

From your user guide I understand find() basically accepts “where” parameter, what we would use as $this->db->where(). Is there a way to pass “limit” or “sort” parameters?

Profile

stensi

Posted: 11 September 2008 05:13 PM

[ Ignore ] [ # 10 ]

Lab Assistant

Total Posts: 124

Joined 06-01-2008

I’m actually working on adding in extra functionality like that now. I’m still deciding on the best way to implement it in terms of ease of use and consistency but once I’m done, you’ll be able to do all the various types of queries such as like, group by, order by, limit and offset.

Once I’ve completed and tested that ok, I’ll post the new version, which already has many improvements on the validation side of things. I’m finding that part very useful for my sites right now. Cuts down the code in my controllers a huge amount.

Anyway, any suggestions/feature requests are welcome!

Signature

[ DataMapper | DataMapper Source Files | DataMapper User Guide ] - [ History | History Source Files | History User Guide ]

Profile

1 of 101

Last »

‹‹ Profiler Popup Flexigrid CodeIgniter Implementation ››

Post Marker Legend
	New posts	Hot Topic with new posts	New Poll	Moved Topic	Sticky topic
	No new posts	Hot Topic with no new posts	Old Poll	Closed Topic	Announcements

Theme

Visitor Statistics
The most visitors ever was 928, on October 26, 2010 11:42 AM
Total Registered Members:	183881	Total Logged-in Users:	36
Total Topics:	113344	Total Anonymous Users:	3
Total Replies:	558558	Total Guests:	444
Total Posts:	671902

Members ( View Memberlist )

Newest Members: Jason Baldwin, averagejoe, Kaye113571, SBCoupons, ubunut, novocainer, black_mania2, jeroenr, monster8, johnnyflash

Active Members: Atharva, bahjaat, bema2004sw, bloodylyons, bonatoc, Boris Strahija, bravonet, budd1726, coma, Dan Murfitt, Daniel Guajardo, Daniel Moore, Evollution, Frychiko, Gürkan, Georgi Veznev, GlennJ, Ion Biziiac, Ivo Amaral, Johnny Freeman, Kamarg, Kazembe, lkrb01, mdvaldosta, pascaln, pspvideoconverter, regfix, rfrancis, Rodrigo Ferreira, Rory Cahill, RS71, Ruben Giancarlo Elmo, The Hamburgler, totels, Vlad0, zwerfkei

Powered By ExpressionEngine
ExpressionEngine Discussion Forum - Version 2.1.2 (20100430)
Script Executed in 0.2536 seconds

Original Source | Taken Source

Username		Remember Me?
Password		forgot password?