Learn VBA & Macros in 1 Week!

PHP - Submit Dropdown

Full Excel VBA Course - Beginner to Expert

Submit Dropdown	View Content

so I need to know how to make this drop down include hidden fields in it:
Code: [Select]
<form id="myform1" method="POST">
<select onchange="document.getElementById('myform1').submit()">

<?php //start the table, and the row.
// Query member data from the database and ready it for display
$sql = mysql_query("SELECT * FROM products");
while($row = mysql_fetch_array($sql)){
$product = $row["product"];
$id =$row["id"];
$price =$row["price"];
?>

<option><input type="text" name="hiddenField2" class="hiddenField2" value="<?php echo $id; ?>" />
<input type="text" name="hiddenField1" class="hiddenField1" value="<?php echo $price; ?>" /><?php echo $product; ?> </option>

<?php
// start a column
} ?>
</select>
<noscript>
<input type="submit" value="Go" id="Submit1" />
</noscript>

</form>
Kind of like is shown.......so that each option has an id. then I need it to submit to this code:
Code: [Select]
<script type="text/javascript">
$(document).ready(function(){
$(".myform1").validate({
debug: false,

submitHandler: function(form) {
// do other stuff for a valid form
$.post('process.php', $(".myform1").serialize(), function(data) {
$("#price").load("index.php #price");$("#total").load("index.php #total");
});
}
});
});
</script> .

Can anyone help? I hope this makes sense????

Full Excel VBA Course - Beginner to Expert

Similar Tutorials

Dynamic Dropdown Question, Submit 2 Values From Dropdown To A Form??

Dropdown - Remember Value On Submit

Storing Option Value As Variable From Dropdown Without Submit

Moved: How To Submit Triple Dropdown Result On Same Page

Showing A Picture Based On Dropdown Form After Submit

Populate Dropdown On The Basis Of Another Dropdown Value In Php Using Jquery Ajax

Is There A Way To Submit Same Entry Multiple Times On A Single Form Submit?

Fetching Selected Value From One Dropdown To Populate Another Dropdown

If [form Validated] Submit Form1 Else Submit Form2?

Dropdown Populating From Another Dropdown

Auto Submit Button, I Am So Tired Of Reading That An Auto Submit Button Is Lame

Dropdown With Php Help

Dropdown Box Help

Dropdown Box To Php

Getting Value & Text From A Dropdown

Populating The Dropdown From Db

Need Help With Dynamic Dropdown

Dropdown Concatenation?

Learn VBA & Macros for Excel in 1 Week!

Dynamic Dropdown Question, Submit 2 Values From Dropdown To A Form??

Similar Tutorials

Dropdown - Remember Value On Submit

Similar Tutorials

So I have a registration form setup. When the user submits the form it sets session variables for each of the form fields and then checks the database to see if the username is taken. If the username is taken I have the form fields values to display the value of what the user just submitted. My problem is I have 2 drop down fields: States and Countries I am using the the following for my countries dropdown box and it works to remember the selection the user made, BUT how can I have it remember the option name as well as the option value? IE if the user chooses United States of America and submits the form I want the drop down to display United States of America not US here is the code:

