How to Convert an Multidimensional Array to One Dimensional Array
//First Method with No Argument

$this->RestructArray($arrTempCounts)

//Second Method with  Column Name as Argument
$this->RestructArray($arrTemp, 'UserNums');

function RestructArray($parrInput, $pArg1 = 0)
{
	$arrTemp = $parrInput;
	
	for($i=0;$i<count($parrInput);$i++)
	{
		$arrNames[$i] = $parrInput[$i][$pArg1];
	}
	return $arrNames;
}

How to Convert an One Dimensional Array to Multidimensional Array

$k = 0;
for($j=0;$j<$lngCols;$j++)
{
	for($i=0;$i<$lngRows-1;$i++)
	{		
		$arrTemp[$j][$i] = $arrIndividualCounts[$k];
		$k = $k+1;
	}
}
Posted in PHP.

How to Run Multiple Queries at Once in OOP
Note:The SQL Queries Shld be seperated by Semicolon(;)

$Conn = $this->dbConnect;
$strSQL = "SELECT name FROM tbSample1;";
$strSQL = $strSQL."SELECT age FROM tbSample1;";

if ($Conn->multi_query($strSQL)) 
{
	 do 
	 { 
		/* store first result set */
		if ($result = $Conn->store_result()) 
		{	
			while ($row = $result->fetch_row()) 
			{
				$item = array();
				$item = $row;
				$arrTempCounts[] = $item;
			}
			$result->free();
		}
		/* print divider */

		if ($Conn->more_results()) 
		{
		 print("-----------------n");
		}
	}while ($Conn->next_result());
}

Posted in PHP.

Storing Array In Cookie and Retrieving it

  $arrNames= array('Name'=>'Mugil',
               	   'Email'=>'Mugil@cse.com', 
	           'ContactNo'=>'9962945097');
  
  $strDetails = implode(',', $arrNames);

  setcookie('Details', $strDetails, time()+ 3600*24);

  if(isset($_COOKIE['Details']))
  {
    $arrDetails = explode(',', $_COOKIE['Details']);
	
    for($i=0;$i<count($arrDetails);$i++)
     print $arrDetails[$i]."
"; }
Posted in PHP.

Mysqli Method
Procedure

  DROP PROCEDURE IF EXISTS prSample1;
  CREATE PROCEDURE prSample1(OUT Name VARCHAR(255))
  BEGIN
    SET Name = 'Mugil';
    SELECT Name;
  END;

Call to Procedure From PHP

  $Conn = new mysqli('localhost', 'root', '', 'metroplots');				

  $strSQL = "CALL prSample1(@Name)";
  $stmt   = $Conn->prepare($strSQL);

  $stmt->execute();
  $stmt->bind_result($Name);	

  while($stmt->fetch())
   $strName = $Name;