Start Teaching
Messages
User

PHP and MYSQL Course from Scratch with Projects

Language: English
PHP and MYSQL Course from Scratch with Projects

This Course is for You

7 hours 55 minutes

of video/audio content

1

Downloadable attachment

1 minute

of reading content

PHP is one of the most important programming language in the world that can work on client and server side. . PHP can connect to MYSQL database to make web applications. MYSQL is a database that can store data in tables.This course starts from the beginning of setting up your server and writing your first line of PHP code.  You will gain understanding on how to send and receive information to and from a database.You will learn how to validate your form too. After that i talk about advanced features in PHP and MYSQL and you will learn about how to create register,login and logout system and also how to make image upload system.

This course contains useful project that help you to understand better PHP & MYSQL too.

Projects include:

Table pagination
Sending E-Mail
User Login to system and upload their private photo without access other users to them
how to use Google reCAPTCHA system and how to make it for your own website.


Why should you take this course?

This course helps you to make online web application and can get big projects and also spend much money in your job.


Personal contact with me, the course tutor   
Lifetime access to course materials   
A friendly, informal community to support you every step of the way   
A deep understanding of how to code,work with data base and make web applications

Course Overview

  • 1. PHP-What does the course cover

  • 2. Install WAMP SERVER

  • 3. PHP-Install XAMPP SERVER

  • 4. Text Editors

  • 5. PHP-What is PHP

  • 6. Display Hello World

  • 7. Variables

  • 8. Data Types

  • 9. Strings

  • 10. GET&POST

  • 11. If Statements

  • 12. Switch-Case Statement

  • 13. While Loops

  • 14. For Loops

  • 15. Arrays

  • 16. Function

  • 17. What is MYSQL Database

  • 18. MYSQL Create Database and Tables

  • 19. MYSQL Connect PHP to MYSQL

  • 20. MYSQL Insert DATA to MYSQL Database

  • 21. MYSQL INSERT DATA to MYSQL Database via Form

  • 22. MYSQL Prepare Insert Data

  • 23. MYSQL SELECT Data

  • 24. MYSQL LIMIT Data

  • 25. MYSQL DELETE Data

  • 26. MYSQL UPDATE Data

  • 27. PROJECT- Table Pagination (Preview)

  • 28. PROJECT - Table Pagination (Part 1)

  • 29. PROJECT - Table Pagination (Part 2)

  • 30. PROJECT - Table Pagination (Part 3)

  • 31. PROJECT - Table Pagination (Part 4)

  • 32. Form Validation - Create Form

  • 33. Username Validation

  • 34. Password Validation

  • 35. E-Mail Validation

  • 36. Display error messages on main page

  • 37. Project - Send E-Mail (Preview)

  • 38. Project - Send E-Mail (Part 1)

  • 39. Project - Send E-Mail (Part 2)

  • 40. Project - Send E-Mail (Part 3)

  • 41. Session

  • 42. User Registration

  • 43. User Login & Logout System

  • 44. Hash Password

  • 45. Roles

  • 46. Upload Image

  • 47. Mini Project - Users Upload Image with Login to System

  • 48. Relation between Database

  • 49. Project - Google reCAPTCHA (preview)

  • 50. Project - Google reCAPTCHA

  • 51. What is the next step

  • 52. All Projects