How to code in PHP an onchange event in a <select>?

Tomás Corrales Lemoine <tomas@xxxxxxxxxxxxxxxxxxxx> · Thu, 4 Nov 2010 15:23:07 -0500

Hi, List,

I have this two files (“index.php”
and “include.php”). They both work fine, but I want to substitute
the code for de onchange event in the <select> tag. Can I use PHP to code
this event? How?

Thanks.

index.php:

<?php

echo '<html><body>';

include_once 'include.php';

$mysql_link =
tcl_MySQL_ConnectToServer('localhost', 'user', 'password');

tcl_MySQL_OpenDataBase($mysql_link, 'production');

$query = 'SELECT
DISTINCT recipe.product_id, product.description FROM recipe, product WHERE recipe.product_id
= product.product_id ORDER BY product.description';

$result =
tcl_MySQL_DataQuery($mysql_link, $query);

tcl_FillComboBox($result, 'Product', 'product_id', 'description', 'alert(\'Alert
Message\')');

tcl_MySQL_CloseConnection($mysql_link);

echo '</body></html>';

?>

include.php:

<?php

function tcl_MySQL_CloseConnection($link) {

      mysql_close($link);

}

function tcl_MySQL_ConnectToServer($host, $user, $password) {

      $link
= mysql_connect($host, $user, $password);

      if (!$link) {

            die('No se pudo
conectar: '.mysql_error());

      }

      echo '<h3>User
'.strtoupper($user).'
connected to MySQL server.</h3>';

      return
$link;

}

function tcl_MySQL_DataQuery($link, $query) {

      return
mysql_query($query, $link);

}

function tcl_MySQL_OpenDataBase($link, $database) {

      mysql_select_db($database, $link);

}

function tcl_FillComboBox($result, $label, $col1, $col2, $onchange) {

      echo '<label>'.$label.'</label><select
>.$onchange.'"><option
value="">';

      while ($line
= mysql_fetch_array($result, MYSQL_ASSOC))
{

            echo '<option
value="'.$line[$col1].'">'.$line[$col2];

      }

      echo '</select>';

}

?>

-- 

Aeropuerto Internacional Frank País García de Holguín.

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php