我们如何从数据库中填写下拉列表以及我们如何在第一个droupdown值更改时填写另一个下拉列表。 [英] How we can fill Dropdown list from data base and how we can fill another dropdownlist on change of first droupdown value.
本文介绍了我们如何从数据库中填写下拉列表以及我们如何在第一个droupdown值更改时填写另一个下拉列表。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Add_State
SID SName SSName
Add_Distric
DID SID DName DSName
Add_Dep
DepID SID DepName DepSName
我想将数据从add_state传送到droupdown list1,并希望在第一个droupdownlist1的更改的基础上填写两个下拉列表。
解决方案
一点点努力,Google和...... 在PHP中显示从一个ComboBox到另一个ComboBox的记录 [ ^ ]
当我使用时以下
数据库:`work`
表`category`的表结构
CREATE TABLE`category`(
`id` bigint(11)NOT NULL auto_increment,
`category_name `varchar(255)NOT NULL,
PRIMARY KEY(`id`)
)ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 20;
转储表category的数据:
INSERT INTO`category`(`id`,`category_name`)VALUES
(9,'Electronics') ,
(2,'手机'),
(3,'相机'),
(10,'家庭和厨房'),
(11,'服装' ),
(12,'礼品'),
(13,'家电'),
(19,'医药');
表company的表结构:
CREATE TABLE`company`
(
`id`bigint(11)NOT NULL auto_increment,
`cat_id`int(11)NOT NULL,
`company_name`varchar(255)NOT NULL,
PRIMARY KEY(`id`)
)ENGINE = MyISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT = 34;
转储表company的数据:
INSERT INTO`company`(`id`,`cat_id`,`company_name`)VALUES
(1, 2,'三星'),
(2,2,'诺基亚'),
(3,2,'LG'),
(6,11,'Rebook'),
(7,11,'牛仔'),
(8,11,'耐克'),
(9,13,'飞利浦'),
(10,13, 'Prestige'),
(11,3,'尼康'),
(12,3,'Cannon'),
(13,3,'索尼'),
(14,9,'Tohsiba'),
(15,9,'松下'),
(16,12,'晚餐套餐'),
(31,19,'通用'),
(18,10,'三星'),
(19,10,'LG'),
(30,19,'品牌'),
(32,19,'Ayurvedic'),
(29,19,'场外交易'),
(33,19,'homeopethic');
代码部分
config.php
<? php
< span class =code-summarycomment>
host = localhost ;
dear sir we have three table
Add_State
SID SName SSName
Add_Distric
DID SID DName DSName
Add_Dep
DepID SID DepName DepSName
I want to fatch data from add_state to a droupdown list1 and want to fill two dropdown on base of SID FROM REMAINING tables onChange of first droupdownlist1.
解决方案
A bit of effort, Google and... Display Records From One ComboBox to Another in PHP[^]
when i am using following
Database: `Work` Table structure for table `category` CREATE TABLE `category` ( `id` bigint(11) NOT NULL auto_increment, `category_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; Dumping data for table "category": INSERT INTO `category` (`id`, `category_name`) VALUES (9, 'Electronics'), (2, 'Mobiles'), (3, 'Camera'), (10, 'Home & Kitchen'), (11, 'Apparel'), (12, 'Gifts'), (13, 'Appliances'), (19, 'Medicine'); Table structure for table "company": CREATE TABLE `company` ( `id` bigint(11) NOT NULL auto_increment, `cat_id` int(11) NOT NULL, `company_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=34 ; Dumping data for table "company": INSERT INTO `company` (`id`, `cat_id`, `company_name`) VALUES (1, 2, 'Samsung'), (2, 2, 'Nokia'), (3, 2, 'LG'), (6, 11, 'Rebook'), (7, 11, 'Denim'), (8, 11, 'Nike'), (9, 13, 'Philips'), (10, 13, 'Prestige'), (11, 3, 'Nikon'), (12, 3, 'Cannon'), (13, 3, 'Sony'), (14, 9, 'Tohsiba'), (15, 9, 'Panasonic'), (16, 12, 'Dinner Set'), (31, 19, 'Generic'), (18, 10, 'Samsung'), (19, 10, 'LG'), (30, 19, 'Branded'), (32, 19, 'Ayurvedic '), (29, 19, 'OTC'), (33, 19, 'homeopethic'); Code Part config.php <?php
host="localhost";
这篇关于我们如何从数据库中填写下拉列表以及我们如何在第一个droupdown值更改时填写另一个下拉列表。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文