RE: [PHP] How to code in PHP an onchange event in a <select>?
| From: | admin at buskirkgraphics dot com | Date: | Fri, 05 Nov 2010 02:58:53 +0000 |
| Subject: | RE: [PHP] How to code in PHP an onchange event in a <select>? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-309328@lists.php.net to get a copy of this message | ||
OnChange is Javascript.
I might suggest you get yourself familiar with JQuery.
JQuery makes your life a lot easier when there is a need for client browser
interaction with site scripting.
Richard L. Buskirk
From: Tomás Corrales Lemoine [mailto:tomas@hog.ecasa.avianet.cu]
Sent: Thursday, November 04, 2010 4:23 PM
To: php-general@lists.php.net
Subject: [PHP] How to code in PHP an onchange event in a <select>?
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.