????瀹?渚?璁茶堪浜?php+mysql瀹??扮??浜?绾ц???ㄨ????????????浜?缁?澶у?朵?澶у?跺????锛??蜂?濡?涓?锛?
????瀛????涓?绾ц??涓???????娴?璇????╋? ==璇烽???╁????==
==???╀?涓? ==
sql璇??ワ?
--
-- 琛ㄧ??缁??? `colleges`
--
CREATE TABLE IF NOT EXISTS `colleges` (
`college_id` int(8) NOT NULL auto_increment COMMENT '瀛??㈢??瘋???ㄥ???',
`name` varchar(40) NOT NULL COMMENT '瀛??㈠??绉?,
PRIMARY KEY (`college_id`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=7 ;
--
-- 瀵煎?鴻〃涓????版?? `colleges`
--
INSERT INTO `colleges` (`college_id`, `name`) VALUES
(4, '??瀛????宸ュ????),
(1, '璁＄???轟?淇℃??绉?瀛?????),
(6, '缇???瀛???),
(2, '??瀛???),
(5, '?充?瀛???),
(3, '?挎不涓????辯?＄??瀛???);
--
-- 琛ㄧ??缁??? `majors`
--
CREATE TABLE IF NOT EXISTS `majors` (
`major_id` int(8) NOT NULL auto_increment COMMENT '涓?涓??鳳????ㄥ???',
`name` varchar(40) NOT NULL COMMENT '涓?涓???',
`college_id` int(8) default NULL COMMENT '???ㄥ????,
`counsellor_id` int(10) default NULL COMMENT '杈?瀵煎??',
PRIMARY KEY (`major_id`),
UNIQUE KEY `college_id` (`college_id`,`counsellor_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gb2312 AUTO_INCREMENT=8 ;
--
-- 瀵煎?鴻〃涓????版?? `majors`
--
INSERT INTO `majors` (`major_id`, `name`, `college_id`, `counsellor_id`) VALUES
(1, '?靛??????, 1, 1),
(2, '?充?瑙???, 5, 1),
(3, '?ゅ?告??瀛?, 2, 1),
(4, '璁＄???虹?瀛?, 1, NULL),
(5, '???ㄥ??', 1, NULL),
(6, '?頒唬??瀛?, 2, NULL),
(7, '?伴?誨??浣?', 2, NULL);
?村??充?PHP?稿?沖??瀹規???磋叮??璇昏?????ョ????绔?涓?棰?锛???PHP?轟?pdo??浣??版??搴???宸ф?葷???????PHP+MongoDB?版??搴???浣???宸уぇ?ㄣ??????php?㈠??瀵矽薄绋?搴?璁捐?″?ラ?ㄦ??绋???????php瀛?绗?覆(string)?ㄦ??葷???????php+mysql?版??搴???浣??ラ?ㄦ??绋???????php甯歌??版??搴???浣???宸ф??彙??
甯?????????杩闆?瑰ぇ瀹?HP绋?搴?璁捐?℃????甯??┿??
??????????甯?php涓???缃?锛?杞?杞借?鋒敞???哄?锛???璋㈡?ㄧ??灏???锛?