Solved

Looking for PHP based query tool for MySQL

Posted on 2004-10-28
178 Views
Last Modified: 2006-11-17
I am looking for something I can use to provide simple query capabilities to end users.  Something to build some complex SELECTs on the fly in a web browser, and get the data back in a table and perhaps even a CSV download.  I know I've seen stuff like this, but all the Googling in the World is getting me nowhere.
0
Question by:christopherutley
    7 Comments
     
    LVL 49

    Assisted Solution

    by:Roonaan
    phpmysqladmin?
    0
     

    Author Comment

    by:christopherutley
    phpmyadmin is a back-end tool, I need something I can roll into an existing application so dumb users can do some simple SELECTs and what not
    0
     
    LVL 49

    Expert Comment

    by:Roonaan
    Then you might want to try the hotscripts database.

    Regards

    -r-
    0
     

    Author Comment

    by:christopherutley
    tried sourceforge and hotscripts no luck...
    0
     
    LVL 29

    Accepted Solution

    by:
    IS MySQL's "query browser" too much "IT" rather tan "user"?
    http://dev.mysql.com/downloads/query-browser/index.html

    A comment building on Roonan's suggestion:
    - there is a query tool in phpmyadmin
    - if this query tools does macth your requirements, then you might just use the code functions corresponding to this and drop most of the other php code.
    0
     

    Author Comment

    by:christopherutley
    Going to use the phpmyadmin code as a starting point.  Thanks.
    0
     
    LVL 29

    Expert Comment

    by:fibo
    Hmmm...A second thought now that you are on the PHP route:
    of course you had considered also the idea of an Acces or Excel frontend connected to the MySQL server thru ODBC??
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Anonabox PRO Tor & VPN Router

    PRO is the most advanced way to fortify your privacy and online anonymity by layering the Tor network with VPN services. Use both together or separately, and without needing to download software onto your devices.

    This is a general how to create your own custom plugin system for your PHP application that you designed (or wish to extend a third party program to have plugin functionality that doesn't have it yet).  This is not how to make plugins for existing s…
    Author Note: Since this E-E article was originally written, years ago, formal testing has come into common use in the world of PHP.  PHPUnit (http://en.wikipedia.org/wiki/PHPUnit) and similar technologies have enjoyed wide adoption, making it possib…
    The viewer will learn how to count occurrences of each item in an array.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    884 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now