Model Database class required (PHP/MySQL)

Question

I'm after a model-based database class for PHP/MySQL. But it must have one particular functionality:

Once the class is initialised ( e.g $user=new User(); ) I should be able to access the attributes in the user table as follows:

$user->name // returns the value of the 'name' field in the user table

I should not have to define the attributes or need to create any functions to return the attribute value, it should be done automatically when the class is initialised.

Is there such a database class out there? If not can someone tell me how I would go about creating this functionality?

What you are looking for is called an ORM (Object relational mapping) solution. — K. Norbert
– K. Norbert, Commented Jul 6, 2010 at 15:42
Cheers. This might be what I'm looking for: phpactiverecord.org — MAX POWER
– MAX POWER, Commented Jul 6, 2010 at 15:58
Only problem is that particular ORM needs PHP 5.3. Anyone know of any other solutions? — MAX POWER
– MAX POWER, Commented Jul 6, 2010 at 17:09
I doubt this is possible with PHP < 5.3 if you do not want to do at least some configuration. For full automagic you will need an ActiveRecord base class to inherit from that utilizes Late Static Binding. — Gordon
– Gordon, Commented Jul 6, 2010 at 17:45

Lizard · Accepted Answer · 2010-07-06 15:30:45Z

2

I am unsure on a database class, but if you were to write one then look into PHP's Magic Methods, in particular the __get() function

http://www.php.net/manual/en/language.oop5.overloading.php#language.oop5.overloading.members

class myClass {

    function __get($field) {
        // grab $field from database
    }

    function __set($field, value) {
        // set $field in database
    }
}

$class = new myClass();

echo $class->field1; // grab value field1

$class->field1 = 'myVal'; // set field1 = 'myVal';

answered Jul 6, 2010 at 15:30

Lizard

45.3k39 gold badges108 silver badges170 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MAX POWER Over a year ago

This looks good. But I assume I would still need to manually define the field names? I want complete automation, so for example if I were to add a new field to the database I should just be able to access it without adding any new code. I suppose what's needed is for the class needs to go in to the table, get the list of field names and add them as properties of the object.

gnome · Accepted Answer · 2010-07-06 15:33:54Z

2

Check out http://www.phpobjectgenerator.com/. Will same you a lot of time in the long run.

answered Jul 6, 2010 at 15:33

gnome

1,1332 gold badges11 silver badges19 bronze badges

Comments

Steven Mercatante · Accepted Answer · 2010-07-06 15:36:18Z

1

Have you looked at Doctrine? You can generate model classes based on your DB schema. I use it on every project and I love it.

answered Jul 6, 2010 at 15:36

Steven Mercatante

25.4k9 gold badges68 silver badges109 bronze badges

2 Comments

MAX POWER Over a year ago

I had a look at Doctrine but I can't make any sense of it. Have you got any usage examples for finder and crud functions? Also did you get version 1.2 stable or 2.0 beta?

MAX POWER Over a year ago

Anybody else used Doctrine? How easy is it to use?

Manos Dilaverakis · Accepted Answer · 2010-07-06 15:33:10Z

0

You can use stdClass to do just that:

$object = new StdClass;  
$object->foo = 'bar';

Or if you want a little bit more control you could use PHP's magic methods.

answered Jul 6, 2010 at 15:33

Manos Dilaverakis

5,8794 gold badges34 silver badges57 bronze badges

Collectives™ on Stack Overflow

Model Database class required (PHP/MySQL)

4 Answers 4

1 Comment

Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

1 Comment

Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related