Php Fundamentals and Mysql- part 1 (core/structure Php)
Training
In London
Description
-
Type
Training
-
Level
Beginner
-
Location
London
-
Duration
Flexible
-
Start date
Different dates available
This course is suitable for non-programmers and software developers at a beginning level. PHP Fundamentals (Part 1) provides you with an overview of the PHP language, main concepts, and helps you develop and adopt the methodologies and best practices of coding professionally in PHP. It is designed to provide beginner programmers with a solid foundation in the PHP language
Please note that this course does not cover anything regarding to object oriented programming. You will learn about object oriented programming in ‘PHP Fundamentals - Part 2 (OOP)’ which is designed for experienced PHP programmers.
Facilities
Location
Start date
Start date
About this course
This course guides you through the basics of PHP with an experiential approach, filled with numerous examples and hands-on exercises. In this course, you will also learn about the relational database management system and how to connect and work with MySQL database.
This course is designed for non-programmers and beginners with less or no software Development experience who want to learn the basics of the PHP language. Web designers who intend to learn the basics of professional web programming and become PHP Developers would benefit from this course.
It is highly recommended that you have a strong command over HTML and CSS before starting this course.
Reviews
Subjects
- Object oriented training
- Object-oriented training
- PHP
- MySQL
- Database
- Database training
- Programming
- Object oriented Programming
- Oriented Programming
- Loops
Course programme
COURSE OUTLINE:
1. INTRO TO PROGRAMMING
1.1. Language and the Logic of Programming
1.2. Types of Programming Languages and Vocabulary
1.3. What is PHP
1.4. Why use PHP
1.5. Installing AppServ, WAMP, XAMPP
1.6. Client/Server Communications
2. PHP LANGUAGE BASIC SYNTAX
2.1 Opening and Closing Tags
2.2 echo and print commands
2.3 embedding PHP in HTML
2.4 embedding HTML in PHP
2.5 Comments
3. PHP VARIABLES
3.1 How to declare variable and assign value
3.2 General rules for writing variable name
3.3 Introduction to different data types
3.4 How to use gettype() and settype() functions
3.5 Introduction to Constants
4. PHP OPERATORS
4.1 Assignment Operator
4.2 Concatenation Operator
4.3 Combined Assignment Operator
4.4 Comparison Operator
4.5 Logical Operator
4.6 Increment, Decrement Operator
5. SUPER-GLOBAL ARRAYS
5.1 $_SERVER
5.2 $_POST
5.3 $_GET
5.4 $_SESSION
5.5 $_FILES
6. CONDITIONAL STATEMENTS
6.1 IF Statement
6.2 IF-Else Statement
6.3 If-ElseIf-Else Statement
6.4 Switch Statement
7. LOOPS
7.1 For Loop
7.2 While Loop
7.3 Do-While Loop
7.4 Break and Continue statements in loop
7.5 Nested Loop (loop inside loop)
8. LOOPS
8.1 For Loop
8.2 While Loop
8.3 Do-While Loop
8.4 Break and Continue statements in loop
8.5 Nested Loop (loop inside loop)
9. STRING FUNCTIONS
- strlen()
- trim()
- ucfirst()
- ucwords()
- strtoupper()
10. DATE AND TIME FUNCTIONS
10.1 Date() Function
10.2 Time() Function
10.3 Parameters (Y,y,M,m,D,d,F,A,a,h,i,s).
11. ARRAYS
11.1 Difference between Array and Variable
11.2 How to define an array
11.3 Associative Array
11.4 Multi-dimensional Array
11.5 Foreach Loop
11.6 Print_r() function
12. ARRAY FUNCTIONS
- count()
- is_array()
- sizeof()
- in_array()
- array_merge()
13. FUNCTIONS
- strtolower()
- strstr()
- substr()
- addslashes()
- htmlspecialchars()
- str_replace()
- str_repeat()
- Md5
- array_push()
- array_shift()
- array_pop()
- sort()
- array_sum()
13.1 What are functions.
13.2 How to write a function.
13.3 Using arguments or Parameters
13.4 Variable Scope
Variable inside function
Variable outside function.
14. PHP SESSIONS
14.1 What are sessions?
14.2 How session works?
14.3 How to start and destroy a session?
14.4 ob_start() function.
15. PHP FILE HANDLING
- fopen()
- fread()
- fclose()
- fwrite()
In this part of the course you will learn about the Relational Database Management Systems
(RDBMS), MySQL Database and how to work with MySQL database.
16. PHP DATABASE BASICS
16.1 Introduction to Relationship Databases
16.2 Introduction to MySQL
16.3 Introduction to MySQLi and PDO
16.4 Connecting MySQL database with PHP
16.5 CRUD (Create, Read, Update, Delete Records)
Php Fundamentals and Mysql- part 1 (core/structure Php)