Tag: mysql

Learn how to take information stored in a MySQL database and display it on a web page for all to see.

Learn what a database is, and how to work with your own databases using Structured Query Language (SQL).

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.

MySQL 5.7+ InnoDB databases and PostgreSQL 9.2+ support JSON document types in a single field. We explore the MySQL 8.0 JSON implementation in more detail.

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).

Installing MySQL is easier than you think. Craig provides a step-by-step guide to get your database up and running in minutes.

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.

Craig's simple tutorial is for anyone who's ever struggled to install a WordPress MySQL database using cPanel. That's everyone, right?!

Kirill demonstrates a practical example of optimizing a website's MySQL queries - check it out, it might come in handy in your optimization gigs!

Bruno demonstrates the use of Phinx, a framework-agnostic database migration package helping you write database-independent and versionable database changes

Zack Wallace covers three SQL join approaches which can aid you in filtering your data. If you're an SQL newbie, this post will teach you valuable things!

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

Here's a look at Yahoo's MySQL performance analyzer - we go through its options, from graphs to alerts. It's getting ever easier to speed up your DBs!

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.

HyperDB is a powerful WordPress plugin that allows you to connect to multiple databases, enabling features such as failover, replication and load balancing.

The second article in a series on Docker for WordPress Developers, Aleksander Koko shows us how to manually build Docker containers for WordPress.

Wern Ancheta introduces Medoo, a small database abstraction library that aims to make your database related codebase lighter.

There are many ways of scaling your website. In this article we focus on database tweaks and optimizations that can improve WordPress performance.

This article explores the WordPress database and how things work in the background. It will also help you gain an understanding of the database structure.

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

Here are seven mistakes PHP developers often do - from wrong database drivers to too much transparency, read this list to find out what you shouldn't do

Francesco Malatesta introduces you to FluentPDO - a small and simple PDO library built to solve your data manipulation needs. See what it can do.

0xDBE is a new tool by JetBrains made to solve all our database management problems. Soon, we'll be able to leave Workbench behind and work without crashes!

Amit Gupta simplifies and explains the Repository Design Pattern on a Laravel backed example

Google BigQuery now hosts GDELT - the world's largest dataset on human history - and it's free to use.

Taylor Ren explains how you can use Phreeze to autogenerate CRUD applications for your already existing databases - often in already existing apps.

Learn about ChromeMyAdmin - a packaged app that lets you manage your MySQL/MariaDB database directly from any instance of your Google Chrome browser

Wern Ancheta explains what DBV is and how one can use it to version control a database

Taylor Ren looks at a relatively new suite of DB tools - Valentina - and gives you his opinion on it.

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.

Learn to deploy your first Laravel application on Nitrous.io - the cloud development environment

Taylor Ren explains and demonstrates the use of Cursors in MySQL's Stored Procedures

Horizontal scaling of databases in PHP applications - the how and why of master-slave replication

Revisit the long forgotten topic of Stored Procedures in MySQL and PHP

Learn about unique index and the way they can increase performance when built correctly

Read How to Use Unique Indexes in MySQL and Other Databases and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Learn how to create and deploy a PHP+MySQL app on Windows Azure

Read How to Explain Your SQL EXPLAIN Queries and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read We're Putting the (MySQL) Band Back Together and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Richard will explain how to create MySQL view and how to use it in your application. Something to note is MySQL views are only available from version 5.

In this article, Jacco Blankenspoor wanted to give you an impression of what is available in Database-as-a-Service.

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).

Read What's New in WordPress 3.3 and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read Creating Drill-down Analytics with FusionCharts, PHP, MySQL and JSON and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

In the last of a three-part database series, this tutorial explains how to create scheduled events in MySQL which run automatically at during pre-defined intervals.

In the second of a three-part database series, this tutorial explains how to create triggers in MySQL which run automatically when records are added, changed or deleted.

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.

Handling dates in PHP and MySQL is difficult unless timezones match. This tutorial provides code which should help solve date/time problems in your application.

Read What's New in WordPress 3.1? and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read MySQL Transaction Gotchas & Good Parts and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read What's New in MySQL 5.5 and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read MySQL Transactions & Why They Can't Be Emulated in PHP and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

A database is a fundamental component for most web applications. Let's look at the top 10 MySQL mistakes made by PHP developers and how to avoid them.

Read PostgreSQL 9.0 Released and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read Sign-Up to Save MySQL? and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read Oracle Publicly Commits to MySQL and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.

Read EU Object to Oracle's MySQL Takeover and learn with SitePoint. Our web development and design tutorials, courses, and books will teach you HTML, CSS, JavaScript, PHP, Python, and more.