Search in the database with select

Question

I am developing a website to display registered videos, for this I did with a select to select the desired discipline of the user. Soon after I put a button to display these registered videos pulling from MYSQL (based on the selected discipline).

How can I get the id of select and search, based on this id of the selected discipline, the uploaded videos?

I have a part of a previous code, but it was used to identify the logged in user, can serve as a basis for solving the problem.

Search code in mysql:

   <?php

    $disciplina = $_SESSION['disciplina_prof'];
    $servidor = 'localhost';
    $usuario  = 'root';
    $senha    = 'root';
    $banco    = 'onteach';
    $conexao  = mysqli_connect($servidor, $usuario, $senha, $banco);

    $consulta = "SELECT
                    *
                FROM
                    video_monitor
                WHERE
                    video_monitor.disciplina     = '$disciplina'
                    AND video_monitor.pendente = 1";

    $resultados       = mysqli_query($conexao, $consulta);
    $videos_pendentes = array();

    while ($video = mysqli_fetch_assoc($resultados))
        $videos_pendentes[] = $video;

    mysqli_free_result($resultados);
    mysqli_close($conexao);

    $videos_pendentes = json_encode($videos_pendentes);

?>

Script code to select the data that will appear in the Carousel: (modify to the DISCIPLINE ID, 1 for "Physics", 2 for "Mathematics") The select of this discipline is in html like this:

<div class="box">
                        <select name="disciplina_prof" id="disciplina_prof">
                          <option value="" selected=selected>Selecione uma disciplina</option>
                          <?php
                          if($num_logar > 0) {
                              do {
                              echo "<option value='".$fet_logar['disciplina_id']."'>".$fet_logar['disciplina_nome']."</option>";
                              }while($fet_logar = mysqli_fetch_assoc($exe_logar));
                          }
                          ?>          
                        </select>
                        <?php print_r($consulta);?>
                      </div>

An example that after mysql selected the discipline these would be displayed in Carousel:

 $('#btn-lista-videos-carousel').click(function() {
            let itens       = '';
            let indicadores = '';

            if (videos_pendentes.length > 0) {

                videos_pendentes.forEach(function(video, indice) {
                    indicadores += '<li data-target="#carouselExampleIndicators" data-slide-to="' + indice + '" class="' + (indice == 0? 'active' : '') + '"></li>'

                    itens += '<div class="carousel-item ' + (indice == 0? 'active' : '') + '">';
                    itens += '    <iframe  width="100%" height="350" src="https://www.youtube.com/embed/'+ video.link_video +'" frameborder="0" allowfullscreen></iframe>' 
                    itens += '</div>';

                });

                console.log(indicadores);

                $('#carouselExampleIndicators').show();
                $('#carousel-indicadores').html( indicadores );
                $('#carousel-itens').html( itens );

            } else {

                alert('Nenhum vídeo pendente');

            }
        });


        $('.carousel').carousel();

    });

</script>

Answer 1

Bro, from what I understand, you don’t have to do those two actions. you can do it like this. using a select that sends straight to Session when selected. I think that’s what you want

this php part, you will receive the data on the page itself.

$_SESSION['disciplina_prof'] = '';

if(isset($_GET['disciplina']))
{
    $_SESSION['disciplina_prof'] = $_GET['disciplina'];
    $disciplina = $_SESSION['disciplina_prof'];
} else {
    $_SESSION['disciplina_prof'] = '';
    $disciplina = $_SESSION['disciplina_prof'];
}

$selected = function($check) {
if($_SESSION["disciplina_prof"] == $check) {
return 'selected';
}
};

?>

example of use:

<select name="forma" onchange="location = this.value;">
 <option <?php echo ($_SESSION['disciplina_prof'] == 0)  ? 'selected' : '' ; ?> value="index.php?disciplina=null"></option>
 <option <?php echo ($_SESSION['disciplina_prof'] == 1)  ? 'selected' : '' ; ?> value="index.php?disciplina=1">Física</option>
 <option <?php echo ($_SESSION['disciplina_prof'] == 2)  ? 'selected' : '' ; ?> value="index.php?disciplina=2">Matemática</option>
</select>

adapted to your select code.

<select name="disciplina_prof" id="disciplina_prof" onchange="location = this.value;">
    <option <?php echo ($_SESSION['disciplina_prof'] == 0)  ? 'selected' : '' ; ?> value="professor.php?disciplina=null">Selecione uma disciplina</option>
    <?php
    if($num_logar > 0) {
        do {
        echo "<option ". $selected($fet_logar['disciplina_id']) ." value=professor.php?disciplina=".$fet_logar['disciplina_id'].">".$fet_logar['disciplina_nome']."</option>";
        }while($fet_logar = mysqli_fetch_assoc($exe_logar));
    }
    ?>
</select>

Answer 2

Hello, at this point where you say:

I’m developing a website to display registered videos, to this I did with a select to select the desired discipline of user.

I’m seeing the video table query, but the user table query is missing since you want to show the user information;

example:

SELECT * FROM video_monitor a
inner join usuario b on a.usuarioid = b.ID
WHERE video_monitor.disciplina = '$disciplina'
AND video_monitor.pendente = 1
AND B.ID = 1