I use MAMP to run my SQL server, MAMP is available at https://www.mamp.info/en/downloads/. You will also need to create the tables in the SQL server.
A demo can be seen at https://youtu.be/ENi-VVnlCSk.
Note that there is no audio, it is a quick video to show the application and database uploading.
This is a resume registry developed using PHP, MySQL, jQuery, JavaScript, HTML, and CSS. It was developed to have CRUD functionality and follows a Model-View-Controller design.
You can sign up and sign in to the web application and then create, read, update, and delete profiles. Each profile has a first name, last name, email, headline, and summary as mandatory sections. Additionally, you can add education and positions.
For the eduction I have autocompletion that uses the institution database shown in my demo to autocomplete previously entered schools. Whenever someone enters a school that is not recognized it is added to the institution database.
I used htmlentities() and PDO prepare statements to avoid SQL and HTML injection.
Features Implemented
- Sign In Page: You can create an account, note that once you sign in you can only see profiles that you own
- Sign Up Page: You can create an account note that passwords are stored with a salted hash for security
- Create: You can create profiles through the "Add New Entry" feature (only if you are signed in)
- Read: A table is shown for viewing the data, click on a specific profile name to see more info
- Update: Click the edit link to update an entry (only if you are signed in and you own the profile)
- Delete: Click the delete link to delete an entry (only if you are signed in and you own the profile)
