Course Content
-
Basic PHP
- course requirements
- Downloading and installing XAMPP
- How to create the file and some information about PHP
- PHP script some tips about html
- Introduction to phpStorm
- Comments and case sensitive
- PHP variables
- Data types in PHP
- Concatenation in PHP
- Arithmetic Operator
- Comparison Operators
- if and else in PHP
- else if in PHP
- switch statement in PHP
- functions in PHP
- Passing arguments by calling a function
- Return type in PHP
- Local and global variables
- Echo and print functions in PHP
- for loop in PHP
- While and do while loop
- Exit and die in php
- Function in php
- Arguments and return type in php
- Arrays in php
- Associative arrays
- Fetching the values from array by suing the loops
- Sorting the arrays by using the functions
- Global variables
- Server variable
- $_POST variable in php
- GET variable in php
- Form handling in php
- Validation the html forms
- Strip_tag function in php
- Multidimensional arrays
- Time and date in php
-
Object Oriented Programming(OOP) OR PHP5
- OOP in php
- Classes, properties, objects
- Classes, properties, objects part 2
- Constructor
- Inheritance in object-oriented php
- Method overriding in php
- Access Modifiers in php
- Access Modifiers part 2 in php
- Scope Resolution operator in php
- Interfaces in php
- Final Keyword in php
- Abstract class and method in php
-
SQL
- Introduction to SQL
- Introduction to RDBMS
- Basic syntax
- SQL and NO-SQL databases
- Introduction to mysql database and tools
- Creating database and table
- Select statement in SQL
- select distinct statement in SQL
- Where Clause in SQL
- SQL And, OR, not operators
- Order by keyword in SQL
- Insert statement in SQL
- NULL values in SQL
- Update statement in SQL
- Delete statement in SQL
- IN operator in SQL
- SQL Alias
- Between operator in SQL
- Min,Max,Sum,Count,Avg in SQL
- Like in SQL
- Introduction to join and creating the second tables
- Inner Join in SQL
- Left join in SQL
- Group by in SQL
- Having clause in SQL
- PHP tutorials introduction to subquery in SQL
- PHP tutorials creating the Databases
- PHP tutorials creating the tables in SQL
- PHP tutorials alter Columns in SQL
- PHP tutorials SQL constraints in SQL
- PHP tutorials conclusion
-
CodeIgniter
- Course Detail and Requirements
- Downloading and installing CodeIgniter
- Folder Structure and application flow chart
- Introduction to MVC(Model View Controller)
- Working with controllers
- Working with Views
- Working with models
- URLStructure in CodeIgniter
- What are helpers and URL helper
- Form helpers in codeigniter
- Input class in Codeigniter
- CAPTCHA helper and download helper
- HTML helper
- Alternate PHP Syntax for View Files and PHP Style guide
- String and Text helper
- Inflector helper
- Introduction to Libraries and Benchmarking class
- Calendaring library
- Shopping Cart library
- Encrypt class and encryption library in CodeIgniter
- Introduction to autoload.php
- Upload library in Codeigniter
- Form validation in Codeigniter
- Session library in codeigniter
- Introduction to database and ORM and setting the database
- Creating our first table adding some data
- SELECT, FROM, WHERE and get_where in Codeigniter
- MIN,MAX,AVG,SUM in codeIgniter
- Where_in, Like, Or_like in Query builder
- Order_By limit offset in CodeIgniter
- Insert in Codeigniter
- Update and delete using Query Builder
- Introduction To query helper and overview of database section
- Create another table and joining theme
- Chaining in query builder
- Form fro CRUD operation to insert
- Showing all the records to the user_admin
- Edit Record in CRUD section
- Deleting students in CRUD section
- Why we beak our HTML content into multiple views
- Adding CSS and JS files and what about Plugins
- Adding Bootstrap 4 inside our project.
- Creating Signup form
- Sending the link to the user’s email address
- Activating the User