djsaeedkhan
چهارشنبه 21 دی 1390, 15:33 عصر
ورودی کاربر رو توی همین دوتا جدول وارد کردید یا یه جدول جداگانه؟
ممنون ولی خودم می خوام یکی بنویسم.
سلام
من دیتابیس رو برات میذارم
مطمئنا کامل متوجه میشی
روش من ابداعی هست
یعنی ممکنه یه روش بهتر هم پیدا بشه. ولی من با این روش بیشتر حال کردم.
CREATE TABLE IF NOT EXISTS `examtest` (
`id_soal` int(11) NOT NULL AUTO_INCREMENT,
`soal_type` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
`if_text_value` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
`if_radio_value` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
`if_check_value` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
`if_list_value` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
`soal_onvan` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
`soal_primary_key` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
`noname1` int(11) NOT NULL DEFAULT '0',
`noname2` int(11) NOT NULL DEFAULT '0',
`when_saved` varchar(50) CHARACTER SET latin1 NOT NULL,
`who_saved` varchar(50) CHARACTER SET latin1 NOT NULL,
`sorting` varchar(10) COLLATE utf8_persian_ci NOT NULL DEFAULT '0',
PRIMARY KEY (`id_soal`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=33 ;
--
-- Dumping data for table `examtest`
--
INSERT INTO `examtest` (`id_soal`, `soal_type`, `if_text_value`, `if_radio_value`, `if_check_value`, `if_list_value`, `soal_onvan`, `soal_primary_key`, `noname1`, `noname2`, `when_saved`, `who_saved`, `sorting`) VALUES
(1, '3', '0', '0', '806338681321408', '0', 'aa', '740085726709437', 0, 0, '2011/12/27', 'admin', 'aa'),
(2, '3', '0', '0', '573569963069448', '0', '1', '761202646454699', 0, 0, '2011/12/28', 'admin', '1'),
(3, '3', '0', '0', '958515799108044', '0', '1', '555707903761163', 0, 0, '2011/12/28', 'admin', '1'),
(4, '3', '0', '0', '181981605813184', '0', '1', '808959356222788', 0, 0, '2011/12/28', 'admin', '1'),
(5, '3', '0', '0', '556451955776593', '0', '1', '192049501426005', 0, 0, '2011/12/28', 'admin', '1'),
(6, '3', '0', '0', '987794153223991', '0', '1', '981918908122713', 0, 0, '2011/12/28', 'admin', '1'),
(7, '3', '0', '0', '881063331421471', '0', '1', '552237895309727', 0, 0, '2011/12/28', 'admin', '1'),
(8, '3', '0', '0', '804913386688468', '0', '1', '138558000702950', 0, 0, '2011/12/28', 'admin', '1'),
(9, '3', '0', '0', '977730005270989', '0', '1', '415345838735394', 0, 0, '2011/12/28', 'admin', '1'),
(10, '3', '0', '0', '711630415009618', '0', '1', '919633769111278', 0, 0, '2011/12/28', 'admin', '1'),
(11, '3', '0', '0', '957596649345181', '0', '1', '582239457305057', 0, 0, '2011/12/28', 'admin', '1'),
(12, '3', '0', '0', '753099234883703', '0', '1', '313970082945547', 0, 0, '2011/12/28', 'admin', '1'),
(13, '3', '0', '0', '213493456785444', '0', '1', '979384659761523', 0, 0, '2011/12/28', 'admin', '1'),
(14, '3', '0', '0', '300691059270192', '0', '1', '831619040039215', 0, 0, '2011/12/28', 'admin', '1'),
(15, '3', '0', '0', '005244992310676', '0', '1', '550486732059418', 0, 0, '2011/12/28', 'admin', '1'),
(16, '3', '0', '0', '118672323903731', '0', '1', '159802855774170', 0, 0, '2011/12/28', 'admin', '1'),
(17, '3', '0', '0', '443613762359983', '0', '1', '965287030555880', 0, 0, '2011/12/28', 'admin', '1'),
(18, '3', '0', '0', '590282348209882', '0', '1', '427937091058995', 0, 0, '2011/12/28', 'admin', '1'),
(19, '3', '0', '0', '598477604733447', '0', '1', '366003805196532', 0, 0, '2011/12/28', 'admin', '1'),
(20, '3', '0', '0', '150018026402835', '0', '1/2//4/7', '616928627757258', 0, 0, '2011/12/28', 'admin', '1'),
(21, '3', '0', '0', '319192240608539', '0', '1/2//4/55', '907014697523410', 0, 0, '2011/12/28', 'admin', '1'),
(22, '3', '0', '0', '109116487995903', '0', '1/2//4/m3', '666853501355564', 0, 0, '2011/12/28', 'admin', '1'),
(23, '3', '0', '0', '818448278936715', '0', '1/2//4/m3', '305488088288494', 0, 0, '2011/12/28', 'admin', '1'),
(24, '3', '0', '0', '201648827953785', '0', '1/2//4/m3', '264935247990759', 0, 0, '2011/12/28', 'admin', '1'),
(25, '3', '0', '0', '313037126839517', '0', '1/2//4/m3', '151739684566702', 0, 0, '2011/12/28', 'admin', '1'),
(26, '3', '0', '0', '773443462654118', '0', '1/2//4/m3', '880015177582071', 0, 0, '2011/12/28', 'admin', '1'),
(27, '3', '0', '0', '444249685686743', '0', '1/2//4/m3', '012914388470008', 0, 0, '2011/12/28', 'admin', '1'),
(28, '3', '0', '0', '107911717655038', '0', '1/2//4/m3', '842083847956541', 0, 0, '2011/12/28', 'admin', '1'),
(29, '3', '0', '0', '933332547168927', '0', '1/2//4/m3', '045642354285098', 0, 0, '2011/12/28', 'admin', '1'),
(30, '3', '0', '0', '723882208744039', '0', '1/2//4/m3', '089036093116159', 0, 0, '2011/12/28', 'admin', '1'),
(31, '3', '0', '0', '758875577559054', '0', '1/2//4/m3', '246175062460841', 0, 0, '2011/12/28', 'admin', '1'),
(32, '3', '0', '0', '890364385237103', '0', '1/2//4/m3', '575340249537108', 0, 0, '2011/12/28', 'admin', '1');
CREATE TABLE IF NOT EXISTS `checkradio` (
`iden` int(11) NOT NULL AUTO_INCREMENT,
`soal_id` varchar(50) COLLATE utf8_persian_ci NOT NULL,
`soal_string` varchar(50) COLLATE utf8_persian_ci NOT NULL COMMENT 'مقداری که نمایش داده می شود',
`soal_value` varchar(50) COLLATE utf8_persian_ci NOT NULL DEFAULT '0' COMMENT 'مقداری که بایدبعد از انتخاب برگرداند',
`noname2` varchar(50) CHARACTER SET latin1 NOT NULL DEFAULT '0',
PRIMARY KEY (`iden`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=91 ;
--
-- Dumping data for table `checkradio`
--
INSERT INTO `checkradio` (`iden`, `soal_id`, `soal_string`, `soal_value`, `noname2`) VALUES
(1, '806338681321408', 'ad', '0', '0'),
(2, '806338681321408', 'adasd', '0', '0'),
(3, '573569963069448', '', '', '0'),
(4, '958515799108044', '', '', '0'),
(5, '181981605813184', '', '', '0'),
(6, '556451955776593', '', '', '0'),
(7, '987794153223991', '', '', '0'),
(8, '987794153223991', '3', '3', '0'),
(9, '881063331421471', '3', '3', '0'),
vBulletin® v4.2.5, Copyright ©2000-1403, Jelsoft Enterprises Ltd.