exemple

I replied in require_once("classes/class.group.php"); group with my group just generated but the error still exist like Undefined index: group_name.

Dear You need to use genrator.php this class and the sample code of this class is aviable in sample-generate.php, once you run the class it will generate the DAL, example.php file is generated by it you dont need to use it, you just use genrator.php file to generate the Data access Layer.

I did that and the script works fine. I was wondering what is doing that form from example. Good idea, good script. Maybe one for pdo will be not bad.

Dear Alexandru,

This script actually a generator for your database, you just need to enter database name it create all the member variables and insert, select, update, delete methods for all tables into database, then you can use this class strucutre in your project, you just need to create a form and then create the object of the class, then call copyPostData or copyGetData depend upon your form type then need to call insert function it insert the object into database and set the primary key of into that object, one thing which need to make sure the name of the fields of form must be same as the database fields for doing mapping of the objects.

You can use this in designing some custom CMS sort of thing or you can design different types of portal using this class strucutre.

Regards

Thank you very much for this advices!

Finally it is working. I hope so that it's working well against sqlinjection. Good job !

For sql injection it will, i am working on its new version as well, that is more powerful. will release it soon.

It could look very cool if the classes generate will look like active record from codeigniter.
A guy wrote a very easy to use class and with a good example in Readme.md (http://www.phpclasses.org/package/8861-PHP-Build-and-run-SQL-queries-with-a-fluent-interface.html#usage)
I saw also a part from a mvc framework that if I run the script it will create automatically the tables in database without need phpadmin. You have to do only declare the name of colons (in vars) and attributes in comment above the every field declared in model class. Something like that.
class Example extends Framework\Model
{
/**
* @readwrite
* @column
* @type autonumber
* @primary
*/
protected $_id;
/**
* @readwrite
* @column
* @type text
* @length 32
*/
protected $_name;
/**
* @readwrite
* @column
* @type datetime
*/
protected $_created;
}

Yes it look great, I think it is drived from Entity Framework of .Net, in Entity Framework we create classes and then by using linq we operate it, classes automatically generate the database script for you and using linq you can use it.

Yes, all put together make a good framework or I have to learn Yii. I saw that code in a book from Apress named Pro PHP MVC by Chris Pitt. I built at a moment a framework and I get stuck and the source code didn't help me to much in that time.