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

[Srbija]

Web App From Scratch - Html5, Css3, Php & Mysql
Last updated 6/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.42 GB | Duration: 17h 7m

Create a hotel reservation web app from scratch with admin panel using 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

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.

Hidden Content

Give reaction to this post to see the hidden content.