# Project export: Side Project This document was generated by HackStack to give an AI agent context about a hackathon project. Sections are labeled with their provenance; content marked as truncated was cut to keep this document small. ## Project metadata - Hackathon: CruzHacks 2024 - Tagline: SideProject is your one-stop shop for all things collaboration. From carpentry and C++ to genomic mapping and graphic design, you can find peers to work with on SideProject. - Devpost: https://devpost.com/software/side-project - GitHub: https://github.com/Bod1eF/side-project-reborn - Demo: https://side-project.in/ - Team: 4 GitHub contributor(s) — Bodie Feinberg (56 commits), katelynsun (30 commits), Mira Prabhakar (27 commits), Bhavya-212 (5 commits) ## Devpost submission (written by the team) ### Inspiration We were inspired ## ### What it does Side Project is a Full Stack CRUD app, that allows users to post about projects they are working on/want to work on to a public board. They can find people to collaborate with this board. ## ### How we built it We built it with a PHP and MySQL backend, with a vanilla HTML, CSS, and JS frontend. ## ### Challenges we ran into We originally tried to make the app in React and FireBase but decided to switch after being unable to do so for 6 hours. ## ### Accomplishments we're proud of We're proud of having a finished project after such a large setback and making something for all of our' first-ever hackathon. ## ### What we learned We learned a great deal about work delegation, having lots of back up plans, and using the underlying technologies. ## ### What's next An expansion of features such as profile pages, which we planned to make but lacked time. ## README (from the GitHub repository) cruzhacks project, reborn ^_^ ## Detected evidence (automated analysis) Indexed codebase: 12 recognized source files, 38 KB. - CSS (language) — detected in the code - HTML (language) — detected in the code - JavaScript (language) — detected in the code - PHP (language) — detected in the code - SQL (language) — detected in the code ## Codebase structure (from repository index) ### Files (12 of 12) ``` databse.sql form.php index.css index.php js/minimal-theme-switcher.js loggedin.html login.php logout.php myprofile.html profile.php README.md signup.php ``` ### Dependencies No dependency index available. ### Recent commits (newest first) - mild fixes - updated png - Merge branch 'main' of https://github.com/Bod1eF/side-project-reborn - live - updated final - updated png - live - logged in - update - added cats - update profile - Merge branch 'main' of https://github.com/Bod1eF/side-project-reborn - ignore - stlyed sign up - Update login.php - Merge branch 'main' of https://github.com/Bod1eF/side-project-reborn - Update index.php - my profile - Update index.php - rwq ## Key source files (fetched from GitHub, selected and truncated for size) ### profile.php ```php Side Project

Side Project

Sign In ``` ### logout.php ```php Sign Out ``` ### databse.sql ```sql CREATE TABLE IF NOT EXISTS `user` ( `id` int NOT NULL AUTO_INCREMENT, `isAdmin` boolean, `email` text, `password` text, `schoolyear` int, PRIMARY KEY (`id`) ); CREATE TABLE IF NOT EXISTS `posts` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(32), `body` varchar(300), `name` varchar(18), `category` varchar(16), `num_collaborators` int, `date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `user_id` int, PRIMARY KEY (`id`) ); ``` ### index.css ```css @import url('https://fonts.googleapis.com/css2?family=Poppins:wght@400;700&display=swap'); /* Grid */ body>main { display: flex; flex-direction: column; justify-content: center; min-height: calc(100vh - 7rem); padding: 1rem 0; } article { padding: 0; overflow: hidden; } article div { padding: 1rem; } @media (min-width: 576px) { body>main { padding: 1.25rem 0; } article div { padding: 1.25rem; } } @media (min-width: 768px) { body>main { padding: 1.5rem 0; } article div { padding: 1.5rem; } } @media (min-width: 992px) { body>main { padding: 1.75rem 0; } article div { padding: 1.75rem; } } @media (min-width: 1200px) { body>main { padding: 2rem 0; } article div { padding: 2rem; } } /* Nav */ summary[role="link"].secondary:is([aria-current], :hover, :active, :focus) { background-color: transparent; color: var(--secondary-hover); } /* Hero Image */ article div:nth-of-type(2) { display: none; background-color: #374956; background-image: url("img/alessio-soggetti-8jeWeKdygfk-unsplash-1000x1200.jpg"); background-position: center; background-size: cover; } @media (min-width: 992px) { .grid>div:nth-of-type(2) { display: block; } } /* Footer */ body>footer { padding: 1rem 0; } ``` ### signup.php ```php Side Project
☰ Side Project

The #1 website to find collaborators for any project!

