Re: Re: Passing variables to a PHP script on clicking a hyperlink

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>&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>"; ?> *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@connexios.com> 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.