php CRUD passing parameters

Question

I'm working on a php service. I'd like to pass an object with the parameters to use in the "where" clause and also the "order" and "limit" params.

I'm wondering whether there is a standard way/library to make up the query based on the parameters given, or whether I'll need to roll one.

I'm using ezsql to connect to mysql.

Any pointers, much appreciated.

look on ORM like doctrine, propel : http://stackoverflow.com/questions/108699/good-php-orm-library — Haim Evgi, Feb 07 '12 at 12:38

score 1 · Accepted Answer · answered Feb 07 '12 at 12:42

1

Writing one yourself shouldn't be too hard. If you don't want to do so (DRY, right?), you may check out sites like phpclasses.org or use an abstraction layer from Doctrine (take a look at its QueryBuilder if it is what you need)

answered Feb 07 '12 at 12:42

wonderb0lt

2,035
1
23
37

thanks, Yeah I was just looking for something light to tide me over as it won't run for long. Doubt, I'll go with a orm. I just want to parse the object and create a few simple statements. – Chin Feb 07 '12 at 14:09

score 1 · Answer 2 · answered Feb 07 '12 at 13:11

Another suggestion if you would like to use already existing code: Zend Framework has a "query builder", Zend_Db_Select.

This does not require the whole Zend Framework, but it does have some depedencies you will have to include.

Documentation: http://framework.zend.com/manual/en/zend.db.select.html

php CRUD passing parameters

2 Answers2