database query tool

[nobertos]

hi, i'd like to create a simple tool for a client so that they can query a database. they'd like to be able to do SELECT, INSERT, UPDATE, DELETE, ALTER, CREATE, DROP calls

if they do a select, i'd like to show the column names across the top of a html table, and have the values listed below, like:

Col 1 Name Col 2 Name
col 1 value col 2 value
next col 1 value next col 2 value

if they do one of the other calls, i'd like for them to be able to see a 'success' message.

is there some simple code out there i could use to do this? i've used phpmyadmin before, and i'm looking for something simpler that just does the free form sql entry portion...

cg

[szym9341]

Do you have a web server running? Why not write some simple code yourself...?? It wouldn't take that much time, plus you could customize it as you go.

[nobertos]

how simple would the code be? the project is for a client, and they run the server. i am trying to figure out if i can easily code this myself, or if a tool that allows free form sql queries would be easier... just install it and it works...

i am having a rough time figuring out how to display the results of SELECT statements, for starters.

for testing, i do:

$db_query = "SELECT * FROM foo_table";

$db_query_result = mysql_query($db_query);
$db_query_result_row = mysql_fetch_array($db_query_result);

it seems the query returns column name/column value pairs.....

then i should be able to do some sort of call to get the column names (how i am not sure)

then i should be able to display each column's information below each column header (how i am not sure)

some sort of mix of a while statement and a for each statement....?

i have phpmyadmin running on my own server, and it is great, but the people i am working on this project for (who run the project's server) are concerned about security issues and phpmyadmin. i really like the way phpmyadmin lets you do free form SQL queries, though. I'd like to mimic that if possible, or get another tool running, perhaps a simpler one, that would allow free form queries.

thoughts?

cg

[szym9341]

are they using MYSQL?

do you have the address, login, password?

Here is some code to consider...

<?
//The following gets you connected to the database server
$dbcnx = mysql_connect("address_of_mysql", "login_of_mysql", "password_of_mysql");
if (!$dbcnx) {
   echo "<p>Unable to connect to the MySQL Server</p>";
   exit ();
}
//The following connects you to the database
if (!mysql_select_db("name_of_database") ){
  echo "<p>Unable to connect to the database at this time</p>";
  exit ();
}
//The following selects the table and its entries
$result = @mysql_query("SELECT * FROM tablename ORDER BY some_row_name ASC");
if (!mysql_num_rows($result)) {
  echo( "<p>No Entries!</p>" );
  exit();
}
//The following will display the results in a table
echo "<p><i> Here is the data in the database:</i></p><br>";
echo "<table cellspacing='10'>";
echo "<tr><th>ID</th><th>First Name</th><th>Middle Name</th><th>Last Name</th></tr>";
while ( $row = mysql_fetch_array($result) ) {
  $id = $row["id"];
  $first_name = $row["f_name"];
  $middle_name = $row["m_name"];
  $last_name = $row["l_name"];
  echo "<tr><td>";
  echo "$id />";
  echo "</td><td>";
  echo "$first_name />";
  echo "</td><td>";
  echo "$middle_name";
  echo "</td><td>";
  echo "$last_name";
  echo "</td></tr>";
}
echo "</table>";
?>

[nobertos]

yes, it is mysql, and i make similar calls in my php pages to access the database and display information. but what i'm looking for is a generic way to display information from any select statement the client might enter. it could be SELECT * from company_names, it could be SELECT name, email from buyer_list WHERE name LIKE 'foobar%', any SELECT statement you could think of.

then i need a way to display the result. i'd like the column names accross the top of an html table, and all the values to fill in below... i'm currently having trouble displaying this information correctly....

after that, i'll need to figure out how to do INSERT, UPDATE, DELETE etc calls and display a 'success' message.

this all seems a bit complicated. this is why i thought a tool might be a better choice.

chris

[szym9341]

Well Chris, I'm not sure of any "quick N easy" solution... Maybe one is out there... browse www.sourceforge.net you may have luck there.

[phpprogrammer]

Dear Friend,

use phpmyadmin toll

regards
bvsureshbabu