Fill select tag with php - fill select tag of form with php

While working on a project you might need a dynamic select box to be generated from the values present in the database.

So this example gives you a simple way to populate a select box with the values present in the database.



Consider a example - there is a table "article" in your database "mydb"



So for this first we need to create a connection with the database and we need to select the database.



For this we will create a file called "connect.php"



replace the values with your actual values as per directed in code



<br /><br /><?php<br /><br />//code for connect.php<br /><br /><br /><br />$host = "localhost"; // replace this with your host, default is localhost<br /><br />$user = "username"; // replace with the mysql username<br /><br />$pass = "password"; // replace with the mysql password<br /><br />$db_name = "mydb";<br /><br /><br /><br />mysql_connect($host,$user,$pass) or die("<br>Cannot connect to host.....".mysql_error());<br /><br />mysql_select_db($db_name) or die("<br>Cannot connect to Database.....".mysql_error());<br /><br />?><br /><br />



After that we will write our main code in a file called "myselect.php"



<br /><br /><?php<br /><br />//code for myselect.php<br /><br /><br /><br />include "connect.php"; // we will include our connect.php here<br /><br />$sql = "SELECT * FROM article";<br /><br />$result = mysql_query($sql);<br /><br />?><br /><br /><select name="articleauthor"><br /><br /> <?php <br /><br /> while($row = mysql_fetch_array($result))<br /><br /> {<br /><br /> ?><br /><br /> <option value="<?php echo $row['author']; ?>"><br /><br /> <?php <br /><br /> echo $row['author']; <br /><br /> ?><br /><br /> </option><br /><br /> <?php <br /><br /> } <br /><br /> ?><br /><br /></select><br /><br /><br /><br />



And its over. Its very simple.

Try it out, if you face any problem then comment here, i will help you.