Course Content

Introduction to PHP

10m 23s

Understanding SDLC Process

13m 58s

Client Server Architecture

5m 18s

How to set up PHP Environment?

18m 6s

Understanding HTTP Methods

33m 26s

Understanding PHP Program structure Comments in PHP

13m 7s

Variables in PHP

11m 46s

Arithmetic & Assignment Operators in PHP

24m 28s

Comparison & Logical Operators in PHP

33m 17s

Ternary Operator in PHP

14m 38s

Assignment : Operators

1m 22s

Super Global Variable in PHP

19m 30s

GET & POST Variable in PHP

12m 21s

$_FILES & $_ENV in PHP

15m 24s

Assignment : Super Global Variables

2m 16s

If-else in PHP

26m 25s

switch case in PHP

15m 2s

Assignment : Conditional Statements

2m 28s

Functions in PHP

39m 46s

Call by value vs Call by reference in PHP

17m 28s

Assignment : Functions

5m 25s

Array Functions in PHP

44m 28s

Array in PHP

19m 35s

Assignment : Array

7m 18s

String and its Functions in PHP

27m 53s

Assignment : String

3m 44s

Loops in PHP

19m 28s

More examples on Loops in PHP

17m 20s

Assignment : Loops

8m 32s

Cookies in PHP

15m 45s

Session in PHP

35m 42s

Header Function in PHP

17m 11s

Assignment : Header Functions

1m 57s

Date and Time functions in PHP

36m 14s

Assignment : Date Time Functions

4m 29s

Include & Require Statement in PHP

13m 52s

Error Handling in PHP

15m 18s

File Upload in PHP

42m 55s

Database Connection in PHP Part 1

29m 17s

Database Connection in PHP Part 2

32m

SQL Injection in PHP

30m 33s

Crud - Registration and DB connection Part 1

31m 31s

Crud - Registration and DB connection Part 2

24m 2s

Log in Operation

27m 25s

Read Operation

30m 27s

Update Operation Part 1

12m 53s

Update Operation Part 2

27m 17s

Log out Operation

9m 29s

MySQL Interview Question 1

33m 7s

MySQL Interview Question 2

25m 23s

MySQL Interview Question 3

24m 27s

PHP Course For Beginners

MY SQL with PHP MySQL Trigger

Enroll Now For Free
Previous Next
Discussion
Previous Discussion Next
Previous
Next
  • MySQL Trigger
  • learnvern-1
  • learnvern-2

Course Content

Introduction to PHP

10m 23s

Understanding SDLC Process

13m 58s

Client Server Architecture

5m 18s

How to set up PHP Environment?

18m 6s

Understanding HTTP Methods

33m 26s

Understanding PHP Program structure Comments in PHP

13m 7s

Variables in PHP

11m 46s

Arithmetic & Assignment Operators in PHP

24m 28s

Comparison & Logical Operators in PHP

33m 17s

Ternary Operator in PHP

14m 38s

Assignment : Operators

1m 22s

Super Global Variable in PHP

19m 30s

GET & POST Variable in PHP

12m 21s

$_FILES & $_ENV in PHP

15m 24s

Assignment : Super Global Variables

2m 16s

If-else in PHP

26m 25s

switch case in PHP

15m 2s

Assignment : Conditional Statements

2m 28s

Functions in PHP

39m 46s

Call by value vs Call by reference in PHP

17m 28s

Assignment : Functions

5m 25s

Array Functions in PHP

44m 28s

Array in PHP

19m 35s

Assignment : Array

7m 18s

String and its Functions in PHP

27m 53s

Assignment : String

3m 44s

Loops in PHP

19m 28s

More examples on Loops in PHP

17m 20s

Assignment : Loops

8m 32s

Cookies in PHP

15m 45s

Session in PHP

35m 42s

Header Function in PHP

17m 11s

Assignment : Header Functions

1m 57s

Date and Time functions in PHP

36m 14s

Assignment : Date Time Functions

4m 29s

Include & Require Statement in PHP

13m 52s

Error Handling in PHP

15m 18s

File Upload in PHP

42m 55s

Database Connection in PHP Part 1

29m 17s

Database Connection in PHP Part 2

32m

SQL Injection in PHP

30m 33s

Crud - Registration and DB connection Part 1

31m 31s

Crud - Registration and DB connection Part 2

24m 2s

Log in Operation

27m 25s

Read Operation

30m 27s

Update Operation Part 1

12m 53s

Update Operation Part 2

27m 17s

Log out Operation

9m 29s

MySQL Interview Question 1

33m 7s

MySQL Interview Question 2

25m 23s

MySQL Interview Question 3

24m 27s

FAQs

A trigger is a database event that is executed automatically by MySQL whenever data manipulation language (DML) operations are executed on one or more tables. Triggers can be used to enforce referential integrity, maintain data integrity, and implement security policies. It's important to understand that there are two types of triggers: INSERT and UPDATE. A trigger is called an INSERT trigger when it executes as a result of an INSERT statement or SELECT . It's called an UPDATE trigger when it executes as a result of an UPDATE statement or SELECT . For example, if you have a table with columns id and name , then the following script will create a trigger which will update the value in column name with the value in column id : CREATE TRIGGER update_name_by

In the table, you can see that triggers are 35% faster than the OUTPUT clause. With OUTPUT, you have more control on the code, because you can extract the inserted and deleted rows in a specific stored procedure whenever you want. The problem with triggers is that they are executed even if you do not want them to

MySQL is an open-source database management system. It is widely used by many businesses and organizations that need a database for their applications. MySQL has certain limitations that are not appealing for all types of applications. One of these limitations is the fact that it does not support transactions, which is not the case with most other DBMSs. Some other limitations are related to the lack of indexing capabilities, which can be resolved in MySQL but at a cost. MySQL is a powerful open-source database management system (DBMS) and can be used for many use cases. But as it's an open-source software, it does come with some limitations. Here are some of the limitations of MySQL: 1. Price: MySQL is free to use, but there are other charges associated with maintaining the server and other resources required to run MySQL. There can also be charges for paid support and additional modules that you might need for your application. 2. Performance: While MySQL is fast enough for most applications, there can be performance issues if you're not careful about how much data you load into the system and how often you update records in the database. There's also a limitation on how many concurrent connections you can have to a single instance

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere