PHP - What Day Is It? Buried Dropdown List Option Problem

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'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 />";

Hopefully someone can help, firstly i am a newbie at php coding but keen to learn more.   Here is my problem    The database is built correctly with all the information i need, the first part is the dropdown menu which you select a car, next you choose a month and mileage - from there it shall show you the correct price for each one. There is columns for each price, mileage and months i just need to figure out how best to start this thing.   I first started by this   $query = "SELECT DISTINCT Full_Description FROM import"; 

Hi,

I am doing an EDIT user page and would like to check records with a dropdown and then set as selected, please help!


<select name="BrokerID" class="small-input">

<option value="Please select an option">Please select a Broker</option> 

<?php 

while($row2 = mysql_fetch_array($broker))

{

echo '<option name="BrokerID" value="'.$row2['BrokerID'].'">'.$row2['BrokerName'].'</option>';

}

?>

</select>

Hey guys, i have a small problemo. As you can see i have made an option list from 0 to 3.

How can I put this optionlist in a for loop so I can save some place? I have found an example but I dont know how to integrate it in my php
Example
Code: [Select]
for( $i = 0; $i < 4; $i++ ) {
$optionlist .= "<option value=\"$i\">$i</option>\n";
}
$optionlist .= "</select>\n";

Code: [Select]
        <?php
        $dranken = array("cola", "fanta", "bier", "koffie", "thee");
        $prijzen = array("2", "2", "1.80", "2.20", "2.20");


        $i = 0;

        echo "<table>";

        while ($dranken[$i]) {
            $listnaam = $dranken[$i] . "_aantal";
            $optionlist = "<select name= '$listnaam'><option>0</option><option>1</option><option>2</option><option>3</option></select>";
            
            echo "<tr><td >" . $dranken[$i] . "</td>";
            echo "<td>" . $prijzen[$i] . "</td>";
echo "<td>" . $optionlist . "</td></tr>";

            $i++;
        }

        echo "</table>";
        ?>


thanks

I am passing an array to an option list but if a value has two words, the second word doesnt get sent via POST. So if the value should be THE ONE, the word ONE doesnt get sent via POST. Kinda wierd, wondered if there is an easy explanation for this?
Code: [Select]
<?php echo '<SELECT name=carrier>';

foreach ($allcar as $key => $value) {
    echo '<OPTION value=' . $value . '> ' . $value . '';
}

echo '</select>'; ?>

Quote

I have this code here. i wanted to know how i can be able to make multiple selections from the returned data from the database and how to save them

Quote

 

 <select name="troom"  multiple class="form-control" required>
                                    <option  selected="true" disabled="disabled">--Select a room--</option>
                                    


                                        
                                        $records =mysqli_query($con, "select * from room where TRoom not in (select TRoom from roombook where cin <= '$checkout' and cout >= '$checkin');");
                                        
                                        while ($data = mysqli_fetch_array($records)) {
                                            echo "<option value='" . $data['TRoom'] . "'>" . $data['TRoom'] . "</option>"; //displaying data in option menu
                                        }
                                    }

                                    ?>

                                </select>

 

 

Hello.

I am working on something where I don't want to do this....


if ($pages <= 1){$P=1;}
elseif ($pages > 1 && $pages <= 2){$P=2;}
elseif ($pages > 2 && $pages <= 3){$P=3;}
elseif ($pages > 3 && $pages <= 4){$P=4;}
elseif ($pages > 4 && $pages <= 5){$P=5;}
elseif ($pages > 5 && $pages <= 6){$P=6;}
elseif ($pages > 6 && $pages <= 7){$P=7;}
elseif ($pages > 7 && $pages <= 8){$P=8;}
elseif ($pages > 8 && $pages <= 9){$P=9;}
elseif ($pages > 9 && $pages <= 10){$P=10;}


This could go on and on and I would rather use the for $ i++ for this so it will wright out the coding for as little or as much as it needs rather then I.

However I am not sure how I would do this. I also have


if ($PN == 1){$L = "0,20";}
elseif ($PN == 2){$L = "20,20";}
elseif ($PN == 3){$L = "40,20";}
elseif ($PN == 4){$L = "60,20";}
elseif ($PN == 5){$L = "80,20";}
elseif ($PN == 6){$L = "100,20";}

 were I will need to be able to add 20 to the number.

Is this easily done? I'm a bit loss tried a few things and its not working properly.

I have a form that contains 3 text fields and 7 populated lists (that are dependent on the choice of the previous lists).  When I post the information to MySQL and to my processing page, it posts the table "ids" instead of the selected option. 

Here's the php code for the form:

