I do not know how to take the value of a select

Question

I do not know how to take the value of a select

Navigation

#1 by (0 votes)

0

Hello everyone I need to take the value of a select which I fill with php, but when sending the variables to the php file I do not take the select

            <select name = "congregacion" id = "cmbCongregacion"class = "input-100" required>
            <option value = "0">Escoga una congregación</option>
                <?php
                    $sql  = "SELECT cod_congregacion, nombre_congregacion FROM congregacion ORDER BY nombre_congregacion ASC";
                    $result = mysqli_query($con, $sql);
                    while($row = mysqli_fetch_array($result))
                    {
                ?>
                        <option value="<?php echo $row['cod_congregacion'] ?>"><?php echo $row['nombre_congregacion'] ?> </option>'
                <?php
                    }
                    mysqli_free_result($result);
                    mysqli_close($con);
                ?>
        </select>



 <?php
include ("conex.php");
$cedula = $nombre = $apellido = $cmbCongregacion = $user = $pwd = "";
if ($_SERVER["REQUEST_METHOD"] == "POST"){
    $cedula = mysqli_real_escape_string($con,$_POST['cedula']);
    $nombre = mysqli_real_escape_string($con,$_POST['nombre']);
    $apellido = mysqli_real_escape_string($con,$_POST['apellido']);
    $cmbCongregacion = mysqli_real_escape_string($con,$_POST['cmbCongregacion']);
    $user = mysqli_real_escape_string($con,$_POST['user']);
    $pwd = mysqli_real_escape_string($con,$_POST['pwd']);
    $sql  = "SELECT cedula FROM hermanos WHERE cedula = '$cedula'";
    $result = mysqli_query($con, $sql);
    $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
    $active = $row['active'];
    $count = mysqli_num_rows($result);
    if ($count >= 1){
        echo ("El usuario ya exite");
        mysqli_free_result($result);
        mysqli_close( $con);
    }else{
        $sql = "INSERT INTO hermanos (cedula, nombre, apellido) VALUES ('$cedula', '$nombre', '$apellido')";
        mysqli_query($con, $sql);
        $sql = "INSERT INTO hermano_congregacion (cod_congregacion, cedula, user, pwd) VALUES ('$cmbCongregacion', '$cedula', '$user', '$pwd')";
        mysqli_query($con, $sql);
        mysqli_free_result($result);
        mysqli_close( $con);
    }   
}   
?>

I really appreciate your help

javascript html5 html php phpmyadmin

asked by Familia Valencia Hdz 28.12.2017 в 03:41

source

1 answer

Count words that are the same as the first word of a Vector How to put the title and the votes in each item of the carousel?

score 0 · Accepted Answer

<select name = "congregacion" id = "cmbCongregacion"class = "input-100" required>
        <option value = "0">Escoga una congregación</option>
            <?php
                $sql  = "SELECT cod_congregacion, nombre_congregacion FROM congregacion ORDER BY nombre_congregacion ASC";
                $result = mysqli_query($con, $sql);
                while($row = mysqli_fetch_array($result))
                {
            ?>
                    <option value="<?php echo $row['cod_congregacion'] ?>"><?php echo $row['nombre_congregacion'] ?> </option>'
            <?php
                }
                mysqli_free_result($result);
                mysqli_close($con);
            ?>
    </select>

To pick up the select you have to do it through name , not id

Try this way:

 <?php
include ("conex.php");
$cedula = $nombre = $apellido = $cmbCongregacion = $user = $pwd = "";
if ($_SERVER["REQUEST_METHOD"] == "POST"){
    $cedula = mysqli_real_escape_string($con,$_POST['cedula']);
    $nombre = mysqli_real_escape_string($con,$_POST['nombre']);
    $apellido = mysqli_real_escape_string($con,$_POST['apellido']);
    $cmbCongregacion = mysqli_real_escape_string($con,$_POST['congregacion']);
    $user = mysqli_real_escape_string($con,$_POST['user']);
    $pwd = mysqli_real_escape_string($con,$_POST['pwd']);
    $sql  = "SELECT cedula FROM hermanos WHERE cedula = '$cedula'";
    $result = mysqli_query($con, $sql);
    $row = mysqli_fetch_array($result, MYSQLI_ASSOC);
    $active = $row['active'];
    $count = mysqli_num_rows($result);
    if ($count >= 1){
        echo ("El usuario ya exite");
        mysqli_free_result($result);
        mysqli_close( $con);
    }else{
        $sql = "INSERT INTO hermanos (cedula, nombre, apellido) VALUES ('$cedula', '$nombre', '$apellido')";
        mysqli_query($con, $sql);
        $sql = "INSERT INTO hermano_congregacion (cod_congregacion, cedula, user, pwd) VALUES ('$cmbCongregacion', '$cedula', '$user', '$pwd')";
        mysqli_query($con, $sql);
        mysqli_free_result($result);
        mysqli_close( $con);
    }   
}   
?>