Web App From Scratch - Html5, Css3, Php & Mysql

What you'll learn
Building responsive real-world website with HTML5 & CSS3
Create a hotel reservation web app from scratch with admin panel
Learn to Create CMS (Content Management System) using PHP & MySQL
Best and most used SQL queries
PHP from scratch
Working with database
Sign in & sign up
Upload image
Requirements
Taste to learn :)
Description
In this course, you will be able to learn how to use PHP & MySQL to create any project that you would like to. The course covers basics and advanced functions in PHP and also SQL queries such as select / display, update, delete, and so many useful functions. A hotel reservation system is created for the purpose of an example so that you can create your own project after you take this course.You will learn basics and advance PHP such as: data types, strings, functions, loops, arrays, OOP (Object-Oriented Programming). And also best MySQL queries such as: (CRUD (Create, Read, Update, Delete), wildcards, subqueries, connecting more tables together, working with dates, and many more operations for data manipulation in any database) that will help you creating big real-world web application. At the end, you will be able to connect your MySQL database with PHP to create your big projects.Designing, front-end development is very important, this is what the users/customers see, so create beautiful things for the world. We tried to have only HTML & CSS in this course in order to prevent having confusion by learning so many things at once - Take your time, practice, and get ready for more. Avoid having too much information on too many technologies, they are all very nice and useful things to learn and build great apps.All the best with learning!
Overview
Section 1: Introduction
Lecture 1 HTML5 & CSS3 - Introduction
Lecture 2 Introduction
Section 2: HTML5
Lecture 3 Starting
Lecture 4 Structure of HTML5
Lecture 5 Tags
Lecture 6 Path link
Lecture 7 HTML5 rules
Lecture 8 New semantic elements
Lecture 9 Physical styles
Lecture 10 Lists - Ordered & Unordered
Lecture 11 Adding images
Lecture 12 Adding tables
Lecture 13 Adding forms
Lecture 14 Forms: Get vs Post
Lecture 15 Form: selection list
Lecture 16 Audio & Video
Lecture 17 div vs span
Section 3: CSS3
Lecture 18 Linking CSS
Lecture 19 CSS simple selectors
Lecture 20 CSS Pseudo-selectors & Attributes
Lecture 21 Useful units
Lecture 22 Padding & Margin
Lecture 23 Transition & Transform
Lecture 24 Shadow
Lecture 25 @media query
Lecture 26 div inline-block
Lecture 27 Flex layout
Lecture 28 Grid layout
Lecture 29 Position
Section 4: Use HTML5 & CSS3 to build our website
Lecture 30 Adding navigation bar
Lecture 31 Cleaning up the section
Lecture 32 Create Parallax
Lecture 33 Footer & name anchor
Lecture 34 Editing contact page
Lecture 35 Designing the form
Lecture 36 Finishing the form
Lecture 37 Finishing & overlay effect
Lecture 38 Clone / Download the project
Lecture 39 Before moving to next section (PHP)
Section 5: PHP
Lecture 40 Installation
Lecture 41 Clone the repository
Lecture 42 Preparation
Lecture 43 Basic syntax
Lecture 44 Variables
Lecture 45 Concatenation
Lecture 46 Data type with var_dump()
Lecture 47 PHP Operators
Lecture 48 Strings
Lecture 49 If else condition
Lecture 50 If else example with html form
Lecture 51 More with if else statements
Lecture 52 Switch operator
Lecture 53 Switch operator example with date
Lecture 54 For loop
Lecture 55 For loop - Solution
Lecture 56 While & do...while
Lecture 57 Functions
Lecture 58 Try...Catch
Lecture 59 Array
Lecture 60 Array & for...each loop
Lecture 61 Associative array
Lecture 62 File handling
Lecture 63 File handling - fopen, fread, fwrite
Lecture 64 File handling - append
Lecture 65 File handling - delete
Lecture 66 File handling - CSV
Lecture 67 File handling - file_get_content & glob
Lecture 68 Cookie - set_cookie
Lecture 69 Cookie - delete_cookie
Lecture 70 Session
Lecture 71 Session with example
Lecture 72 Filter & Sanitize
Lecture 73 OOP (Object-Oriented Programming)
Lecture 74 OOP - Explained
Lecture 75 OOP - Constructor & Destructor
Lecture 76 OOP - Access modifiers
Lecture 77 OOP - Inheritance
Lecture 78 OOP - Overriding & final keyword
Lecture 79 OOP - Constants
Lecture 80 OOP - Interfaces
Lecture 81 OOP - Static methods
Lecture 82 OPP - Namespaces
Section 6: MySQL
Lecture 83 Starting with MySQL
Lecture 84 Create database
Lecture 85 Schema - what we will build
Lecture 86 Create & describe table
Lecture 87 Create other tables
Lecture 88 Foreign key
Lecture 89 Insert data
Lecture 90 Alter table
Lecture 91 Select from more table with join
Lecture 92 Joins overview
Lecture 93 Where clause, order by, & alias
Lecture 94 Aggregate functions
Lecture 95 Limit & offset
Lecture 96 Useful operations
Lecture 97 Working with dates - datediff
Lecture 98 Working with dates - interval
Lecture 99 Subquery & Group by
Lecture 100 Wildcards
Lecture 101 In & Not in
Lecture 102 Select from more tables
Lecture 103 Select total
Lecture 104 Delete
Lecture 105 Delete with subquery
Lecture 106 Update
Lecture 107 Drop / delete table
Section 7: The project
Lecture 108 Starting the project
Lecture 109 Adding thumb column
Lecture 110 Connect PHP to the MySQL database
Lecture 111 Display data from the database to our website
Lecture 112 Displaying rooms from our database
Lecture 113 Displaying detail of specific room
Lecture 114 Adding description column
Lecture 115 Display data from db on a table
Lecture 116 Sign in preparation
Lecture 117 Sign up preparation
Lecture 118 Sign in - hash password & filter inputs
Lecture 119 Sign in - Finishing
Lecture 120 Page view access - header location
Lecture 121 Sign up with procedural statements
Lecture 122 Preparation for reservation
Lecture 123 Reservation
Lecture 124 Practice something good
Lecture 125 User profile page - add view restriction
Lecture 126 Finishing user profile page - let user edit his info
Lecture 127 Display reservations for logged in user
Section 8: Dashboard - Admin panel
Lecture 128 Starting the admin panel
Lecture 129 Admin login
Lecture 130 File upload preparation
Lecture 131 File upload - restrict non-acceptable file types
Lecture 132 File upload - finishing
Lecture 133 Last notes
Lecture 134 Next
Website developer,Database manager / administrator


Homepage

https://www.udemy.com/course/web-app-from-scratch-ii-php-mysql/