# Topics

## PHP

#### SQL sqrt Function | Square Root of a Number

SQL sqrt is an inbuilt Math Function in SQL Server. It calculates the square root of an input number in SQL Server. In this article, we will discuss the SQL sqrt Function. Also, we will discuss a few examples of using it. Syntax SQRT (number) Parameters The function expects only ...

#### PHP decbin Function | Convert Decimal To Binary String

PHP decbin is an inbuilt Math Function in PHP. It converts an input decimal integer into its corresponding binary representation string. You can convert a binary string to its corresponding decimal integer using PHP bindec Function. Syntax decbin (\$integer) Parameters The function accepts only one parameter. The decimal value for ...

#### PHP bindec Function | Convert a Binary to Decimal

PHP bindec is an inbuilt Math Function in PHP. It converts an input binary string into its corresponding decimal representation. In this article, we will discuss the PHP bindec Function. You can use the PHP decbin Function to convert a decimal integer to it's corresponding binary string. Syntax bindec (\$binaryString) ...

#### SQL abs Function | Absolute Value of an Integer

SQL abs is an inbuilt Math function in SQL Server. It returns the absolute (positive) value of a number. It is identical to modulus in mathematics. In this article, we will discuss the abs Function in SQL Server. Also, we will discuss examples of using it. Syntax ABS (number) Parameters ...

#### PHP substr_count Function | Count of Occurrences of Substring

PHP substr_count is an inbuilt String Function in PHP. It calculates the number of occurrences of a substring in another string. Also, the function provides an option to search the substring within a range in the string. In this article, we will discuss the PHP substr_count Function. Also, we will ...

#### PHP exit Function | Print a Message and Exit Script

PHP exit is a very useful and important inbuilt function in PHP. It prints a message and exits the current running script. Therefore, any code after the exit function will not be executed. Also, shutdown functions and object destructors are always executed even after the exit function. In this article, ...

#### PHP die Function | Print a Message and Exit Script

PHP die is a very useful and important inbuilt function in PHP. It prints a message and exits the current running script. Therefore, any code after the die function will not be executed. Also, shutdown functions and object destructors are always executed even after the die function. In this article, ...

#### PHP print | Print a Single String as Output

PHP print is not exactly a function, but a language construct which prints a single string in the output. Since it is a language construct and not a function, it is not mandatory to use parentheses with its argument list. In this article, we will discuss the PHP print Function ...

#### PHP str_rot13 Function | rot13 Transform on a String

PHP str_rot13 is an inbuilt string function in PHP. It performs ROT13 transformation on a string by excluding numeric and non-alphanumeric characters. Also, if you input an encoded string, the function returns the original string back. In this article, we will discuss the PHP str_rot13 Function. Also, we will discuss ...

#### PHP hex2bin Function | Convert Hexadecimal to Binary String

PHP hex2bin is an inbuilt function in PHP. It converts a hexadecimal character sequence back to a binary string. However, it does not convert the hexadecimal string to binary number. In this article, we will discuss the PHP hex2bin Function. Also, we will discuss a few examples of using it ...

View All on PHP >

## MySQL

#### MySQL INSTR | Case Insensitive Position of String in String

MySQL INSTR Function is an inbuilt function in MySQL. It finds the first position of occurrence of a substring in another string. Moreover, it performs the search in a case-insensitive manner. In this article, we will discuss the MySQL INSTR Function. Also, we will discuss a few examples of using ...

#### MySQL ASCII Function | Return ASCII Value of First Character

MySQL ASCII is an inbuilt function in MySQL. It returns the ASCII value of the first character of the input string to it. In this article, we will discuss the MySQL ASCII Function. Also, we will discuss a few examples of using it. Syntax ASCII (string) Parameters The MySQL ASCII ...

#### MySQL INSERT Function | Insert String Within a String

