public function guardar() { $conexion = new Connect(); $utils = new Utils(); if ($this->con_id) { $query = 'UPDATE ' . self::DB_TBL_CONFIRMACION . ' SET con_prioridad=:con_prioridad, con_transmision=:con_transmision, con_imagen=:con_imagen, con_informacion=:con_informacion, con_url=:con_url, con_id_reserva=:con_id_reserva, con_id_tipo_evento=:con_id_tipo_evento, con_id_recurso=:con_id_recurso, con_id_canal=:con_id_canal, con_id_usuario=:con_id_usuario WHERE con_id =:con_id'; $consulta = $conexion->prepare($query); $consulta->bindParam(':con_prioridad', $this->con_prioridad); $consulta->bindParam(':con_transmision', $this->con_transmision); $consulta->bindParam(':con_imagen', $this->con_imagen); $consulta->bindParam(':con_informacion', $this->con_informacion); $consulta->bindParam(':con_url', $this->con_url); $consulta->bindParam(':con_id_reserva', $this->con_id_reserva); $consulta->bindParam(':con_id_tipo_evento', $this->con_id_tipo_evento); $consulta->bindParam(':con_id_recurso', $this->con_id_recurso); $consulta->bindParam(':con_id_canal', $this->con_id_canal); $consulta->bindParam(':con_id_usuario', $this->con_id_usuario); $consulta->bindParam(':con_id', $this->con_id); if ($consulta->execute()) { //echo "<script>alert('Datos actualizados correctamente')</script>"; return 1; } else { //echo $consulta->errorCode(); //echo "<script>alert('Error al actualizar datos')</script>"; } } else { $query2 = 'INSERT INTO ' . self::DB_TBL_CONFIRMACION . ' ( con_id, con_prioridad, con_transmision, con_imagen, con_informacion, con_url, con_id_reserva, con_id_tipo_evento, con_id_recurso, con_id_canal, con_id_usuario) VALUES( con_id, :con_prioridad, :con_transmision, :con_imagen, :con_informacion, :con_url, :con_id_reserva, :con_id_tipo_evento, :con_id_recurso, :con_id_canal, :con_id_usuario)'; $consulta = $conexion->prepare($query2); $consulta->bindParam(':con_prioridad', $this->con_prioridad); $consulta->bindParam(':con_transmision', $this->con_transmision); $consulta->bindParam(':con_imagen', $this->con_imagen); $consulta->bindParam(':con_informacion', $this->con_informacion); $consulta->bindParam(':con_url', $this->con_url); $consulta->bindParam(':con_id_reserva', $this->con_id_reserva); $consulta->bindParam(':con_id_tipo_evento', $this->con_id_tipo_evento); $consulta->bindParam(':con_id_recurso', $this->con_id_recurso); $consulta->bindParam(':con_id_canal', $this->con_id_canal); $consulta->bindParam(':con_id_usuario', $this->con_id_usuario); if ($consulta->execute()) { $this->con_id = $conexion->lastInsertId(); //echo "<script>alert('Datos actualizados correctamente')</script>"; return 1; } else { //echo $consulta->errorCode(); //echo "<script>alert('Error al actualizar datos')</script>"; echo $consulta->errorCode(); return 0; } } }