Viewing file:  legis3.php (7.26 KB) -rw-rw-rw-
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$sed = isset($user);
if ($sed == false) {
exit;
}else{
//require('conexion2.php');
//$stmt = Ociparse($c1, " SELECT EU_USERNAME FROM envista.env_users where EU_USERNAME='$user'");
//$result = OCIExecute($stmt);
//if ($result == false) {
//exit;
//}else{
//$cont = 0;
//while (OCIFetchInto($stmt, $value1)) {
//foreach ($value1 as $val1)
//{
//$cont++;
//}}
$cont = 1;
if ($cont == 1) {
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Legislación Ambiental Colombiana</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
.textopequeno {
font-family: "Times New Roman", Times, serif;
font-size: 10px;
color: #333333;
}
select {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #666666;
background-color: #FFFFF9;
}
.in1 {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #666666;
background-color: #FFFFF9;
}
.in1Copia {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #333333;
background-color: #B9E7FD;
}
a {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #006699;
text-decoration: none;
}
a:hover {
font-family: Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
color: #006699;
text-decoration: underline;
}
-->
</style>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
function MM_findObj(n, d) { //v4.0
var p,i,x; if(!d) d=document; if((p=n.indexOf("?"))>0&&parent.frames.length) {
d=parent.frames[n.substring(p+1)].document; n=n.substring(0,p);}
if(!(x=d[n])&&d.all) x=d.all[n]; for (i=0;!x&&i<d.forms.length;i++) x=d.forms[i][n];
for(i=0;!x&&d.layers&&i<d.layers.length;i++) x=MM_findObj(n,d.layers[i].document);
if(!x && document.getElementById) x=document.getElementById(n); return x;
}
function MM_jumpMenuGo(selName,targ,restore){ //v3.0
var selObj = MM_findObj(selName); if (selObj) MM_jumpMenu(targ,selObj,restore);
}
//-->
</script>
</head>
<body topmargin="0">
<table width="100%" border="1" cellpadding="5" cellspacing="0" bordercolor="#FFFFFF">
<tr>
<td width="20%"> </td>
<td width="60%" colspan="3"><div align="center"><img src="legis.gif" width="550" height="150"></div></td>
<td width="20%"> </td>
</tr>
<tr>
<td> </td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFF9">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center"><a href="reqlegis.php?user=<?php echo $user; ?>">Volver
a Buscar...</a></div></td>
</tr>
</table>
</td>
<td bordercolor="#CCCCCC" bgcolor="#FFFFF9"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center"><a href="reqlegis2.php?user=<?php echo $user; ?>">Agregar
Normas...</a></div></td>
</tr>
</table></td>
<td bordercolor="#CCCCCC" bgcolor="#F2F2F2">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td> <div align="center"><a href="#">Agregar Entidades...</a></div></td>
</tr>
</table>
</td>
<td> </td>
</tr>
<tr>
<td width="20%"> </td>
<td width="60%" colspan="3" bordercolor="#CCCCCC" bgcolor="#FFFFF9"> <form name="form1" method="post" action="">
<p><font size="5"><strong><font size="2">>></font> Añadir
& Borrar Entidades...</strong></font></p>
<p>Agrege nuevas entidades de las cuales quiera ingresar legislación
ambiental colombiana.</p>
<?php
$sed = isset($acc);
if ($sed == true) {
if ($acc == 1) {
require('conexion3.php');
$query ="INSERT INTO entidad VALUES('','$enti','$usuario')";
$result = mysql_query($query,$db);
if ($result == 0) {
?>
<p><font color="#000000" size="3" face="Times New Roman, Times, serif">Error: No se pudo agregar la entidad, intente nuevamente.</font></p>
<?php
}
}
}
$sed = isset($acc);
if ($sed == true) {
if ($acc == 2) {
require('conexion3.php');
$query ="DELETE FROM entidad WHERE id=$id";
$result = mysql_query($query,$db);
if ($result == 0) {
?>
<p><font color="#000000" size="3" face="Times New Roman, Times, serif">Error: No se pudo borrar la entidad, intente nuevamente.</font></p>
<?php
}
}
}
?>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr bgcolor="#FAFEE2">
<td width="100%"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" valign="top"><strong>Entidad:</strong></td>
<td><strong>
<input name="enti" type="text" class="in1Copia" id="enti" size="50">
</strong><font size="1">
<input name="Submit" type="submit" class="in1" value="OK">
<input name="usuario" type="hidden" id="usuario" value="<?php echo $user; ?>">
<input name="acc" type="hidden" id="acc" value="1">
<br>
</font><span class="textopequeno">* Escriba el nombre de la
entidad de la cual quiere añadir normas...</span> </td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FAFEE2">
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" valign="top"><strong>Entidad:</strong></td>
<td><strong>
<select name="menu1" id="entidad">
<?php
require('conexion3.php');
$consul = "SELECT *
FROM entidad";
$result = mysql_query($consul,$db);
$num_filas = mysql_num_rows($result);
while ($myrow = mysql_fetch_array($result))
{
$ide = $myrow["id"];
$noe = $myrow["nomen"];
echo "<option value=\"reqlegis3.php?id=$ide&user=$user&acc=2\">$noe</option>";
}
?>
</select>
</strong><font size="1">
<input name="Submit2" type="button" class="in1" value="Borrar" onClick="MM_jumpMenuGo('menu1','parent',0)">
<br>
</font><span class="textopequeno">* Seleccione la entidad
y haga click en borrar para eliminarla.</span></td>
</tr>
</table></td>
</tr>
</table>
<p align="center"> </p>
</form></td>
<td width="20%"> </td>
</tr>
<tr>
<td width="20%"> </td>
<td width="60%" colspan="3"><div align="center"><img src="legis2.gif" width="550" height="30">
<br>
<span class="textopequeno">© Copyright, DAMA 2003. Todos los Derechos
Reservados para<br>
El Departamento Técnico Administrativo del Medio Ambiente</span></div></td>
<td width="20%"> </td>
</tr>
</table>
<p> </p>
</body>
</html>
<?php
//}}
//$c2 = OciLogoff($c1);
}
}
?>
|