Learn how to take information stored in a MySQL database and display it on a web page for all to see.
Learn how to set up a development environment by installing PHP 8 and MySQL using Docker, in this excerpt from our book PHP & MySQL: Novice to Ninja.
Looking for tips on how to install PHP on Windows? We walk step by step through how to install PHP 8 and Apache 2.4 on Windows 10 (64-bit).
This guide shows how to use the mysql module to connect to your database and perform basic CRUD operations, before moving on to some more advanced uses.
Claudio Ribeiro shows how you can use explain and indexes to spot and remedy possible performance issues with your database before they strike.
Here's a compendium of practical MySQL optimization tricks - from bottlenecks to configuration and indexes. Leave your ORM behind and get your hands dirty!
Scott explains how we can have a secure, encrypted, and hack-proof database, but still use normal SELECT and search queries on it. Interesting stuff!
David Bush discusses the importance of understanding core functionality in Rails, showing how indexes work and how to implement a database by yourself.
WordPress records a copy of every post revision so you can revert to earlier versions. That can be useful but is it affecting your database performance?
Developing WordPress themes and plugins on a local server can be problematic if it doesn't match your live system. Craig discusses synchronization options.
Bruno demonstrates the use of Phinx, a framework-agnostic database migration package helping you write database-independent and versionable database changes
MySQL 5.7 introduced some awkward changes for older codebases and tends to break apps. Here's how to temporarily (or permanently) lower the strictness level
Parham re-introduces PDO ahead of the PHP 7 launch, preparing you for a transition from the soon-to-be removed insecure and deprecated mysql extension!
Wern Ancheta covers three common approaches to caching in PHP: Zend Opcache, Query Caching and Expires Headers.
The second article in a series on Docker for WordPress Developers, Aleksander Koko shows us how to manually build Docker containers for WordPress.
There's no shortage of new things to learn in the web development world. Shaumik Daityari presents some of the best skills you can learn in a weekend
An introduction to creating a client-server dart app: setting up the environment, making sure we have the latest SDK, and going over some Dart basics.
Episode 161 of The SitePoint Podcast is now available! This week our regular interview host Louis Simoneau (@rssaddict) interviews long-term podcast host, Kevin Yank (@sentience).
A short tutorial of two powerful database features: triggers and events. When should and shouldn't they be used?
SQL JOINs are often misunderstood and one of the biggest causes of database optimization problems. This brief tutorial explains JOINs and their use in MySQL and other relational databases.