<select id="country" name="country" tabindex = "511">
<option value="<?php if(isset($_SESSION['country'])) echo $_SESSION['country']; ?>" selected="<?php if(isset($_SESSION['country'])) echo $_SESSION['country']; ?>"><?php if(isset($_SESSION['country'])) echo $_SESSION['country']; ?></option>
    <option value="">(please select a country)</option>
    <option value="AF">Afghanistan</option>
    <option value="AL">Albania</option>
    <option value="DZ">Algeria</option>
    <option value="AS">American Samoa</option>
    <option value="AD">Andorra</option>
    <option value="AO">Angola</option>
    <option value="AI">Anguilla</option>
    <option value="AQ">Antarctica</option>
    <option value="AG">Antigua and Barbuda</option>
    <option value="AR">Argentina</option>
    <option value="AM">Armenia</option>
    <option value="AW">Aruba</option>
    <option value="AU">Australia</option>
    <option value="AT">Austria</option>
    <option value="AZ">Azerbaijan</option>
    <option value="BS">Bahamas</option>
    <option value="BH">Bahrain</option>
    <option value="BD">Bangladesh</option>
    <option value="BB">Barbados</option>
    <option value="BY">Belarus</option>
    <option value="BE">Belgium</option>
    <option value="BZ">Belize</option>
    <option value="BJ">Benin</option>
    <option value="BM">Bermuda</option>
    <option value="BT">Bhutan</option>
    <option value="BO">Bolivia</option>
    <option value="BA">Bosnia and Herzegowina</option>
    <option value="BW">Botswana</option>
    <option value="BV">Bouvet Island</option>
    <option value="BR">Brazil</option>
    <option value="IO">British Indian Ocean Territory</option>
    <option value="BN">Brunei Darussalam</option>
    <option value="BG">Bulgaria</option>
    <option value="BF">Burkina Faso</option>
    <option value="BI">Burundi</option>
    <option value="KH">Cambodia</option>
    <option value="CM">Cameroon</option>
    <option value="CA">Canada</option>
    <option value="CV">Cape Verde</option>
    <option value="KY">Cayman Islands</option>
    <option value="CF">Central African Republic</option>
    <option value="TD">Chad</option>
    <option value="CL">Chile</option>
    <option value="CN">China</option>
    <option value="CX">Christmas Island</option>
    <option value="CC">Cocos (Keeling) Islands</option>
    <option value="CO">Colombia</option>
    <option value="KM">Comoros</option>
    <option value="CG">Congo</option>
    <option value="CD">Congo, the Democratic Republic of the</option>
    <option value="CK">Cook Islands</option>
    <option value="CR">Costa Rica</option>
    <option value="CI">Cote d'Ivoire</option>
    <option value="HR">Croatia (Hrvatska)</option>
    <option value="CU">Cuba</option>
    <option value="CY">Cyprus</option>
    <option value="CZ">Czech Republic</option>
    <option value="DK">Denmark</option>
    <option value="DJ">Djibouti</option>
    <option value="DM">Dominica</option>
    <option value="DO">Dominican Republic</option>
    <option value="TP">East Timor</option>
    <option value="EC">Ecuador</option>
    <option value="EG">Egypt</option>
    <option value="SV">El Salvador</option>
    <option value="GQ">Equatorial Guinea</option>
    <option value="ER">Eritrea</option>
    <option value="EE">Estonia</option>
    <option value="ET">Ethiopia</option>
    <option value="FK">Falkland Islands (Malvinas)</option>
    <option value="FO">Faroe Islands</option>
    <option value="FJ">Fiji</option>
    <option value="FI">Finland</option>
    <option value="FR">France</option>
    <option value="FX">France, Metropolitan</option>
    <option value="GF">French Guiana</option>
    <option value="PF">French Polynesia</option>
    <option value="TF">French Southern Territories</option>
    <option value="GA">Gabon</option>
    <option value="GM">Gambia</option>
    <option value="GE">Georgia</option>
    <option value="DE">Germany</option>
    <option value="GH">Ghana</option>
    <option value="GI">Gibraltar</option>
    <option value="GR">Greece</option>
    <option value="GL">Greenland</option>
    <option value="GD">Grenada</option>
    <option value="GP">Guadeloupe</option>
    <option value="GU">Guam</option>
    <option value="GT">Guatemala</option>
    <option value="GN">Guinea</option>
    <option value="GW">Guinea-Bissau</option>
    <option value="GY">Guyana</option>
    <option value="HT">Haiti</option>
    <option value="HM">Heard and Mc Donald Islands</option>
    <option value="VA">Holy See (Vatican City State)</option>
    <option value="HN">Honduras</option>
    <option value="HK">Hong Kong</option>
    <option value="HU">Hungary</option>
    <option value="IS">Iceland</option>
    <option value="IN">India</option>
    <option value="ID">Indonesia</option>
    <option value="IR">Iran (Islamic Republic of)</option>
    <option value="IQ">Iraq</option>
    <option value="IE">Ireland</option>
    <option value="IL">Israel</option>
    <option value="IT">Italy</option>
    <option value="JM">Jamaica</option>
    <option value="JP">Japan</option>
    <option value="JO">Jordan</option>
    <option value="KZ">Kazakhstan</option>
    <option value="KE">Kenya</option>
    <option value="KI">Kiribati</option>
    <option value="KP">Korea, Democratic People's Republic of</option>
    <option value="KR">Korea, Republic of</option>
    <option value="KW">Kuwait</option>
    <option value="KG">Kyrgyzstan</option>
    <option value="LA">Lao People's Democratic Republic</option>
    <option value="LV">Latvia</option>
    <option value="LB">Lebanon</option>
    <option value="LS">Lesotho</option>
    <option value="LR">Liberia</option>
    <option value="LY">Libyan Arab Jamahiriya</option>
    <option value="LI">Liechtenstein</option>
    <option value="LT">Lithuania</option>
    <option value="LU">Luxembourg</option>
    <option value="MO">Macau</option>
    <option value="MK">Macedonia, The Former Yugoslav Republic of</option>
    <option value="MG">Madagascar</option>
    <option value="MW">Malawi</option>
    <option value="MY">Malaysia</option>
    <option value="MV">Maldives</option>
    <option value="ML">Mali</option>
    <option value="MT">Malta</option>
    <option value="MH">Marshall Islands</option>
    <option value="MQ">Martinique</option>
    <option value="MR">Mauritania</option>
    <option value="MU">Mauritius</option>
    <option value="YT">Mayotte</option>
    <option value="MX">Mexico</option>
    <option value="FM">Micronesia, Federated States of</option>
    <option value="MD">Moldova, Republic of</option>
    <option value="MC">Monaco</option>
    <option value="MN">Mongolia</option>
    <option value="MS">Montserrat</option>
    <option value="MA">Morocco</option>
    <option value="MZ">Mozambique</option>
    <option value="MM">Myanmar</option>
    <option value="NA">Namibia</option>
    <option value="NR">Nauru</option>
    <option value="NP">Nepal</option>
    <option value="NL">Netherlands</option>
    <option value="AN">Netherlands Antilles</option>
    <option value="NC">New Caledonia</option>
    <option value="NZ">New Zealand</option>
    <option value="NI">Nicaragua</option>
    <option value="NE">Niger</option>
    <option value="NG">Nigeria</option>
    <option value="NU">Niue</option>
    <option value="NF">Norfolk Island</option>
    <option value="MP">Northern Mariana Islands</option>
    <option value="NO">Norway</option>
    <option value="OM">Oman</option>
    <option value="PK">Pakistan</option>
    <option value="PW">Palau</option>
    <option value="PA">Panama</option>
    <option value="PG">Papua New Guinea</option>
    <option value="PY">Paraguay</option>
    <option value="PE">Peru</option>
    <option value="PH">Philippines</option>
    <option value="PN">Pitcairn</option>
    <option value="PL">Poland</option>
    <option value="PT">Portugal</option>
    <option value="PR">Puerto Rico</option>
    <option value="QA">Qatar</option>
    <option value="RE">Reunion</option>
    <option value="RO">Romania</option>
    <option value="RU">Russian Federation</option>
    <option value="RW">Rwanda</option>
    <option value="KN">Saint Kitts and Nevis</option>
    <option value="LC">Saint LUCIA</option>
    <option value="VC">Saint Vincent and the Grenadines</option>
    <option value="WS">Samoa</option>
    <option value="SM">San Marino</option>
    <option value="ST">Sao Tome and Principe</option>
    <option value="SA">Saudi Arabia</option>
    <option value="SN">Senegal</option>
    <option value="SC">Seychelles</option>
    <option value="SL">Sierra Leone</option>
    <option value="SG">Singapore</option>
    <option value="SK">Slovakia (Slovak Republic)</option>
    <option value="SI">Slovenia</option>
    <option value="SB">Solomon Islands</option>
    <option value="SO">Somalia</option>
    <option value="ZA">South Africa</option>
    <option value="GS">South Georgia and the South Sandwich Islands</option>
    <option value="ES">Spain</option>
    <option value="LK">Sri Lanka</option>
    <option value="SH">St. Helena</option>
    <option value="PM">St. Pierre and Miquelon</option>
    <option value="SD">Sudan</option>
    <option value="SR">Suriname</option>
    <option value="SJ">Svalbard and Jan Mayen Islands</option>
    <option value="SZ">Swaziland</option>
    <option value="SE">Sweden</option>
    <option value="CH">Switzerland</option>
    <option value="SY">Syrian Arab Republic</option>
    <option value="TW">Taiwan, Province of China</option>
    <option value="TJ">Tajikistan</option>
    <option value="TZ">Tanzania, United Republic of</option>
    <option value="TH">Thailand</option>
    <option value="TG">Togo</option>
    <option value="TK">Tokelau</option>
    <option value="TO">Tonga</option>
    <option value="TT">Trinidad and Tobago</option>
    <option value="TN">Tunisia</option>
    <option value="TR">Turkey</option>
    <option value="TM">Turkmenistan</option>
    <option value="TC">Turks and Caicos Islands</option>
    <option value="TV">Tuvalu</option>
    <option value="UG">Uganda</option>
    <option value="UA">Ukraine</option>
    <option value="AE">United Arab Emirates</option>
    <option value="GB">United Kingdom</option>
    <option value="US">United States</option>
    <option value="UM">United States Minor Outlying Islands</option>
    <option value="UY">Uruguay</option>
    <option value="UZ">Uzbekistan</option>
    <option value="VU">Vanuatu</option>
    <option value="VE">Venezuela</option>
    <option value="VN">Viet Nam</option>
    <option value="VG">Virgin Islands (British)</option>
    <option value="VI">Virgin Islands (U.S.)</option>
    <option value="WF">Wallis and Futuna Islands</option>
    <option value="EH">Western Sahara</option>
    <option value="YE">Yemen</option>
    <option value="YU">Yugoslavia</option>
    <option value="ZM">Zambia</option>
    <option value="ZW">Zimbabwe</option>
</select>

Storing Option Value As Variable From Dropdown Without Submit

Similar Tutorials

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

Moved: How To Submit Triple Dropdown Result On Same Page

Similar Tutorials

This topic has been moved to Ajax Help.

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

Showing A Picture Based On Dropdown Form After Submit

Similar Tutorials

Hello there,

I'm trying to show a picture based on the value that was chosen in the dropdown menu of the page before the submit.

Let's say i'm having a drop down form with 3 values: Porsche, BMW, Audi, the form also consists of a button to submit form and some other text fields but these aren't really relevant.

So what i want is, you choose whatever car, let's say BMW, fill in all the other data of the form, hit submit, and on the next page it should show a Picture which i define for each car.

I hope i explained that somehow understandable.

Thanks in advance,

Sabine

Populate Dropdown On The Basis Of Another Dropdown Value In Php Using Jquery Ajax

Similar Tutorials

I have a form with dropdown list that is populated with values from Sql Server table. Now i would like to use this selected item in SQL query. The results of this query should be shown in label or text field. So when a user selects item from dropdown menu, results from SQL query are shown at the same time.

I have two dropdown list at the moment in my form. First one gets all values from a column in table in SQL Server. And the second one should get a value from the same table based on a selection in first dropdown list.

When i load ajax.php i get 2 error mesages:
Notice: Undefined index: machinery in C:\wamp64\www\gecko\ajaxfile.php on line *8*
Warning: sqlsrv_fetch_array() expects parameter 1 to be resource, boolean given in C:\wamp64\www\site\ajaxfile.php on line *16*

