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:


$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>&nbsp;</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>&nbsp;</td></tr>";
print "<tr><td colspan=2 align=center><input type=submit value='Submit'></td></tr>";


$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 <[EMAIL PROTECTED]> wrote:

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
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


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.

Reply via email to