예제 #1
0
                            <?php 
$data = 1;
LayoutPadrao::ListaCursoss(0, '', 'disciplina', 'id_disciplina', 'nome_disciplina');
?>
                            <span class="help-block"></span>
                        </div>
                    </div>
                    <div class="control-group <?php 
echo !empty($id_professorError) ? 'has-error' : '';
?>
">
                        <label class="control-label" for="inputid_prof">Professor</label>
                        <div class="controls">
                            <?php 
$data = 1;
LayoutPadrao::ListaCursoss(0, '', 'professor', 'id_professor', 'nome_professor');
?>
                            <span class="help-block"></span>
                        </div>
                    </div>
                     <div class="control-group <?php 
echo !empty($horas_turmaError) ? 'has-error' : '';
?>
">
                        <label class="control-label" for="inputidade_hora">Horas</label>
                        <div class="controls">
                            <input style="height:30px" type="number" min="1" required="required"  id="inputidade_hora" value="<?php 
echo !empty($horas_turma) ? $horas_turma : '';
?>
" name="horas_turma" placeholder="horas turma">
                            <span class="help-block"></span>
예제 #2
0
    public static function MenuBusca($modo, $dados, $titulo, $titulo1, $titulo2, $nome, $texto, $link, $tabela, $id, $campo)
    {
        echo '
                <link rel="stylesheet" href="../layout/bootstrap/bootstrap.min.css">
                <link rel="stylesheet" href="../layout/bootstrap/bootstrap-theme.min.css">
                <script src="../layout/bootstrap/bootstrap.min.js"></script>
                <div class="navbar navbar-inverse" role="navigation">
					<div class="navbar-header">
				        <button type="button" class="navbar-toggle" data-toggle="collapse" data-target=".navbar-ex1-collapse">
				        <span class="sr-only">Toggle navigation</span>
				        <span class="icon-bar">a</span>
                                        <span class="icon-bar">a</span><span class="icon-bar">a</span><span class="icon-bar">a</span>
				         </button>
				        <a class="navbar-brand" rel="home">Buscar Por:</a>
                                         </div>
                                        <form class="navbar-form" action="' . $link . '" method="post">';
        if (!empty($dados[$titulo][$nome])) {
            echo '<input type="text"   class="navbar-form" style="height:33px" name="' . $dados[$titulo][$nome] . '" placeholder="' . $dados[$titulo][$texto] . '" value="">';
        }
        if (!empty($dados[$titulo1][$nome])) {
            echo ' <input type="text"   class="navbar-form" style="height:33px" name="' . $dados[$titulo1][$nome] . '" placeholder="' . $dados[$titulo1][$texto] . '"value="">';
        }
        if (!empty($dados[$titulo2][$nome])) {
            echo '  <input type="number" class="navbar-form" style="height:33px" name="' . $dados[$titulo2][$nome] . '" min="14" placeholder="' . $dados[$titulo2][$texto] . '" value="" >';
        }
        if (!empty($tabela)) {
            echo LayoutPadrao::ListaCursoss($modo, 1, $tabela, $id, $campo);
        }
        //   if (!empty($tabela1)){ echo LayoutPadrao::ListaCursoss($modo,$tabela,$id,$campo);}
        //   if (!empty($tabela2)){ echo LayoutPadrao::ListaCursoss($modo,$tabela,$id,$campo);}
        //  if (!empty($tabela3)){ echo LayoutPadrao::ListaCursoss($modo,$tabela,$id,$campo);}
        echo '   <button type="submit" class="btn btn-success"><span class="glyphicon glyphicon-search"></span></button>';
        echo '<input type = "checkbox" name = "cbksql" value = "valor"><label class="sr-only"><a class=" btn navbar-brand" rel="home">Exibir SQL</a> </span> ';
        echo '         </form>	
                                                                    
						                </div>
				        		   </div>
                                                       ';
    }
                            <?php 
$data = 1;
LayoutPadrao::ListaCursoss(0, '', 'disciplina', 'id_disciplina', 'nome_disciplina');
?>
                            <span class="help-block"></span>
                        </div>
                    </div>
                    <div class="control-group <?php 
echo !empty($id_matriculaError) ? 'has-error' : '';
?>
">
                        <label class="control-label" for="inputid_prof">Aluno</label>
                        <div class="controls">
                            <?php 
$data = 1;
LayoutPadrao::ListaCursoss(0, '', 'aluno', 'id_matricula', 'nome_aluno');
?>
                            <span class="help-block"></span>
                        </div>
                  
                    <div class="form-actions">
                        <button type="submit" class="btn btn-success">Salvar</button>
                        <a class="btn btn-default" href="../../index.php">Voltar</a>
                    </div>
                </form>

            </div> <!-- /row -->
        </div> <!-- /container -->

    </body>
    <?php 
?>
        <div class="container">
            <div class="col-sm-8" style="background-color:lavender;">
                <center><h1>Quantidade de Alunos de Cada Disciplina:</h1></center>

                     <form action="relAlunosDisciplina.php" method="post">
                    

                   
                        <div class="form-inline">

            <div class="control-group ">
                        <label class="control-label" for="inputid_dicip">Disciplina</label>
                        <div class="controls">
                            <?php 
LayoutPadrao::ListaCursoss(0, '', 'disciplina', 'id_disciplina', 'nome_disciplina');
?>
                            <span class="help-block"></span>
                        </div>
                    </div>
                        </div>	
                         <div class="form-actions">
                        <button type="submit" class="btn btn-success">Buscar</button>
                       
                    </div>
                    </form>
                <h4><p><blockquote><?php 
echo '<table><tr><td>Disciplinas :</td><td>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td><td>Numero de alunos Matriculados</td> </tr> ';
$pdo = Database::connect();
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
foreach ($pdo->query(" SELECT COUNT(aluno.id_matricula)As Alunos ,disciplina.nome_disciplina\n             FROM aluno,matricula,turma,disciplina\n\t\t\t WHERE aluno.id_matricula = matricula.id_matricula\n\t\t\t AND matricula.id_turma = turma.id_turma\n\t\t\t AND matricula.id_disciplina = turma.id_disciplina\n\t\t\t AND turma.id_disciplina = disciplina.id_disciplina\n                         {$and}\n                \t GROUP BY disciplina.nome_disciplina") as $row) {
                        <label class="control-label" for="inputid_dicip">Disciplina</label>
                        <div class="controls">
                            <?php 
LayoutPadrao::ListaCursoss(2, $data, 'disciplina', 'id_disciplina', 'nome_disciplina');
?>
                            <span class="help-block"></span>
                        </div>
                    </div>
                    <div class="control-group <?php 
echo !empty($id_professorError) ? 'has-error' : '';
?>
">
                        <label class="control-label" for="inputid_prof">Professor</label>
                        <div class="controls">
                            <?php 
LayoutPadrao::ListaCursoss(2, $data, 'professor', 'id_professor', 'nome_professor');
?>
                            <span class="help-block"></span>
                        </div>
                    </div>
                     <div class="control-group <?php 
echo !empty($horas_turmaError) ? 'has-error' : '';
?>
">
                        <label class="control-label" for="inputidade_hora">Horas</label>
                        <div class="controls">
                            <input style="height:30px" type="number" min="1" required="required"  id="inputidade_hora" value="<?php 
echo !empty($horas_turma) ? $horas_turma : '';
?>
" name="horas_turma" placeholder="horas turma">
                            <span class="help-block"></span>