SQL

Image: Use PHP to insert information into a MySQL/MariaDB database from a HTML formGoroden­koffshut­ter­stock

Use PHP to insert in­form­a­tion into a MySQL/MariaDB database from a HTML form

A PHP script is a con­veni­ent way to accept in­form­a­tion submitted from a website's HTML form and insert it into a MySQL/MariaDB database. This tutorial will cover how to create a basic PHP script for inserting data, and an HTML form to take user input from a webpage and pass it to…

  • Database
  • PHP
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to fetch data with PHP mysqli_query?Virrage Imagesshut­ter­stock

How to fetch data with PHP mysqli_query?

PHP is designed to integrate easily into a website. One of the most common uses of PHP is to fetch content from a database and display it on an HTML page. This tutorial covers con­nect­ing to a MySQL/MariaDB database, re­triev­ing in­form­a­tion from a simple table with `PHP…

  • Database
  • PHP
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to fix the ‘too many connections’ error in MySQL/MariaDBJuice Flairshut­ter­stock

How to fix the ‘too many con­nec­tions’ error in MySQL/MariaDB

The MySQL ‘too many con­nec­tions’ error in MySQL or MariaDB can cripple websites and ap­plic­a­tions if there are too many sim­ul­tan­eous con­nec­tions. In this article, we show the actions you can take to fix it. You’ll learn how to increase the maximum number of allowed con­nec­tions,…

  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to reset MySQL/MariaDB root passwordREDPIXEL.PLshut­ter­stock

How to reset MySQL/MariaDB root password

For­get­ting the root password in MySQL or MariaDB doesn’t need to become a serious issue. By following the right steps, you can reset a MySQL/MariaDB root password quickly and easily at any time. This dedicated guide walks you step by step through both methods and points out what…

  • Security
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to optimise MySQL/MariaDB performance on a Linux serverrangizzzShut­ter­stock

How to optimise MySQL/MariaDB per­form­ance on a Linux server

The per­form­ance of a MySQL or MariaDB database sig­ni­fic­antly impacts ap­plic­a­tion speed. With the right op­tim­isa­tions, queries can be ac­cel­er­ated, resources used more ef­fi­ciently, and bot­tle­necks avoided. This article guides you step-by-step on how to optimise MySQL/MariaDB on a…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: What are the top 6 PostgreSQL alternatives?REDPIXEL.PLShut­ter­stock

What are the top 6 Post­gr­eSQL al­tern­at­ives?

While Post­gr­eSQL offers ro­bust­ness and security, if you’re looking for speed or a non-re­la­tion­al approach, al­tern­at­ive solutions are worth con­sid­er­ing. We’ll explore al­tern­at­ives to Post­gr­eSQL and outline their benefits so you can find the one that is ideal for your project and…

  • Database
  • SQL
  • Post­gr­eSQL
  • Com­par­is­on
Read more
Image: How to connect a MySQL/MariaDB database to a Linux cloud server with PHPOleksiy Markshut­ter­stock

How to connect a MySQL/MariaDB database to a Linux cloud server with PHP

By con­nect­ing MySQL to a Linux server, you can link your database with a Linux cloud en­vir­on­ment. In this article, we’ll show you how to do it step by step: from creating a test database and accessing it via a PHP script to querying data. You’ll also find troubleshoot­ing tips for…

  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: How to fix “error establishing a database connection” in MySQL/MariaDBOllyyshut­ter­stock

How to fix “error es­tab­lish­ing a database con­nec­tion” in MySQL/MariaDB

The ‘error es­tab­lish­ing a database con­nec­tion’ often blocks access to websites and ap­plic­a­tions using MySQL or MariaDB. Our article provides a step-by-step guide to identi­fy­ing and fixing the cause. Learn how to check cre­den­tials, reset passwords, and test con­nec­tions from the…

  • Database
  • MySQL
  • Tutorials
  • SQL
  • MariaDB
Read more
Image: What alternatives to SQL are there?Wright Studioshut­ter­stock

What al­tern­at­ives to SQL are there?

In terms of databases, al­tern­at­ives to the SQL approach have existed for quite some time. The ad­vant­ages of a re­la­tion­al system shouldn’t be over­looked though. In fact, it might be exactly what your project requires. Here, we’ll go over which NoSQL solutions are worth con­sid­er­ing…

  • Database
  • SQL
Read more
Image: What are the key differences in a MariaDB vs MySQL comparison?kentohShut­ter­stock

What are the key dif­fer­ences in a MariaDB vs MySQL com­par­is­on?

MySQL is one of the most widely used database man­age­ment systems worldwide. The open-source software has been available since 1995 and is con­sidered the standard solution for re­la­tion­al databases. However, MariaDB is becoming an at­tract­ive al­tern­at­ive. We compare both systems and…

  • Database
  • MySQL
  • SQL
  • MariaDB
  • Com­par­is­on
Read more