Simple SQL query interface

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Shendemiar
Forum Contributor
Posts: 404
Joined: Thu Jan 08, 2004 8:28 am

Simple SQL query interface

Post by Shendemiar »

Id like to give some people ability to view (some of) the tables and do simple SELECT queries of them. Ii there any nice piece of code for that?
User avatar
RobertGonzalez
Site Administrator
Posts: 14293
Joined: Tue Sep 09, 2003 6:04 pm
Location: Fremont, CA, USA

Post by RobertGonzalez »

This sounds like a database privileges type question.
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

What level of view are we talking about here?

You could give them a database user with only the rights to select from those tables (and columns) you wish them to be able to access.
Shendemiar
Forum Contributor
Posts: 404
Joined: Thu Jan 08, 2004 8:28 am

Post by Shendemiar »

Sorry... i meant some kind of pre-made interface to do some database viewing like phpmyadmin, but way simpler, and only selects
User avatar
s.dot
Tranquility In Moderation
Posts: 5001
Joined: Sun Feb 06, 2005 7:18 pm
Location: Indiana

Post by s.dot »

PHPMyAdmin would work (minus the simpler part). I'm pretty sure if they log in as a user that only has select priveledges, they wouldn't be able to do anything else.
Set Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
User avatar
califdon
Jack of Zircons
Posts: 4484
Joined: Thu Nov 09, 2006 8:30 pm
Location: California, USA

Post by califdon »

Shendemiar wrote:Sorry... i meant some kind of pre-made interface to do some database viewing like phpmyadmin, but way simpler, and only selects
I don't know if this will do what you want, but I wrote a rather simple db read-only interface a few months ago you're welcome to use it if it meets your needs: http://ravey.net/demo/
Shendemiar
Forum Contributor
Posts: 404
Joined: Thu Jan 08, 2004 8:28 am

Post by Shendemiar »

califdon wrote:
Shendemiar wrote:Sorry... i meant some kind of pre-made interface to do some database viewing like phpmyadmin, but way simpler, and only selects
I don't know if this will do what you want, but I wrote a rather simple db read-only interface a few months ago you're welcome to use it if it meets your needs: http://ravey.net/demo/
That sounds very nice for my purposes. Thank you.
Post Reply