微信小程序（php后端）之仿制淘票票

/* Navicat Premium Data Transfer Source Server : mysql Source Server Type : MySQL Source Server Version : 50732 Source Host : localhost:3306 Source Schema : php_work Target Server Type : MySQL Target Server Version : 50732 File Encoding : 65001 Date: 25/03/2022 14:57:45 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for cinema_info -- ---------------------------- DROP TABLE IF EXISTS `cinema_info`; CREATE TABLE `cinema_info` ( `cinema_id` int(11) NOT NULL AUTO_INCREMENT, `cinema_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `cinema_address` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `grade` float NULL DEFAULT NULL, `cinema_telephone` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `latitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `longitude` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `city` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`cinema_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of cinema_info -- ---------------------------- INSERT INTO `cinema_info` VALUES (1, '星汇时代影城（临安青山店）', '浙江省杭州市临安区临安市青山湖街道大园路123号星汇天地4楼', 8.7, '0571-61099076', '30.262296', '119.828342', '杭州市'); INSERT INTO `cinema_info` VALUES (2, '大地影院(杭州临安宝龙店)', '浙江省杭州市临安区锦北街道农林大路899号宝龙广场3层M-F3-025室', 9, '0571-63759981', '30.250401', '119.726169', '杭州市'); INSERT INTO `cinema_info` VALUES (3, '时代华纳国际影城', '浙江省杭州市临安区笤溪北路笤溪时代广场5楼(时代广场5楼)', 8.9, '0571-61093311', '30.234081', '119.69222', '杭州市'); INSERT INTO `cinema_info` VALUES (4, '完美世界影城（临安万华店）', '浙江省杭州市临安区锦城街道临安区钱王街855号万华广场4层C1', 7.8, '0571-63807665', '30.222263', '119.706228', '杭州市'); INSERT INTO `cinema_info` VALUES (5, '金逸影城(天虹购物中心)', '浙江省杭州市江干区四季青街道新塘路108号天虹购物中心B座6层606号', 9.8, '0571-86022798', '30.264985', '120.210126', '杭州市'); INSERT INTO `cinema_info` VALUES (6, '青春光线电影院', '北京市东城区滨河路乙1号雍和航星园74-76号楼', 7.9, '010-64142287', '39.951115', '116.420823', '北京市'); -- ---------------------------- -- Table structure for film_broadcast_info -- ---------------------------- DROP TABLE IF EXISTS `film_broadcast_info`; CREATE TABLE `film_broadcast_info` ( `film_broadcast_id` int(11) NOT NULL AUTO_INCREMENT, `film_id` int(11) NULL DEFAULT NULL, `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `is_main_page` int(11) NULL DEFAULT NULL, `type` int(11) NULL DEFAULT NULL, PRIMARY KEY (`film_broadcast_id`) USING BTREE, INDEX `film_id`(`film_id`) USING BTREE, CONSTRAINT `film_id` FOREIGN KEY (`film_id`) REFERENCES `film_info` (`film_id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of film_broadcast_info -- ---------------------------- INSERT INTO `film_broadcast_info` VALUES (1, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/dlam_juzhao_01.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (2, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/dlam_juzhao_02.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (3, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/dlam_juzhao_03.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (4, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/dlam_juzhao_04.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (5, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/dlam_juzhao_05.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (6, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/dlam_video_01.mp4', 1, 1); INSERT INTO `film_broadcast_info` VALUES (7, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/dlam_video_02.mp4', 0, 1); INSERT INTO `film_broadcast_info` VALUES (8, 1, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/dlam_main_page.jpg', 1, 0); INSERT INTO `film_broadcast_info` VALUES (9, 2, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/sdyjq9_main_page.jpg', 1, 0); INSERT INTO `film_broadcast_info` VALUES (10, 2, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/sdyjq9_juzhao_01.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (11, 2, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/sdyjq9_juzhao_02.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (12, 2, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/tlzel_juzhao_04.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (13, 2, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/tlzel_juzhao_05.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (14, 2, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/sdyjq9_video_01.mp4', 1, 1); INSERT INTO `film_broadcast_info` VALUES (15, 2, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/sdyjq9_video_02.mp4', 0, 1); INSERT INTO `film_broadcast_info` VALUES (16, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_main_page.jpg', 1, 0); INSERT INTO `film_broadcast_info` VALUES (17, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_01.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (18, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_02.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (19, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_03.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (20, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_04.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (21, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_05.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (22, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/wywmzyq_video_01.mp4', 1, 1); INSERT INTO `film_broadcast_info` VALUES (23, 3, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/wywmzyq_video_02.mp4', 0, 1); INSERT INTO `film_broadcast_info` VALUES (24, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/tnzel_main_page.jpg', 1, 0); INSERT INTO `film_broadcast_info` VALUES (25, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_01.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (26, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_02.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (27, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_03.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (28, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_04.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (29, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/image/wywmzyq_juzhao_05.jpg', 0, 0); INSERT INTO `film_broadcast_info` VALUES (30, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/tnzel_video_01.mp4', 1, 1); INSERT INTO `film_broadcast_info` VALUES (31, 4, 'https://xiaoyi-jason.oss-cn-beijing.aliyuncs.com/tpp/video/tnzel_video_02.mp4', 0, 1); INSERT INTO `film_broadcast_info` VALUES (32, 5, 'htt