Usamos cookies para medir audiência e melhorar sua experiência. Você pode aceitar ou recusar a qualquer momento. Veja sobre o iMasters.
Olá, vou resumir meu projeto:
Tenho uma tabela:
CREATE TABLE `vg_pes_area_usuario` (
`cod_usuario` varchar(255) NOT NULL,
`cod_area` varchar(255) NOT NULL,
`respondido` varchar(255) NOT NULL,
`cod_pergunta` varchar(255) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Onde me exibe os dados:
Certo... Eu tenho a página index.php que me mostra um modal para responder as perguntas:
Ao clicar em uma pergunta, ele me exibe o modal:
Como perceberam, ele mostra 2 ADMCORP, mas eu não quero isso, o que ele está fazendo é: Selecionando as duas áreas, mas eu quero que ele selecione apenas da pergunta que eu selecionar, ele pega as duas por que eu tenho 2 registros da mesma área mas de pergunta diferente:
Eu quero que, se eu selecionar a pergunta 1, apenas apareça 1, que corresponde aquela pergunta, e não os dois, e quando eu selecionar a pergunta 2, exiba o ADMCORP da pergunta 2, segue o PHP que eu crio dinamicamente:
<?php
include_once('app/config.php');
$queryResult = "SELECT
vg_perguntas.descricao_pergunta,
vg_pes_area_usuario.cod_usuario,
vg_perguntas.id_pergunta,
vg_pes_area_usuario.cod_pergunta,
vg_pes_area_usuario.cod_area,
vg_pes_area_usuario.respondido
FROM
vg_perguntas
INNER JOIN
vg_pes_area_usuario ON vg_perguntas.id_pergunta = vg_pes_area_usuario.cod_pergunta
WHERE
vg_pes_area_usuario.respondido = 'N' AND vg_pes_area_usuario.cod_usuario = 'jesse.pereira'";
$result = mysqli_query($mysqli, $queryResult);
$sql = "SELECT * FROM vg_perguntas";
$resultado = mysqli_query($mysqli, $sql);
?><html lang="pt-BR">
<head>
<meta charset="utf-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1">
<meta name="description" content="">
<meta name="author" content="">
<title>Starter Template for Bootstrap</title>
<link href="css/bootstrap.min.css" rel="stylesheet">
<link href="css/ie10-viewport-bug-workaround.css" rel="stylesheet">
<link href="css/starter-template.css" rel="stylesheet">
<link rel="stylesheet" href="css/style.css"/>
<script src="js/ie-emulation-modes-warning.js"></script>
<style type="text/css">
label {margin-right:14px;}
</style>
</head>
<body>
<nav class="navbar navbar-inverse navbar-fixed-top">
<div class="container">
<div class="navbar-header">
<button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
<span class="sr-only">Toggle navigation</span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
<span class="icon-bar"></span>
</button>
<a class="navbar-brand" href="#">Project name</a>
</div>
<div id="navbar" class="collapse navbar-collapse">
<ul class="nav navbar-nav">
<li class="active"><a href="#">Home</a></li>
<li><a href="#about">About</a></li>
<li><a href="#contact">Contact</a></li>
</ul>
</div>
</div>
</nav>
<br>
<div class="container">
<div class="list-group">
<?php
if ($res=$mysqli->query($sql)) {
if($res)
{
while($row = mysqli_fetch_array($res)):
?>
<a href="#" data-toggle="modal" data-target="#are_mdl" data-whatever="<?php echo $row["id_pergunta"]; ?>"data-whateverdescricaopergunta="<?php echo utf8_encode($row["descricao_pergunta"]); ?>"data-whateverid_pergunta="<?php echo utf8_encode($row["id_pergunta"]); ?>" class="list-group-item"><?php echo $row['id_pergunta']." - "; echo utf8_encode($row['descricao_pergunta']);?></a>
<?php endwhile; ?>
<br>
</div>
</div>
<?php }} ?>
<div class="modal fade" id="are_mdl" tabindex="-1" role="dialog" aria-labelledby="are_mdlLabel">
<div class="modal-dialog" role="document">
<div class="modal-content">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-label="Close"><span aria-hidden="true">×</span></button>
<h4 class="modal-title" id="are_mdlLabel">...</h4>
</div>
<div class="modal-body">
<form method="POST" action="update.php" enctype="multipart/form-data">
<?php
if ($res=$mysqli->query($queryResult)) {
if($res)
{
while($row = mysqli_fetch_array($res)):
?>
<div class="panel panel-default">
<div class="panel-heading">
<h3 class="panel-title"><?php
echo utf8_encode($row['cod_area']); ?></h3>
</div>
<div class="panel-body">
<div class="form-group">
<div>
<table>
<tr><td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="0" id="<?php echo $row['cod_area']."0"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."0"; ?>" class="css-label radGroup2">0</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="1" id="<?php echo $row['cod_area']."1"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."1"; ?>" class="css-label radGroup2">1</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="2" id="<?php echo $row['cod_area']."2"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."2"; ?>" class="css-label radGroup2">2</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="3" id="<?php echo $row['cod_area']."3"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."3"; ?>" class="css-label radGroup2">3</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="4" id="<?php echo $row['cod_area']."4"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."4"; ?>" class="css-label radGroup2">4</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="5" id="<?php echo $row['cod_area']."5"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."5"; ?>" class="css-label radGroup2">5</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="6" id="<?php echo $row['cod_area']."6"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."6"; ?>" class="css-label radGroup2">6</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="7" id="<?php echo $row['cod_area']."7"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."7"; ?>" class="css-label radGroup2">7</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="8" id="<?php echo $row['cod_area']."8"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."8"; ?>" class="css-label radGroup2">8</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="9" id="<?php echo $row['cod_area']."9"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."9"; ?>" class="css-label radGroup2">9</label>
</td>
<td>
<input type="radio" name="<?php echo $row['cod_area']; ?>" value="10" id="<?php echo $row['cod_area']."10"; ?>" class="css-checkbox" />
<label for="<?php echo $row['cod_area']."10"; ?>" class="css-label radGroup2">10</label>
</td>
</tr>
</table>
</div>
<br>
</div>
</div>
</div>
<?php endwhile;}}?>
<div class="form-group">
<label for="id_pergunta" class="control-label">id_pergunta:</label>
<input name="id_pergunta" type="text" class="form-control" id="id_pergunta" readonly>
</div>
<button type="submit" class="btn btn-success">Confirmar</button>
<button type="button" class="btn btn-danger" data-dismiss="modal">Cancelar</button>
</form>
</div>
</div>
</div>
</div>
Espero que compreendam. Obrigado!Carregando comentários...