``` ### login.php ```php prepare("INSERT INTO user (`email`, `password`, `isAdmin`) VALUES (:reg_email, :reg_password, false);"); //store account info into database $sth->bindValue(':reg_email', htmlspecialchars($_POST["email"])); $sth->bindValue(':reg_password', password_hash(htmlspecialchars($_POST["password"]), PASSWORD_DEFAULT)); $sth->execute(); $sth_id = $dbh->prepare("SELECT * FROM user WHERE `email`=:reg_email"); //gets user row of newly created account $sth_id->bindValue(':reg_email', htmlspecialchars($_POST["email"])); $sth_id->execute(); $reg_id = $sth_id->fetch(); $new_account = true; echo "<

Account registered

"; } catch(PDOException $e) { echo "Connection failed: " . $e->getMessage(); } } } ?> Side Project
☰ Side Project

The #1 website to find collaborators for any project!

 ``` ### myprofile.html ```html Side Project
☰ Side Project
×

Your Profile

Your most recent posts.

John

John Doe

CEO & Founder

(Insert link to GitHub/Project)

Jane

Jane Doe

Designer

(Insert link to GitHub/Project)

Mike

Mike Ross

Architect

(Insert link to GitHub/Project)

John

John Doe

CEO & Founder

(Insert link to GitHub/Project)

Jane

Jane Doe

Designer

(Insert link to GitHub/Project)

Mike

Mike Ross

Architect

(Insert link to GitHub/Project)

``` ### loggedin.html ```html Side Project
☰ Side Project
×

Recent Posts

See the most recent posts by fellow coders!

John

Observing UCSC raccoon behavior

John Doe

JohnDoe@gmail.com

Biology

They are abnormally larger than normal racoons!

Jane

Coding a Project database for UCSC students!

Jane Doe

Jane Doe@gmail.com

Tech

(Insert link to GitHub/Project)

Mike

Drawing Cats

Mike Ross

MikeRoss@gmail.com

Art

(Insert link to GitHub/Project)

John

Observing UCSC raccoon behavior

John Doe

JohnDoe@gmail.com

Biology

They are abnormally larger than normal racoons!

Jane

Coding a Project database for UCSC students!

Jane Doe

Jane Doe@gmail.com

Tech

(Insert link to GitHub/Project)

Mike

Drawing Cats

Mike Ross

MikeRoss@gmail.com

A [truncated — 1223 more characters] ``` ### index.php ```php prepare("INSERT INTO posts (`title`, `body`, `category`, `name`,`num_collaborators`, `user_id`) VALUES (:reg_title, :reg_body, :reg_category, :reg_name, 1, :reg_user_id);"); //store post data in posts db $sth->bindValue(':reg_title', htmlspecialchars($_POST["title"])); $sth->bindValue(':reg_body', htmlspecialchars($_POST["body"])); $sth->bindValue(':reg_category', htmlspecialchars($_POST["category"])); $sth->bindValue(':reg_name', htmlspecialchars($_POST["name"])); $sth->bindValue(':reg_user_id', htmlspecialchars($_SESSION["user_id"])); $sth->execute(); echo ''; } catch (PDOException $e) { echo "

Error: {$e->getMessage()}

"; } } try { //fetch all posts in the posts table $dbh = new PDO($DB_DSN, $DB_USER, $DB_PASSWORD); $sth_posts= $dbh->prepare("SELECT email, title, body, name, category, date, num_collaborators FROM posts INNER JOIN user ON posts.user_id = user.id ORDER BY date DESC;"); $sth_posts->execute(); $arr_of_posts = $sth_posts->fetchAll(PDO::FETCH_ASSOC); } catch (PDOException $e) { echo "

Error: {$e->getMessage()}

"; } ?> Side Project
☰ Side Project
×

Recent Posts

See the most recent posts by fellow coders!

"; echo "

"; } echo '
'; if ($post['category'] == "art") { echo 'John'; } elseif ($post['category'] == "bio") { echo 'John'; } elseif ($post['category'] == "tech") { echo 'John'; } else { echo 'John'; } echo '
'; echo '

' . $post['title'] . '

'; echo '

prepare("SELECT * FROM user WHERE email=:login_email");//find pass_hash where id matches login id $sth_password->bindValue(':login_email', htmlspecialchars($_POST["user_login"])); $sth_password->execute(); $login_row = $sth_password->fetch(); $user_id = $login_row["id"]; $_SESSION["user_id"] = $user_id; //store user id in session if (password_verify(htmlspecialchars($_POST["pass_login"]), $login_row['password'])) { //verify password agaisnt hash echo "

Succesfully Logged in as " . htmlspecialchars($_POST["user_login"]) . "

"; } else { //if password doesn't match send to sign in header('Location: index.php'); exit; } } else { //if password doesn't match send to sign in header('Location: login.php'); exit; } } catch (PDOException $e) { echo "

Error: {$e->getMessage()}

"; } ?> Side Project
☰ Side Project
×

Post

Share your projects with other students and join the Side Project community!





0 Words and 0 Characters