Thanks. The CRUD functionality is exactly what I want to do. So maybe I should ask the group this: -What is everyone using to accomplish this? I mean, are most people just hand coding this stuff? It's so much easier to have a generator do it and then just tweak the code as needed, add a stylesheet, etc. My issue is that that I will probably have to do Postgres work like this in the future so I don't want to have to repeat this same generic task for each job that comes up. A generator would just be nice and it'd be one less argument against psql for the mysql-nazis. :) Thanks, Aaron -----Original Message----- From: Rick Morris [mailto:rick@xxxxxxxxxxxxxxx] Sent: Thursday, November 17, 2005 4:28 PM To: Announce Cc: pgsql-php@xxxxxxxxxxxxxx Subject: Re: PHP Generator For PostgreSQL? Announce wrote: > Maybe I need to explain a little more... I'm aware of phpPGAdmin but it is > overkill in this case. > > A MySQL example of this would be "PHP MySQL Wizard". I'm looking for a > PostgreSQL equivalent. > > What I really want is a time-saving utility that will automatically generate > some administration pages (view, update, add, delete) given a set of related > tables. I want it to create some PHP pages w/html forms that non-technical > users can use to make changes to a database... Usually would support lookup > functionality for foreign keys, etc. You might want to check out PHPLens (http://phplens.com/), which uses ADODB to support multiple DBMS's. This is a commercial PHP toolkit, though. I don't know of a free PostgreSQL-specific kit for this, but there are a couple excellent PEAR (http://pear.php.net) classes for form generation (HTML_QuickForm) and table generation (HTML_Table). With these, it's really not too hard to automate a lot of the work of standard CRUD database interaction. > > I COULD do this manually but I know there should be good utilities that > accomplish the same task in like 1/100th the time. And my time... is > PRICELESS. :-) > > -Aaron > -----Original Message----- > From: Ray Garrison [mailto:ray@xxxxxxxxxxxx] > Sent: Thursday, November 17, 2005 2:59 PM > To: 'Announce'; pgsql-php@xxxxxxxxxxxxxx > Subject: RE: PHP Generator For PostgreSQL? > > > Uh, have you looked at phpPgAdmin? > > | -----Original Message----- > | From: pgsql-php-owner@xxxxxxxxxxxxxx [mailto:pgsql-php- > | owner@xxxxxxxxxxxxxx] On Behalf Of Announce > | Sent: Thursday, November 17, 2005 2:53 PM > | To: PostgreSQL PHP List > | Subject: PHP Generator For PostgreSQL? > | > | Hi, > | > | I am looking for a tool that will automatically generate web forms > that > | will > | allow me to view/update/insert data on a PG database. Preferably in > PHP. > | I > | am seeing TONS of tools for MySQL but nothing yet for PG. If anyone > knows > | of > | something please let me know. > | > | Thanks, > | > | Aaron > | > | > | ---------------------------(end of > broadcast)--------------------------- > | TIP 1: if posting/reading through Usenet, please send an appropriate > | subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that > your > | message can get through to the mailing list cleanly > > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 > > > -- > No virus found in this incoming message. > Checked by AVG Free Edition. > Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.362 / Virus Database: 267.13.3/173 - Release Date: 11/16/2005 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
