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("dni"); $sql->addValue(":dni"); $sql->addSelect("nombre"); $sql->addValue(":nombre"); $sql->addSelect("fechaAlta"); $sql->addValue(":fechaAlta"); $sql->addSelect("cuota"); $sql->addValue(":cuota"); }
private function _crearLoad() { $bd = new MySQL(); $sql = new Sql(); $base = $bd->getBase(); $tb = $bd->getTabla(); $tabla = $base . ".{$tb}"; $sql->addTable($tabla); $sql->addSelect("*"); $sql->addWhere("codigo = :codigo"); 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("usuario"); $sql->addValue(":usuario"); $sql->addSelect("clave"); $sql->addValue(":clave"); $sql->addSelect("nombre"); $sql->addValue(":nombre"); $sql->addSelect("apellidos"); $sql->addValue(":apellidos"); $sql->addSelect("email"); $sql->addValue(":email"); return $sql; }
private function _crearLoad() { $bd = new MySQL(); $sql = new Sql(); $base = $bd->getBase(); $tb = $bd->getTabla(); $tabla = $base . ".{$tb}"; $sql->addTable($tabla); $sql->addSelect("*"); $curso = $_POST['curso']; if (isset($_POST['nota'])) { $nota = $_POST['nota']; } else { $nota = ""; } if (!empty($this->_asignatura)) { $sql->addWhere("asignatura = :asignatura"); } if ($curso != 'Todos') { $sql->addWhere("curso = :curso"); } if ($nota == 'suspensos') { $sql->addWhere("nota < 5"); } elseif ($nota == 'aprobados') { $sql->addWhere("nota >= 5"); } return $sql; }