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
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
chevron up
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

Securing MariaDB

In this section, we will cover a few topics that will help us secure our MariaDB database server. A few issues that we will cover in this section are:

  • Password-protected access

  • Building views to restrict access

  • Creating users and granting access

Password-protected access

During the MariaDB installation process, the user is normally prompted to enter a password for the root user. It is not required to enter a password; users can hit escape to avoid entering a password. As we are trying to secure the installation, let's go over the steps to protect access by adding a password if the password was not added initially. We will use mysqladmin for this process and enter the following command:

mysqladmin –u root password <userpassword>

In this snippet, we set the new password of the root user. From here on, we will need this password to log in as the root user. Now that we have added the password to the root user, let's log in as the root user and go over the concepts of views...

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 9
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