how to create dynamic a html form with dropdown listbox in php which get data from mysql database?

Question

I have created a form in html with dropdown list box with static values inside a php file, now i need to populate those dropdown with data from mysql database. i have written a function in php to retrive data from the mysql table. since i am new to php i don't know how to call a php function from html. is it possible to call a php function like calling a JavaScript function.

Here is my HTMl code.

 <div id="machinelog">
    <form id="intermediate" name="inputMachine" method="post">

    <select id="selectDuration" name="selectDuration"> 
      <option value="1 WEEK" >Last 1 Week</option>
      <option value="2 WEEK" >Last 2 Week </option>
      <option value="3 WEEK" >Last 3 Week</option>
    </select>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


    <select id="selectMachine" name="selectMachine"> 
        <option value="M1" >Machine 1</option>
        <option value="M2" >Machine 2</option>
        <option value="M3" >Machine 3</option>
    </select>  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;


<input id="Button" class="button" type="submit" value="Submit" />
</form> 
</div>

I need to take all machine names form mysql and populate the "selectMachine" drop down list box.

My php function is

  function selectMachine()
  {
    $strQuery = "select id, machine
           from rpt_machine
           order by machine";

    $machineResult = mysql_query($strQuery);

    while($arrayRow = mysql_fetch_assoc($machineResult)) {
      $strA = $arrayRow["id"];
      $strB = $arrayRow["machine"];

  }

Allen · Accepted Answer · 2012-11-09 05:03:58Z

2

Why you are creating functions? simply do it like this

<?php
$query = "SELECT * FROM ...."; //Write a query
$data = mysqli_query($connect, $query);  //Execute the query
?>
<select>
<?php
while($fetch_options = mysqli_fetch_array($data)) { //Loop all the options retrieved from the query
?>
 //Added Id for Options Element 
<option id ="<?php echo $fetch_options['id']; ?>"  value="<?php echo $fetch_options['name']; ?>"><?php echo $fetch_options['name']; ?></option><!--Echo out options-->

<?php
}
?>
</select>

edited Nov 9, 2012 at 5:03

Allen

6815 gold badges16 silver badges30 bronze badges

answered Nov 5, 2012 at 3:48

Mr. Alien

158k36 gold badges307 silver badges287 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Allen Over a year ago

Hi Mr.Alien, your code solves my problem of populating the options with dynamic values from MsqDb. I have added Id for Options Element which is UUID of MySql, To Retrieve Values Based on That UUID. How to access that dynamic id in javascript. I can't use getElementById, since i requires the Id to be specified.

rharrison33 · Accepted Answer · 2012-11-05 03:55:14Z

0

You could write a function similar to this one:

function display_dropdown($id){
  //We need to get the dropdown option from the database
  $sql = 'SELECT machine_name FROM your_table';
  $result =   mysql_query($sql) or die ('Query in display_dropdown failed:'. mysql_error());
  echo '<select name="'.$id.'" id="'.$id.'">';
  while($row = mysql_fetch_array($result,MYSQLI_ASSOC)){
    echo '<option value="'.$row{machine_name}.'">
            '.$row{machine_name}.'</option>';
  }
  echo '</select>';
  echo '</td>';
}

To learn how to make and call php functions go here

answered Nov 5, 2012 at 3:55

rharrison33

1,2824 gold badges18 silver badges35 bronze badges

Collectives™ on Stack Overflow

how to create dynamic a html form with dropdown listbox in php which get data from mysql database?

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related