does anyone know a PHP/HTML code to allow a user to query an PostgreSQL database?

Question

I have a code to acces the data base and view the tables but I want to allow the user to enter there own query, including updates and additions into the database.

Is there such a code. I'd really hate to re-invent something here because I'm not real good with PHP.

Thanks

I have a code to acces the data base and view the tables but I want to allow the user to enter there own query, including updates and additions into the database.

Is there such a code. I'd really hate to re-invent something here because I'm not real good with PHP.

This needs to be a web interface. I cannot use programs like PG Admin or DB Visulizer.

Thanks

Answer 1

You can install phpPgAdmin:

http://phppgadmin.sourceforge.net/

It does what you want and more; just be careful about which privileges you assign...