1.创建数据库 CREATE DATABASE `network` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci; CREATE TABLE `network`.`mac_ip_list` ( `id` INT( 11 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `ip` CHAR( 30 ) NOT NULL , `mac` CHAR( 30 ) NOT NULL , FULLTEXT ( `mac` ) ) ENGINE = MYISAM 2.插入数据: INSERT INTO `network`.`mac_ip_list` (`ip`, `mac`) VALUES ( '192.168.1.2', 'ff-33-21-f4-44-f9'); mac的格式自定义有‘-’还是没有‘-’; 3.查询页面:
PHP学习的天地: http://www.it596.com/html/10/category-catid-10.html