The do…while loop example: <?php $i = 1; Do { $i++; echo $i . “<br>”; } while($i <= 3); ?> Output: 2 3 4 Difference …
Continue ReadingThe While loop
A While loop is used when we have to repeat a set of statements as long as the condition is false. It could be the …
Continue ReadingThe FOR Loop
PHP for loop can be used to traverse set of code for the specified number of times. For example if you want to repeat something …
Continue ReadingPHP- DATE/TIME FUNCTIONS
When working in any programming language, dealing with dates and time is a simple task. That is, until time zones have to be supported. PHP’s …
Continue ReadingExcel CONCATENATE Function
Excel CONCATENATE function is one of the best time saving Excel function. You must have seen people copying the value from one cell and then …
Continue ReadingExcel Right Left and Mid Functions
Excel Right, Left and Mid functions return number of characters from selected text. These formulas can be used to get a pattern of characters from …
Continue ReadingExcel Trim Function
Excel Trim function is very useful function that removes extra spaces from data. This formula removes all spaces from data except for single space between …
Continue ReadingExcel Length Formula
Excel LEN formula is used to get number of characters in a cell. The formula counts the number of characters in a cell including spaces …
Continue ReadingExcel Count Function
Excel COUNT function counts the cells which has numeric values. For instance if we want count total cells that has only and only numeric values …
Continue ReadingExcel Sum Function
SUM function is one of the most used function in MS Excel. This formula not only adds user defined values in a cell but also …
Continue Reading