PHP - Dynamic Dropdown Selected

i have the following code:
<td width='100px'>Suppliers
                <select name="supplier">
                    <?php
                       $catcher_id = $service->getCatcherId();
                       $supplier_names = LpmAdnetworkPeer::getByName($catcher_id);
                       foreach($supplier_names as $row)
                       {
                           ?>
                           <option><?php echo $row->getName();
                           ?></option>
                    <?php     
                       }
                    ?>
                </select>
                </td>   

then on the same form i have a submit button that takes me to the next form..the problem now is how can i access the ID of the item seleted in the dropdown on the NEXT form please?
i can get the name from the list by $_POST['supplier'] on the next form
thanks

friend the code display all the managers name  

  <?php

        echo '<select name="Manager">';

        $query="SELECT * FROM managers";

        $result = mysql_query($query);

        while ($row = mysql_fetch_array($result)) {

            echo "<option value='" . $row['manager_name'] . "'>" . $row['manager_name'] . "</option>";

        }

        echo '</select>';

        ?>

  and the variable below displays the result   $Manager= $row['Manager'] ;     but how do i do it on the above dropdown list the it shows which result is in the $Manager variable?

mysql.php
<?php
$con = mysql_connect("localhost","root","");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("ckeditor",$con);
?>
---------------------------------------------------------
add.php
<?php
include("mysql.php");


if(isset($_POST["button2"]))
{
$sql="INSERT INTO cktext (section)
VALUES
('$_POST[select2]')";

if (!mysql_query($sql,$con))
  {
  die('Error: ' . mysql_error());
  }

?>

-----------------------------------------------------------------
home.php

<form id="form1" name="form1" method="post" action="add.php">
<tr>
    <td>Section:</td>
    <td><select name="select2" id="select2">
     <option selected="selected" value="MALE">Male</option>
  <option selected="" value="FEMAIL">FEMAIL</option>
    </select></td>
  </tr>
<input type="submit" name="button2" id="button2" value="Upload" />
  </form>

In DATABASE :- cktext table attribute "section" is varchar type.

BUT IT RETURN ME BLANK OUTPUT.

i skipped solving this the other day with an easier way but now i am stuck with this stumble again in another area and i have no way out....
so here it goes,
i have an ajax dropdown box...i need to get the value that is selected by the user when it is clicked and then pass this value to a new pop window by appending to its url....any suggestions?

I'm just attempting to learn how PHP handles things and I can't quite wrap my head around how to apply Selected to the final Option and show the Traits for the Character based on the Selected Option.

I understand this might need POST, if it does, I would appreciate a bit of help on how I would set this up as POST since I didn't think a drop down required a submit button.

Code: [Select]
$character= array (array(Name=>"Barry","Class"=>"Fighter",Level=>1,Str=>10,Dex=>10,"Int"=>10),array(Name=>"Lindehar","Class"=>"Ranger",Level=>1,Str=>10,Dex=>10,"Int"=>10),array(Name=>"Verelden","Class"=>"Mage",Level=>1,Str=>10,Dex=>10,"Int"=>10));

print "Select a Character:<br /><select>";
foreach($character as $array_num)
{
foreach($array_num as $char_trait=>$trait_value)
{
if($char_trait==Name)
{
$selected_value="";
$generated_chars="<option selected=".$selected_value." value='".$char_trait."'>".$char_trait.": ".$trait_value."</option>";
print $generated_chars;
if($selected_value=/".$char_trait.": Barry"/")
{
foreach($char_trait=="Barry")
{
print "<h4>".$char_trait.": ".$trait_value."</h4>";
}
}
}


}
}
print "</select><p />";

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;
}

I'm new to this form and php/mysql so sorry if this isn't the right place to post this.


This is what is in the first dropdown box.
Code: [Select]

$selValues['john'] = "a, b, c, d, e";

These are the different lists I want it to put in the second drop down box depending on what they choose in the first.
Code: [Select]
$selValues['list1']= " a1, a2, a3, a4, a5";
$selValues['list2']= " b1, b2, b3, b4, b5";

This is how I made an attempt to make it work before posting here. Along with plently of other ways.
Code: [Select]
if ($selValues['john']=a)
{
     $chan_input = selectBuilder($selValues['$list1'] };
else if ($selValues['john']=b)
 {
     $chan_input = selectBuilder($selValues['$list2'] };

Basicly how I need it to work is there are two drop down boxes. First they will chose between a,b,c,d,e. If they chose a then on the second drop down box I only want them to be able to select a1,a2,a3,a4,a5.

Hey Everyone...

First off, I am only a young web developer and i'm working on a school project and am making a text-based game online...

Now what i'm having trouble with...

I want a drop-down list that has a list of characters classes
Clubber
Mixer
Sauceror
Tamer

And I want whatever is selected to be placed into the database along with the username/password (THIS ALL WORKS FINE JUST NOT THE DROP DOWN LIST)

All help appreciated

Yesterday, I created a topic about how I could update records and I managed to achieve that successfully.

Now I have another dilemma.

When I have a specific record I want to update, I want to change a category ID of an product (e.g. change it from 1 to 2) but how do I go about doing this?

Here is my code thus far:

Code: [Select]
<?php

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$id=$_GET['prodID'];

$results = mysqli_query($dbc, "SELECT * FROM product WHERE prodID=".$_GET['prodID']."");
$row = mysqli_fetch_assoc($results);

?>
<form action="" method='POST'>
Product ID: <input type="text" value="<?php echo $row['prodID'];?>" name="prodID" /> <br />
Product: <input type="text" value="<?php echo $row['product'] ;?>" name="product" /> <br />
Product Description: <input type="text" value="<?php echo $row['prod_descr'] ;?>" name="prod_descr" /> <br />
Category:
<select name="category">
<option value="<?php echo $row['catID'];?>"></option>
</select>
Price: <input type="text" value="<?php echo $row['price'] ;?>" name="price" /> <br />
In Stock: <input type="text" value="<?php echo $row['stock'] ;?>" name="stock" /> <br />
<br /><input type="submit" value="save" name="save">
</form>

<?php

if(isset($_POST['save']))
 {
    $id = $_POST['prodID'];
    $product = $_POST['product'];
$descr = $_POST['prod_descr'];
$price = $_POST['price'];
$stock = $_POST['stock'];

// Update data
    $update = mysqli_query($dbc, "UPDATE product SET product='$product', prod_descr='$descr', price='$price', stock='$stock' WHERE prodID=".$_GET['prodID']."");
header( 'Location: update_save.php' ) ;
}
?>

Folks,

I have a dropdown, once values are selcted, these values should be put in a URL structure so that it matches with the one MoD_rewrite rule in my .htaccess.

Here is my Mod_Rewrite Rule:

   RewriteRule ^(.*)/([^/]*)\.html$ search.php?q=$1&sc=$2 [QSA,L] 


Here is my Dropdown Code:

 <div id="search" >

<form id="searchform" method="get" action="search.php">
<label>Search By Brand/ Manufacturer: </label>

<select name="q">

<option value="SelectBrand">Select Brand</option>

<?php if(isset($this->search->options)): ?>
<?php foreach($mfg as $lolachild): ?>

  <option value="<?php echo $lolachild; ?>"><?php echo ucwords($lolachild); ?></option>

<?php endforeach; ?>
<?php endif; ?>

</select>

<select name="sc">

  <option value="All"><?php eprint(LangAll); ?></option>
<?php if(isset($this->search->options)): ?>
<?php foreach($this->search->options as $cat): ?>

  <option value="<?php echo $cat->value; ?>"><?php echo $cat->name; ?></option>
<?php endforeach; ?>
<?php endif; ?>

</select>

        <input type="submit" value="<?php eprint(LangSearch); ?>" />

</form>

 </div> 



Problem is, upon Submit, it goes to this link structu

http://mydomain.co.uk/search.php?q=fisher&sc=302

It should rather be:

http://au2.co.uk/fisher/302.html

What am i missing or doing wrong?

Cheer
Natasha

Hi guys,

I've got this php script which display the users of my database in a dynamic dropdown:
<?php 
include "leadscript/connect_to_mysql.php"; 
$canvass_name="";
$sql = mysql_query("SELECT * FROM csj_canvasser");
$appointmentCount6 = mysql_num_rows($sql); // count the output amount
if ($appointmentCount6 > 0) {
while($row = mysql_fetch_array($sql)){ 
$c_employee = $row["c_employee"];
$canvass_name .='<option value="' . $c_employee . '">' . $c_employee . '
</option>';
 }
}


?>
                <form>
                <select name="c_employee">
                <option value="">Select a person:</option>
                <?php echo $canvass_name; ?>
                </select>
                </form>

I was wondering if there's a way I can write a code to GET value I select from the dynamic dropdown and use it to write a select query.

Thank

Hi guys. I am having a hard time finding a solution for this, is it possible to get not the value of a dropdown (oh what's it called??? ) but what is in between of the <option> tag?like,

Code: [Select]
<select name="catID">
<option value=$row['c_id']>$row['c_name']</option>

and save it to the database??cuz I'm using a dynamic dropdown which bases the content of another dropdown by the id of the previous. And so, if i save it to the database, instead of for example "BSA" is saved, the id of "BSA" which is "1" is saved..any ideas guys?

I want make the following,
(I have already a database with three tables (Countries, Timeline and Category)).

1: list of countries (drop down menu 1), Timeline of the countries history (drop down 2) and Category (drop down 3).
2: The selected values of the drop down menus must show take the information from the database.

Can any one help me with the coding?