Web Development
-
Introduction To MariaDB
A database is a structured collection of records or data stored in a computer server and organized in such a way that it can be quickly searched and information can be rapidly retrieved with very min
-
[MariaDB] Guide To Creating Databases and Tables
IF you are new to mariadb or mysql, you might want to take a sneak peek at the Introduction To MariaDB, I covered a couple of interesting concept in that post. In this guide, you'll learn how to cre
-
Altering MariaDB Tables
In our last guide, we dive deep into creating databases and tables. In this guide, we would discuss altering and manipulating the data, well, you can get the full structure of your table in a go, so
-
Indexes In MariaDB
IF you are new to mariadb or mysql, you might want to take a sneak peek at the Introduction To MariaDB, I covered a couple of interesting concept in that post. Also, I wrote a guide on: Creating Dat
-
Guide To Understanding INSERT Statement (MariaDB)
So far, we've covered a couple of topics on mariadb, if you want to follow the progress, here are the guides: Introduction To MariaDB [MariaDB] Guide To Creating Databases and Tables Altering MariaD
-
Guide To Selecting Data In MariaDB
In this guide, we would look at various ways you can select data in mariadb. If you are new to mariadb, you can read the following guide, doing this would help you understand the select statement eve
-
Guide To Updating and Deleting Data In MariaDB
In this guide, we would look at various ways you can update and delete data in mariadb. If you are new to mariadb, you can read the following guide to follow the progression right from the start. In
-
Joining and Subquerying Data (MariaDB)
In this guide, we would look at various ways you can join and subquery data in mariadb. If you are new to mariadb, you can read the following guide to follow the progression right from the start. In
-
List of Functions and Practical Uses In MariaDB
MariaDB comes bundled with a lot of built-in functions that can be used to manipulate data within a column. If you are new to mariadb, you can read the following guide, doing this would help you und
-
User Accounts and Privileges In MariaDB
In this guide, we would look at various ways you can manage user's accounts and privileges in mariadb, If you are new to mariadb, you can read the following guide to follow the progression right fro
-
Exploring Data Types, Variables and Operators in PHP
In PHP or any programming language, a data type is an attribute of data that tells the interpreter how the programs intend to use the given data. PHP supports a couple of data types of which are inte
-
Getting Started With PHP (Introduction)
This is my first PHP guide on this blog, and in this guide, we would go over the introduction of PHP, but first... What is PHP? PHP which is a recursive acronym of Hypertext Preprocessor is a dynam
-
Conditional Statements In PHP
Conditional statements alter the program flow, and by using a conditional flow, you can make your program make choices about what should happen based on certain conditions. We can achieve this by usi
-
Control Structure: Guide To Learning Loops In PHP
In our previous guide, we've seen conditional statements in PHP that lets us alter the program flow base on conditional choices, in this guide, we would look into the different types of loops in PHP
-
Guide To Functions In PHP
In this guide, we would look at functions in PHP...so...first Intro To Functions Functions are modular building blocks for creating powerful and modular scripts, using function makes it easy to isol
-
Arrays in PHP
An array is an orderly arrangement of a collection of multiple values, that is the basic explanation I can up with. You can think of them as a collection of values stored in a specific variable, and
-
Object Oriented Programming Intro in PHP
We recently went through the understanding of functions in PHP, well, that is one way of writing a PHP code, and the other way is using objects. In object-oriented programming, objects include data a
-
Static Methods and Properties In PHP
We've recently dived deep into the basics of Object-Programming language in PHP, in this guide, we would look into static methods and properties. In the OOP guide, I said class describes the concept
-
Abstract Classes, Interfaces and Traits In PHP
So far, we've covered OOP basics in PHP, and Static Methods, & Properties, in this guide, we would cover abstract classes in PHP. What is an abstract class? Just like I explained in the OOP basi
-
PDO: Querying Data From Database - PHP MariaDB/MySQL
In this guide, you'll learn how to query data from a MariaDB database using PHP PDO, plus an understanding of how the nuances work. So, here are the details... I have a table cmusicin marn_melodicd
Sub Categories
-
ClassicPress
-
JavaScript
-
MySQL and MariaDB
MySQL or MariaDB are one of the most popular open-source relational databases that give you the ability to create one or more database tables, each of which contains records or rows, on this page, you
-
PHP