<?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>
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> </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>