This is my code so far. I have tried to do it with this Ajax script. But i can only get first dropdown to work. The second dropdown(sub_machinery) does not show values, when first dropdown item is selected. The second dropdown should show values from databse table with this query( *$machineryID* is first dropdown selected item): SELECT MachineID FROM T013 WHERE Machinery=".$machineryID.

Index.php

    <!doctype html>
      <?PHP
    $server = "server";
    $options = array(  "UID" => "user",  "PWD" => "pass",  "Database" => 
    "database");
    $conn2 = sqlsrv_connect($server, $options);
    if ($conn2 === false) die("<pre>".print_r(sqlsrv_errors(), true));
    echo " ";
    ?>
    <html>
    <head>
    <meta charset="utf-8">
    <title>Untitled Document</title>
    </head>
    
    <body>
                <section id="formaT2" class="formaT2 formContent">
                <div class="row">
                    <div class="col-md-2 col-3 row-color remove-mob"></div>
                    <div class="col-md-5 col-9 bg-img" style="padding-left: 0; 
    padding-right: 0;">
                        <h1>Form</h1>
                        <div class="rest-text">
                           <div class="contactFrm">
                              <p class="statusMsg <?php echo 
    !empty($msgClass)?$msgClass:''; ?>"><?php echo $statusMsg; ?></p>
                               
                                <form action="connection.php" method="post">
                                    <div>machinery</div>     
    <select id="machinery">
       <option value="0">--Please Select Machinery--</option>
       <?php 
       // Fetch Department
       $sql = "SELECT Machinery FROM T013";
       $machanery_data = sqlsrv_query($conn2,$sql);
       while($row = sqlsrv_fetch_array($machanery_data) ){
          $id = $row['Id'];
          $machinery = $row['Machinery'];
          
          // Option
          echo "<option value='".$id."' >".$machinery."</option>";
       }
       ?>
    </select>
    <div class="clear"></div>
                                    <div>Sub Machinery</div>
    <select id="sub_machinery">
       <option value="0">- Select -</option>
    </select>
                                    
                                    <input type="submit" name="submit" 
    id="submit" class="strelka-send" value="Insert">
                                    <div class="clear"> </div>
                                </form>
                             </div> 
                         </div>
                    </div>
                </div> 
            </section>
             </script>
          <script type="text/javascript">
          $(document).ready(function(){

        $("#machinery").change(function(){
            var machinery_id = $(this).val();
    
            $.ajax({
                url:'ajaxfile.php',
                type: 'post',
                data: {machinery:machinery_id},
                dataType: 'json',
                success:function(response){
    
                    var len = response.length;
     
                    $("#sub_machinery").empty();
                    for( var i = 0; i<len; i++){
                        var machinery_id = response[i]['machinery_id'];
                        var machinery = response[i]['machinery'];
                        
                        $("#sub_machinery").append("<option 
    value='"+machinery_id+"'>"+machinery+"</option>");
    
                    }
                }
            });
        });
    
    });
          </script>
    </body>
    </html>

Ajaxfile.php

<?php
    $server = "server";
    $options = array(  "UID" => "user",  "PWD" => "pass",  
    "Database" => "database");
    $conn2 = sqlsrv_connect($server, $options);
    if ($conn2 === false) die("<pre>".print_r(sqlsrv_errors(), true));
    echo " ";

    $machineryID = $_POST['machinery'];   // department id

    $sql = "SELECT MachineID FROM T013 WHERE Machinery=".$machineryID;
    
    $result = sqlsrv_query($conn2,$sql);
    
    $machinery_arr = array();
    
    while( $row = sqlsrv_fetch_array($result) ){
        $machinery_id = $row['ID'];
        $machinery = $row['MachineID'];
    
        $machinery_arr[] = array("ID" => $machinery_id, "MachineID" => 
    $machinery);
    }
    
    // encoding array to json format
    echo json_encode($machinery_arr);
    ?>

Edited May 6, 2019 by davidd

Is There A Way To Submit Same Entry Multiple Times On A Single Form Submit?

Similar Tutorials

Say I have an "Entries" table. I want to submit same multiple entries using a form submission. And If I have other queries submitted in the same form, I want those quarries to be submitted only once. Is that possible to do?

Here's my code.

if(isset($_POST['submit'])) {

  $entries = 10;

  $id   = 55;
  $name = 'Smith';

  $insert = $db->prepare("INSERT INTO entries(id, name) VALUES(:id, :name)");
  $insert->bindParam(':id', $id);
  $insert->bindParam(':name', $name);
  $result_insert = $insert->execute();
  if($result_insert == false) {
    echo 'Fail';
  } else {
    echo 'Success';
  }

}
?>
<form action="" method="post">
  <input type="submit" name="submit" value="SUBMIT" />
</form>

Edited January 13, 2019 by imgrooot

Fetching Selected Value From One Dropdown To Populate Another Dropdown

Similar Tutorials

Hi freaks,

I'm new to php first of all. I'm dynamically binding a dropdownlist with mysql database . After the user selects an item from it , I want to match that item with another table so as to populate another database.

The code I'm using to populate dropdown:
Code: [Select]
<?php
$con = mysql_connect("localhost","root","");
if(!$con)
{
  die ('Can not connect to : '.mysql_error());
}
mysql_select_db("ims",$con);
$result=mysql_query("select cat_id,cat_name from category");
echo "<select name=cat>";
while($nt=mysql_fetch_array($result))
{
echo "<option value=$nt[cat_id]> $nt[cat_name] </option>";
}
echo "</select>";
        mysql_close($con);
  ?>

Now after the user selects any one of the item , I want to bind another dropdown on the same page using such query like
   $result=mysql_query("select subcategory.sc_id,subactegory.sc_name from subcategory,category where subcategory.sc_id=$nt[cat_id]");

Please anyone tell me the logic and code to do it. Also tell me do I need an intermediate page to post the 1st dropdown value and then continue with 2nd dropdown. I couldn't figure out the concept anyhow.
Help on this will be highly appreiable .
(Tell me if I'm not clear with my question)

If [form Validated] Submit Form1 Else Submit Form2?

Similar Tutorials

Hi. Pretty straight forward I guess but as the name suggests am a newbie. I have a form that requires the user to enter certain parameters. If the values are blank it submits to itself and loads the error messages. What I want to do is create PHP code that submits the form to a different url. What I thought was create two forms (the second with hidden fields replicating the first form), each form having a different url in the action"" code. What I cant work out is the PHP IF ELSE code to submit form 2 if Form1 is is validated correctly. This is the PHP code relevant to the form validation. Help?

<?php
      //If form was submitted
      if ($_POST['submitted']==1) {
        $errormsg = ""; //Initialize errors
        if ($_POST[width]){
           $title = $_POST[width]; //If title was entered
        }
        else{
           $errormsg = "Please enter width";
        }
        if ($_POST[drop]){
           $textentry = $_POST[drop]; //If comment was entered
        }
        else{
           if ($errormsg){ //If there is already an error, add next error
              $errormsg = $errormsg . " & content";
           }else{
              $errormsg = "Please enter drop";
           }
        }
      }

      if ($errormsg){ //If any errors display them
      echo "<div class=\"box red\">$errormsg</div>";
      }

      //If all fields present
      if ($title && $textentry){
       //Do something

echo 'THIS IS WHERE I WANT THE CODE TO SUBMIT FORM 2 or SUBMIT FORM 1 TO A DIFFERENT URL';
      }
      ?>

Dropdown Populating From Another Dropdown

Similar Tutorials

I am not a developer but I can modify code to work for me. The following code works on my test machine (Windows 10, IIS, PHP 7.4) but doesn't work on my website (cPanel, Some version of Linux, PHP 7.4). The two dropdowns are for State and City. You are supposed to be able to select the state and then select a city from that state then bring up a report for craft breweries in the city. When selecting State from the first dropdown, the page refreshes, the URL is correct with the reports.php?cat=<STATE> so $cat is being set, but the first dropdown no longer has the state selected and the second dropdown is populated with All cities and not just one ones from the selected state. Any ides why this is working fine on one machine and not the other?

Selected code from reports.php

<?php
$cat=$_REQUEST['cat'];

?>
<SCRIPT language=JavaScript>
   <!--
   function reload(form)
   {
       var val=form.cat.options[form.cat.options.selectedIndex].value;
       self.location='reports.php?cat=' + val ;
   }

</script>

<?Php
   ///////// Getting the State from Mysql table for first list box//////////
   $Cyquer2="SELECT DISTINCT breweries.State, states.state FROM breweries INNER JOIN states ON breweries.State=states.abbr ORDER BY states.state";
   $Cyresult2 = mysqli_query($con, $Cyquer2);

   /////// for second drop down list we will check if State is selected else we will display all the cities/////
   if(isset($cat) and strlen($cat) > 0)
   {
       $Cyquer="SELECT DISTINCT City FROM breweries where State='" . $cat . "' order by City";
   }
   else
   {
       $Cyquer="SELECT DISTINCT City FROM breweries order by City";
   }

   $Cyresult1 = $con->query($Cyquer);

   echo "<form method=post action='brewerylistbycity.php'>";
       ////////// Starting of first drop downlist ///////// -->
       echo "<select name='cat' onchange=\"reload(this.form)\"><option value=''>Select State</option>";
           while($Cynoticia2 = mysqli_fetch_array($Cyresult2))
           {
               if($Cynoticia2['State']==@$cat)
               {
                   echo "<option selected value='$Cynoticia2[State]'>$Cynoticia2[state]</option>"."<BR>";

               }
               else
               {
                   echo "<option value='$Cynoticia2[State]'>$Cynoticia2[state]</option>";

               }
           }
       echo "</select>";
       echo "</br>";

       ////////// Starting of second drop downlist /////////
       echo "</br>";
       echo "<select name='subcat' selected=''><option value=''>Select City</option>";
           while($Cynoticia = $Cyresult1->fetch_assoc())
           {
               echo "<option value='$Cynoticia[City]'>$Cynoticia[City]</option>";
           }
       echo "</select></br>";

       //// End Form /////
       echo "<input type=submit value=Submit>";
   echo "</form>";
?>

Auto Submit Button, I Am So Tired Of Reading That An Auto Submit Button Is Lame

Similar Tutorials

the info posts beautifully i just canst seem to get the button to auto click or submit, tried numerous ways! help

Code: [Select]
<?php

require_once "../store/paypal/utility.php";
require_once "../store/paypal/constants.php";

$url = "https://www.".DEFAULT_ENV.".paypal.com/cgi-bin/webscr";
$postFields =   "cmd=".urlencode("_notify-synch").
            "&tx=".urlencode(htmlspecialchars($_GET["tx"])).
            "&at=".urlencode(DEFAULT_IDENTITY_TOKEN);
$ppResponseAr = Utils::PPHttpPost($url, $postFields, true);

if(!$ppResponseAr["status"]) {
   Utils::PPError($ppResponseAr["error_msg"], $ppResponseAr["error_no"]);
   exit;
}

$httpParsedResponseAr = $ppResponseAr["httpParsedResponseAr"];

// assign posted variables to local variables
   $item_name = $httpParsedResponseAr['item_name'];
   $item_number = $httpParsedResponseAr['item_number'];
   $receiver_email = $httpParsedResponseAr['receiver_email'];
   $receiver_id = $httpParsedResponseAr['receiver_id'];
   $quantity = $httpParsedResponseAr['quantity'];
   $first_name = $httpParsedResponseAr['first_name'];
   $last_name = $httpParsedResponseAr['last_name'];
   $payer_email = $httpParsedResponseAr['payer_email'];
   $txn_type = $httpParsedResponseAr['txn_type'];
   $address_street = $httpParsedResponseAr['address_street'];
   $address_city = $httpParsedResponseAr['address_city'];
   $address_state = $httpParsedResponseAr['address_state'];
   $address_zip = $httpParsedResponseAr['address_zip'];
   $item_number = $httpParsedResponseAr['item_number'];
   $option_name1 = $httpParsedResponseAr['option_name1'];
   $option_selection1 = $httpParsedResponseAr['option_selection1'];
   $option_name2 = $httpParsedResponseAr['option_name2'];
   $option_selection2 = $httpParsedResponseAr['option_selection2'];
   $invoice = $httpParsedResponseAr['invoice'];
   $custom = $httpParsedResponseAr['custom'];
   $payer_id =$httpParsedResponseAr['payer_id'];

?>
<html lang="en">
<head>
<title>Rec</title>
<link REL="stylesheet" href="include/style.css" type="text/css">

<style>
#center_block {width:50%;margin:0 auto;min-width:500px;}
#contents_block {text-align:center;}
#header_block {white-space:nowrap;height:25px;padding:0 10px 5px;text-align:center;}
#fields_block {width:100%;margin:0;padding:10px}
#header_block span {margin:0 5px}
#buttons_block {padding:10px 10px 5px}
#buttons_block div {padding:3px}
#delimiter {margin:2px}
#fields_block td {padding:3px 14px}
#username_block td {padding-top:13px;white-space:nowrap;}
#remember_block td {padding-bottom:13px;white-space:nowrap;}
#required_block {text-align:left;padding:5px}
</style>

</head>
<body>
<script language="JavaScript" src="include/jquery.js"></script>

<script language="JavaScript" src="include/jsfunctions.js"></script>

<script language="JavaScript" src="include/runnerJS/RunnerBase.js"></script>

<form action="rec.php" method="post" id="rec" name="rec.php">

<table id="center_block" align="center">
<tr><td id="contents_block">

<div class="main_table_border2 loginshade" id="main_block">

<table cellpadding=0 cellspacing=0 border=0 id="fields_block" class="loginshade">

<tr id="email_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_email_1">Email:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_email_0" style="white-space: nowrap;"><input id="value_email_1" style="" type="text" name="value_email_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["payer_email"]) ?>"> <font color="red">*</font></span>
<div class="error"></div>
</td>
</tr>

<tr id="pass_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_pass_1">Pass:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_pass_0" style=""><input style="" id="value_pass_1" type="Password" name="value_pass_1" maxlength=50 value="1234"> <font color="red">*</font></span>
<div class="error"></div>
</td>
</tr>

<tr id="confirm_block">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_confirm_1">Re-enter password:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_confirm_0" style=""><input style="" id="value_confirm_1" type="Password" name="value_confirm_1" value="1234"> <font color="red">*</font></span>
<div class="error"></div>
</td>
</tr>

<tr id="fname_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_fname_1">First Name:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_fname_0" style="white-space: nowrap;"><input id="value_fname_1" style="" type="text" name="value_fname_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["first_name"]) ?>"> <font color="red">*</font></span>
</td>
</tr>

