Irvin Pool Panta GarciaPublicado en Mysql, PHP 
function consultar($flag, $sede = '') {
      $data = array();
	  $query = 'CALL pa_maeConsultar("'.$flag.'", "'.$sede.'")';
	  $result = parent::query($query);     
	  if(!isset($result['error'])){
	     foreach ($result as $row) {
	         $data[] = $row;
	     }         
	  } else {
	     $this->setMsgErr($result['error']);
	  }
	  return $data;
}

public function mantenerData($xFlag, $xForm) {
    $data = array();      
    $xCampo = "";
    $xCheckbox = 0;

    if ($xFlag == "1" || $xFlag == "2") {
        $xCampo = $xForm["name"];
        $xCheckbox = isset($xForm["namechk"]) ? 1 : 0;
    }elseif ($xFlag == "3"){
       $xCampo = $xForm;
    }       
    $query = " 
       CALL pa_maeMantenimiento(
	        '{$xFlag}',
	        '{$xCampo}',
	        '{$xCheckbox}'
	    )
	 ";
	 $result = parent::query($query);
	 if (!isset($result["error"])) {
	    foreach ($result as $row) {
	       $data[] = $row;
	    }
	 } else {
	     $this->setMsgErr($result["error"]);
	 }
	 return $data;
}