Awesome Open Source
Awesome Open Source

Geek


Geek Pythonweb

Geek webweb

  • 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.0``front-end-v5.0

okmovie,jikeMovie-v5.0.sql;

root, root; dbconnection.php

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

WEB

    1. GITgit clone https://github.com/kangvcar/GeekMovie.git
    2. (git)
  1. GeekMovie``back-end-v5.0,front-end-v5.0PythonmovieSpider.py
    1. back-end-v5.0 web
    2. front-end-v5.0 web
    3. movieSpider.py Python
  2. back-end-v5.0``front-end-v5.0(/var/www/html``/usr/share/nginx/html)
  3. WEBfront-end
    1. Apache
      ...
      DocumentRoot "/var/www/html/front-end" 
      ...
      
    2. Nginx
      ...
      root /usr/share/nginx/html/front-end;
      ...
      
  4. 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    |                |
+----------+-------------+------+-----+---------+----------------+

Related Awesome Lists
Top Programming Languages
Top Projects

Get A Weekly Email With Trending Projects For These Topics
No Spam. Unsubscribe easily at any time.
Javascript (1,059,387
Python (806,773
Php (285,915
Html (241,406
Css (142,344
Web (37,368
Mysql (31,056
Bootstrap (27,685
Admin (21,959
Nginx (16,712
Apache (16,410
Ajax (7,698