asked on
<?php
echo '<form method="post">';
$rows = db_select("SELECT idcompany, company FROM company order by idcompany;");
if($rows === false) {
$error = db_error();
echo "<ul class='error'>";
echo "<li class='error'>Error : $error </li> ";
echo "</ul>";
}
?><label>Company: </label><?php
?><select id="Company" onChange=" onChange="location.reload()"> <?php
foreach($rows as $row){
echo "<option value='" . $row['idcompany'] ."'>" . $row['company'] ."</option>";
}
echo '</select>';
echo '</form>';
?>
// SELECT * FROM notifications_vw where idcompany = $id_company
$id_company = $_GET['Company'];
$rows = db_select("SELECT * FROM notifications_vw where idcompany = $id_company");
if($rows === false) {
$error = db_error();
echo $error;
}
ASKER
<?php
echo '<form action="" method="post" name="company_form">';
$rows = db_select("SELECT idcompany, company FROM company order by idcompany;");
if($rows === false) {
$error = db_error();
echo "<ul class='error'>";
echo "<li class='error'>Error : $error </li> ";
echo "</ul>";
}
?><label>Company: </label><?php
?><select id="id_company" onChange="this.form.submit()" name="Company"> <?php //onChange="location.reload()"
echo "<option value='0'>Select Company</option>";
foreach($rows as $row){
echo "<option value='" . $row['idcompany'] ."'>" . $row['company'] ."</option>";
}
echo '</select>';
echo '</form>';
?>
<?php
//include "connect.php";
$id_company = $_POST['Company'];
$rows = db_select("SELECT * FROM notifications_vw where idcompany = $id_company ");
if($rows === false) {
$error = db_error();
echo $error;
}
echo "<option value='0'>Select Company</option>";
ASKER
<?php
echo '<form action="" method="post" name="company_form">';
?><label>Company: </label><?php
?><select id="id_company" onChange="this.form.submit()" name="Company"> <?php
if (! empty($_POST['Company'])) {
$id_company = $_POST['Company'];
$rows = db_select("SELECT idcompany, company FROM company where idcompany = $id_company;");
echo "<option value='" . $row['idcompany'] ."' selected >" . $row['company'] ."</option>";
}
$rows = db_select("SELECT idcompany, company FROM company order by idcompany;");
if($rows === false) {
$error = db_error();
echo "<ul class='error'>";
echo "<li class='error'>Error : $error </li> ";
echo "</ul>";
}
foreach($rows as $row){
if ( $row['idcompany'] == $id_company)
$seled = "selected"; else $seled = "";
echo "<option value='" . $row['idcompany'] ."' " . $seled .">" . $row['company'] ."</option>";
}
echo '</select>';
echo '</form>';
?>
ASKER
JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and in almost every mainstream web browser.
TRUSTED BY