Giter VIP home page Giter VIP logo

louyu65 / geekmovie Goto Github PK

View Code? Open in Web Editor NEW

This project forked from kangvcar/geekmovie

0.0 0.0 0.0 21.85 MB

GeekMovie 极客影院是一个免费的在线观影系统,本网站内容使用Python爬虫技术收集于互联网上公开资源,提供最优质的web界面服务,但不提供也不参与影片档案录制、下载、上传、储存。本站资源永久免费共享、无需安装任何插件、免注册登入、无隐藏恶意(挖矿)软体,欢迎影迷安心浏览观赏。

Home Page: http://geek.freevar.com

JavaScript 37.85% Python 0.11% PHP 3.85% CSS 13.20% Hack 0.08% HTML 21.56% TSQL 23.35%

geekmovie's Introduction

Geek 极客影院

【学习研究所用,请勿用于生产环境】

Geek 极客影院是一个免费的在线观影系统,本网站内容使用Python爬虫技术收集于互联网上公开资源,提供最优质的web界面服务,但不提供也不参与影片档案录制、下载、上传、储存。本站资源永久免费共享、无需安装任何插件、免注册登入、无隐藏恶意(挖矿)软体,欢迎影迷安心浏览观赏。

Geek 极客影院系统包含了前端web观影页面后端web站点管理系统

  • 前端包含用户登陆(v5.0已移除)、用户注册(v5.0已移除)、影片搜索、网友评论、影片排行榜、各类型影片栏目、讨论组、无插件在线播放等功能
  • 后端包含服务器系统信息总览、管理员登录(超级管理员&普通管理员)、影片信息的增删查改、网友评论管理、用户信息管理、天气提醒、在线音乐播放等功能。

v5.0 在线演示 Demo

v4.0 在线演示 Demo

API (部分失效)

功能介绍

前端系统功能介绍

后端系统功能介绍

版本

  • Apache/Nginx
  • PHP-5.4.45
  • MySQL
  • Bootstrap-4.0.0
  • Python 3.7

说明

本系统前后端分离,可按需下载back-end-v5.0front-end-v5.0目录进行部署。

数据库导入

先创建数据库okmovie,在导入jikeMovie-v5.0.sql文件即可;

默认数据库登陆账号为root, 密码为root; 如有变化请修改dbconnection.php文件,否则会数据库连接失败!

[root@kangvcar ~]# mysql -V
mysql  Ver 15.1 Distrib 5.5.60-MariaDB, for Linux (x86_64) using readline 5.1
[root@kangvcar ~]# mysql -uroot -proot -e "CREATE DATABASE okmovie;"
[root@kangvcar ~]# mysql -uroot -proot -e "use okmovie; source jikeMovie-v5.0.sql;"

部署WEB

部署前请按照上述**数据库导入**进行数据库导入

  1. 首先下载项目文件
    1. GIT下载git clone https://github.com/kangvcar/GeekMovie.git
    2. (如果没有安装git)还可以点击此下载
  2. 下载项目文件后会获得一个GeekMovie目录,在该目录下的有两个子文件夹back-end-v5.0,front-end-v5.0和一个Python文件movieSpider.py
    1. back-end-v5.0: 后端web站点管理系统
    2. front-end-v5.0: 前端web观影系统
    3. movieSpider.py: Python爬虫文件
  3. back-end-v5.0front-end-v5.0文件夹移动到网站的根目录下(如/var/www/html/usr/share/nginx/html)
  4. 配置WEB服务器指定网站根目录为front-end文件夹即可
    1. Apache配置
      ...
      DocumentRoot "/var/www/html/front-end" 
      ...
      
    2. Nginx配置
      ...
      root /usr/share/nginx/html/front-end;
      ...
      
  5. 由于后端管理系统一般不能暴露给普通用户,所以直接输入路径进行访问http://<ip>/admin.php

数据库结构

部署本系统前,先导入jikeMovie-v5.0.sql数据库文件

数据表结构(总共4张表)

数据库必须使用InnoDB引擎

表名 存储信息 说明
admin 存储后台管理员用户信息表
comment 存储用户评论表 ON DELETE CASCADE
movie 存储影片信息表
user 存储普通用户信息表
MariaDB [okmovie]> show tables;
+-------------------+
| Tables_in_okmovie |
+-------------------+
| admin             |
| comment           |
| movie             |
| user              |
+-------------------+

MariaDB [okmovie]> desc admin;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| id       | int(20)     | NO   | PRI | NULL    | auto_increment |
| username | varchar(20) | NO   |     | NULL    |                |
| password | varchar(20) | NO   |     | NULL    |                |
| role     | int(10)     | NO   |     | 2       |                |
+----------+-------------+------+-----+---------+----------------+

MariaDB [okmovie]> desc comment;
+----------+--------------+------+-----+---------+----------------+
| Field    | Type         | Null | Key | Default | Extra          |
+----------+--------------+------+-----+---------+----------------+
| cid      | int(20)      | NO   | PRI | NULL    | auto_increment |
| user_id  | int(20)      | YES  | MUL | NULL    |                |
| movie_id | int(20)      | YES  | MUL | NULL    |                |
| content  | varchar(200) | YES  |     | NULL    |                |
+----------+--------------+------+-----+---------+----------------+

MariaDB [okmovie]> desc movie;
+-----------+--------------+------+-----+---------+-------+
| Field     | Type         | Null | Key | Default | Extra |
+-----------+--------------+------+-----+---------+-------+
| mid       | int(20)      | NO   | PRI | NULL    |       |
| mname     | varchar(50)  | YES  |     | NULL    |       |
| mimgurl   | varchar(200) | YES  |     | NULL    |       |
| mscore    | varchar(20)  | YES  |     | NULL    |       |
| mdirector | varchar(20)  | YES  |     | NULL    |       |
| mstar     | varchar(200) | YES  |     | NULL    |       |
| mtype     | varchar(50)  | YES  |     | NULL    |       |
| marea     | varchar(20)  | YES  |     | NULL    |       |
| myear     | varchar(20)  | YES  |     | NULL    |       |
| msumary   | varchar(400) | YES  |     | NULL    |       |
| mplayurl  | varchar(400) | YES  |     | NULL    |       |
+-----------+--------------+------+-----+---------+-------+

MariaDB [okmovie]> desc user;
+----------+-------------+------+-----+---------+----------------+
| Field    | Type        | Null | Key | Default | Extra          |
+----------+-------------+------+-----+---------+----------------+
| uid      | int(20)     | NO   | PRI | NULL    | auto_increment |
| username | varchar(20) | NO   | UNI | NULL    |                |
| password | varchar(20) | NO   |     | NULL    |                |
| email    | varchar(30) | NO   |     | NULL    |                |
+----------+-------------+------+-----+---------+----------------+

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.