<form action="gccsuccess_form.php" method="post" enctype="multipart/form-data" name="gcc" id="gcc">
  <table width="700" border="0" align="center" cellpadding="3" cellspacing="3">
    <tr>
      <td><label for="date">Today's Date:</label>
 <input type="text" name="date" id="date"></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>Week Number:
       <select name="week" size="1" id="week">
         <option value="0" selected>Week 0 - 3/26 - 4/1</option>
         <option value="1">Week 1 - 4/2 - 4/8</option>
         <option value="2">Week 2 - 4/9 - 4/15</option>
         <option value="3">Week 3 - 4/16 - 4/22</option>
         <option value="4">Week 4 - 4/23 - 4/29</option>
         <option value="5">Week 5 - 4/30 - 5/6</option>
         <option value="6">Week 6 - 5/7 - 5/13</option>
      </select></td>
      <td><label for="location"></label>
      </td>
    </tr>
    <tr>
      <td>Location:
        <select id='locations' name='location'>
      </select></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><label for="label8">Team Name</label>
<select id='team_names' name='team_name'>
</select></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><em>*Please enter each team member's first and last name:</em></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td><label for="mem_1"> Team <strong>Captain:</strong></label>
        <select id='team_members 1' name='capt'>
        </select></td>
      <td><label for="label4"><strong>Steps:</strong></label>
        <input type="text" name="steps_1" id="steps_1"></td>
    </tr>
    <tr>
      <td><label for="mem_2">Team Member #2 <strong>Name: 
        <select id='team_members 2' name='mem_2'>
        </select>
      </strong></label></td>
      <td><label for="label5"><strong>Steps:</strong></label>
        <input type="text" name="steps_2" id="steps_2"></td>
    </tr>
    <tr>
      <td><label for="mem_3">Team Member #3 <strong>Name:
            <select id='team_members 3' name='mem_3'>
        </select>
      </strong></label></td>
      <td><label for="label6"><strong>Steps:</strong></label>
        <input type="text" name="steps_3" id="steps_3"></td>
    </tr>
    <tr>
      <td><label for="mem_4">Team Member #4<strong> Name</strong>:
        <select id='team_members 4' name='mem_4'>
        </select>
      </label></td>
      <td><label for="label7"><strong>Steps:</strong></label>
        <input type="text" name="steps_4" id="steps_4"></td>
    </tr>
    <tr>
      <td><label for="label">Team Member #5<strong> Name</strong>:
        <select id='team_members 5' name='mem_5'>
        </select>
      </label></td>
      <td><label for="label7"><strong>Steps:</strong></label>
          <input type="text" name="steps_5" id="steps_5"></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><em>* Maximum steps for each team member per week is <strong>105,000. </strong></em></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input type="submit" name="Submit Form" id="Submit Form" value="Submit"></td>
    </tr>
  </table>
  <label></label>
  <div align="center"><br>
    If you have questions about the competition or reporting please contact KC   WELLNESS, INC&nbsp;toll free at <SPAN id="lw_1237248942_0">877-634-1412.</SPAN><br>
    <br>
  </div>
</form>


And here's the code for the page it is posted in:

<?php
      
      $date = $_POST['date'];
      $week = $_POST['week'];
      $location = $_POST['location'];
      $team_name = $_POST['team_name'];
      $capt = $_POST['capt'];
      $mem_2 = $_POST['mem_2'];
      $mem_3 = $_POST['mem_3'];
      $mem_4 = $_POST['mem_4'];
      $mem_5 = $_POST['mem_5'];
      $steps_1= $_POST['steps_1'];
      $steps_2= $_POST['steps_2'];
      $steps_3= $_POST['steps_3'];
      $steps_4 = $_POST['steps_4'];
      $steps_5 = $_POST['steps_5'];
      
      mysql_connect("mysql1.myregisteredsite.com", "49200_kandace", "Leonardo56")
      or die(mysql_error());
      mysql_select_db("49200_GCC") or die(mysql_error());
      mysql_query("INSERT INTO `walkathon` VALUES ('$date', '$week', '$location', '$team_name', '$capt','$mem_2','$mem_3',  '$mem_4', '$mem_5', '$steps_1','$steps_2', '$steps_3','$steps_4', '$steps_5' )"); 

      Print "Thank you for your entry. <br>
      Report summary: <br/><br/>";    
      
         echo "<strong> Date: </strong>   {$date} 
         <br/> <br/><strong> Week: </strong>   {$week}
         <br/> <br/><strong> Location: </strong>  {$location}
         <br/> <br/><strong> Team Name: </strong>   {$team_name}
         <br/> <br/><strong> Team Captain: </strong>  {$capt} / <strong> Steps: </strong> {$steps_1} 
         <br /> <br/><strong> Team Member 2 Name: </strong>  {$mem_2} / <strong> Steps: </strong> {$steps_2} 
         <br /> <br/><strong> Team Member 3 Name: </strong>  {$mem_3} / <strong> Steps: </strong> {$steps_3}
         <br /> <br/><strong> Team Member 4 Name: </strong>  {$mem_4} / <strong> Steps: </strong> {$steps_4}
         <br /> <br/><strong> Team Member 5 Name: </strong>  {$mem_5} / <strong> Steps: </strong> {$steps_5}"
         
               ?>

