Re: PHP Generator For PostgreSQL?

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(at)brainscraps(dot)com]
Sent: Thursday, November 17, 2005 4:28 PM
To: Announce
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: [PHP] 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(at)periship(dot)com]
> Sent: Thursday, November 17, 2005 2:59 PM
> To: 'Announce'; pgsql-php(at)postgresql(dot)org
> Subject: RE: [PHP] PHP Generator For PostgreSQL?
>
>
> Uh, have you looked at phpPgAdmin?
>
> | -----Original Message-----
> | From: pgsql-php-owner(at)postgresql(dot)org [mailto:pgsql-php-
> | owner(at)postgresql(dot)org] On Behalf Of Announce
> | Sent: Thursday, November 17, 2005 2:53 PM
> | To: PostgreSQL PHP List
> | Subject: [PHP] 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(at)postgresql(dot)org 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