Employees-Manager

Fully functioning PHP web app that Supports CRUD operations on employees.


View Demo · Report Bug · Request Feature

Table of Contents

1. About The Project
   • Built With
2. Getting Started
3. Contributing
4. License
5. Contact
6. Acknowledgments

About The Project

my.employees.webm

Main features

Fully functioning web app that Supports:

• Registration.
• Authentication.
• CRUD operations on employees.
• Search for an employee.
• Password reset.
• Validation and sanitization of all inputs before inserting to the database...

(back to top)

Built With

• MySQL
• PHP 7
• Bootsrap 5
• JavaScript
• HTML5
• CSS3

(back to top)

Getting Started

1. First of all make sure your have PHP 7+, MySQL installed and running
2. clone the repo using git clone https://github.com/youssef-imlyhen/Employees-Manager.git
3. Run these SQL commands or you can create the database and the tables manually using PhpMyAdmin.

/* create the database */
CREATE DATABASE cruddb;
/* create users tables */
CREATE TABLE `users` ( `id` INT NOT NULL AUTO_INCREMENT , `username` VARCHAR(100) NOT NULL , `password` VARCHAR(100) NOT NULL , `created_at` DATE NOT NULL DEFAULT CURRENT_TIMESTAMP , PRIMARY KEY (`id`)) ENGINE = InnoDB;
/* create employeesList table */
CREATE TABLE `employeesList` ( `id` INT NOT NULL AUTO_INCREMENT , `name` VARCHAR(100) NOT NULL , `email` VARCHAR(100) NOT NULL , `phone` VARCHAR(15) NOT NULL , `job` VARCHAR(100) NOT NULL , PRIMARY KEY (`id`)) ENGINE = InnoDB;

4. Open config.php and change DB_SERVER , DB_USERNAME, DB_PASSWORD, DB_NAME with the details of your database.
5. Have fun.

(back to top)

Acknowledgments

• This project started after I learned PHP basics, and I wanted to do something more advanced to challenge myself. I took a static front-end app that I built as part of a great bootstrap 5 Udemy course. And started building on that by implementing new features like searching, input validation, CRUD operations using AJAX on the front end, and all of the back-end functionalities.

(back to top)

Contributing

Contributions are what make the open source community such an amazing place to learn, inspire, and create. Any contributions you make are greatly appreciated.

If you have a suggestion that would make this better, please fork the repo and create a pull request. You can also simply open an issue with the tag "enhancement". Don't forget to give the project a star! Thanks again!

1. Fork the Project
2. Create your Feature Branch (git checkout -b feature/AmazingFeature)
3. Commit your Changes (git commit -m 'Add some AmazingFeature')
4. Push to the Branch (git push origin feature/AmazingFeature)
5. Open a Pull Request

(back to top)

License

Distributed under the MIT License.

(back to top)

Contact

Project Link: https://github.com/youssef-imlyhen/Employees-Manager
Linkedin: https://linkedin.com/in/youssef-imlyhen

(back to top)