MySQL INSERT function is an inbuilt function in MySQL. It inserts a string within another string removing the corresponding characters from the original string. In this article, we will discuss the MySQL INSERT Function. Also, we will discuss a few examples of using it. Syntax INSERT(string, position, length, replaceString) Parameters ...

#### MySQL FIND_IN_SET | String Position in List of Strings

MySQL FIND_IN_SET is an inbuilt function in MySQL. It returns the position of a string in a list of string separated by commas. Also, the function performs the search in a case-insensitive manner. In this article, we will discuss the MySQL FIND_IN_SET Function. Also, we will discuss a few examples ...

#### MySQL FORMAT Function | Format a Number after Rounding

The FORMAT Function is an inbuilt function in MySQL. It converts a number in a format like "#,###,###.###" after rounding it to a specified number of decimal places. Also, it returns the number as a string. In this article, we will discuss the MySQL FORMAT Function. Also, we will discuss ...

#### MySQL FIELD Function | Get Position of Value in a List

MySQL FIELD is an inbuilt function in MySQL. It returns the index position of a value in a list of values. It compares the position of a value in a list of remaining values in a case-insensitive search. In this article, we will discuss the MySQL FIELD Function. Also, we ...

#### MySQL LENGTH Function | Length of String

MySQL LENGTH is an inbuilt function in MySQL. It returns the length of the input string according to a total number of bytes of the characters. Therefore, it does not ignore whether the characters are single-byte or multi-bytes. It counts a single byte character as 1 and a 2-byte character ...

#### MySQL CHARACTER_LENGTH Function | Length of String

MySQL CHARACTER_LENGTH is an inbuilt function in MySQL. It returns the length of the input string by counting the number of characters. Also, it ignores whether the characters are single-byte or multi-bytes. It simply counts the number of characters. In this article, we will discuss the MySQL CHARACTER_LENGTH Function. Note: ...

#### MySQL CHAR_LENGTH Function | Length of String

MySQL CHAR_LENGTH is an inbuilt function in MySQL. It returns the length of the input string by counting the number of characters. Also, it ignores whether the characters are single-byte or multi-bytes. It simply counts the number of characters. In this article, we will discuss the MySQL CHAR_LENGTH Function. Also, ...

#### MySQL RIGHT | Extract Characters from Right of String

MySQL Right is an inbuilt function in MySQL. It extracts a number of characters from a string starting from the right. In this article, we will discuss the MySQL Right Function. Also, we will discuss a few examples of using it. Also, you can read about MySQL LEFT Function. Syntax ...

View All on MySQL >

## Linux

#### Linux Watch Command | Run Command at Regular Intervals

Watch Command in Linux is a useful command which is present in most of the Linux Based Systems. It runs a command at regular intervals and displays its output. It is useful when you have to run a command repeatedly and watch the output for any changes. For example, you ...

#### Load Average | Monitor Performance of Linux System

You must have seen the three magical numbers in Linux called the 'Load Average'. In fact, all Unix based systems like Linux, MAC etc display these Numbers. Although they are not self-explanatory, it's easy to get familiar with them. In this article, we will discuss Monitoring Performance and Understanding Load ...

#### Anacrons Vs Crons | Setting Up Anacrons on Linux

One of the biggest weakness of using Crontab is that it assumes that your system is always on. The task will never run if the system is not powered on at that time. In this article, we will discuss another way to schedule repeated tasks using Anacrons. What are Anacrons? ...

#### Using Screen in Linux to Resume Sessions

Many times we need to perform a long-running task on a remote machine. The SSH connection might get disconnected due to a network connectivity issue or power failure. As a result of that, you will lose all your work as you can’t resume the session. Luckily, Linux provides a utility ...

#### Configuring Crontab In Ubuntu Explained

You can automate many tasks in your system or your server using Crontab in Ubuntu in order to prevent manual work. In this article, I will discuss configuring crontab in Ubuntu with examples. What is Crontab? The CRON daemon is an always running utility which executes certain commands at specific ...

View All on Linux >