<tr id="lname_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_lname_1">Last Name:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_lname_0" style="white-space: nowrap;"><input id="value_lname_1" style="" type="text" name="value_lname_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["last_name"]) ?>"> <font color="red">*</font></span>
</td>
</tr>

<tr id="address_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_address_1">Address:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_address_0" style="white-space: nowrap;"><input id="value_address_1" style="" type="text" name="value_address_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_street"]) ?>"> <font color="red">*</font></span>
</td>
</tr>

<tr id="city_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_city_1">City:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_city_0" style="white-space: nowrap;"><input id="value_city_1" style="" type="text" name="value_city_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_city"]) ?>"> <font color="red">*</font></span>
</td>
</tr>

<tr id="state_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_state_1">State:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_state_0" style="white-space: nowrap;"><input id="value_state_1" style="" type="text" name="value_state_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_state"]) ?>"> <font color="red">*</font></span>
</td>
</tr>

<tr id="zip_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_zip_1">Zip:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_zip_0" style="white-space: nowrap;"><input id="value_zip_1" style="" type="text" name="value_zip_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["address_zip"]) ?>"> <font color="red">*</font></span>
</td>
</tr>

<tr id="cosponsor_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_cosponsor_1">Cosponsor:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_cosponsor_0" style=""><input id="type_cosponsor_1" type="hidden" name="type_cosponsor_1" value="checkbox"><input id="value_cosponsor_1" type="Checkbox" name="value_cosponsor_1" ></span>
</td>
</tr>

