MySQL stores information in different formats. It allows different types of data to be used in different ways. The main types of data are character, numerical, and date and time. When you create a database, you tell MySQL what kind of data to expect in a particular column by using the MySQL names for data types.

A field with a NULL value is a field with no value. If a field in a table is optional, it is possible to insert a new record or update a record without adding a value to this field. Then, the field will be saved with a NULL value.

If you use Kunena forum extension for Joomla, there is a simple way to remove the footer back link. The following method works for Kunena 5.x and later versions. Follow the steps if it is necessary for you to remove Powered By Kunena Forum Footer Link. This works as of Kunena version 5.0.14.

You may get confused over choosing Windows or Linux as host operating system in both server and desktop spaces. With focus on aspects of cost, the functionality provided, hardware compatibility, support, reliability, security, existing software, and other factors, here are reasons why Linux can be better option than Windows operating system.

Linux is free and open-source, so can simply change anything in Linux. There are several Linux Distributions (also known as distros) - Ubuntu, Red Hat, Mint, Debian, Fedora.

Linux Shell or Terminal

A shell is a program that receives commands from the user and gives it to the OS to process, and then it shows the output. Linux distributions come in GUI (graphical user interface), but Linux has a CLI (command line interface). To open the terminal, press Ctrl+Alt+T in Ubuntu, or press Alt+F2, type in gnome-terminal, and press enter.

If you want all the visitor on the webpage https://example.com/initial.php to redirect to https://example.com/final.php, this can be done using several methods using PHP, JavaScript and HTML.

There are a lot of situations where you might need to get the URL of a webpage that any user might be currently visiting. For example, you may require you to dynamically generate the title of a webpage based on its URL. There are many ways in which you can obtain the URL of a webpage.

Calculating the difference between two dates is not as easy as it sounds. There are a lot of things that can go wrong if you are not careful. For example, you have to take both leap years and daylight saving time into consideration. Simply converting two dates to a timestamp and subtracting the values is not reliable in all cases. The PHP DateTime class takes care of all this.

Many times, you have to programmatically resize images. Maybe you have to create multiple sizes of the same image to serve on different devices. Maybe you need to resize images that your users are uploading. You can make use of the PHP’s GD library to resize images in PHP. GD has all the necessary functions to manipulate images so you won’t have to use any other 3rd party library.

Many times, the strings have extra spaces that need to be removed. For example, you might want to replace multiple spaces with a single space or you might want to get rid of all the whitespace in a string. Similarly, you might be planning on stripping all the whitespace from either the left or the right end of a string.

You can upload files on server using a HTML form and PHP. You can upload any kind of file like images, videos, ZIP files, Microsoft Office documents, PDFs, and other files. The uploaded file can be saved in any folder on permanent basis. You can also implement some basic security check like file type and file size to ensure that users upload the correct file type and within the allowed limit.

PHP allows you to work with directories on the file system. For example, you can open a directory and read its contents, create or delete a directory, list all files in the directory, and so on.

PHP can be used to handle files on the server. You can create, access (or read) and manipulate files dynamically using the PHP file system functions. Since PHP is a server side programming language, it allows you to work with files and directories stored on the web server. To work with a file, first you need to open the file.

PHP 5 introduced new object oriented way of dealing with errors. Exceptions are used to change the normal flow of a script if a specified error occurs. Exception handling is used to change the normal flow of the code execution if a specified error (exceptional) condition occurs. This condition is called an exception.

You can use the array_shift() function to remove the first element or value from an array. The array_shift() function returns the removed first value of array. If the array is empty (or the variable is not an array), the returned value is NULL.

You can use the array_pop() function to remove an element or value from the end of an array. The array_pop() function returns the last value of array. If the array is empty (or the variable is not an array), then the returned value is NULL.

Joomla 4.0 is Joomla’s new major version. Joomla 3.9 is released alongside Joomla 4 as the last minor release of Joomla 3. Joomla 3.9 will continue to be supported for 2 years giving plenty of time to webmasters to plan migration to Joomla 4 and update extensions to Joomla 4 compatible versions.

Joomla! 3.8 is the ninth standard-term support release in the Joomla 3 series. It was released on 19 September, 2017. This release features over 300 improvements to the CMS, with two primary major features aimed at developers: the new routing system and the beginning of a forward compatibility layer with Joomla! 4.0. Additionally, two security issues have been resolved.