 |
|
Code (SQL)
CREATE TABLE IF NOT EXISTS `tb_member` (
`id_member` int(8) NOT NULL AUTO_INCREMENT,
`username` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`price_card` int(8) NOT NULL DEFAULT '0',
`date_num` int(8) NOT NULL DEFAULT '0',
`key_card` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`class_user` int(2) NOT NULL DEFAULT '0',
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`date_over` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`email` text COLLATE utf8_unicode_ci NOT NULL,
`status_other` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`status_other_a` varchar(200) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`userban` text COLLATE utf8_unicode_ci NOT NULL,
`reflogin` text COLLATE utf8_unicode_ci NOT NULL,
`ipuser` text COLLATE utf8_unicode_ci NOT NULL,
`lastlogin` datetime NOT NULL,
`LoginStatus` int(1) NOT NULL,
PRIMARY KEY (`id_member`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=721 ;
--
-- dump ตาราง `tb_member`
--
INSERT INTO `tb_member` (`id_member`, `username`, `password`, `price_card`, `date_num`, `key_card`, `class_user`, `date`, `date_over`, `email`, `status_other`, `status_other_a`, `userban`, `reflogin`, `ipuser`, `lastlogin`, `LoginStatus`) VALUES
(676, 'wgvnp', '17615', 50, 4, '67037364455916', 0, '2017-02-10 07:34:38', '2017-02-14 07:34:38', '', '', '', '', '1579994258', '1.46.235.120', '2017-02-13 09:22:25', 0),
(677, 'osxcs', '26780', 50, 4, '26679910644883', 0, '2017-02-10 08:25:12', '2017-02-14 08:25:12', '', '', '', '', '1148521790', '171.7.246.82', '2017-02-13 03:40:48', 0),
(678, 'rwwiu', '24092', 50, 4, '74138640732002', 0, '2017-02-10 10:06:52', '2017-02-14 10:06:52', '', '', '', '', '94146948', '223.24.102.173', '2017-02-10 10:07:24', 0),

อยากได้แบบ ค้นหา เลขบัตรเติมเงิน ถ้าเจอให้ขึ้นข้อมูล พาส กับไอดี ถ้าไม่เจอให้ไม่มีข้อมูลในระบบ
Tag : PHP

|
|
 |
 |
 |
 |
Date :
2018-04-08 21:54:22 |
By :
skyblack2009 |
View :
789 |
Reply :
5 |
|
 |
 |
 |
 |
|
|
|
 |