private function _crearLoad($campos = array(), $tabla = '', $accion = '') { $bd = new MySQL(); $sql = new Sql(); $base = $bd->getBase(); $tabla = $base . ".{$tabla}"; $sql->addTable($tabla); switch ($accion) { case 'buscar': $sql->addSelect("*"); if ($campos) { foreach ($campos as $key => $value) { $sql->addWhere($key . " = :" . $key); } } break; case 'guardar': $sql->setFuncion("insert"); if ($campos) { foreach ($campos as $key => $value) { $sql->addSelect($key); $sql->addValue(":" . $key); } } break; case 'eliminar': $sql->setFuncion("delete"); if ($campos) { foreach ($campos as $key => $value) { $sql->addWhere($key . " = :" . $key); } } break; case 'modificar': $sql->setFuncion("update"); if ($campos) { foreach ($campos['select'] as $key => $value) { $sql->addSelect($key . " = :" . $key); } foreach ($campos['where'] as $key => $value) { $sql->addWhere($key . " = :" . $key); } } break; } return $sql; }
private function _crearGuardar() { $bd = new MySQL(); $sql = new Sql(); $base = $bd->getBase(); $tb = $bd->getTabla(); $tabla = $base . ".{$tb}"; $sql->addTable($tabla); $sql->setFuncion("insert"); $sql->addSelect("nombre"); $sql->addValue(":nombre"); return $sql; }