How do I get the processing page to echo the selected option instead of the id?

Hi I have a list of states using the array method in a form. The drop down menu works fine.  I want to save the user choice,if the form is re-displayed due to a blank field or pattern mismatch.  I know I can use the selected=selected, but don't know wher to put the statement:
My array is:
state_province = array ("list of states", "provinces")
Var in my labels array is "state"=>"state"
Here is my code for the select/option statement:

{
 if($field == "state")
   {
      echo "<div class='province_state'><label for='state' size='10'>* Province/State</label><select>";
            
      foreach($state_province as $state)
         {
         echo "\n<option value='$state_province' /> ";   
          echo $state ;
          echo "</option>";
         }
      echo "</select></div>\n";   

   }
?Is this the correct code to add and where would I add  it?
          if(@$_POST['state'] == $value)
     {
         echo "selected='selected'  ";
     }          

I have a search function in php where the text characters are matched to characters in a tables field--- works perfectly....
I need to make the input box have a droplist of words from database, this is also easy for me to do. the problem here is there is no definitive value! the options list always outputs a blank in the url---

its supposed to search a matching value and then output the matching value to url...

Here is the droplist code:


            $output['RATESTITLE']='<input class="inputbox" type="text" size="24px" name="ratestitle" value="'.$sch->filter['ratestitle'].'"  onfocus="if (this.value ==\''.$output['LANGUAGE_SEARCH_RATESTITLE'].'\') {this.value = \'\'}" />';

this outputs a input text box--- i want to have a droplist of options to populate this text box...
If you must know this is the third day im at it...

Hi,

I am trying to call the data from Mysql but I am getting an empty drop down list, this is the code:


mysql:

Code: [Select]
create table years
(  yearID integer auto_increment,
   year varchar(30),
   primary key (yearID)
);

insert into years (yearID, year) values ('1', '2007-2008');
insert into years (yearID, year) values ('2', '2008-2009');
insert into years (yearID, year) values ('3', '2009-2010');
insert into years (yearID, year) values ('4', '2010-2011');
insert into years (yearID, year) values ('5', '2011-2012');
insert into years (yearID, year) values ('6', '2012-2013');

PHP:

Code: [Select]
<?php require_once('../Connections/connection.php'); ?>
<?php
 
$result = @mysql_query( "select yearID, year, from sss.years");

print "<p>Select a year:\n";
print "<select name=\"yearID\">\n";
while ($row = mysql_fetch_assoc($result)){
$yearID = $row[ 'yearID' ];
$year = $row[ 'year' ];
print "<option value=$yearID>$year\n";
}
print "</select>\n";
print "</p>\n";
?>

Thank you!

Hey,

I have the following coding:
Quote

<?
$dbuser="*******";
$dbpass="*******";
$dbname="virtuda_db";  //the name of the database
$chandle = mysql_connect("localhost", $dbuser, $dbpass)
    or die("Connection Failure to Database");
mysql_select_db($dbname, $chandle) or die ($dbname . " Database not found. " . $dbuser);

$mainsection="license";

$query1="select name from license";
$result = mysql_db_query($dbname, $query1) or die("Failed Query of " . $query1);  //do the query
while($thisrow=mysql_fetch_row($result))
{
  $i=0;
  while ($i < mysql_num_fields($result))
  {
    $field_name=mysql_fetch_field($result, $i);
    echo $thisrow[$i] . " ";  //Display all the fields on one line
    $i++;
  }
echo "<br>";  //put a break after each database entry
}
?>



How would I set up this so that instead of just "listing" them out on new lines, it would list the results into a drop down list? Thanks!

Hi i'm new to php.

I want to get all the values of dropdown list on another page wether selected or not.

Hi.

I am using this script to populate a dropdown list box from sql, it works but does anyone know how to sort the list in alphabetical order?


$sql="SELECT * FROM Fish WHERE ***** = '".$_GET['stocktype']."'"; 
$result=mysql_query($sql); 

$options=""; 

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

    $ID=$row["ID"]; 
    $Stock=$row["Commonn"]; 
    $Options.="<OPTION VALUE=\"$ID\">".$Stock; 
} 


<SELECT NAME='stock1'> 
<OPTION VALUE='$Options'>$Options</option>

</SELECT>