PHP WITH MYSQL

PHP WITH MYSQL


₹ 5000

    

60 HRS

As per the reports, the latest version of PHP is 7.2 while in case of MYSQL is 5.6 and it is important to learn them because one can use them efficiently to implement the desired back-end design. The course will provide a complete clarification of the modules, helping the students to gather more knowledge. According to resources, PHP is one of the leading media through which one can modify as well as manipulate databases. Learning PHP with MYSQL is obviously beneficial as MYSQL is one of the most popular database systems which are used along with PHP. MYSQL is designed to run on the web as well as the server, it can handle magnanimous operations and it is free to download which makes it easy to use. This course will brief the student about variables, loops, and switch, arrays, and functions, introduction to MYSQL, bridging PHP with MYSQL, session, and string handling in PHP and much more Prerequisites: Basics of programming language

Syllabus

Overview

1. Overview of web
2. What is PHP
3. Installing php
4. Overview of web server
5. PHP connectivity to IIS/Apache
6. Php.ini file
7. Running the first script in php
8. Exercise

A Variables and Operators

Variables
1. Dynamic Variables
2. References to Variables
3. Data Types
4. Changing Type with settype()
5. Changing Type by Casting
6. Operators and Expressions
7. The Assignment Operator
8. Arithmetic Operators
9. The Concatenation Operator
10. More Assignment Operators
11. Comparison Operators
12. Creating More Complex Test Expressions with the Logical
13. Operators
14. Automatically Incrementing and Decrementing an Integer
15. Variable
16. Operator Precedence
17. Exercise

B if else, switch

1. Constants
2. Predefined Constants
3. Switching Flow
4. The if Statement
5. Using the else Clause with the if Statement
6. Using the elseif Clause with the if Statement
7. The switch Statement
8. Using the ? Operator
9. Exercise

C Loops and functions

1. Loops
2. The while Statement
3. The do..while Statement
4. The for Statement
5. Breaking Out of Loops with the break Statement
6. Skipping an Iteration with the continue Statement
7. Nesting Loops
8. Functions
9. Overview
10. What Is a Function?
11. Calling Functions
12. Defining a Function
13. Returning Values from User-Defined Functions
14. Exercise

D functions contd and arrays

1. Dynamic Function Calls
2. Variable Scope
3. Accessing Variables with the global Statement
4. Saving State Between Function Calls with the static Statement
5. More About Arguments
6. Setting Default Values for Arguments
7. Passing References to Variables to Functions
8. Overview of Array
9. What Is an Array?
10. Creating Arrays
11. Defining Arrays with the array() Function
12. Defining or Adding to Arrays with the Array Identifier
13. Associative Arrays
14. Defining Associative Arrays with the array() Function
15. Directly Defining or Adding to an Associative Array
16. Exercise

E Multidimensional Arrays and array functions

1. Multidimensional Arrays
2. Accessing Arrays
3. Getting the Size of an Array
4. Looping Through an Array
5. Looping Through an Associative Array
6. Outputting a Multidimensional Array
7. Manipulating Arrays
8. Joining Two Arrays with array_merge()
9. Adding Multiple Variables to an Array with array_push()
10. Removing the First Element of an Array with array_shift()
11. Slicing Arrays with array_slice()
12. Exercise

F Working with Forms
1. Working with Forms
2. Overview
3. Global and Environment Variables
4. A Script to Acquire User Input
5. Accessing Input from Multiple SELECT Elements
6. Accessing All the Fields from a Form in an Associative Array
7. Distinguishing Between GET and POST Transactions
8. Combining HTML and PHP Code on a Single Page
9. Using Hidden Fields to Save State
10. Redirecting the User
11. File Upload Forms and Scripts
12. Exercise


G Mysql Introduction and SQL

1. MySQL
2. Overview
3. A (Very) Brief Introduction to SQL
4. Using mysql from windows
5. Creating table
6. Inserting records in table
7. Deleting records fromle
8. Updating table
9. Altering table
10. Commit and rollback
11. Selecting records
12. Exercise

H PHP with MYSQL

1. Database integration with PHP
2. Connecting to the Database Server
3. Selecting a Database
4. Finding Out About Errors
5. Adding Data to a Table
6. Acquiring the Value of an Automatically Incremented Field
7. Accessing Information
8. Finding the Number of Rows Found by a Query
9. Accessing a Resultset
10. Changing Data
11. Getting Information About Databases
12. Listing Databases
13. Listing the Tables Within a Database
14. Listing and Exploring Fields
15. Database Structure� Bringing It All Together
16. Exercise

I Datatype and strings handling

1. Working with Data
2. Overview
3. Data Types Revisited
4. A Recap
5. Converting Complex Types
6. Automatic Conversion of Data Types
7. Testing Data Types
8. Working with Strings
9. Formatting Strings
10. Working with printf()
11. printf() and Type Specifiers
12. Padding Output with the Padding Specifier
13. Specifying a Field Width
14. Specifying Precision
15. Conversion Specifications: A Recap
16. Storing a Formatted String
17. Exercise

J Sessions handling in PHP

1. What Are Session Functions?
2. Starting a Session with session_start()
3. Working with Session Variables
4. Destroying Sessions and Unsetting Variables
5. Passing Session IDs in the Query String
6. Encoding and Decoding Session Variables
7. Checking that a Session Variable Is Registered
8. Using sessions in forms for projects
9. Exercise


Project Discussion