Create a Calendar Booking system in PHP and MySQL

Learn to create your own booking calendar in PHP and MySQL from scratch without using any frameworks and securing it

Ratings: 4.32 / 5.00




Description

Hi and welcome,

Thanks for taking the time to browse this section.



What will we be doing in this course?



We will be creating a simple calendar from scratch where we will allow users to make booking entries into it and interacting with the database. Users can then edit and delete bookings.

We’re also securing the application.
We’re not using any frameworks such as fullCalendar or Google calendar.

Whether you have some PHP experience and wish to improve your Web Security skills then this course may suit you.



- Creating the calendar

- Styling the calendar using CSS

- Setting up the MySQL database

- Insert a calendar entry(booking) into the calendar

- Sanitize and validate the forms in our application

- Display and style the current date

- Displaying booking information from the database

- Delete and edit a calendar entry

- Creating our own captcha to the form to protect from bots

- Using prepared statements to prepare against SQL injection attacks

- Implement a Content Security Policy to protect the application against XSS attacks

- Implement various headers to protect the application from malicious use

- Implement Cross-Site Request Forgery(CSFR)


Lectures are explained in great detail so to cater for a wide audience(beginners and intermediate).

Source code included in each lecture.


What You Will Learn!

  • Create a calendar booking application using PHP and MySQL
  • Allow a user to insert, edit and delete a booking entry in the calendar
  • Secure the application using a Content Security Policy(CSP) to prevent XSS attacks, prepared statements to protect against SQL injection attacks
  • Protect the application from bots by building your own captcha and protecting your forms against CSRF attacks
  • Each line of code is described so to beginners and intermediate students can follow along
  • Style the calendar using CSS

Who Should Attend!

  • This course is for anyone wanting to learn PHP and MySQL whether they are at beginner level or intermediate level wishing to brush up on their existing skills
  • Someone who wants to include a calendar booking system into their existing website or application