PHP & MySQL Advanced | Brainmatics

Back

Short Courses
Regular Courses
Private Courses
About Us
Account

Login | Register | Cart

header

25 Sections
143 Lessons
32 Hours

Expand all sectionsCollapse all sections

PERSIAPAN
2
- 1.1
  Pre-Test
  0 Questions
- 1.2
  Download Bundle Materi
1. INTRODUCTION TO PHP
3
- 2.1
  1.1. PHP Facts
- 2.2
  1.2. PHP Development Tools
- 2.3
  1.3. PHP Syntax
2. USING VARIABLES & OUTPUT STATEMENTS
4
- 3.1
  2.1. Variables in PHP
- 3.2
  2.2. Echo and Print Statement
- 3.3
  2.3. PHP Superglobals
- 3.4
  2.4. Functions in PHP
3. PHP – BUILDING BLOCKS
3
- 4.1
  3.1. PHP Conditional Statements
- 4.2
  3.2. Loops in PHP
- 4.3
  3.3. Switch Case Statement in PHP
4. DATA SENDING WAYS IN PHP
3
- 5.1
  4.1. Using Form Methods
- 5.2
  4.2. The POST Method
- 5.3
  4.3. Using Query String
5. STRING FUNCTIONS IN PHP
8
- 6.1
  5.1. String Concatenation Operator
- 6.2
  5.2. Using the strlen() Function
- 6.3
  5.3. Using the strpos() Function
- 6.4
  5.4. The explode() Function
- 6.5
  5.5. The substr() Function
- 6.6
  5.6. The md5( ) Function
- 6.7
  5.7. The trim() Function
- 6.8
  5.8. The str_replace() Function
6. DATE FUNCTIONS IN PHP
3
- 7.1
  6.1. The DateTime Class in PHP
- 7.2
  6.2. The PHP time()
- 7.3
  6.3. PHP Timezones
7. ARRAYS IN PHP
3
- 8.1
  7.1. Introduction to Arrays
- 8.2
  7.2. Sorting of Arrays
- 8.3
  7.3. Associate Arrays
8. SANITIZE FUNCTIONS IN PHP
2
- 9.1
  8.1. Sanitize Functions
- 9.2
  8.2. Validation Functions
9. INTRODUCTION TO MYSQL / MARIADB
8
- 10.1
  9.1. Introduction to Relational Databases
- 10.2
  9.2. Data Types in Mysql / Mariadb
- 10.3
  9.3. Types of Mysql/ MariadbTables
- 10.4
  9.4. Some Popular MySQL Commands
- 10.5
  9.5. Working with MYSQL / Mariadb Database
- 10.6
  9.6. Aggregate Functions in MYSQL
- 10.7
  9.7. Using Group by Clause
- 10.8
  9.8. Subqueries in MYSQL
10. SENDING DATA TO MARIADB
4
- 11.1
  10.1. Design a HTML Page Containing HTML Form Fields
- 11.2
  10.2. Receive Form Field Data to the PHP Page Using $_GET, $_REQUEST or $_POST
- 11.3
  10.3. Prepare a Database Connection
- 11.4
  10.4. Place Appropriate Query to Insert Record into Mysql Table
11. RETRIEVING DATA FROM MARIADB
2
- 12.1
  11.1. Learn How to Retrieve Data from Mariadb to PHP Pages
- 12.2
  11.2. Some Popular Methods to Retrieve Records from the Dtabase in PHP
12. ERROR HANDLING IN PHP
7
- 13.1
  12.1. Errors Types
- 13.2
  12.2. Using die() function
- 13.3
  12.3. Some Possible Errors in PHP
- 13.4
  12.4. Creating a Custom Error Handler
- 13.5
  12.5. Using include() Function
- 13.6
  12.6. Difference Between Include and Require
- 13.7
  12.7. PHP Errors – Troubleshooting
13. WORKING WITH IMAGES
4
- 14.1
  13.1. Create HTML Code
- 14.2
  13.2. Error Messages
- 14.3
  13.3. Make Uploaded Images, Your Profile Image
- 14.4
  13.4. PHP File Upload & Security
14. COOKIES / SESSION IN PHP
4
- 15.1
  14.1. Cookies
- 15.2
  14.2. Sessions
- 15.3
  14.3. Cookie Example
- 15.4
  14.4. Session Example
15. SENDING MAIL IN PHP
3
- 16.1
  15.1. Syntax
- 16.2
  15.2. Example to Create Enquiry Form for the Website
- 16.3
  15.3. Example to Create and Send Activation Code to Activate an User Profile
16. OBJECT ORIENTED PROGRAMMING
11
- 17.1
  16.1. Some Advantages of Using OOP
- 17.2
  16.2. Important Terms Related to Object Oriented Programming
- 17.3
  16.3. Define a PHP Class and Object
- 17.4
  16.4. Naming a Class
- 17.5
  16.6. The $this Keyword
