Giter VIP home page Giter VIP logo

kangvcar / geekmovie Goto Github PK

View Code? Open in Web Editor NEW
63.0 4.0 40.0 21.85 MB

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

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

PHP 3.85% Hack 0.08% JavaScript 37.85% HTML 21.56% CSS 13.20% Python 0.11% TSQL 23.35%
php mysql bootstrap html css javascript python ajax movie web

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    |                |
+----------+-------------+------+-----+---------+----------------+

geekmovie's People

Contributors

kangvcar avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar

geekmovie's Issues

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.