PHP scripts and programs for Beginner to Master

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

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

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

And its over. Its very simple.
Try it out, if you face any problem then comment here, i will help you.