Query System

[elflacodepr]

hello all,

 

I designing my MySQL query system, for now I can do all commands(insert, delete..etc.), the next step add a script where it displays the results, for example if I type: SELECT * FROM tbl,  it must display the results in a table. any help?

 

Heres the script

<?php
if(isset($_POST['save']))
{
include 'library/config.php';
include 'library/opendb.php';


$querybox = $_POST['query_content'];


//Query
$sql = mysql_query($querybox) or die('Error, query failed<br/><b>Query:</b><pre>' . $querybox . '</pre><b>Error: </b>' . mysql_error());

echo "Query entered!";

include 'library/closedb.php';
}

?>

[DarkWater]

Why re-invent the wheel when you can just use something like phpMyAdmin?

[elflacodepr]

phpMyAdmin is the inspiration 

plus I'm doing this for project of myself

[DarkWater]

So you're basically trying to reinvent the wheel.  You'd probably need to run a DESCRIBE table; and extract the column names.

[elflacodepr]

ya got me lost there  ???

[DarkWater]

Open up the mysql client and run this query:

 

DESCRIBE some_table\G

 

(The \G just makes it easier to read and see what's actually returned for you to loop through; don't use it in PHP.)

 

You can see that it returns the column names, types, etc.