Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Building a Web Application with PHP and MariaDB: A Reference Guide
  • Table Of Contents Toc
Building a Web Application with PHP and MariaDB: A Reference Guide

Building a Web Application with PHP and MariaDB: A Reference Guide

By : Sai S Sriparasa
4.3 (3)
Buy this Book
close
close
Building a Web Application with PHP and MariaDB: A Reference Guide

Building a Web Application with PHP and MariaDB: A Reference Guide

4.3 (3)
By: Sai S Sriparasa
Buy this Book

Overview of this book

This is a step-by-step, tutorial guide designed to help readers transition from beginners to more experienced developers using clear explanations. The variety of examples will help readers build, secure, and host real-time web applications. If you are a developer who wants to use PHP and MariaDB to build web applications, this book is ideal for you. Beginners can use this book to start with the basics and learn how to build and host web applications. Seasoned PHP Developers can use this book to get familiar with the new features of PHP 5.4 and 5.5, unit testing, caching, security, and performance optimization.
Table of Contents (12 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. CRUD Operations, Sorting, Filtering, and Joins
chevron up
Icon
1. CRUD Operations, Sorting, Filtering, and Joins
Icon
String datatypes
Icon
Number datatypes
Icon
Date datatypes
Icon
The students table
Icon
Inserting data
Icon
Retrieving data
Icon
Sorting data
Icon
Filtering data
Icon
Updating data
Icon
Deleting data
Icon
Joins
Icon
Summary
2
2. Advanced Programming with MariaDB
Icon
2. Advanced Programming with MariaDB
Icon
Enhancing the existing tables
Icon
Working with stored procedures
Icon
Working with stored routines
Icon
Working with triggers
Icon
Summary
3
3. Advanced Programming with PHP
Icon
3. Advanced Programming with PHP
Icon
New features in PHP 5.4 and 5.5
Icon
Unit testing
Icon
Working with MariaDB
Icon
Summary
4
4. Setting Up Student Portal
Icon
4. Setting Up Student Portal
Icon
Setting up the nuts and bolts of our application
Icon
Setting up MVC
Icon
Adding a student
Icon
Listing all students
Icon
Adding a course
Icon
Listing all courses
Icon
Registering a student to a course
Icon
Viewing all registrations
Icon
Summary
5
5. Working with Files and Directories
Icon
5. Working with Files and Directories
Icon
Data imports
Icon
Data exports
Icon
Logging
Icon
Summary
6
6. Authentication and Access Control
Icon
6. Authentication and Access Control
Icon
Authentication
Icon
Access controls
Icon
User roles
Icon
Summary
7
7. Caching
Icon
7. Caching
Icon
Introduction to caching
Icon
Caching in the database
Icon
Caching in the application
Icon
Advanced caching techniques
Icon
Summary
8
8. REST API
Icon
8. REST API
Icon
What is REST?
Icon
Generating XML feeds
Icon
Generating JSON feeds
Icon
Summary
9
9. Security
Icon
9. Security
Icon
Securing the Apache web server
Icon
Securing MariaDB
Icon
Securing PHP
Icon
Summary
10
10. Performance Optimization
Icon
10. Performance Optimization
Icon
Performance optimization for the Apache web server
Icon
Performance optimization for MariaDB
Icon
Performance optimization for PHP
Icon
CDN, reverse proxy, and database replication
Icon
Summary
11
Index
Icon
Index

Deleting data

We will use the DELETE DML statement for deletion of data. The DELETE statement at a minimum expects the name of the table. Similar to the UPDATE statement, it is recommended that the DELETE statement is always used with filter criteria to avoid loss of data.

The DELETE statement should be used when a record has to be permanently removed from the table.

Note

To avoid permanent loss or deletion of data Boolean flags are used to determine if a record is active or inactive (1 or 0). These are called soft deletes and help us retain data in the long run.

Deleting data

In the preceding example, we are deleting the records from the students table that match the criterion of student_id equal to 4. As there is only one record that matches that criterion, that record has been deleted. The recommendations that were made above about how to use the filter criterion apply for the DELETE statement too.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Building a Web Application with PHP and MariaDB: A Reference Guide
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon