一、功能介绍
基于php+mysql+html
前台:
网站首页
宠物推荐
最新宠物
新闻咨询
宠物分类
宠物资讯
评论
登录/注册
加入购物车、领养、个人中心
后台:各种增删改查
系统设置
分类管理
宠物管理
领养管理
评价管理
新闻资讯
用户管理
二、效果展示
三、代码展示
CREATE TABLE `liuyan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `userid` int(11) NOT NULL COMMENT '用户id', `username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户名', `content` text CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT '内容', `addtime` datetime(0) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci CREATE TABLE `orders` ( `id` int(11) NOT NULL AUTO_INCREMENT, `onumber` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `userid` int(11) NOT NULL DEFAULT 0, `sex` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `address` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `tel` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `shfs` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `content` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `addtime` timestamp(0) DEFAULT CURRENT_TIMESTAMP, `xname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, `nickname` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 19 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
四、项目总结
这是用php+mysql+html+css实现的一个宠物的核心流程,如果有任何问题了可以私信我或者在评论区指出,我们共同学习进步!
标签:ci,NULL,DEFAULT,utf8,领养,SET,COLLATE,毕业设计,php From: https://blog.csdn.net/weixin_42258627/article/details/143606264