<tr id="recipients_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_recipients_1">Recipients:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_recipients_0" style="white-space: nowrap;"><input id="value_recipients_1" style="" type="text" name="value_recipients_1" maxlength=50 value="<?php echo urldecode($httpParsedResponseAr["quantity"]) ?>"> <font color="red">*</font></span>
</td>
</tr>

<tr id="clients_fieldblock">
<td align=left width=50% class=loginshade>
<div align="left"><label for="value_clients_1">Clients:</label></div>
</td>
<td width=50% class=loginshade>
<span id="edit1_clients_0" style=""><input id="type_clients_1" type="hidden" name="type_clients_1" value="checkbox"><input id="value_clients_1" type="Checkbox" name="value_clients_1" ></span>
</td>
</tr>

<tr id="space_block"></tr>

</table>

</div>
</td></tr>
</table>
<input type=submit value="Submit" class=button id="saveButton1" onload="Submit"></form>

</body>
</html>

Dropdown With Php Help

Similar Tutorials

Hi all. I kinda need some from a more advanced PHP expert. I have a table that displays time slots that are available to be booked. As you can see I have a table with two columns, The 1st column displays the times and the 2nd column has a link that says 'Available'. I want to be able to put all this in a select dropdown box to save space, but how can I do this?

<?php 
	
	$doc = JFactory::getDocument();
	$doc->addStyleSheet(JURI::root(false)."components/com_pbbooking/user_view.css");
