I think that you can also do that buy making a drop down list with the
available databases and pass the chosen database to another (or perhaps
the same) script and make the queries and output results there. You can
catch the posted or got option buy using the $_REQUEST array ($_GET and
$_POST are included in that like a less lame solution). Let's say you
have a databases.php script that passes options to con_query.php the
code could something like that:
*databases.php:*
<?php
$label = "Choose a database :";
$database = array('database1','database3','database3');
# Print the headers
print '<html><head><meta http-equiv="content-type"
content="text/html; charset=UTF-8"><title>Database
selection</title></head><body no-repeat;">';
print '<table class=outer border=0 width=100% cellpadding=10
cellspacing=10>';
print ' <tr><td height=92px colspan=2></td></tr>';
# Print the drop down form
print "<form name='dtbases' action='con_query.php' method='POST'>";
print '<table border=0 ><tr><td><table
class=invis><tr><td> </td></tr>';
print "<tr><td><b>$label</b></td><td><select name='database'>";
foreach ($database as $value){
print "<option value='$value'>$value</option>";
}
print "</td></tr></select>";
print "<tr><td> </td></tr>";
print "<tr><td colspan=2 align=center><input type=submit
value='Submit'></td></tr>";
?>
*con_query.php:*
<?php
$database = $_REQUEST['database'];
print "The user chose database : ".$database;
?>
You can take now the $database containing the one chosen by the user and
connect and query whatever you wan't.
Have fun.
mike wrote:
On 8/23/07, Suamya Srivastava <suamya.srivastava@xxxxxxxxxxxxx> wrote:
Hello,
How can I pass variables on clicking a hyperlink to a PHP script? I have 5
hyperlinks, all pointing to the same PHP script. However, on clicking each
hyperlink a different value of the variable needs to be passed to the PHP
script.
i.e. I have 5 databases from which I want to obtain information, however
the information should be displayed only when the user clicks on the
hyperlink for that database. How can I pass the database name to the PHP
script? How would the script know which database to get information from?
I am new to PHP so any help would be greatly appreciated. I hope my
question is clear.
use GET
foo.php?param=value
or you could use POST by using some client-side javascript to do a
form submit with key/value pairs.
this is a *very* simple operation... all web-enabled languages
understand HTTP POST/GET/etc. - those are the main ways of exchanging
data between client/server.
