NOTE
Searching for movies/tv shows isn't currently working due to the OMDB API now requiring a key.
Create a twitter like social media platform for sharing tv/movie interests
- Server, such as XAMPP/LAMP/MAMP
- PHP 5.5+
To use the application:
- Clone into your
htdocs
directory - Read line 2 of
database-config.php
- Create a file that defines the database
CONSTANTS
and that matches the specified path (line 2 ofdatabase-config.php
), OR remove the required file path and define the necessary constants within the file e.g...
<?php
// Create the connection
$db_connection = new mysqli('host', 'database_username', 'database_password', 'database_table');
// Check the connection, and output an error message if unsuccessful
if ($db_connection->connect_error) {
die("Connection failed: " . $db_connection->connect_error);
}
- Copy the code from
statements.sql
into your SQL command line - Have fun!
You are tasked with developing a prototype system in PHP and JavaScript with a back-end database (e.g. MySQL), to store details of registered posters, posted TV episodes and comments. For the prototype you can make the following simplifying assumptions:
-
A reader can view all posts of all users.
-
Each user has a page that lists all of the TV episodes and comments that they have posted.
-
Any user can create an account and immediately create posts.
-
Once registered, a user can edit their own profile that contains a short biography and their contact details.
-
All posts are to be time stamped with their creation date and time.
-
Both interfaces (mobile and desktop) have the same functionality and display the same content but in a manner appropriate to each device.
-
A post should contain the TV episode name and series/TV programme it is a part of and a comment of up to 140 characters including spaces.
-
Posters can delete their own past posts.
-
Posters can create and edit their own profile.
-
Any user can see a list of all messages for any poster ordered by date posted (most recent first).
-
Any user can view the profile of any poster.
-
Validation of all data entry forms.
-
A secure login system for posters.
-
A registration system for any user to become a poster.
In addition to the basic functionality, you will get additional marks if the prototype provides the following functionality:
-
Posters should be able to “tag” the TV episode they are posting with a suitable tag e.g.actors, genre, year etc., and users should be able to view all posts that have been posted with a particular tag e.g. view all posts that have been tagged with “2017”.
-
A user’s profile page should contain their short biography/contact details as well as a list of their posts.
-
jQuery validators and Ajax functions that check the password strength and username availability within the registration form (whilst the user is typing).