flipsider
DESCRIPTION
TRANSCRIPT
![Page 1: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/1.jpg)
Emily Lazo, Nicholas Mitchell, and Hillary Funk
![Page 2: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/2.jpg)
THE IDEA
Create a website where Flipsider entries can be posted, similar to Craigslist.
![Page 3: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/3.jpg)
TABLES
Useruser_id INTeid VARCHAR(15)first_name VARCHAR(40)last_name VARCHAR(40)email VARCHAR(50)
![Page 4: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/4.jpg)
CommunityCategorycommunity_id INTcommunitycategory_name VARCHAR(25)
CommunityPostcommunitypost_id INTuser_id INTcommunity_id INTcommunity_title VARCHAR(60)description TEXTphoto VARCHAR(40)date date
![Page 5: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/5.jpg)
JobCategoryjobcategory_id INTjobcategory_name VARCHAR(25)
JobPostjobpost_id INTuser_id INTjobcategory_id INTjob_title VARCHAR(100)description TEXTdate date
![Page 6: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/6.jpg)
HousingCategoryhousing_id INThousing_type VARCHAR(25)
HousingPosthousingpost_id INTuser_id INThousing_id INThousing_title VARCHAR(60)location VARCHAR(25)monthly_rent DECIMAL (6, 2)description TEXTphoto VARCHAR(75)date date
![Page 7: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/7.jpg)
SaleCategorysalecategory_id INTsalecategory_name VARCHAR(25)
SalesPostsalespost_id INTuser_id INTsalecategory_id INTitem_name VARCHAR(60)price DECIMAL(7,2)description TEXTphoto VARCHAR(75)date date
![Page 8: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/8.jpg)
![Page 9: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/9.jpg)
![Page 10: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/10.jpg)
![Page 11: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/11.jpg)
![Page 12: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/12.jpg)
![Page 13: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/13.jpg)
![Page 14: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/14.jpg)
The Code
bootstrapIn addition to a local stylesheet, the site uses Twitter bootstrap CSS file
.jsNavigation bar is handled with javascript and CSS.
include()Header and footer files.
![Page 15: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/15.jpg)
The Code pt. 2
cd Main DirectoryHomepage, login files, and files that handle creating new posts.
cd Other DirectoriesSubdirectories for storing images and structuring each post category.
![Page 16: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/16.jpg)
The code pt. 3
<?php // PHP Scripts
● Browse/sort existing content
● Search
● Add content
● Get newly added content
● Handle login/out
?>
![Page 17: Flipsider](https://reader034.vdocuments.us/reader034/viewer/2022051208/5470108eaf79598c308b45e0/html5/thumbnails/17.jpg)
http://herbie.ischool.utexas.edu/flipsider