bdsuman/basic-php-to-advance-laravel

Laravel has been the rock star of PHP application development for many years and with a good reason. Huge ecosystem, active community, strong job market, successful startups — it has everything that makes it worthwhile to adopt a new technology.

Basic-PHP-to-Advance-Laravel

Class 01

Click Here For Details

Github

• What is Git & Github

• Why need Git & Github

• Git bash Downloads & Installation

• Create an Account on Github

• Create project Local to Online

• Create Project Online

• How to fork any github project from another account.

IDE / Code Editor

• Vs Code Downloads

• Vs Code Editor keyboard shortcuts

• Important Package installation

Class Resource

From the very beginning, we have to know about git & github to showcase our daily practice and work for future use.

And secondly we have to know about vs keyboard shortcuts to save our time in coding, and install essential packages for extra facilities in vs code.

• Git bash Downloads - https://git-scm.com/downloads

• Create your github account - https://github.com/

• Create project Local to Online - https://github.com/rafiswe/Github-Tutorial/blob/master/Create-local-to-online.txt

• Create Project Online - https://github.com/rafiswe/Github-Tutorial/blob/master/Create-online-repository.txt

• Vs Code Downloads - https://code.visualstudio.com/download

• Vs Code Editor keyboard shortcuts - https://code.visualstudio.com/shortcuts/keyboard-shortcuts-windows.pdf

Important Package installation

• Html snippet

• Html css support

• Intellisense for css class names in html

• Auto close tag

• Auto rename tag

• Beautify

• Bracket pair colorizer

• Php intellisense

• Php namespace resolver

• Alignment

Class 02

Click Here For Details

PHP Language.

• History of php

• How does php work

• Power of php

Environment setup, Code Structure & Run Code

• Server setup

• Code syntax & run code

• How to write Php code in html.

Variable

• What is Variable?

• Declaration rules of common variables.

• Declaration rules of Constant variables.

• Different between variable & constant.

Print Way

• Concat string, inverted comma.

• echo, Printf, sprintf

Different types of Data types

• Most commonly used scalar (মৌলিক) data types - (String, Integer, float, Boolean)

• Compound (যৌগিক) data types - (Array, Object)

• Null, Resource

Resource

Please search by keyword which is given on overview and know more from google. Here is just the w3school link. You can learn more from javatpoint, tutorialspoint etc.

• A variable starts with the $ sign, followed by the name of the variable

• A variable name must start with a letter or the underscore character

• A variable name cannot start with a number

• A variable name can only contain alpha-numeric characters and underscores (A-z, 0-9, and _ )

• Variable names are case-sensitive ($age and $AGE are two different variables)

• Ref. Link Variable - https://www.w3schools.com/php/php_variables.asp

Declaration rules of constant variables:

• define(name, value, case-insensitive)

• name: Specifies the name of the constant

• value: Specifies the value of the constant

• case-insensitive: Specifies whether the constant name should be case-insensitive. Default is false

• Ref. Link Variable - https://www.w3schools.com/php/php_constants.asp

• Echo & Print - https://www.c-sharpcorner.com/UploadFile/051e29/types-of-print-function-in-php/

• Data types - https://www.w3schools.com/php/php_datatypes.asp

Class 03

Click Here For Details

Operators and its types in php

Arithmetic (গাণিতিক অপারেটর)

Arithmetic operators are used to perform arithmetic on numbers:

| Operator | Description                  |
| -------- | ---------------------------- |
| +        | Addition                     |
| -        | Subtraction                  |
| *        | Multiplication               |
| **       | Exponentiation               |
| /        | Division                     |
| %        | Modulus (Division Remainder) |
| ++       | Increment                    |
| --       | Decrement                    |

Assignment (নির্ধারণ অপারেটর)

=, +=, -=, *=, /=

Comparison (তুলনা)

==, !=, ===, !==, < (less), > (greater), <=, >=

Increment / decrement

++a, a++, --a, a--

Logical and others

!, &&, ||

Statements

• If

• Else

• Else if

• Switch

Resource

Operators and its types in php

Arithmetic (গাণিতিক অপারেটর)

• R Link: https://www.javatpoint.com/php-operators#Arithmetic

Assignment (নির্ধারণ অপারেটর)

• https://www.javatpoint.com/php-operators#Assignment

Comparison (তুলনা)

• R Link: https://www.javatpoint.com/php-operators#Comparison

Increment / decrement

• R Link: https://www.php.net/manual/en/language.operators.increment.php

Logical and others

• Link: https://www.javatpoint.com/php-operators#Logical

Class 04

Click Here For Details

loop

• Operator: Increment (++) and Decrement (--)

• For Loop

• While loop

• Do while

• Foreach

Resource

Operator: Increment (++) and Decrement (--)

• https://www.php.net/manual/en/language.operators.increment.php

For Loop

• https://www.javatpoint.com/php-for-loop

While loop

• https://www.javatpoint.com/php-while-loop

Do while

• https://www.javatpoint.com/php-do-while-loop

-Exercises: https://codeforwin.org/2015/06/for-do-while-loop-programming-exercises.html

Foreach

• https://www.javatpoint.com/php-foreach-loop

Class 05

Click Here For Details

Different types of Array

• Keyword: break, continue

• Indexed array

• Associative array

• Multidimensional array

Resource

1. Break, continue keyword

• https://www.javatpoint.com/php-break

• https://www.javatpoint.com/php-continue

2. Indexed array

• https://www.javatpoint.com/php-indexed-array

3. Associative array

• https://www.javatpoint.com/php-associative-array

4. Multidimensional array

• https://www.javatpoint.com/php-multidimensional-array

Class 06

Click Here For Details

