About
About Us
Help
Privacy Policy
Terms of Service
LearnDesk
Learn
Academics
Business
Creative
Health and Fitness
Lifestyle
Personal Development
Software
Topics
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Pharma
View All Topics
Topics
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
View All Topics
Topics
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
View All Topics
Topics
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
View All Topics
Topics
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
View All Topics
Topics
Career Development
Learning
Religion and Spirituality
Self-Improvement
View All Topics
Topics
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
View All Topics
Teach
Teach Online
Schedule
Items
Billing
Users
Marketing
Analytics
Settings
Change School
Account
Log In
Sign Up
Ultimate PHP and MySQL Web Development
Introduction & Setup
Introduction
Preview
Setup On Windows
Setup On Mac
Setup On Linux
Online Code Editor
Basics
Basic File Syntax
Preview
Printing (echo)
Preview
Comments
Variables
Variable Data Types
Preview
Variable Naming
Constants
Arrays
Associative Arrays
Multidimensional Arrays
Control Structures
if Statement
if...else Statement
Preview
if...elseif...else Statement
Switch Statement
while Loop
do...While Loop
Preview
for Loop
foreach Loop
Break Statement
Continue Statement
Preview
Functions
Basic Function
Passing Function Arguments
Preview
Passing Function Arguments By Reference
Default Argument Value
Function Returning Values
Preview
Dynamic Function Calls
Variable Scope
Forms
Simple HTML Form
Preview
GET vs POST
$_SERVER["PHP_SELF"]
Validating Form Data With PHP
Required Fields
Preview
Display Error Messages
Preview
Validate Name
Preview
Validate Email
Validate URL
Keep The Values In The Form
File Handling
Read File (readfile())
Open, Read & Close A File (fopen(), fread(), fclose())
Preview
Read Single Line (fgets())
Check End-Of-File (feof()
Read Single Character (fgetc())
Preview
Write To File (fwrite())
Configure php.ini File For File Uploading
Front End HTML Upload Form
PHP Upload Script
Check If File Exists
Limit File Size
Limit File Type
Preview
MySQL
MySQL vs MySQLi vs PDO
Preview
Creating A Database & Table (phpMyAdmin)
Connecting To A Database
Get Data Using SELECT Query
Preview
WHERE Property For Filtering
LIKE Property For Pattern Search
Sorting Results Using ORDER BY Propert
Using JOINS
Insert Data Using INSERT Query
Get ID Of The Last Inserted Row
Insert Multiple Rows
Update Data Using UPDATE Query
Delete Data Using DELETE Query
Delete All Rows In A Table Using TRUNCATE Query
Delete Table Using DROP Query
Limit Data Selections Using LIMIT, ROWNUM
Create Table Using CREATE Query
Clone/Duplicate Table
Alter Table
Create Database
Drop Database
SQL Injection & Prepared Statements
XML
What Is XML?
What Is SimpleXML?
Preview
Parse XML String
Parse XML File
Get Node Values
Get Node Values of Specific Elements
Get Node Values - Loop
Preview
Get Attribute Values
What Is The XML Expat Parser?
Initializing the XML Expat Parser
Load and Output XML Using The Dom Parser
Looping through XML Using The Dom Parser
AJAX
What Is AJAX?
Load Simple Data Using AJAX Front End
Load Simple Data Using AJAX Back End
Load Data From A Database Using AJAX
Emails
Send A Plain Text Email
Preview
Send A HTML Email
Email Attachments
PHPMailer Setup
Send Email Using PHPMailer
Send HTML Email Using PHPMailer
Email Attachments Using PHPMailer
Object Oriented Programming
What Is Object Oriented Programming (OOP)?
Basic Class With Variables
Preview
Functions
Constructor
Destructor
Preview
Inheritance
Multi Class Inheritance
Function Overriding
Public vs Private vs Protected
Interfaces
Constants
Abstract Class
Static Keyword
Final Keyword
Initiating Parent Constructor
Error Handling
die() Function
Custom Error Handler
Triggering An Exception
Exception Handling
Advanced
Validate an Integer Within a Range
Validate IPv6 Address
Validate URL - Must Contain QueryString
Remove Characters With ASCII Value > 127
Including & Requiring External PHP Files
MySQL
Ultimate PHP and MySQL Web Development
By:
Admin
Share
Share the link to this page
Copied
Facebook
Twitter
WhatsApp
LinkedIn
Email
Add to Calendar
Add the class to your calendar
Add to Google Calendar
Add to Apple Calendar
Add to Yahoo Calendar
Add to Outlook Calendar
Print
Completed
We'll cover the following topics in this section:
MySQL vs MySQLi vs PDO
Creating A Database & Table (phpMyAdmin)
Connecting To A Database
Get Data Using SELECT Query
WHERE Property For Filtering
LIKE Property For Pattern Search
Sorting Results Using ORDER BY Propert
Using JOINS
Insert Data Using INSERT Query
Get ID Of The Last Inserted Row
Insert Multiple Rows
Update Data Using UPDATE Query
Delete Data Using DELETE Query
Delete All Rows In A Table Using TRUNCATE Query
Delete Table Using DROP Query
Limit Data Selections Using LIMIT, ROWNUM
Create Table Using CREATE Query
Clone/Duplicate Table
Alter Table
Create Database
Drop Database
SQL Injection & Prepared Statements
Previous
Next
Sign Up
Signup to access thousands of classes
Continue with Facebook
Continue with Google
OR
Continue with Email
Already a member?
Log In
By registering for a LearnDesk account, you agree to our
Terms of Service
and
Privacy Policy
.
Share
Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.
Share with Google Contacts