Year: 2021

Home » 2021

Checking for null values in JavaScript, With Examples

by
Javascript Null Check

What is null in JavaScript, and how can you check if a value is equal to null? Read on to find out. What is Null? Null is a term with a special meaning in computing and computer programming. Null is not 0 (zero). Null means that something has no value. Zero is a value (a number). An empty string has a value (though sometimes called a null string, they aren’t null). A variable with a value of null is considered to be empty. It is not undefined – it has been defined … Read more

Home » 2021

How to Remove Duplicates From an Array in JavaScript [Examples]

by
Javascript Remove Duplicates from Array

Being able to remove duplicates from (or de-duplicate) an array is a useful thing to be able to do. Here’s how it’s done. What is an Array? In programming, an array is a type of variable that can hold other values, or references to other variables, in a list at a certain position. Arrays are vital to building any application – allowing you to store a list of variables or values of any length in a single variable – ready to be iterated over, processed, … Read more

Home » 2021

JavaScript – Pausing Execution or Sleep Function Equivalent

by
Javascript Pause/Sleep

JavaScript does not include a sleep function to pause execution – but you can achieve the same effect with this simple code. Unlike shell scripts and PHP, JavaScript does not include a built-in function to pause execution for a set amount of time. In other programming languages, this is usually called the sleep function. Unfortunately, JavaScript doesn’t have an equivalent function, but we can build one ourselves! JavaScript Promises Modern versions of JavaScript include support for new functionality called promises. Put simply; a promise is a new … Read more

Home » 2021

How to Use the MySQL/MariaDB COUNT Function, With Examples

by
MySQL Count

This quick article will demonstrate how to use the MySQL/MariaDB COUNT function to count the number of records returned by a query. MySQL/MariaDB COUNT Function Syntax COUNT(query) Note that: query can be an SQL query or a string representing a column name Null values found by the query will not be counted The COUNT function will return the number of matching records for a query and should be combined with the SELECT statement to output the result. Example Data The below examples use the following … Read more

Home » 2021

The MySQL/MariaDB DELETE Statement – How to Use It

by
MySQL Delete

Being able to delete data from a table in a database is a pretty important thing – This article will show you how it’s done in MySQL/MariaDB. MySQL DELETE Statement Syntax In its basic usage, the DELETE operator is used in conjunction with a WHERE query to delete records matching that query: DELETE FROM table WHERE query; Note that: table is the table you wish to delete records from query is the query that defines the conditions records should match to be deleted Safety First! Please … Read more

Home » 2021

How to List/Show Users in MySQL/MariaDB

by
MySQL Show List Users

This short article will show you how to list all of the users on your MySQL server. MySQL Users and Permissions MySQL databases usually have access granted to only certain users, each with their own permissions limiting what they can and can’t do on that specific database. As there are often multiple databases on a server, there will be several user accounts – some for different databases, some from different hosts – so it’s useful to be able to list them all out quickly. Command … Read more

Home » 2021

How to Update Records – MySQL UPDATE Statement

by
MySQL Update

This article will show you how to use the MySQL/MariaDB UPDATE statement to update existing database records. MySQL/MariaDB UPDATE Syntax The syntax for the MySQL UPDATE statement requires the use of two keywords, UPDATE, and SET, and is as follows: UPDATE table SET column = value WHERE conditions; Note that: table is the name of the table which contains the records to be updated column = value defines which column to update and what the new value for that column should be Multiple column/value pairs can be defined, separated by a … Read more

Home » 2021

How To Get Info About your PHP Environment Using phpinfo()

by
PHP phpinfo()

This article will explain what the phpinfo() function does and how to use it to get information about the PHP environment on your system. Many PHP packages and platforms (like WordPress, Laravel, and Symfony) have system requirements beyond what is included in the base PHP installation on most systems. These required modules include things like support for encryption, database support, and the ability to make HTTP requests from within PHP. To ensure that your PHP environment meets these conditions before trying to run the software, you … Read more

Categories PHP

Home » 2021

Merging/Combining Arrays in PHP with array_merge [Examples]

by
PHP array_merge

This article will explain how to merge arrays using the PHP array_merge function and provide some code examples. What is an Array? An array is a type of PHP variable that can hold other values, or references to other variables, in a list at a certain position. Arrays are really useful – allowing you to store a list of variables or values of any length in a single variable – ready to be iterated over, printed as the rows in a table, or otherwise processed. Arrays might … Read more

Categories PHP

Home » 2021

Using PHP cURL To Retrieve Data or Talk to an API

by
PHP cURL

The PHP cURL library adds support for requesting and submitting data over HTTP connections. This article will show you how to use it. There are a plethora of useful online services you can pull data from. From mapping to currency conversion, weather, flight schedules, language translations (in fact, just look at a big list of them here), these services, called APIs (Application Programming Interface), allow you to interact with massive databases of information over the HTTP protocol. PHP includes the tools to do this in its … Read more

Categories PHP