

<?php
    if(isset($_POST['limite'])) {
        foreach($_POST as $key => $value) {
            $key = Statics::SafeInput($con, $key);
            $value = !empty($value) ? Statics::SafeInput($con, $value) : 0;
            if($key != 'limite') {
                $Schema->executeQuery('UPDATE VEHICULOS_PORTALES SET LIMITE = ? WHERE ALIAS = ?', 'is', [$value, $key]);
            }
        }
        $is_valid = 'is-valid';
    } else {
        $is_valid = FALSE;
    }
    $html = '<form action="#" method="post" class="mt-3">';
        $html .= '<div class="form-row">';
            $res = $Schema->executeQuery('SELECT * FROM VEHICULOS_PORTALES WHERE ACTIVO = ?', 'i', [1]);
            while($row = $res->fetch_array()) {
                $html .= '<div class="form-group col-12 col-md-6 mb-4">';
                    $html .= '<label for="' . $row['ALIAS'] . '">' . $row['DESCRIPCION'] . '</label>';
                    $value = !empty($row['LIMITE']) ? $row['LIMITE'] : FALSE;
                    $html .= '<input type="number" name="' . $row['ALIAS'] . '" value="' . $value . '" class="form-control ' . $is_valid . '" id="' . $row['ALIAS'] . '" placeholder="' . $sin_limite_lg . '">';
                $html .= '</div>';
            }
        $html .= '</div>';

        $html .= '<button type="sumbit" name="limite" class="btn btn-primary">' . $actualizar_lg . '</button>';
    $html .= '</form>';

    echo $html;
?>
    
