<?php

class dbconexion
{
	
	var $db="xxxx";
	var $user="xxxx";
	var $password="";
	var $host="localhost";
	var $conneccion;
	function conectarse()
	{
		$this->conneccion= mysqli_connect($this->host,$this->user,$this->password,$this->db);
		return $this->conneccion;

	}

	function procedimiento($sql)
	{
		$_displayResult = mysqli_query($this->conectarse(),$sql);
		return $_displayResult;
	}

}

/*
$objeto = new dbconexion();
$rs = $objeto->procedimiento("call sp_vista_ciudad();");
while($fila = $rs->fetch_assoc())
{
    print_r($fila);

}*/



?>

Class of store procedure in PHP with mysqli

PHP store procedure  with mysqli

PHP