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

Data imports

In real-world applications, data may have to be consumed from multiple sources, and a lot of applications are still built to use flat files for data storage. In this section, we will work with a file containing data about students, and import that data into our course_registry database. There are multiple formats that are commonly used to store data in a flat file. These formats use delimiters such as a comma, tab, or space, to separate one data item from another. The most popular formats are the CSV (comma separated values) and TSV (tab separated values) formats. We will work with a comma-separated list of student data that is stored in a flat file. Let's take a quick look at this data.

The following code snippet is contained in the students.csv file:

George,Johnson,3225 Woodland Park Dr,Houston,TX,77087,george.johnson,6579e96f76baa00787a28653876c6127
Charles,Davis,3225 Woodland Park Dr,Houston,TX,77087,charles.davis,6579e96f76baa00787a28653876c6127
Edward,Moore,3225 Woodland...
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 5
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