DP DESIGN PRO dpaschenko

## Set a font size in header in PHPexcel.php
$objPHPExcel->getActiveSheet()->getHeaderFooter()
    ->setOddHeader('&C&H&25INTERVIEW WORKSHEET');

## Hreader and Footer Codes - PHPExcel.php
Header/Footer Formatting Syntax taken from Office Open XML Part 4 - Markup Language Reference, page 1970:

There are a number of formatting codes that can be written inline with the actual header / footer text, which
affect the formatting in the header or footer.

Example: This example shows the text "Center Bold Header" on the first line (center section), and the date on
the second line (center section).
                &CCenter &"-,Bold"Bold&"-,Regular"Header_x000A_&D

General Rules:

## Count Array Values.php
array_count_values

//----------------------------------------------------------------------------------------------------------------------------------------------------------------


function array_icount_values($array) {
    $ret_array = array();
    foreach($array as $value) {
        foreach($ret_array as $key2 => $value2) {
            if(strtolower($key2) == strtolower($value)) {

## Unique Array.php
<?php
$input = array("a" => "green", "red", "b" => "green", "blue", "red");
$result = array_unique($input);
print_r($result);
?>

## Get the first element of an array.php
I USE: array_shift(array_values($array));


Original answer, but costly (O(n)):

array_shift(array_values($array));
In O(1):

array_pop(array_reverse($array));
Edited with suggestions from comments for other use cases etc...

## In Array.php
<?php
$os = array("Mac", "NT", "Irix", "Linux");
if (in_array("Irix", $os)) {
    echo "Got Irix";
}
if (in_array("mac", $os)) {
    echo "Got mac";
}
?>

## Panel Collapsed.php
<div class="panel panel-flat panel-collapsed">

## SQL Date Convert.php
CONVERT(VARCHAR(10),RECORDS_ACTIONS.DTE ,101) As ActionDate,

## Remove Whitespaces & Blanks.php
            $customList = trim($customList);
            $customList = str_replace(' ', '', $customList);

## if a string contains a specific word.php
$a = 'How are you?';

if (strpos($a, 'are') !== false) {
    echo 'true';
}
	array_count_values

	//----------------------------------------------------------------------------------------------------------------------------------------------------------------


	function array_icount_values($array) {
	$ret_array = array();
	foreach($array as $value) {
	foreach($ret_array as $key2 => $value2) {
	if(strtolower($key2) == strtolower($value)) {
	<?php
	$input = array("a" => "green", "red", "b" => "green", "blue", "red");
	$result = array_unique($input);
	print_r($result);
	?>
	I USE: array_shift(array_values($array));


	Original answer, but costly (O(n)):

	array_shift(array_values($array));
	In O(1):

	array_pop(array_reverse($array));
	Edited with suggestions from comments for other use cases etc...
	<?php
	$os = array("Mac", "NT", "Irix", "Linux");
	if (in_array("Irix", $os)) {
	echo "Got Irix";
	}
	if (in_array("mac", $os)) {
	echo "Got mac";
	}
	?>
	$customList = trim($customList);
	$customList = str_replace(' ', '', $customList);
	$a = 'How are you?';

	if (strpos($a, 'are') !== false) {
	echo 'true';
	}