Create a Calendar Booking system in PHP and MySQL

Focused View

Filipe Santos

5:37:34

10 View

1. Introduction

1.1 course outline.pptx

1. Course outline.mp4

06:29

2. Demo of the application.mp4

05:16

3. Requirements.mp4

02:53

2. Creating the calendar functionality

1.1 (3) creating the calendar.txt

1. Creating the calendars basic skeleton.mp4

28:52

2.1 (4) styling the calendar.txt

2. Styling the calendar.mp4

25:13

3.1 (5) Setting up the database.txt

3. Setting up the Database.mp4

07:45

4.1 (6) event file.txt

4.2 (6) index file.txt

4. Insert calendar entry.mp4

51:14

5.1 (7) Form sanitization and validation.txt

5. Form sanitization and validation.mp4

17:28

6.1 (8) styling the form.txt

6. Styling the form.mp4

10:25

7. Creating the calendar functionality QUIZ.html

3. Securing the Application and development continued

1.1 (9) Add a captcha to the form.txt

1. Add a captcha to a form.mp4

14:02

2. Captcha QUIZ.html

3.1 (10) Display current event in form.txt

3. Display current event in form.mp4

14:19

4. Display current event in form.html

5.1 (11) Protect app from XSS attacks with a CSP.txt

5. Protect app from XSS attacks with a Content Security Policy(CSP).mp4

42:23

6. CSP QUIZ.html

7.1 (12) Display current date.txt

7. Display current date.mp4

10:52

8.1 (13) Deleting a calendar entry.txt

8. Deleting a calendar entry.mp4

20:51

9. QUIZ.html

10.1 (14) Confirmation dialog before delete.txt

10. Confirmation dialog before delete.mp4

04:12

11.1 (15) Editing a calendar entry.txt

11. Editing a calendar entry.mp4

32:30

12.1 (16) CSRF attack example.txt

12.2 (16) csrf attack.zip

12.3 (16) CSRF attacks.txt

12. Cross-Site Request Forgery(CSRF) attacks.mp4

31:29

13. CSRF QUIZ.html

4. Conclusion

1.1 Conclusion.txt

1. Conclusion.mp4

11:21

Description

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

What You'll 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 is this for?

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

What You Need to Know?

There is no programming experience required for taking this course although a basic knowledge in some programming language would be beneficial such as arrays, variables, operators. We will be diving into the code in quite detail so even a beginner learning PHP would understand.

Some interest in Web development

More details

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.

Who this course is for:
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

User Reviews

Rating

average 0

Total votes0

Focused display

PHP

App Development

MySQL

Filipe Santos

Instructor's Courses

Hi everyone,I've taught Computing for 4 years in Colleges, community centres and privately.Currently I'm working 4 hours per week building websites in PHP and Wordpress for a company called footnotesvmt.I'm also teaching English as a foreign language to refugees from the Ukraine and Syria.I'm passionate about Web development and God who is a big part of my life.I love cycling, going to the cinema and travelling.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.