Project Status App

One day, my boss mentioned the idea of a website where he could post updates about projects and send the link to clients so they could read up on it and view pictures. I was intrigued and was curious to see if I could make something like that, whether he was going to use it or not. I had no idea how I would do it but the solution hit me like a train in the shower. I used a TinyMCE WYSIWYG Editor to allow admins to make their pages. The editor already had features such as adding images, videos, rich text, tables, etc. When the admin posts the page, the app exports the editor content as html, encodes it as JSON, and adds it to a MySQL table alongside any authorized emails that are allowed to view it.

Though basic, I tried to make the app as accessible as possible. The admin page allows you to preview pages in a new tab, quickly switch between editing existing pages, delete pages, and more. Not only is the admin page easy to use but the client-experience is fairly simple. On the landing page, clients fill out a form for the Project Name and their Email address. If their email is on the list and the Project Name matches, they are emailed a temporary link that lets them view the page. The PHP script pulls the JSON data from the MySQL table, decodes it, and injects the html into the page. The app uses HTML, JS, CSS, MySQL, PHP, PHPMailer, TinyMCE, Bootstrap, and BlueHost SMTP

Though it is just a preview page with content embedded into the query, you can click this link to see what the app is capable of.www.treyotech.com/s/Zs9