Skip to main content

POPULATE DROPDOWN MENU FROM MYSQL

Populate  drop down menu from MYSQL:


1
2
3
4
5
6
7 
8
<select name="user">
<?php
   $sql = mysqli_query ( $connect, "SELECT name FROM users" );
   while ( $row = $sql->fetch_assoc () ) {
 echo '<option value = "' . $row ['name'] . '">' . $row ['name'] . "</option>";
   }
?>
</select>

Show a drop down selected value coming from database:

1
 2 
 3
 4
 5
 6
 7
 8
 9
10
11
<select name="user">
<?php
  $name = $users['name'];  

  $sql = mysqli_query ( $connect, "SELECT name FROM users" );
  while ( $row = $sql->fetch_assoc () ) {
 $selected = ($row ['name'] == $name) ? 'selected="selected"' : '';
 echo '<option value="' . $row ['name'] . '" ' . $selected . '>' . $row ['name'] . '</option>';
 }
  ?>
</select>

Hope you understand it.If any queries please comment below.Please subscribe to other solutions.Thank you :)
Labels:

Comments

Post a Comment

Popular posts from this blog

MYSQL CONNECTION USING PDO WITH PHP

Hello guys, In the previous tutorial we have seen how to connect to MySQL database with PHP using MySQLi. Today we will learn how to connect with PDO. As a PHP programmer we have learned how to access database by using either MySQL and MySQLi. As of PHP 5.1, there's a better way. PHP Data Objects(PDO) provide methods for prepared statements and working with objects that will make you far more productive! PDO Introduction :        PDO provides a data-access abstraction layer, which means that, regardless of which database you're using, you use the same functions to issue queries and fetch data. PDO does not provide a database abstraction; it doesn't rewrite SQL or emulate missing features. Database Support:       The extension can support any database that a PDO driver has been written for. The following drivers currently implement the PDO interface: PDO_CUBRID Cubrid PDO_DBLIB FreeTDS / Microsoft SQL Server / Sybase PDO_FIREBIRD Firebird PDO_I...
4 comments
Read more

Convert JSON to ARRAY in PHP

 To convert an Array to JSON in PHP, we use json_encode() function. The function is used to encode a value to JSON format $arr = array ( 'Millie' => 'Eleven' ,             'Mike' => 'Finn' ,             'Gaten' => 'Dustin' ,             'Noah' => 'Will' ); echo json_encode ( $arr ). " \n " ; Output : { "Millie" : "Eleven" , "Mike" : "Finn" , "Gaten" : "Dustin" , "Noah" : "Will" }
Post a Comment
Read more

MYSQL DATABASE CONNECTION WITH PHP

Hello friends, today we will learn how to connect to  MySQL  database with PHP. This tutorial will require a MySQL database and a web development environment using mysql, apache and php and a simple text editor. The tutorial takes you through establishing a  MySQL  connection using php on a web page, connecting to a  MySQL  table and retrieving the results and displaying them back on the web page. Earlier versions of PHP used the  MySQL  extension.However, this extension was depreciated in 2012. Later can work with  MySQL  database using MySQLi extension (the "i" stands for improved) PDO (PHP Data Objects)        The main difference between these two are if you want to switch your project to another database PDO makes it easy(since it can connect 12 different databases). You only have to change the connection string and a few queries. With MySQLi, you will need to rewrite the entire code - queries included.In this t...
Post a Comment
Read more