?>

<style>
table#pbbooking td, table#pbbooking th {padding: 0em;}
</style>


<h1><?php echo JText::_('COM_PBBOOKING_DAY_VIEW_HEADING').' '.Jhtml::_('date',$this->dateparam->format(DATE_ATOM),JText::_('COM_PBBOOKING_DAY_VIEW_DATE_FORMAT'));?></h1>
<table id="pbbooking">
<!-- Draw header row showing calendars across the top....-->
	<tr>
		<th></th> <!-- first column left blank to display time slots -->
		<?php foreach ($this->cals as $cal) :?>
			<th><?php echo $cal->name;?></th>
		<?php endforeach;?>
	</tr>


	<!-- draw table data rows -->

	<?php while ($this->day_dt_start <= $this->dt_last_slot) :?>
		<?php $slot_end = date_create($this->day_dt_start->format(DATE_ATOM),new DateTimezone(PBBOOKING_TIMEZONE));?>
		<?php $slot_end->modify('+ '.$this->config->time_increment.' minutes');?>
		<tr>
			<th><?php echo Jhtml::_('date',$this->day_dt_start->format(DATE_ATOM),JText::_('COM_PBBOOKING_SUCCESS_TIME_FORMAT'));?></th>
			<?php foreach ($this->cals as $cal) :?>
				<td class="pbbooking-<?php echo (!$cal->is_free_from_to($this->day_dt_start,$slot_end)) ? 'free' : 'busy';?>-cell">
					<?php if ($this->day_dt_start>date_create("now",new DateTimeZone(PBBOOKING_TIMEZONE)) && !$cal->is_free_from_to($this->day_dt_start,$slot_end)) :?>
						<a href="<?php echo JRoute::_('index.php?option=com_pbbooking&task=create&dtstart='.$this->day_dt_start->format('YmdHi').'&cal_id='.$cal->cal_id);?>">
							<?php echo (!$cal->is_free_from_to($this->day_dt_start,$slot_end)) ? JText::_('COM_PBBOOKING_FREE') : JText::_('COM_PBBOOKING_BUSY');?>
						</a>
					<?php else :?>
						<?php echo JText::_('COM_PBBOOKING_BUSY');?>
					<?php endif;?>
				</td>
			<?php endforeach;?>
		</tr>
		<?php $this->day_dt_start->modify('+ '.$this->config->time_increment.' minutes');?>
	<?php endwhile;?>

	<!-- end draw table data rows-->

</table>

Dropdown

Similar Tutorials

I'm trying to have it shows the data from my array as each option will have a value of the user's id and the text for the option will be their name. As of right now it only shows the last person.

Code: [Select]

<?php echo form_label('Recipient', 'recipient'); ?>

<?php
$data = array(
  'name'   => 'to',
  'class'  => 'required'
);
<?php echo form_label('Recipient', 'recipient'); ?>
<?php
                                    $data = array(
                                    'name'   => 'to',
                                    'class'  => 'required'
                                    );
                                    $options = array();
