-
Notifications
You must be signed in to change notification settings - Fork 0
/
telaConsultarSolicitacaoBolsaPesquisa.php
68 lines (63 loc) · 2.18 KB
/
telaConsultarSolicitacaoBolsaPesquisa.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
<!DOCTYPE html>
<html lang="pt">
<?php
include("banco/banco.php");
$query = "SELECT bp.idbolsaPesquisa,pe.nome, p.nome as programa, bp.autorizado FROM bolsapesquisa bp join programa p on bp.programa_idPrograma = p.idPrograma join pessoa pe on bp.pessoa_cpf = pe.cpf ";
$rs = Select ($query);
$row = mysql_fetch_array($rs);
?>
<?php include("head.php"); ?>
<body>
<?php include("escolheCabecario.php");?>
<div class="panel panel-default">
<!-- Default panel contents -->
<div class="panel-body">
<!-- <p> ... </p> -->
</div>
<!-- Table -->
<table class="table table-striped table-bordered table-condensed">
<!--<caption>Consulta de Beneficiario</caption> -->
<thead>
<tr>
<th>Codigo</th>
<th>Nome</th>
<th>Programa</th>
<th>Autorizado</th>
</tr>
</thead>
<tbody>
<?php
echo '<tr>';
echo"<td>".$row['idbolsaPesquisa']."</td>" ;
echo"<td>".$row['nome']."</td>" ;
echo"<td>".$row['programa']."</td>" ;
if($row['autorizado']==1){
echo"<td>Autorizado</td>" ;
}elseif ($row['autorizado']==2) {
echo"<td>Negado</td>" ;
}elseif ($row['autorizado']==0) {
echo"<td>Em analise</td>" ;
}
echo "</tr>";
while($row = mysql_fetch_array($rs)){
echo '<tr>';
echo"<td>".$row['idbolsaPesquisa']."</td>" ;
echo"<td>".$row['nome']."</td>" ;
echo"<td>".$row['programa']."</td>" ;
if($row['autorizado']==1){
echo"<td>Autorizado</td>" ;
}elseif ($row['autorizado']==2) {
echo"<td>Negado</td>" ;
}elseif ($row['autorizado']==0) {
echo"<td>Em analise</td>" ;
}
echo "</tr>";
}
?>
</tbody>
</table>
</div>
<?php include("script.html"); ?>
<?php include("foot.html"); ?>
</body>
</html>