Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Advanced Search 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
chevron up
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

Working with stored routines

Stored routines are similar to stored procedures; both of them contain a block of SQL statements. There are a few differences such as a stored routine cannot return a result set and that a stored routine has to return a value and therefore, not preferred over stored procedures. Stored routines are invoked using the SELECT statement and can interchangeably be called as functions. The SHA1 function that we are using is a system-built stored routine to generate hashes for strings. Let's build a simple stored routine that would return the full name of the student when a username is passed in as a parameter, as shown in the following screenshot:

Working with stored routines

Note

We will be using the fn_functionName convention for our stored routines.

We begin by using the CREATE FUNCTION DDL command, appended by the name of the function, to create the function. This function takes the student's username as a parameter and returns the full name of the student, if the student exists. In...

Visually different images
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 2
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