Making it work with persistent data.
In this assignment, your job is to:
posts
in your posting
databasepost
, with all its comments
post
on the first page, you should go to the second and view that postDetails
https://classroom.github.com/a/CzE2YMoV
post
to view through the query string in the link URL$_GET
superglobalcp -r
to copy directories), or re-setupusers
, posts
and comments
to test your code as you go.user
from a post
), refer to the Propel Relations reference to make sure the Foreign Keys are correctly set up in your database.propel init
(you can follow the instructions for re-generation, but there's more steps and thus more places to run into problems).Submitting
posts.php
and post.php
filesOnce again, if you missed or fell behind the database creation that we did through phpMyAdmin
, here are the details. Please ensure that your database uses the same names (case-sensitive!) so that when we grade it it works with our database as well. There are details about setting up a foreign key in the Propel Relations reference (just pay attention to the database part).
Database name: posting
Table: user
id
: int, primary key, auto_incrementusername
: varchar(32)first_name
: varchar(64)last_name
: varchar(64)join_date
: dateTable: post
id
: int, primary key, auto_incrementuser_id
: int, indexed, foreign key to user.id
(id
in the user
table)content
: textpost_date
: datetimeTable: comment
id
: int, primary key, auto_incrementuser_id
: int, indexed, foreign key to user.id
post_id
: int, indexed, foreign key to post.id
content
: varchar(512)post_date
: datetime