pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Announce <truthhurts@insightbb.com>
To: pgsql-php@postgresql.org
Subject: Re: PHP Generator For PostgreSQL?
Date: Thu, 17 Nov 2005 16:38:00 -0600
Message-ID: <KBEKKNMFLELKGIADDEPEOEMGCCAA.truthhurts@insightbb.com> (raw)
In-Reply-To: <437D0405.7000805@brainscraps.com>

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




view thread (10+ messages)  latest in thread

Message-ID: <KBEKKNMFLELKGIADDEPEOEMGCCAA.truthhurts@insightbb.com>
Permalink:  ../KBEKKNMFLELKGIADDEPEOEMGCCAA.truthhurts@insightbb.com/
Also on:    postgresql.org/message-id/KBEKKNMFLELKGIADDEPEOEMGCCAA.truthhurts@insightbb.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: truthhurts@insightbb.com
  Subject: Re: PHP Generator For PostgreSQL?
  In-Reply-To: <KBEKKNMFLELKGIADDEPEOEMGCCAA.truthhurts@insightbb.com>
  References: <437D0405.7000805@brainscraps.com> <KBEKKNMFLELKGIADDEPEOEMGCCAA.truthhurts@insightbb.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox