On 2010-11-04, at 4:23 PM, Tomás Corrales Lemoine <[email protected]>
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
