[thelist] MySQL GUI Interfaces
Christopher Joseph
Christopher at ideadesigners.com
Tue Mar 26 08:19:01 CST 2002
Try phpmyadmin http://www.phpwizard.net/projects/phpMyAdmin/
-find it very useful
-runs on most php/webserver combinations
!important - remember to secure it before and after use if using against
remote db's on a remote web server.
chris.
-----Original Message-----
From: thelist-admin at lists.evolt.org
[mailto:thelist-admin at lists.evolt.org]On Behalf Of Jay Blanchard
Sent: Tuesday, March 26, 2002 10:03 AM
To: thelist at lists.evolt.org
Subject: [thelist] MySQL GUI Interfaces
G'mornin' group,
Currently I am using MySQLGUI 1.7.5-1 on my Linux box, and while it is a
timesaver I am in need of more power and flexibility. Knowing that you all
would know what works I seek your input (gawd, I am formal this morning!
:-) ). I have looked at many MySQL GUI's, I just need some recommendations
during this time of me not having much time to test and pick a new
interface.
I need a GUI with the following features -
* Can be either Linux based or Windows based.
* Must be able to connect easily to multiple MySQL databases on multiple
servers without having to change an 'options' setting.
(similar to MS SQL Server Enterprise Manager)
* Must have the ability to run lengthy SQL scripts without choking (MySQLGUI
will not). I know that I can do this from the command line, which I do
frequently, but if the GUI has syntax checking it would help vastly, you
know how frustrating a syntax error can be to track down.
* If it has an easy to manage GRANTS feature that would be a big plus.
Thanks all for your input!
Jay
<tip type="MySQL & PHP" author="Jay Blanchard">
When needing to return/print a SUM or a COUNT from a SQL query in PHP you
have to give PHP a handle to grab the SUM or COUNT information so that it
can be displayed or used;
WRONG! :(
SELECT COUNT(*)
FROM tblFoo
Does not give PHP a handle to the COUNT
RIGHT! :)
SELECT COUNT(*) AS CountOfFoo
FROM tblFoo
Now you can print("$row->CountOfFoo") or work with CountOfFoo as you need.
Another example;
SELECT SUM(TotalSales) as SalesTTL
FROM tblFoo
SalesTTL is the handle that PHP can work with.
A NOTE OF CAUTION! - Do not name the handle the same as a column name with
which you are working, the result is not pretty. Always give the handle a
unique name.
</tip>
--
For unsubscribe and other options, including
the Tip Harvester and archive of thelist go to:
http://lists.evolt.org Workers of the Web, evolt !
More information about the thelist
mailing list