Drop down with options from MySQL database table

Select One option and onChange event will display the value of selected option.

<div ng-app="my_app" ng-controller="my_ctrl">
<select ng-model="students" ng-options="x.name for x in details">
var app = angular.module('my_app', []);
app.controller('my_ctrl', function($scope, $http) {
  $http.get("student-data.php") // data source for options 
  .then(function (response) {$scope.details = response.data.student_data;});

Using PDO

The variable $dbo is declared inside the database connection file config.php, read more on PDO connection and config file here.
require "config.php"; // database connection 

$sql="SELECT  id, name ,class ,mark FROM student LIMIT 0,10"; 

echo json_encode($result); 
You can check the output ( in JSON format ) of student-data.php file here.
Dropdown List Box
DEMO: Options using JSON format DEMO: OnChange Event

Post your comments , suggestion , error , requirements etc here

We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2023 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer