PHP laravel框架开发实践项目代码

-- phpMyAdmin SQL Dump -- version 4.8.5 -- https://www.phpmyadmin.net/ -- -- 主机： localhost -- 生成日期： 2023-06-11 12:01:44 -- 服务器版本： 8.0.12 -- PHP 版本： 7.3.4 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET AUTOCOMMIT = 0; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 数据库： `manger` -- -- -------------------------------------------------------- -- -- 表的结构 `adcontent` -- CREATE TABLE `adcontent` ( `id` int(10) UNSIGNED NOT NULL COMMENT '主键', `advid` int(11) NOT NULL COMMENT '广告位id', `path` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '图片路径', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- 转存表中的数据 `adcontent` -- INSERT INTO `adcontent` (`id`, `advid`, `path`, `created_at`, `updated_at`) VALUES (21, 15, 'a0fb9049c9cd2a38689ad5507ffa9ffa.jpeg|ecd9b21bfafe38ef77d16eb34318a0fe.jpeg|709f0d2d6578d7c7091842148a989193.jpeg|89ccbc46bb673bb67764652fcaaadbbc.jpeg', '2023-06-10 04:59:17', '2023-06-10 05:01:38'), (22, 16, '5e2aeb74e0b9aacfe1dbac2b4ede0f83.png', '2023-06-10 05:05:34', '2023-06-10 05:05:34'), (23, 17, 'e40f90afde6b2b995af8bc5d0271096f.jpeg', '2023-06-10 06:01:04', '2023-06-10 06:01:04'); -- -------------------------------------------------------- -- -- 表的结构 `admin_user` -- CREATE TABLE `admin_user` ( `id` int(10) UNSIGNED NOT NULL COMMENT '主键', `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名', `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码', `salt` char(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码salt', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- 转存表中的数据 `admin_user` -- INSERT INTO `admin_user` (`id`, `username`, `password`, `salt`, `created_at`, `updated_at`) VALUES (1, 'admin', '5231b3ad4d6ccc56b860bdd4cf6347db', '0460c4ba14ec265361197ce0bad0373f', NULL, NULL); -- -------------------------------------------------------- -- -- 表的结构 `adv` -- CREATE TABLE `adv` ( `id` int(10) UNSIGNED NOT NULL COMMENT '主键', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '广告位名称', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- 转存表中的数据 `adv` -- INSERT INTO `adv` (`id`, `name`, `created_at`, `updated_at`) VALUES (15, '摇一摇', '2023-06-10 04:57:33', '2023-06-10 04:57:33'), (16, '樱花', '2023-06-10 05:05:17', '2023-06-10 05:05:17'), (17, '柒耀任', '2023-06-10 06:00:23', '2023-06-10 06:00:23'); -- -------------------------------------------------------- -- -- 表的结构 `category` -- CREATE TABLE `category` ( `id` int(10) UNSIGNED NOT NULL COMMENT '主键', `pid` int(11) NOT NULL DEFAULT '0' COMMENT '父栏目id', `name` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '栏目名称', `sort` int(11) NOT NULL DEFAULT '0' COMMENT '排序值', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- 转存表中的数据 `category` -- INSERT INTO `category` (`id`, `pid`, `name`, `sort`, `created_at`, `updated_at`) VALUES (53, 0, '新闻', 0, '2023-05-16 00:00:00', '2023-05-16 00:00:00'), (54, 0, '科技', 0, '2023-05-16 00:00:11', '2023-05-16 00:00:11'), (55, 0, '世界', 0, '2023-05-16 00:00:20', '2023-05-16 00:00:20'), (56, 0, '运动', 0, '2023-05-16 00:00:28', '2023-05-16 00:00:28'), (57, 0, '商业', 0, '2023-05-16 00:00:40', '2023-05-16 00:00:40'), (58, 0, '生活', 0, '2023-05-16 00:00:55', '2023-05-16 00:00:55'), (59, 58, '健康', 0, '2023-05-16 00:01:04', '2023-05-16 00:01:04'), (60, 53, 'PHP', 1, '2023-06-10 04:40:43', '2023-06-10 04:40:43'), (61, 53, '柒耀任', 1, '2023-06-10 05:56:55', '2023-06-10 05:56:55'); -- -------------------------------------------------------- -- -- 表的结构 `comments` -- CREATE TABLE `comments` ( `id` int(10) UNSIGNED NOT NULL COMMENT '主键', `uid` int(11) NOT NULL COMMENT '用户id', `cid` int(11) NOT NULL COMMENT '内容id', `content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '评论内容', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- 转存表中的数据 `comments` -- INSERT INTO `comments` (`id`, `uid`, `cid`, `content`, `created_at`, `updated_at`) VALUES (3, 1, 6, '柒耀任', '2023-06-10 05:45:28', '2023-06-10 05:45:28'); -- -------------------------------------------------------- -- -- 表的结构 `content` -- CREATE TABLE `content` ( `id` int(10) UNSIGNED NOT NULL COMMENT '主键', `cid` int(11) NOT NULL DEFAULT '0' COMMENT '栏目id', `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '标题', `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容', `image` char(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '图片', `status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '默认状态1推荐2', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- 转存表中的数据 `content` -- INSERT INTO `content` (`id`, `cid`, `title`, `content`, `image`, `status`, `created_at`, `updated_at`) VALUES (5, 53, '摇一摇', '<p>摇一摇</p>', '6d65de98173eb1dcc8ff8cd7a1985a50.jpeg', 2, '2023-05-16 00:05:19', '2023-06-10 04:33:17'), (6, 55, '樱花', '<p>樱花</p>', 'cb35339fd541e2086ecd8cdc7be371d6.jpeg', 2, '2023-05-16 00:07:05', '2023-06-10 04:33:07'), (10, 59, '樱花', '<p>樱花</p>', 'ed62edfcac5932cd751626d34843623b.jpeg', 1, '2023-06-10 04:36:01', '2023-06-10 04:36:11'), (11, 58, '摇一摇', '<p>摇一摇</p>', '2fb5a39921f434ac0ff96d48b4fd4362.jpeg', 1, '2023-06-10 04:36:32', '2023-06-10 04:36:32'), (12, 53, '樱花', '<p><span style=\"text-decoration: none;\">樱花</span><br/></p>', 'f349a35359520a8208cef8e1a44a99de.jpeg', 1, '2023-06-10 04:36:50', '2023-06-10 04:36:50'), (13, 56, '樱花', '<p>樱花</p>', 'c541f73a0de0874d77a27ede723fec7a.jpeg', 1, '2023-06-10 04:37:13', '2023-06-10 04:37:13'), (14, 57, '樱花', '<p>悄悄<br/></p>', '3b02033d88904fea60ad602533940b6e.jpeg', 1, '2023-06-10 04:37:47', '2023-06-10 04:37:56'), (15, 54, '摇一摇', '<p>摇一摇</p>', 'c38b715ccbc815942572ccb44d31a2ea.jpeg', 1, '2023-06-10 04:38:29', '2023-06-10 04:38:29'), (16, 53, '摇一摇', '<p>樱花</p>', '8086b078a0576f9f9a485f64a3de9f48.jpeg', 2, '2023-06-10 04:39:41', '2023-06-10 04:39:41'), (17, 60, '樱花', '<p>樱花</p>', '7e65da7b971c440e554e4b13161682ba.jpeg', 2, '2023-06-10 04:40:59', '2023-06-10 04:40:59'), (18, 61, '樱花', '<p>电子信息工程学院</p>', '9682aa247ad942239336e5bc701039bc.jpeg', 1, '2023-06-10 05:59:30', '2023-06-10 05:59:30'); -- -------------------------------------------------------- -- -- 表的结构 `likes` -- CREATE TABLE `likes` ( `id` int(10) UNSIGNED NOT NULL COMMENT '主键', `uid` int(11) NOT NULL COMMENT '用户id', `cid` int(11) NOT NULL COMMENT '内容id', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicod