atualizar_grupos.php.old
2.44 KB
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
69
70
71
72
73
<?
require $_SERVER['DOCUMENT_ROOT'] . '/cacic2/verificar.php';
if ($_POST['submit']) {
header ("Location: incluir_grupos.php");
}
include_once "../../include/library.php";
Conecta_bd_cacic();
if ($_POST['Submit'])
{
$id_si_grupo = $_POST['id_si_grupo'];
$id_software_inventariado = $_POST['id_software_inventariado'];
$query = "UPDATE softwares_inventariados
SET
id_si_grupo = '".$_POST['id_si_grupo']."'
WHERE trim(id_software_inventariado) = '".trim($_POST['id_software_inventariado'])."'";
mysql_query($query) or die('Update falhou');
?>
<script>
window.opener.document.form1.id_si_grupo_<? echo $_POST['id_software_inventariado']?>.value = <? echo $id_si_grupo?>;
window.opener.mostrar('<? echo $_POST['numero']?>');
window.close();
</script>
<?
}
$queryG = 'SELECT * FROM softwares_inventariados_grupos ORDER BY id_si_grupo';
$resultG = mysql_query($queryG);
$query = "SELECT * FROM softwares_inventariados where id_software_inventariado=".$_REQUEST["id_software_inventariado"];
$result = mysql_query($query);
$row = mysql_fetch_array($result)
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Atualizar Grupos</title>
<link rel="stylesheet" type="text/css" href="../../include/cacic.css">
<style type="text/css">
<!--
.style2 {font-size: 12px}
-->
</style>
</head>
<body>
<table width="100%" border="0" align="center">
<tr>
<td class="cabecalho"><span class="dado style2">Escolha o grupo de <? echo $row['nm_software_inventariado']; ?></span></td>
</tr>
<tr>
<td class="descricao">
<form name="form1" method="post" action="">
<select name="id_si_grupo" id="id_si_grupo">
<? while($rowG = mysql_fetch_array($resultG)) {?>
<option value="<? echo $rowG['id_si_grupo']; ?>" <? if ($row['id_si_grupo']==$rowG['id_si_grupo']){?>selected<? }?>><? echo $rowG['nm_si_grupo']; ?></option>
<? }?>
</select>
<input name="Submit" type="submit" value="Ok">
<input name="id_software_inventariado" type="hidden" id="id_software_inventariado" value="<? echo $_REQUEST["id_software_inventariado"]?>">
<input name="numero" type="hidden" id="numero" value="<? echo $_REQUEST["numero"]?>">
</form></td>
</tr>
</table>
<p class="dado"> </p>
<p class="dado"> </p>
</body>
</html>