PHP - Moved: Dynamic Option Box

This topic has been moved to JavaScript Help.

http://www.phpfreaks.com/forums/index.php?topic=307346.0

Hello I want product filter groups by category.

There will be different options.

Ex: http://prntscr.com/sr00ay

Product Table : http://prntscr.com/sr00rm

Option Groups Table : http://prntscr.com/sr013r

Options Table : http://prntscr.com/sr01fk

Product Option Table : http://prntscr.com/sr01r3

How can I build this structure? And how should it be sql for filtering? Is the structure correct? I'm waiting for your help.

Edited May 31, 2020 by Atakan

So, it's me again.
Hope you dont mind 

I try to fetch data from mysql and list it to select option like this

Code: [Select]
<td>Category</td>
<td>:   <select name="category">
<?php
$query = "SELECT DISTINCT category FROM dress";
$sql = mysql_query($query);
while($result = mysql_fetch_array($sql)){ 
echo "<option value='".$result['category']."'>".$result['category']."</option>";
}
?>
<option value="other">New Category --></option>
</select><input type="text" name="categoryOther"></td>
</tr>

...and success. BUT, when I try to echo submitted value it return nothing
this is the code to process above form
Code: [Select]
if(isset($_POST['categoryOther'])){
$category = $_POST['categoryOther'];
} else {
$category = $_POST['category'];
}
if(isset($_POST['subcategoryOther'])){
$subcategory = $_POST['subcategoryOther'];
} else {
$subcategory = $_POST['subcategory'];
}
echo "category : ".$category."<br>";

What did I do wrong here?

Hi,

I wanted to make a dynamic php page. I want the user to choose an option you could select in an option box (html) and after that I wish that down the page some text would change. If I take option 1 -> text 1, option 2 -> text 2, ...
But this doesn't work, do I need a button or something to made my code running, and how do I have to use it on the same page?
Or is it possible to run it automaticly after a new choice?

Thanx, Kevin



My code:

<?php
/*
Template Name: template voor Ieder1Trainer #
*/
get_header(); 

$Tacktiek = "";

$Tacktiek1 = "3-5-2";
$Tacktiek2 = "3-4-3";
$Tacktiek3 = "4-5-1";
$Tacktiek4 = "4-4-2";
$Tacktiek5 = "4-3-3";
$Tacktiek6 = "5-4-1";
$Tacktiek7 = "5-3-2";

$aantalDef;
$aantalMid;
$aantalAtt;

?>

<div id="newsfeed">

<div class="banderol">
<div class="banderol_left"></div>
<h1>Dynamic page</h1>
</div>

<?php if(is_user_logged_in()) { 
get_currentuserinfo();
//echo 'Username: ' . $current_user->user_login . "\n";
//echo 'User email: ' . $current_user->user_email . "\n";
?>

<!-- 
Here you choose a tactiek; 1,2,3, .. after that has been choosen I whise the next php-code would be run (the if-then-elseif-...)
-->

<tr>
<td><p class="formulier">Kies je Tacktiek:</p></td>
<td>
<select size="1" name="$Tacktiek">
<option selected><?php echo $Tacktiek1;?></option>
<option><?php echo $Tacktiek2;?></option>
<option><?php echo $Tacktiek3;?></option>
<option><?php echo $Tacktiek4;?></option>
<option><?php echo $Tacktiek5;?></option>
<option><?php echo $Tacktiek6;?></option>
<option><?php echo $Tacktiek7;?></option>
</select>
</td>
</tr>

<!--
This must be run after choosen a tactiek.
-->

<?php
if($Tacktiek == '3-5-2') {
$aantalDef = 3;
$aantalMid = 5;
$aantalAtt = 2;
} elseif($Tacktiek == '3-4-3') {
$aantalDef = 3;
$aantalMid = 4;
$aantalAtt = 3;
} elseif($Tacktiek == '4-5-1') {
$aantalDef = 4;
$aantalMid = 5;
$aantalAtt = 1;
} elseif($Tacktiek == '4-4-2') {
$aantalDef = 4;
$aantalMid = 4;
$aantalAtt = 2;
} elseif($Tacktiek == '4-3-3') {
$aantalDef = 4;
$aantalMid = 3;
$aantalAtt = 3;
} elseif($Tacktiek == '5-4-1') {
$aantalDef = 5;
$aantalMid = 4;
$aantalAtt = 1;
} elseif($Tacktiek == '5-3-2') {
$aantalDef = 5;
$aantalMid = 3;
$aantalAtt = 2;
}

?>

<!--
After this run, the next code must be run and made a choose of text
-->

<tr>
<td><p class="formulier">
<?php if($aantalDef == '3') {
echo "3 defs";   //Choosen text if aantalDef == 3
}
elseif($aantalDef == '4') {
echo "4 defs";   //Choosen text if aantalDef == 4
}
elseif($aantalDef == '5') {
echo "5 defs";   //Choosen text if aantalDef == 5
}
?>
</p></td>

<!--
Other choose of options, but always the same options.
-->
<td>
<select size="1" name="$Speler4">
<option selected><?php echo $NaamDef1;?></option>
<option><?php echo $NaamDef2;?></option>
<option><?php echo $NaamDefMid1;?></option>
<option><?php echo $NaamDefMid2;?></option>
<option><?php echo $NaamDefMid3;?></option>
<option><?php echo $NaamDefMid4;?></option>
<option><?php echo $NaamDefMid5;?></option>
<option><?php echo $NaamDefMid6;?></option>
<option><?php echo $NaamDefMid7;?></option>
<option><?php echo $NaamDefMid8;?></option>
<option><?php echo $NaamDefMidAtt1;?></option>
<option><?php echo $NaamDefMidAtt2;?></option>
<option><?php echo $NaamDefMidAtt3;?></option>
</select>
</td>
</tr>


<?php
} 
else{
echo 'U dient in te loggen.';
}
?>


</div>

<?php get_footer(); ?>

I'm trying to create a dynamic option menu with one alert selected based on the first query to the db. Any help would be greatly appreciated. 

Code: [Select]
//function to get alerts and create select menu with current alerts pre-selected
function getALERTS1($id){
    require('db.php');
    $alert = mysqli_query($conn, "SELECT alert1 FROM visit_data WEHERE patientid = $id AND discharged IS NULL");
    $row = mysqli_fetch_array($alert);
   
    $selects=null;
    $query = mysqli_query($conn, "SELECT alertid, name FROM alerts");

while($row1 = mysqli_fetch_array($query)) {
    $selects .= "<option value=\"" . $row1['alertid'] . "\">
    if($row1['alertid']==$row['alert1'])
            {
                echo ' selected';
            }
   
    ".$row1['name']."</option>";
  }
  return $selects;
}