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

On 2010-11-04, at 4:23 PM, Tomás Corrales Lemoine <tomas@hog.ecasa.avianet.cu> wrote: > 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="'.$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 Ajax back to the server to run the php Bastien Koert