Usage Procedure with Laravel.

MysqliConn.php

<?php
class MysqliConn{
  	
  	/**
        * @return Instance of Mysqli $mysqli
        * @author Flávio Henrique Ferreira <[email protected]>
        **/
        
	public static function conecta(){
        /*
         * Config sets in the app/config/database.php 
         */
		$connection = Config::get('database.connections.mysql');
		$host     = $connection['host'];
		$database = $connection['database'];
		$username = $connection['username'];
		$password = $connection['password'];
		$mysqli = new mysqli($host, $username, $password, $database);
		return $mysqli;

	}

  	/**
        * @return result of call/execute to $sql
        **/
	public static function executaProcedure($sql){

		$mysqli = self::conecta();
		return $mysqli->query( $sql );
		
	}

}
/* Usage */
$sql    = "call updateProfiles();";
$result = MysqliConn::executaProcedure($sql);