Array Function

• count(which_array), sizeof(which_array)

• max(which_array), min(which_array)

• in_array(which_you_want_search, from_which_array, strict_mode)

• array_search(which_you_want_search, from_which_array)

• array_pop(from_which_array) - for delete last element

• array_push(which_array, new_value) - add element on last

• array_merge(all_arrays) - make a new array by merging multiple array

• array_slice(from_which_array, from_index, total_element) - make a new array by taking some element from an array.

• array_splice(from_which_array, from_index, total_element) - remove array element from an this array

• array_diff(first_array, second_array)

• array_unique(which_array)

• array_sum(which_array)

Resource

• https://www.php.net/manual/en/ref.array.php
• https://www.w3schools.com/php/php_ref_array.asp

Class 07

Click Here For Details

More Array functions

• array_rand(from_which_array, how_many_element) - pick random keys
• shuffle(which_array) - randomize order of array elements
• array_chunk(which_array, how_many_element, keys_sequence) - Split an array into chunks
• asort(which_array, sort_rule) - sort ascending order, arsort(which_array, sort_rule) - sort descending order,
• ksort(which_array, sort_rule) - sort keys by ascending order, krsort() - sort keys by descending order
• implode(separator_symble, which_array) - Join array elements with a string (array to string)
• explode(separator_symble, which_string, element_limit) - String to array

Write php code on html

Project based on array

Mini Project - Product List (table/E-commerce)

Resource

• More array Functions

• https://www.php.net/manual/en/ref.array.php

• Writing php code in html

• https://www.php.net/manual/en/control-structures.alternative-syntax.php

• https://stackoverflow.com/questions/10258345/php-simple-foreach-loop-with-html

Class 08

Click Here For Details

Class 8 Overview

1. User defined Functions

• What is function & Why we use it.

• Way to create user defined functions.

• Parameter, Argument, Return

• Mini Project - Execute a common work using function

2. Built in String functions

• Strlen()

• Str_word_count()

• Strpos()

• Substr()

• str_split()

• Str_replace()

• Strtoupper()

• Strtolower()

• Str_shuffle()

• md5()

• money_format()

• number_format()

• htmlspecialchars()

• strip_tags()

• trim()

Class Resource

1. User Defined Function

• https://www.php.net/manual/en/functions.user-defined.php

• https://www.w3schools.com/php/php_functions.asp

2. Built in String functions

• https://www.php.net/manual/en/ref.strings.php

• https://www.w3schools.com/php/php_ref_string.asp

Class 09

Click Here For Details

Class 9 Overview

1. Some essentials things

• isset, empty, die

• Undefined, empty / flag, null, array variable

2. Form Handling

• Set Method - for getting form data

• Set Action - for sending data

• Set Field Name - for getting form data by field name

• Receive Form Value by supper global variable - $_GET, $_POST, $_REQUEST

• Get Method vs Post Method

• Form isset

• Primary Validation message.

Class Resource

1. Some essentials things

• https://www.php.net/manual/en/function.empty.php

• https://www.php.net/manual/en/function.isset

• https://www.php.net/manual/en/function.die

2. Form Handling

• https://www.w3schools.com/php/php_forms.asp

2. Github Link

• https://github.com/rafiswe/PHP-Form-Handling

Class 10

Click Here For Details

Project

Form Handling

• Validate - Set Dismissable alert message

• Validate - filter email or not

• Validate - valid email check function

• Validate - edu email check function

Resource

1. Form Handling

• https://www.w3schools.com/php/php_forms.asp

2. Github Link

• https://github.com/rafiswe/PHP-Form-Handling

Class 11

Click Here For Details

Form Handling

Topic

1. Form Handling

• Validate - age validate function

• Validate - username validate function

• Validate - keep old data in fields.

• Validate - clear field data after success

• Validate - auto suggestion off

• Field - radio button

• Field - Checkbox field

• Field - select option field

Resource

1. Form Handling

• https://www.w3schools.com/php/php_forms.asp

2. Github Link

• https://github.com/rafiswe/PHP-Form-Handling

Class 12

Click Here For Details

Practice class 12

Create a own design of company website

Template it

Class 13

Click Here For Details

Assignment

Practice class 13

• Create a Database name user_information.

• In Users table 7 column: id , username , age , phone, address, created_at, updated_at

• In Products table 7 column: id, post_title , post_details, post_file, created_at, updated_at, deleted_at

• In comments table 3 column: id, post_id, comment, created_at, updated_at, deleted_at

• make a single & multiple insert query for every table.

• Make a update query and also make a delete query for every table

• Now create a text file and write all sql query there and submit github repo link

Resource

Data Types in sql

• https://www.tutorialspoint.com/mysql/mysql-data-types.htm

Data CRUD into a table

• https://www.w3schools.com/sql/sql_insert.asp

• https://www.w3schools.com/sql/sql_update.asp

• https://www.w3schools.com/sql/sql_delete.asp

• https://www.w3schools.com/sql/sql_select.asp

Class 14

Click Here For Details

Title

Create a Database name user_information.

• In Users table 5 column: id , username , age , phone, address, salary , country ,created_at, updated_at

• Find users who live in same country

• Show data by high to low salary

• Show data who get the highest salary

• Show data who get the lowest

• Show how many table you have

• Show me how many users get a salary range of ( 5000 -15000).

Resource

• https://www.w3schools.com/mysql/mysql_select.asp

Class 15

Click Here For Details

Table Joining

MySql Join Table

• Left join

• Right join

• Inner join

• Relation

• Group By

• Having

Class 16

Click Here For Details

Portfolio Website

Given Website Find Draw Database Design

Class 17

Click Here For Details

Title

Sub Title