[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now


Looking for PHP based query tool for MySQL

Posted on 2004-10-28
Medium Priority
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.
Question by:christopherutley
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
  • 2
LVL 49

Assisted Solution

Roonaan earned 750 total points
ID: 12441535

Author Comment

ID: 12441558
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
LVL 49

Expert Comment

ID: 12441571
Then you might want to try the hotscripts database.


What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.


Author Comment

ID: 12441615
tried sourceforge and hotscripts no luck...
LVL 29

Accepted Solution

fibo earned 750 total points
ID: 12447871
IS MySQL's "query browser" too much "IT" rather tan "user"?

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.

Author Comment

ID: 12465526
Going to use the phpmyadmin code as a starting point.  Thanks.
LVL 29

Expert Comment

ID: 12470734
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??

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Since pre-biblical times, humans have sought ways to keep secrets, and share the secrets selectively.  This article explores the ways PHP can be used to hide and encrypt information.
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn how to count occurrences of each item in an array.
Suggested Courses

656 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