[Phpwm] SQL query builder

[Keith Pope]

How complex is the dataset? Could you create a load of views that do most of the aggregation and then create a simple search for each view? 

Also you could use something like zend_db_table to easily wrap each view, then you can just create a simple query interface for the user.  

Talking of DB stuff doctrine http://www.phpdoctrine.org is RC1 now worth checking it out, I am liking the look of the DQL http://www.phpdoctrine.org/documentation/manual/0_10/?chapter=dql-doctrine-query-language


Keith Pope
Web Developer

-----Original Message-----
From: David Goodwin [mailto:david at codepoets.co.uk] 
Sent: 28 April 2008 12:07
To: West Midlands PHP User Group
Subject: Re: [Phpwm] SQL query builder

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Zeth wrote:
| 2008/4/28 alan dunn <alan at dunns.co.uk>:
|> OK couple of other details I didn't add - the db is postgres (I think 
|> phpMyAdmin is just MySQL) and the users are non-technical so a nice 
|> gui query builder would be good.


There is phpPgAdmin, but I'm not sure that giving them a read-only user account would sufficiently provide a 'Query Builder' like capability.



- --
David Goodwin

[ david at codepoets dot co dot uk ]
[ http://www.codepoets.co.uk       ]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIFa/Q/ISo3RF5V6YRAnArAJ4whW58+p4l/Rm8m5xFeDb6jd1IKgCfUMRc
eS/Hyi/RCuvhv5R0cgp3NpY=
=SZXk
-----END PGP SIGNATURE-----

_______________________________________________
Phpwm mailing list
Phpwm at mailman.lug.org.uk
https://mailman.lug.org.uk/mailman/listinfo/phpwm


--

allpay.net Limited, Fortis et Fides, Whitestone Business Park, Whitestone, Hereford, HR1 3SE. 

Registered in England No. 02933191. UK VAT Reg. No. 666 9148 88. 



Telephone: 0870 243 3434, Fax: 0870 243 6041. 

Website: www.allpay.net

Email: enquiries at allpay.net 



This email, and any files transmitted with it, is confidential and intended solely for the use of the individual or entity to whom it is addressed. If you have received this email in error please notify the allpay.net Information Security Manager at the number above.