Praktik pengembangan software berbasis web menggunakan bahasa pemrograman PHP. Dilengkapi dengan pembahasan studi kasus terkait penerapan konsep pemrograman berbasis objek, pembuatan functions, arrays & error handling, penerapan cookie untuk session, dan pembuatan query transaksi MySQL yang lebih efisien.
CONTENT
1. Introduction to PHP
1.1. PHP Facts
1.2. PHP Development Tools
1.3. PHP Syntax
2. Using Variables & Output Statements
2.1. Variables in PHP
2.2. Echo and Print Statement
2.3. PHP Superglobals
2.4. Functions in PHP
3. PHP – Building Blocks
3.1. PHP Conditional Statements
3.2. Loops in PHP
3.3. Switch Case Statement in PHP
4. Data Sending Ways in PHP
4.1. Using Form Methods
4.2. The POST Method
4.3. Using Query String
5. String Functions in PHP
5.1. String Concatenation Operator
5.2. Using the strlen() Function
5.3. Using the strpos() Function
5.4. The explode() Function
5.5. The substr() Function
5.6. The md5( ) Function
5.7. The trim() Function
5.8. The str_replace() Function
6. Date Functions in PHP
6.1. The DateTime Class in PHP
6.2. The PHP time()
6.3. PHP Timezones
7. Arrays in PHP
7.1. Introduction to Arrays
7.2. Sorting of Arrays
7.3. Associate Arrays
8. Sanitize Functions in PHP
8.1. Sanitize Functions
8.2. Validation Functions
9. Introduction to MYSQL / Mariadb
9.1. Introduction to Relational Databases
9.2. Data Types in Mysql / Mariadb
9.3. Types of Mysql/ MariadbTables
9.4. Some Popular MySQL Commands
9.4. Working with MYSQL / Mariadb Database
9.5. Aggregate Functions in MYSQL
9.6. Using Group by Clause
9.7. Subqueries in MYSQL
10. Sending Data to Mariadb
10.1. Design a HTML Page Containing HTML Form Fields
10.2. Receive Form Field Data to the PHP Page Using $_GET,
$_REQUEST or $_POST
10.3. Prepare a Database Connection
10.4. Place Appropriate Query to Insert Record into Mysql Table
11. Retrieving Data from Mariadb
11.1. Learn How to Retrieve Data from Mariadb to PHP Pages
11.2. Some Popular Methods to Retrieve Records from the Dtabase in PHP
12. Error Handling in PHP
12.1. Errors Types
12.2. Using die() function
12.3. Some Possible Errors in PHP
12.4. Creating a Custom Error Handler
12.5. Using include() Function
12.6. Difference Between Include and Require
12.7. PHP Errors – Troubleshooting
13. Working with Images
13.1. Create HTML Code
13.2. Error Messages
13.3. Make Uploaded Images, Your Profile Image
13.4. PHP File Upload & Security
14. Cookies / Session in PHP
14.1. Cookies
14.2. Sessions
14.3. Cookie Example
14.4. Session Example
15. Sending mail in PHP
15.1. Syntax
15.2. Example to Create Enquiry Form for the Website
15.3. Example to Create and Send Activation Code to Activate an User
Profile
16. Object Oriented Programming
16.1. Some Advantages of Using OOP
16.2. Important Terms Related to Object Oriented Programming
16.3. Define a PHP Class and Object
16.4. Naming a Class
16.5. What is Constructor?
16.6. The $this Keyword
16.7. Access Specifiers or Visibility Mode in PHP
16.8. PHP OOPs Inheritance
16.9. Static Methods and Properties in PHP
16.10. Static Properties or Variables
16.11. Getter and Setter in PHP
17. Mysql Joins and Index
17.1. MVC (Model-View-Controller) in PHP
17.2. The Model
17.3. The View
17.4. The Controller
17.5. MVC Program Flow
17.6. A Simple MVC Program
18. MYSQL Triggers and Procedures
18.1. INNER JOIN OR Simple join
18.2. LEFT OUTER JOIN
18.3. RIGHT OUTER JOIN
18.4. Assignments for the practice
18.5. MYSQL Indexes
18.6. Query To View Index in a Table
18.7. Query To Drop Index Command
18.8. Clustered Index
18.9. Primary key, Not null and Clustered index
18.10. Non-Clustered vs Clustered Index
18.11. Mysql – Stored Procedure
18.12. Store Procedure with Parameters
18.13. To Execute Procedure proc
18.14. MySQL Loop in Stored Procedures
18.15. MYSQL – Triggers
18.16. Advantages of Using SQL Triggers
18.17. Disadvantages of Using SQL Triggers
18.18. Two Types of Trigger
18.19. DROP A TRIGGER
19. MYSQL Transactions
19.1. Why Transaction is Required in Database
19.2. Atomicity
19.3. Consistency
19.4. Isolation
19.5. Durability
20. PHP AJAX
20.1. Introduction
20.2. How Ajax Works
20.3. The XMLHttpRequest Object
20.4. Popular XMLHttpRequest Methods
20.5. XMLHttpRequest Properties
20.6. Sending a Request to the Server
20.7. Steps of AJAX Operation
20.8. Sample Code
21. Hosting Your Website
21.1. Servers (DNS Servers)
21.2. Domain Name
21.3. Web Hosting
21.4. Types Of Web Hosting
21.5. Storage Space and Bandwidth
21.6. Bandwidth
21.7. Supported Languages
21.8. Supported Databases
21.9. A MySQL Database
21.10. Server Control and Access
21.11. Administration GUIs
22. PHP Pagination
22.1. A Simple Example to Fetch Records Using LIMIT to Generate Paging
23. Bootstrap Framework
23.1. Installation Guide
23.2. Sample Code: Installing Bootstrap
23.3. Some Major Classes available in Bootstrap 3
23.4. Bootstrap 4: What’s New in Bootstrap 4
23.5. New Classes in Bootstrap 4
23.6. Forms
23.7. Grid System
23.8. Images
23.9. Tables
23.10. Forms
23.11. Buttons
23.12. Panels
23.13. Example – Using Container, Jumbotron, Well, Button, Text Classes
23.14. Example: Image Classes in Bootstrap
23.15. Example: Understanding Grid System –Rows & Cols
23.16. Panel in Bootstrap
23.17. Table Example in Bootstrap
23.18. Nav-bar Example
23.19. Sample Design Using Bootstrap
Course Features
- Lectures 0
- Quizzes 0
- Duration 4 days
- Skill level All levels
- Language English
- Students 0
- Certificate No
- Assessments Yes
