Witam! Mam na stronie dwa rozwijane menu z czego jedno(lewe na screenie) z nich pozwala wybrać typ aktualnie wyświetanych wiadomości a drugie(prawe na screenie) pozwala wybrać typ sortowania wiadomości. Pierwsze menu działa poprawnie, ale niestety drugie(mimo analogii) nie działa - błąd jak na screenie, prawdopodobnie z jakichś powodów parametr(zapytanie mysql - string) nie jest przekazywany do funkcji (
if(isset($_POST['types2'])
){
). Dlaczego?
<?php
function get_options($select){
$types = array('Odebrane'=>2, 'Wysłane'=>3, 'Usunięte' =>4, 'Wszystkie'=>5);
$options =' ';
while(list($k, $v)=each($types)){
if($select==$v){
$options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
}
else{
$options.='<option value=" '.$v.' "> ' .$k. ' </option>';
}
}
return $options;
}
function get_optionsS($select){
$types_s = array( 'Wysłane'=>3, 'Odebrane'=>2, 'Usunięte' =>4, 'Wszystkie'=>5);
$options =' ';
while(list($k, $v)=each($types_s)){
if($select==$v){
$options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
}
else{
$options.='<option value=" '.$v.' "> ' .$k. ' </option>';
}
}
return $options;
}
function get_optionsA($select){
$types_a = array('Wszystkie'=>5, 'Odebrane'=>2, 'Wysłane'=>3, 'Usunięte' =>4);
$options =' ';
while(list($k, $v)=each($types_a)){
if($select==$v){
$options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
}
else{
$options.='<option value=" '.$v.' "> ' .$k. ' </option>';
}
}
return $options;
}
function get_optionsT($select){
$types_t = array('Usunięte' =>4,'Odebrane'=>2, 'Wysłane'=>3, 'Wszystkie'=>5);
$options =' ';
while(list($k, $v)=each($types_t)){
if($select==$v){
$options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
}
else{
$options.='<option value=" '.$v.' "> ' .$k. ' </option>';
}
}
return $options;
}
function get_options2($select){
$types2 = array('Sortuj po'=>6, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco'=>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco'=>14);
$options =' ';
while(list($k, $v)=each($types2)){
if($select==$v){
$options.='<option value=" '.$v.' "selected> ' .$k. ' </option>';
}
else{
$options.='<option value=" '.$v.' "> ' .$k. ' </option>';
}
}
return $options;
}
?>
<div id="mpri-form">
Tutaj możesz wysyłać wiadomości do innych pracowników lub właściciela - UWAGA! Tylko w obrębie Twojego obiektu noclegowego!.
<form method="post">
<p>
<div id="mmsg-form1">Do:<input type="text" name="for" size="60" placeholder = "Podaj nazwę użytkownika odbiorcy"></input></div>
<div id="mmsg-form2">Od:<input type ="text" name="from" cols="60" rows ="1" value = "<?php echo $from; ?>" readonly></input></div>
<div id="mmsg-form3">Temat:<input type ="text" name="subject" cols="60" rows ="1" placeholder="Podaj temat wiadomości" ></input></div>
<div id="mmsg-form4">Treść:<textarea name="content" cols="90" rows="6" placeholder="Treść wiadomości"></textarea></div>
<div id="mmsg-form7"><input class="btn btn-primary" type="submit" value="Wyślij wiadomość" name="postsave"></div><br></p></form>
<div id="span_msg"><span class="error"><?php echo $error;?></span></div></div>
<table name="table" border="1" style="color:#1c4e93; position:relative; top:-120px; ">
<thead>
<th class = "th"><input type="hidden" name="id" value="id" /><input type="button" value="ID" name="id_user" class="btn btn-default btn-warning"></th>
<th class = "th"><input type="hidden" name="to" value="to" /><input type="button" value="Do" name="uto" class="btn btn-default btn-warning" style="width: 222px;"></th>
<th class = "th"><input type="hidden" name="from" value="from" /><input type="submit" value="Nadawca" name="ufor" class="btn btn-default btn-warning" style="width: 222px;"></th>
<th class = "th"><input type="hidden" name="title" value="title" /><input type="button" value="Tytuł" name="utit" class="btn btn-default btn-warning" style="width: 222px;"></th>
<th class = "th"><input type="hidden" name="content" value="content" /><input type="button" value="Treść wiadomości" name="ucon" class="btn btn-default btn-warning" style="width: 222px;" ></th>
<th class = "th"><input type="hidden" name="date" value="date" /><input type="button" value="Data" name="urdat" class="btn btn-default btn-warning" style="width: 222px;" ></th>
<th class = "th" width="120px;"><div style = "width: 120px;">Opcje</div></th>
</tr>
</thead>
<tbody>
<?php
function show($query_disp){
include ('/var/www/vhosts/solaris-ustronie.eu/httpdocs/joomla/administrator/modules/mod_activate/db_joomla.php');
/* $user = JFactory::getUser();
$id = $user->id;
$query_disp="SELECT * FROM jos_program_prices WHERE id_owner= '$id'"; */
//$query_d=$query_disp;
$table ="jos_program_prices";
$id_col="id";
$error = $query_disp;
$resultSet = mysql_query($query_disp, $con);
?>
<div id="mmsg-form5">Pokaż tylko wiadomości:</div>
<div id="mmsg-form14">Sortuj po:</div>
<div id ="mmsg-form6">
<form method ="post">
<select name = "types" onchange = "this.form.submit();"> <?php echo get_options($selected); ?> </select>
</form></div>
<div id ="mmsg-form10">
<form method ="post">
<select name = "types2" onchange = "this.form.submit();"> <?php echo get_options2($selected); ?> </select>
</form></div>
<?php
//ini_set('max_execution_time', 300);
while($row = mysql_fetch_array($resultSet)) {
$id= $row['id'];
$type= $row['to_user'];
$pricefor=$row['from_user'];
$range =$row['title'];
$room =$row['content'];
$price =$row['date'];
?>
<tr>
<td class="container" width = "40px;"><center><?php echo $row['id'];?></td>
<td class="container" ><div><input type="text" name="type" size="40;" line-height="0px" value="<?php echo $row['to_user'];?>"></input></div></td>
<td class="container"><div class="td_div"><input type="text" name="price_for" size="40" line-height="0px" value="<?php echo $row['from_user'];?>"></input></div></td>
<td class="container"><div><input type="text" name="range" size="40" line-height="0px" value="<?php echo $row['title'];?>"></input></div></td>
<td class="container"><div><input type="text" name="room_type" size="40" line-height="0px" value="<?php echo $row['content'];?>"></input></div></td>
<td class="container"><div><input type="text" name="price" size="40" line-height="0px" value="<?php echo $row['date'];?>"></input></div></td>
<td class="container">
<div> <input type="hidden" name="id" value="<?php echo $id; ?> " /></div>
<div><input type="hidden" name="table" value="<?php echo $table; ?> " /></div>
<div class="opt_btnu"> <input type="button" value="Do kosza" class="btn btn-primary" style="width: 58px;" onClick="location.href='https://www.solaris-ustronie.eu/joomla/administrator/modules/mod_activate/trash_messages.php?param=<?php echo $table;?>,<?php echo $id_col;?>,<?php echo $id;?>'"></div>
</td>
</tr>
<?php } mysql_close();}
$trash=1;
$back =0;
$query12="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND ((to_user = '$login' AND trash_to= '$back') OR (from_user = '$login' AND trash_from = '$back')) ORDER BY date DESC"; //wszystkie
$query0="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND (to_user = '$login' AND trash_to= '$back') ORDER BY date DESC"; // odebrane
$query13="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND (from_user = '$login' AND trash_from= '$back') ORDER BY date DESC"; // wysłane
$query7="SELECT * FROM jos_program_messages WHERE owner= '$parent' AND ((to_user = '$login' AND trash_to = '$trash') OR (from_user = '$login' AND trash_from = '$trash')) ORDER BY date DESC"; //usunięte
$query10 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY id DESC";
$query11 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY id ASC";
$query14 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY date DESC";
$query15 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY date ASC";
$query16 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY from_user DESC";
$query17 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY from_user ASC";
$query18 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY title DESC";
$query19 = "SELECT * FROM jos_program_messagess WHERE owner='$parent' AND from_user ='$login' AND trash_from= '$back' ORDER BY title ASC";
if(isset($_POST['types']) || isset($_POST['types_a']) || isset($_POST['types_s']) || isset($_POST['types_t']) || isset($_POST['types2']) || isset($_POST['types3']) || isset($_POST['types4']) || isset($_POST['types5'])){
if(isset($_POST['types'])){
$selected = $_POST['types'];
//$error = $selected;
$o = 2;
$w = 3;
$u = 4;
$ws = 5;
if($selected == $w){
$error= $selected;
$query_disp=$query13;
showSend($query_disp);
}
if($selected == $o){
$error = $selected;
$query_disp=$query0;
show($query_disp);
}
if($selected == $u){
$error = $selected;
$query_disp=$query7;
showTrash($query_disp);
}
if($selected == $ws){
$error = $selected;
$query_disp=$query12;
showAll($query_disp);
}
}
if(isset($_POST['types_a'])){
$selected = $_POST['types_a'];
//$error = $selected;
$o = 2;
$w = 3;
$u = 4;
$ws = 5;
if($selected == $w){
$error= $selected;
$query_disp=$query13;
showSend($query_disp);
}
if($selected == $o){
$error = $selected;
$query_disp=$query0;
show($query_disp);
}
if($selected == $u){
$error = $selected;
$query_disp=$query7;
showTrash($query_disp);
}
if($selected == $ws){
$error = $selected;
$query_disp=$query12;
showAll($query_disp);
}
}
if(isset($_POST['types_s'])){
$selected = $_POST['types_s'];
//$error = $selected;
$o = 2;
$w = 3;
$u = 4;
$ws = 5;
if($selected == $w){
$error= $selected;
$query_disp=$query13;
showSend($query_disp);
}
if($selected == $o){
$error = $selected;
$query_disp=$query0;
show($query_disp);
}
if($selected == $u){
$error = $selected;
$query_disp=$query7;
showTrash($query_disp);
}
if($selected == $ws){
$error = $selected;
$query_disp=$query12;
showAll($query_disp);
}
}
if(isset($_POST['types_t'])){
$selected = $_POST['types_t'];
//$error = $selected;
$o = 2;
$w = 3;
$u = 4;
$ws = 5;
if($selected == $w){
$error= $selected;
$query_disp=$query13;
showSend($query_disp);
}
if($selected == $o){
$error = $selected;
$query_disp=$query0;
show($query_disp);
}
if($selected == $u){
$error = $selected;
$query_disp=$query7;
showTrash($query_disp);
}
if($selected == $ws){
$error = $selected;
$query_disp=$query12;
showAll($query_disp);
}
}
if(isset($_POST['types2'])){
$selected = $_POST['types2'];
$error = $selected;
$o7 = 7;
$w = 3;
$u = 4;
$ws = 5;
if($selected == $o7){
//$error= $selected;
$query_disp=$query11;
show($query_disp);
// $types2 = array('ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
}
if($selected == 8){
$error = $selected;
$query_disp=$query10;
show($query_disp);
$types2 = array( 'ID malejąco'=>8, 'ID rosnąco'=>7, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
}
if($selected == 9){
$error = $selected;
$query_disp=$query17;
showTrash($query_disp);
$types2 = array('Nadawca rosnąco' =>9, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
}
if($selected == 10){
$error = $selected;
$query_disp=$query16;
show($query_disp);
$types2 = array('Nadawca malejąco'=>10, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
}
if($selected == 11){
$error = $selected;
$query_disp=$query15;
show($query_disp);
$types2 = array( 'Od najnowszych'=>11, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
}
if($selected == 12){
$error = $selected;
$query_disp=$query14;
show($query_disp);
$types2 = array('Od najstarszych'=>12, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Tytuł rosnąco'=>13, 'Tytuł malejąco' =>14 );
}
if($selected == 13){
$error = $selected;
$query_disp=$query19;
show($query_disp);
$types2 = array('Tytuł rosnąco'=>13,'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł malejąco' =>14 );
}
if($selected == 14){
$error = $selected;
$query_disp=$query18;
show($query_disp);
$types2 = array('Tytuł malejąco' =>14, 'ID rosnąco'=>7, 'ID malejąco'=>8, 'Nadawca rosnąco' =>9, 'Nadawca malejąco'=>10, 'Od najnowszych'=>11, 'Od najstarszych'=>12, 'Tytuł rosnąco'=>13 );
}
}
}
else
{
$query_disp=$query0;
show($query_disp);
}
?>
</tbody>
</table>
</div>