- 17.6
  16.5. What is Constructor?
- 17.7
  16.7. Access Specifiers or Visibility Mode in PHP
- 17.8
  16.8. PHP OOPs Inheritance
- 17.9
  16.9. Static Methods and Properties in PHP
- 17.10
  16.10. Static Properties or Variables
- 17.11
  16.11. Getter and Setter in PHP
17. MYSQL JOINS AND INDEX
6
- 18.1
  17.1. MVC (Model-View-Controller) in PHP
- 18.2
  17.2. The Model
- 18.3
  17.3. The View
- 18.4
  17.4. The Controller
- 18.5
  17.5. MVC Program Flow
- 18.6
  17.6. A Simple MVC Program
18. MYSQL TRIGGERS AND PROCEDURES
19
- 19.1
  18.1. INNER JOIN OR Simple join
- 19.2
  18.2. LEFT OUTER JOIN
- 19.3
  18.3. RIGHT OUTER JOIN
- 19.4
  18.4. Assignments for the practice
- 19.5
  18.5. MYSQL Indexes
- 19.6
  18.6. Query To View Index in a Table
- 19.7
  18.7. Query To Drop Index Command
- 19.8
  18.8. Clustered Index
- 19.9
  18.9. Primary key, Not null and Clustered index
- 19.10
  18.10. Non-Clustered vs Clustered Index
- 19.11
  18.11. Mysql – Stored Procedure
- 19.12
  18.12. Store Procedure with Parameters
- 19.13
  18.13. To Execute Procedure proc
- 19.14
  18.14. MySQL Loop in Stored Procedures
- 19.15
  18.15. MYSQL – Triggers
- 19.16
  18.16. Advantages of Using SQL Triggers
- 19.17
  18.17. Disadvantages of Using SQL Triggers
- 19.18
  18.18. Two Types of Trigger
- 19.19
  18.19. DROP A TRIGGER
19. MYSQL TRANSACTIONS
5
- 20.1
  19.1. Why Transaction is Required in Database
- 20.2
  19.2. Atomicity
- 20.3
  19.3. Consistency
- 20.4
  19.4. Isolation
- 20.5
  19.5. Durability
20. PHP AJAX
8
- 21.1
  20.1. Introduction
- 21.2
  20.2. How Ajax Works
- 21.3
  20.3. The XMLHttpRequest Object
- 21.4
  20.4. Popular XMLHttpRequest Methods
- 21.5
  20.5. XMLHttpRequest Properties
- 21.6
  20.6. Sending a Request to the Server
- 21.7
  20.7. Steps of AJAX Operation
- 21.8
  20.8. Sample Code
21. HOSTING YOUR WEBSITE
11
- 22.1
  21.1. Servers (DNS Servers)
- 22.2
  21.2. Domain Name
- 22.3
  21.3. Web Hosting
- 22.4
  21.4. Types Of Web Hosting
- 22.5
  21.5. Storage Space and Bandwidth
- 22.6
  21.6. Bandwidth
- 22.7
  21.7. Supported Languages
- 22.8
  21.8. Supported Databases
- 22.9
  21.9. A MySQL Database
- 22.10
  21.10. Server Control and Access
- 22.11
  21.11. Administration GUIs
22. PHP PAGINATION
1
- 23.1
  22.1. A Simple Example to Fetch Records Using LIMIT to Generate Paging
23. BOOTSTRAP FRAMEWORK
19
- 24.1
  23.1. Installation Guide
- 24.2
  23.2. Sample Code: Installing Bootstrap
- 24.3
  23.3. Some Major Classes available in Bootstrap 3
- 24.4
  23.4. Bootstrap 4: What’s New in Bootstrap 4
- 24.5
  23.5. New Classes in Bootstrap 4
- 24.6
  23.6. Forms
- 24.7
  23.7. Grid System
- 24.8
  23.8. Images
- 24.9
  23.9. Tables
- 24.10
  23.10. Forms
- 24.11
  23.11. Buttons
- 24.12
  23.12. Panels
- 24.13
  23.13. Example – Using Container, Jumbotron, Well, Button, Text Classes
- 24.14
  23.14. Example: Image Classes in Bootstrap
- 24.15
  23.15. Example: Understanding Grid System –Rows & Cols
- 24.16
  23.16. Panel in Bootstrap
- 24.17
  23.17. Table Example in Bootstrap
- 24.18
  23.18. Nav-bar Example
- 24.19
  23.19. Sample Design Using Bootstrap
PENUTUPAN
2
- 25.1
  Post- Test
  0 Questions
- 25.2
  Kuesioner

This content is protected, please login and enroll in the course to view this content!

23.10. Forms

23.12. Panels

[email protected]

About

BrainEdu
Personnel
About Us

Social Media

Partners

Brainmatics Curriculum Booklet (PDF)

Login with your site account

Lost your password?

Remember Me

Not a member yet? Register now

Register a new account

Are you a member? Login now

Modal title

Main Content