{"id":1480,"date":"2017-05-08T15:35:28","date_gmt":"2017-05-08T10:05:28","guid":{"rendered":"https:\/\/pheonixsolutions.com\/blog\/?p=1480"},"modified":"2017-05-08T16:59:07","modified_gmt":"2017-05-08T11:29:07","slug":"dynamic-drop-down-list-using-html-php-mysql","status":"publish","type":"post","link":"https:\/\/pheonixsolutions.com\/blog\/dynamic-drop-down-list-using-html-php-mysql\/","title":{"rendered":"Dynamic Dependent drop down list using html,php,mysql"},"content":{"rendered":"

Posted Date:08-05-2017<\/strong><\/p>\n

In this post we will explain how to dropdown list dynamically using html,php<\/p>\n

First we explain dynamic dropdown list using php<\/p>\n

Dynamic dropdown list using php<\/h2>\n

Step 1: Create a new file dropdown.php<\/p>\n

step 2:\u00a0 Create a mysql connection code inside dropdown.php<\/p>\n

$mysqlserver=\"localhost\";\r\n$mysqlusername=\"root\";\r\n$mysqlpassword=\"\";\r\n$link=mysql_connect($mysqlserver, $mysqlusername, $mysqlpassword) or die (\"Error connecting to mysql server: \".mysql_error());\r\n$dbname = 'test';\r\nmysql_select_db($dbname, $link) or die (\"Error selecting specified database on mysql server: \".mysql_error());<\/pre>\n
stp3 : Create mysql table ls_countries<\/p>\n
CREATE TABLE `ls_countries` (  `country_id` int(11) NOT NULL AUTO_INCREMENT,  `sortname` varchar(3) NOT NULL,  `name` varchar(150) NOT NULL,  `phonecode` int(11) NOT NULL,  `status` int(11) NOT NULL COMMENT '1->active,0->deactive',  PRIMARY KEY (`country_id`)) ENGINE=InnoDB AUTO_INCREMENT=247 DEFAULT CHARSET=utf8<\/pre>\n
 <\/p>\n
step4 : Create drop down list dynamically using following code<\/p>\n
<select>\r\n  <option>Select Country<\/option>\r\n  <?php\r\n   $cdquery=\"SELECT * FROM ls_countries\";\r\n            $cdresult=mysql_query($cdquery) or die (\"Query to get data from firsttable failed: \".mysql_error());\r\n            \r\n            while ($cdrow=mysql_fetch_array($cdresult)) {\r\n            $cdTitle=$cdrow[\"name\"];\r\n                echo \"<option>$cdTitle <\/option>\";\r\n            \r\n            }\r\n  ?>\r\n<\/select><\/pre>\n
we are\u00a0 following above steps and getting code like this<\/p>\n
<?php \r\n$mysqlserver=\"localhost\";\r\n$mysqlusername=\"root\";\r\n$mysqlpassword=\"\";\r\n$link=mysql_connect($mysqlserver, $mysqlusername, $mysqlpassword) or die (\"Error connecting to mysql server: \".mysql_error());\r\n$dbname = 'linus';\r\nmysql_select_db($dbname, $link) or die (\"Error selecting specified database on mysql server: \".mysql_error());\r\n?>\r\n<!DOCTYPE html>\r\n<html>\r\n<head>\r\n  <title>Drop Down Using Php<\/title>\r\n<\/head>\r\n<body>\r\n<select>\r\n  <option>Select Country<\/option>\r\n  <?php\r\n   $cdquery=\"SELECT * FROM ls_countries\";\r\n            $cdresult=mysql_query($cdquery) or die (\"Query to get data from firsttable failed: \".mysql_error());\r\n            \r\n            while ($cdrow=mysql_fetch_array($cdresult)) {\r\n            $cdTitle=$cdrow[\"name\"];\r\n                echo \"<option>$cdTitle <\/option>\";\r\n            \r\n            }\r\n  ?>\r\n<\/select>\r\n<\/body>\r\n<\/html>\r\n<\/pre>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
Posted Date:08-05-2017 In this post we will explain how to dropdown list dynamically using html,php First we explain dynamic dropdown […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1022],"tags":[],"class_list":["post-1480","post","type-post","status-publish","format-standard","hentry","category-web-architecture","psol-cat-web-architecture"],"jetpack_publicize_connections":[],"jetpack_shortlink":"https:\/\/wp.me\/phn2x7-nS","jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/1480","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/comments?post=1480"}],"version-history":[{"count":0,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/posts\/1480\/revisions"}],"wp:attachment":[{"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/media?parent=1480"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/categories?post=1480"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pheonixsolutions.com\/blog\/wp-json\/wp\/v2\/tags?post=1480"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}