Show MySQL query with button

Hi All

I have several tables in MySQL that I would like to generate a query view of those records, one table at a time, within a formatted HTML table on the same page, but I would want this to happen when the end user clicks on a button. I would also like a "Clear" button to clear that query from the screen.

Any suggestions or examples?

Thanks
gman

[Join us @ facebook]

You mean you want to see the data stored in the table, like phpMyAdmin does?

Yes, but through a query that can be seen on the same page, and than a simple clear function to make the query disappear. Can this be done...I know the query part can be but not sure how to invoke it using a "Sumbit" like button

Thanks Nikolas

gman

[Join us @ facebook]

You can use a <select> form and when you have a value to the post variable do the query that it sais

Sorry Nikolas but I am still a newbie..any help with code? No rush on this....thanks again 

[Join us @ facebook]

I will try to give you a guide...

Code:

<form method="post" action="http://pathToMyScript.php" />
<select name="table">
<option value="table1">Table1</option>
<option value="table2">Table2</option>
....
....
....
</select>
</form>

<?php
 if ( !empty ($_POST['table'] )
 {
  switch ( $_POST['table'] ){
    case 'table1':
       $query = "SELECT * FROM table";
       break;
    case 'table2':
       $query = .......
       break;
  }
 }
?>

Hope that helps

Thanks Nikolas, I will give that a shot...I appreciate it

Alright...I got the code to work that queries the table data and formats it into a HTML table....came out alright...and I also setup the button to call that PHP code.

The issue is that the query is coming up in a separate window and I would like the data to appear below the button, on the same page.

I was looking at named anchors and not sure if that is the correct approach

Any thoughts?

Thanks

[Join us @ facebook]

You can do it in the same page, by using the same page for the form and the php code that parses the queries.

Thanks Nikolas...just not sure how to do that. When I load the query php page, it automatically shows the data...I only want it to show when I click on the button

Here is the code that I used to show the data in the table...it is called from another page, but like I said, I would like the button on the page as well and this data to appear below the button

show_data.php

Code:

<?php

// This code will draw a table with the data retrieved from the query.
 
function writeResult($result){ 
    if(gettype($result) != "resource" || get_resource_type($result) != "mysql result"){ 
        echo "Could not draw the table, not a valid mysql result."; 
        return; 
    } 
    $HTMLCode = "<table border=\"1\">"; 
    $HTMLCode .= "<tr>";
for($i = 0; $i < mysql_num_fields($result); $i++){ 
        $HTMLCode .= "<th>" . mysql_field_name($result, $i) . "</th>"; 
    } 
    for($i = 0; $i < mysql_num_rows($result); $i++){ 
        $HTMLCode .= "<tr>"; 
        for($k = 0; $k < mysql_num_fields($result); $k++){ 
            $data = mysql_result($result, $i, $k); 
            $data = (($data == "") ? "&nbsp;" : $data); // avoid empty strings 
            $HTMLCode .= "<td>" . $data . "</td>"; 
        } 
        $HTMLCode .= "</tr>"; 
    } 
    $HTMLCode .= "</tr>"; 
    $HTMLCode .= "</table>"; 
    echo $HTMLCode; 
} 
$result = mysql_query("select * from users") or die (mysql_error());

// Use the function written above... 
writeResult($result);

?>

So what I would like is the only thing on the page is the button when loading the page. When they click the button, the query data in the table appears on the same page below the button....hope this helps

Thank you
gman

[Join us @ facebook]

Can you post the form code also?

So on one page I have this code

Code:

<form action="testDB1.php" method="post" name="form1" id="form1">
  <label>
  <input type="submit" name="Submit" value="Show Users" />
  </label>
</form>

So it loads the testDB1.php file that has the query info on it....I would like them all on one page

[Join us @ facebook]

Add to every page that you want it this :

Code:

<form action="<?=$_SERVER['PHP_SELF'];?>" method="post" name="form1" id="form1">
  <label>
  <input type="hidden" name="showT" value="1" />
  <input type="submit" name="Submit" value="Show Users" />
  </label>
</form>
<?php
include 'testDB1.php';
?>

And then change the testDB1.php to this :

Code:

<?php

// This code will draw a table with the data retrieved from the query.
 
function writeResult($result){ 
    if(gettype($result) != "resource" || get_resource_type($result) != "mysql result"){ 
        echo "Could not draw the table, not a valid mysql result."; 
        return; 
    } 
    $HTMLCode = "<table border=\"1\">"; 
    $HTMLCode .= "<tr>";
for($i = 0; $i < mysql_num_fields($result); $i++){ 
        $HTMLCode .= "<th>" . mysql_field_name($result, $i) . "</th>"; 
    } 
    for($i = 0; $i < mysql_num_rows($result); $i++){ 
        $HTMLCode .= "<tr>"; 
        for($k = 0; $k < mysql_num_fields($result); $k++){ 
            $data = mysql_result($result, $i, $k); 
            $data = (($data == "") ? "&nbsp;" : $data); // avoid empty strings 
            $HTMLCode .= "<td>" . $data . "</td>"; 
        } 
        $HTMLCode .= "</tr>"; 
    } 
    $HTMLCode .= "</tr>"; 
    $HTMLCode .= "</table>"; 
    echo $HTMLCode; 
} 
$result = mysql_query("select * from users") or die (mysql_error());

// Use the function written above... 
if ( !empty($_POST['showT']) ) 
      writeResult($result);
?>

I guess this will work, but to be honest I don't understand the use of it

nice code Nick....

post it to the code gallery...

I am getting a Fatal error stating that it cannot redeclare writerresult...will have to look into it further...thanks Nick for the updated code

I am getting a Fatal error stating that it cannot redeclare writerresult...will have to look into it further...thanks Nick for the updated code

check that there is only one time

Code:

function writeResult($result){ ...

[Join us @ facebook]

Change this :

include 'testDB1.php';

to this :

include_once 'testDB1.php';

Thanks guys, all errors are gone but where should I put the DB Connect function? This is actually part of Olaf's Access Class and I have including the access_user_class.php file

It is stating I do not have access to the server.

Thanks again

Thanks guys, all errors are gone but where should I put the DB Connect function? This is actually part of Olaf's Access Class and I have including the access_user_class.php file

It is stating I do not have access to the server.

Thanks again

is this file using the class?

Well...I am trying to use the class...just not how to incorporate the code that Nikolas helped me out with and your code. Sorry for all of the questions...I appreciate the help

[Guest]

[62.873]

deccanbazaar, Googlebot, adsense, Msnbot, hobbit, Yahoo crawler