Skip to content
A Social Network with Argon Design System, PHP/MySQL, Javascript, Jquery, Ajax ...
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
assets
config
includes
README.md
close_account.php
comment_frame.php
index.php
like.php
login.php
messages.php
post.php
profile.php
register.php
requests.php
search.php
settings.php
upload.php
user_closed.php

README.md

Social Network v1.0

My Social Network is a social network, with classic features such as requesting, adding or deleting a friend, liking or not liking a post and commenting on it. It also allows you to modify your personal information, update your profile picture or search for a person, but also to receive notifications and private messages. This project is realized with the Argon Design System framework from Creative Tim, Javascript, Ajax, Jquery, PHP + POO and MySQLi.

Database

STORAGE ENGINE : InnoDB
COMMENTS :
Nom Type Interclassement Extra
id int(10) AUTO_INCREMENT
post_body text utf8_unicode_ci
posted_by VARCHAR(60) utf8_unicode_ci
posted_to VARCHAR(60) utf8_unicode_ci
date_added datetime
removed VARCHAR(3) utf8_unicode_ci
post_id int(10)
FRIEND_REQUESTS :
Nom Type Interclassement Extra
id int(10) AUTO_INCREMENT
user_to VARCHAR(60) utf8_unicode_ci
user_from VARCHAR(60) utf8_unicode_ci
LIKES :
Nom Type Interclassement Extra
id int(10) AUTO_INCREMENT
username VARCHAR(60) utf8_unicode_ci
post_id int(10)
MESSAGES :
Nom Type Interclassement Extra
id int(10) AUTO_INCREMENT
user_to VARCHAR(60) utf8_unicode_ci
user_from VARCHAR(60) utf8_unicode_ci
body text utf8_unicode_ci
date datetime
opened VARCHAR(3) utf8_unicode_ci
viewed VARCHAR(3) utf8_unicode_ci
deleted VARCHAR(3) utf8_unicode_ci
NOTIFICATIONS :
Nom Type Interclassement Extra
id int(10) AUTO_INCREMENT
user_to VARCHAR(60) utf8_unicode_ci
user_from VARCHAR(60) utf8_unicode_ci
message text utf8_unicode_ci
link VARCHAR(100) utf8_unicode_ci
datetime datetime
opened VARCHAR(3) utf8_unicode_ci
viewed VARCHAR(3) utf8_unicode_ci
POSTS :
Nom Type Interclassement Extra
id int(10) AUTO_INCREMENT
body text utf8_unicode_ci
added_by VARCHAR(60) utf8_unicode_ci
user_to VARCHAR(60) utf8_unicode_ci
date_added datetime
user_closed VARCHAR(3) utf8_unicode_ci
deleted VARCHAR(3) utf8_unicode_ci
likes int(10)
image VARCHAR(500) utf8_unicode_ci
USERS :
Nom Type Interclassement Extra
id int(10) AUTO_INCREMENT
first_name VARCHAR(50) utf8_unicode_ci
last_name VARCHAR(50) utf8_unicode_ci
username VARCHAR(100) utf8_unicode_ci
email VARCHAR(100) utf8_unicode_ci
password VARCHAR(255) utf8_unicode_ci
signup_date date
profile_pic VARCHAR(255) utf8_unicode_ci
num_posts int(10)
num_likes int(10)
user_closed VARCHAR(3) utf8_unicode_ci
friend_array text utf8_unicode_ci

HTACCESS File

  1. RewriteEngine On
  2. RewriteRule ^([a-zA-Z0-9_-]+)$ profile.php?profile_username=$1
  3. RewriteRule ^([a-zA-Z0-9_-]+)/$ profile.php?profile_username=$1

Credits :

Author Years Licence Source
Paroxyste 2019 None Udemy
You can’t perform that action at this time.