foreach($users AS $user)
{
    $options = array (
    $user->user_id => $user->first_name.' '.$user->last_name
    );
}
?>

<?php echo form_dropdown($data, $options); ?>

Dropdown Box Help

Similar Tutorials

Hi,
I have a dropdown box, and I want it so that if dropdownbox.value='selected:' then show error message.
The checkbox is dynamically populated.

Pleaee Advise,
- stuart

Dropdown Box To Php

Similar Tutorials

I currently have a web page which the user selects the value from the drop menu.
I then want that value to go into another form in the same page inside a hidden field.
Which will then be submitted to the processing php.

The second option is the user selects the drop menu then the processing php would have to grab
the value without a submit button because I am using a save button on the same page in the
other form.

Any help

Php Dropdown

Similar Tutorials

Hi, I'm wondering how i would go about making a drop down menu in php to insert the option into users > Maint of my database, if anyone has any tutorials or examples it would be great, Thanks a lot.

Getting Value & Text From A Dropdown

Similar Tutorials

Hello,

I am searching to find an answer to my question but without success.
I have a HTML dropdown list like this:

<select name="ports">
<option value="10">1/1/1/0/shdsl</option>
<option value="12">1/1/2/0/shdsl</option>
<option value="14">1/1/3/0/shdsl</option>
<option value="16">1/1/4/0/shdsl</option>
<option value="18">1/1/5/0/shdsl</option>
<option value="20">1/1/6/0/shdsl</option>
<option value="22">1/1/7/0/shdsl</option>
<option value="24">1/1/8/0/shdsl</option>
<option value="26">1/1/9/0/shdsl</option>
<option value="28">1/1/10/0/shdsl</option>
<option value="30">1/1/11/0/shdsl</option>
<option value="32">1/1/12/0/shdsl</option>
<option value="34">1/1/13/0/shdsl</option>
<option value="36">1/1/14/0/shdsl</option>
<option value="38">1/1/15/0/shdsl</option>
<option value="40">1/1/16/0/shdsl</option>
<option value="42">1/1/17/0/shdsl</option>
<option value="44">1/1/18/0/shdsl</option>
<option value="46">1/1/19/0/shdsl</option>
<option value="48">1/1/20/0/shdsl</option>
<option value="50">1/1/21/0/shdsl</option>
<option value="52">1/1/22/0/shdsl</option>
<option value="54">1/1/23/0/shdsl</option>
<option value="56">1/1/24/0/shdsl</option>
</select>

All I want to do is to get the value & the text (e.g 56 & "1/1/24/0/shdsl").
I get the value (say 56) with:
$_POST['ports']

Could you please help me get the text?

Populating The Dropdown From Db

Similar Tutorials

I'm trying to retrieve data from my DB and have it populate the dropdown values inside a form:

echo "<option value='0.00' " . ($array['roastturkey'] == '0.00' ? 'selected="selected"' : '') . ">0</option>";echo "<option value='1.00' " . ($array['roastturkey'] == '1.00' ? 'selected="selected"' : '') . ">1</option>";echo "<option value='2.00'> " . ($array['roastturkey'] == '2.00' ? 'selected="selected"' : '') . ">2</option>";echo "<option value='3.00'> " . ($array['roastturkey'] == '3.00' ? 'selected="selected"' : '') . ">3</option>";echo "<option value='4.00'> " . ($array['roastturkey'] == '4.00' ? 'selected="selected"' : '') . ">4</option>";echo "<option value='5.00'> " . ($array['roastturkey'] == '5.00' ? 'selected="selected"' : '') . ">5</option>";echo "<option value='6.00'> " . ($array['roastturkey'] == '6.00' ? 'selected="selected"' : '') . ">6</option>";echo "<option value='7.00'> " . ($array['roastturkey'] == '7.00' ? 'selected="selected"' : '') . ">7</option>";echo "<option value='8.00'> " . ($array['roastturkey'] == '8.00' ? 'selected="selected"' : '') . ">8</option>";echo "<option value='9.00'> " . ($array['roastturkey'] == '9.00' ? 'selected="selected"' : '') . ">9</option>";echo "<option value='10.00'> " . ($array['roastturkey'] == '10.00' ? 'selected="selected

I'm using this code, but cannot get the data that's inside the DB to populate the dropdown value.

I want it to get the info from the database so that the option that is saved in the database will be new default when the page is loaded.

If I don't change it to the previous info it will update the database with the default option rather then the actual option.

Need Help With Dynamic Dropdown

Similar Tutorials

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?

Dropdown Concatenation?

Similar Tutorials

I am currently learning Zend/PHP on the fly. I've gone from 0 to 40 in about 2 months, as far as savviness is concerned. I am working on a form that I want to display array information of two things (shortname and fullname) in a drop-down list. I am thinking I need to do some sort of concatenation to achieve this, or would I do an array within an array? The array is defined in a value object and that draws the id, shortname and fullname. Shortname is the defined label in that file. In the form page, i have the LO ['full_name'] => LO ['label']... this inputs the right information into the database, but shows the full name. I want the drop-down to show it as following: Shortname|Fullname. This will be used in a couple of places once I get on the right track on how to accomplish this. I would be accepting of any help, as well as any resourced that could answer my question and help me finish this form.

Cheers,
ESK