Book Image

WordPress Development Quick Start Guide

By : Rakhitha Nimesh Ratnayake
Book Image

WordPress Development Quick Start Guide

By: Rakhitha Nimesh Ratnayake

Overview of this book

WordPress is the most used CMS in the world and is the ideal way to share your knowledge with a large audience or build a profitable business. Getting started with WordPress development has often been a challenge for novice developers, and this book will help you find your way. This book explains the components used in WordPress development, when and where to use them, and why you should be using each component in specific scenarios. You begin by learning the basic development setup and coding standards of WordPress. Then you move into the most important aspects of the theme and plugin development process. Here you will also learn how themes and plugins fit into the website while learning about a range of techniques for extending themes and plugins. With the basics covered, we explore many of the APIs provided by WordPress and how we can leverage them to build rapid solutions. Next, we move on to look at the techniques for capturing, processing, and displaying user data when integrating third-party components into the site design. Finally, you will learn how to test and deploy your work with secure and maintainable code, while providing the best performance for end users.
Table of Contents (16 chapters)
Title Page
Copyright and Credits
Packt Upsell
Contributors
Preface
Index

Executing basic CRUD operations on custom tables


WordPress provides a built-in class called wpdb for handling database queries. This class is located inside the wp-includes directory. The wpdb class will be available inside your plugins and themes as a global variable and provides access to all the tables inside the WordPress database, including custom tables. Using this class for queries adds an extra layer of security as well as optimizes the database queries.

Note

Using the wpdb class for CRUD operations is straightforward with its built-in methods. A complete guide for using the wpdb class can be found at http://codex.wordpress.org/Class_Reference/wpdb.

Basically, there are no built-in methods for accessing custom tables using direct functions, so it's a must to use the wpdb class for handling custom tables.

Inserting records

The wpdb class provides a built-in insert function to insert records to custom database tables. So, we need to use it for better performance, instead of writing INSERT...