A simple form made with mostly PHP. Has an admin panel with a search feature for the form results.
| Contents |
|---|
| Step 1: Installation of XAMPP |
| Step 2: Filling out the form |
| Step 3: Visualizing the data |
| Step 4: Editing the data |
| Step 5: Enjoy |
- Download the latest version of XAMPP.
- Fire up the control panel.
- Start up the Apache and MySQL modules.
- Clone the code into your htdocs directory (Make a folder at C:\xampp\htdocs and paste the files)
- Head over to http://localhost/ {folder-name-from-above} /login.php
- Sign up, log in, fill out the form and hit submit.
-
Log out of the previous account and log into any of the generated admin accounts:
-
webadmin1 : webadmin1
-
webadmin2 : webadmin2
-
-
Bunch of options:
- Create DB: Create the database to store the form info. If someone enters the form.php page the database is created automatically so this button just checks.
- Show DB: Show all the submitted form data.
- Search DB: Search the database for input. Filter either by the name of the participant and / or their email provider.
- Reset your password and Log out.
- Head over to http://localhost/phpmyadmin/index.php
- On the left of the page is a column with the available databases. Hitting the plus (+) will reveal the tables of each database
- Database A: The database where all the participants are stored. Has a table called "formparticipants" which includes their name, emails etc. All the fields are filtered for any weird characters and malicious code before they are stored in the database.
- Database B: The database where all the accounts are stored. Has a table called users which includes their username, password hash, user type and date of creation.
- Editing the data can be done by clicking the Edit button in any of the table rows. Editing will be made available through the admin page so one doesn't have to go into phpMyAdmin to do so.
- Congratulations for reading through this, you deserve a cookie 🍪.