How to hang/link/attach MySql data into html Combo box.
<?php
error_reporting(E_ERROR | E_PARSE);
$conn=mysqli_connect("localhost","root","","MySqlDatabasename");
if ($conn)
{
echo "database connected successfully","<br>";
}
else
{
die("Connection Aborted:" . mysqli_connect_error());
}
?>
<html>
<head></head>
<body>
<form name="form1" method="post" action="">
<center>
<fieldset style="width: 600px">
<legend>Create Account</legend>
<table>
<tr>
<td>Name</td>
<td>:</td>
<td><input type="text" name="TxtName"></td>
<td>
<select>
<option value=”Choose One”>Choose One</option>
<?php
$res= mysqli_query($conn, "select Email from createaccount");
while ($row= mysqli_fetch_array($res))
{
?>
<option value=”<?php echo $row["Email"];?>”> <?php echo
$row["Email"];?> </option>
<?php
}
?>
</select>
</td>
</tr>
<tr>
<td>Email</td>
<td>:</td>
<td><input type="text" name="TxtEmail"></td>
</tr>
</table>
</fieldset>
</center>
</form>
</body>
</html> 
0 Comments