1200字范文 > PHP个人相册管理系统源码实现了相册分类和相册分组还有相册图片管理数据库采用m

PHP个人相册管理系统源码实现了相册分类和相册分组还有相册图片管理数据库采用m

时间：2020-02-27 12:44:45

PHP个人相册管理系统，实现了相册分类和相册分组，还有相册图片管理，数据库采用mysql，实现了登录注册功能。PHP个人相册源码，相册管理系统，PHP相册管理系统，界面美观简单，适合用来当做课程设计或者简单毕业设计。

下面是运行效果截图

项目目录结构截图

数据库结构SQL文件：

/*Navicat Premium Data TransferSource Server : MSYQLSource Server Type : MySQLSource Server Version : 50553Source Host : localhost:3306Source Schema : xiangceTarget Server Type : MySQLTarget Server Version : 50553File Encoding : 65001Date: 12/12/ 16:28:41*/SET NAMES utf8mb4;SET FOREIGN_KEY_CHECKS = 0;-- ------------------------------ Table structure for admininfo-- ----------------------------DROP TABLE IF EXISTS `admininfo`;CREATE TABLE `admininfo` (`adminid` int(11) NOT NULL,`username` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`addtime` datetime NULL DEFAULT NULL,PRIMARY KEY (`adminid`) USING BTREE) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of admininfo-- ----------------------------INSERT INTO `admininfo` VALUES (1, 'admin', 'admin', '-12-11 10:24:55');-- ------------------------------ Table structure for imginfo-- ----------------------------DROP TABLE IF EXISTS `imginfo`;CREATE TABLE `imginfo` (`id` int(11) NOT NULL AUTO_INCREMENT,`typename` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`addtime` datetime NULL DEFAULT NULL,`picurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of imginfo-- ----------------------------INSERT INTO `imginfo` VALUES (1, '小猫图片', '猫介绍', '小猫图片', '-12-12 11:25:54', 'upload/2bcabb83f128edeaa088acb8a332f9ea.jpeg');INSERT INTO `imginfo` VALUES (2, '小猫图片', '23424', '234', '-12-12 11:28:58', 'upload/2bcabb83f128edeaa088acb8a332f9ea.jpeg');INSERT INTO `imginfo` VALUES (3, '小猫图片', '沃尔沃二无若', '沃尔沃二无', '-12-12 11:29:55', 'upload/2bcabb83f128edeaa088acb8a332f9ea.jpeg');INSERT INTO `imginfo` VALUES (4, '小狗图片', '水电费', '水电费', '-12-12 15:39:39', 'upload/3134background.jpg');INSERT INTO `imginfo` VALUES (8, '小狗图片', '345345', '34535', '-12-12 15:59:27', 'upload/6197元素和属性.png');-- ------------------------------ Table structure for sorttype-- ----------------------------DROP TABLE IF EXISTS `sorttype`;CREATE TABLE `sorttype` (`id` int(11) NOT NULL AUTO_INCREMENT,`title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`content` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,`fid` int(11) NULL DEFAULT NULL,`addtime` datetime NULL DEFAULT NULL,PRIMARY KEY (`id`) USING BTREE) ENGINE = MyISAM AUTO_INCREMENT = 9 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;-- ------------------------------ Records of sorttype-- ----------------------------INSERT INTO `sorttype` VALUES (1, '风景图片', '风景图片内容介绍', 0, '-12-12 10:58:54');INSERT INTO `sorttype` VALUES (2, '动物图片', '动物图片内容介绍', 0, '-12-12 10:58:54');INSERT INTO `sorttype` VALUES (3, '小狗图片', '小狗图片内容介绍', 2, '-12-12 10:58:54');INSERT INTO `sorttype` VALUES (6, '小猫图片', '小猫图片', 2, '-12-12 10:58:54');INSERT INTO `sorttype` VALUES (5, '自然风景', '自然风景介绍', 1, '-12-12 10:58:54');INSERT INTO `sorttype` VALUES (8, '', '', 0, '-12-12 16:01:12');SET FOREIGN_KEY_CHECKS = 1;