File: /home/asjudine/cartera_modi_datos_debi.php
<?php
require_once("Conectarse.php");
require_once("mainfile.php");
include ("config.php");
global $dbi;
if(isset($_POST["guardar"]))
{
$mssql3 = mysql_query("UPDATE debitos set nombres= '" . $_POST[ape] . "', banco = '" . $_POST[ban] . "', cuenta = '" . $_POST[nocuen] . "', email = '" . $_POST[email] . "', valor_credito= '".$_POST[valor_credito]."', valor_juridica = '".$_POST[valor_juridica]."',valor_debitar,= '".$_POST[valor_debitar]."' WHERE cedula = '" . $_GET["cedu"] . "' ");
if (!$mssql3) {
die('Invalid query cartera_serviasjudinet MODIFICAR: ' . mysql_error());
}
echo "<script>alert('Los datos fueron modificados correctamente');</script>";
}
$control = mysql_query('SELECT cedula, nombres,dirrecion , telefono, celular, ciudad , email, entidad_laboral,banco,cuenta,unidad_desc,valor_credito,valor_juridica,valor_debitar,cuotas,cuotas_pend,cuotas_desc,fecha_debito,usuarios,situacion FROM debitos WHERE cedula = "' . $_GET["cedu"] . '" ');
if (!$control) {
die('Invalid query 1: ' . mysql_error());
}
$num=mysql_num_rows($control);
list($cedula,$apes,$dire, $tele, $celul, $ciud, $email,$enti,$ban,$cue,$unides,$valcon,$numcuo,$valcuo,$salant,$cupen,$salnue,$inipag,$cudesc,$fechaul) = mysql_fetch_row($control);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Documento sin título</title>
<style type="text/css">
<!--
.est_cont1 { font-family: "Times New Roman", Times, serif;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #FFFFFF;
background-color: #E6FFF1;
margin: 1px;
padding: 1px;
height: auto;
width: auto;
border: thin double #33CC66;
}
.est_cont2 {
font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #000000;
background-color: #FFFFFF;
height: 18px;
width: auto;
border: thin solid #FABF85;
}
.Estilo3 {color: #2492FF;
font-weight: bold;
}
.Estilo4 {
color: #CC3300;
font-weight: bold;
}
.est_cont21 {font-family: Geneva, Arial, Helvetica, sans-serif;
font-size: 12px;
font-style: normal;
font-weight: normal;
color: #2B39EC;
background-color: #F0F5CF;
height: 18px;
width: auto;
border: thin solid #FABF85;
}
.Estilo13 {color: #0000CC; font-size: 14; font-weight: bold; }
.Estilo15 {color: #0000CC; font-weight: bold; }
-->
</style>
</head>
<body>
<form id="form1" name="form1" method="post" action="">
<center> <img src="ELEMENTOS\CABEZOTE SERVIASJUDINET.jpg" WIDTH=60% > </center>
<div align="center">
<p class="Estilo4">INFORMACION DEBITOS</p>
<table width="648" border="2" cellpadding="1" cellspacing="1" class="est_cont1">
<tr>
<td width="89" height="23" bgcolor="#CCFFCC"><span class="Estilo13">Cedula :</span></td>
<td width="95" bgcolor="#CCFFCC"><div align="left">
<input name="ced" type="text" class="est_cont2" id="ced" value="<?php echo $cedula ?>" size="18" maxlength="18" readonly="" />
</div></td>
<td width="115" bgcolor="#CCFFCC"><span class="Estilo15">Apellidos y Nombres :</span></td>
<td colspan="3" bgcolor="#CCFFCC"><div align="left">
<input name="ape" type="text" class="est_cont2" id="ape" value="<?php echo $apes ?>" size="60" maxlength="60"/>
</div></td>
</tr>
<tr>
<td bgcolor="#CCFFCC"><span class="Estilo13">Banco :</span></td>
<td bgcolor="#CCFFCC"><div align="left">
<input name="ban" type="text" class="est_cont2" id="ban" value="<?php echo $ban ?>" size="18" maxlength="18" />
</div></td>
<td bgcolor="#CCFFCC"><span class="Estilo15">No Cuenta :</span></td>
<td width="72" bgcolor="#CCFFCC"><div align="left">
<input name="nocuen" type="text" class="est_cont2" id="nocuen" value="<?php echo $cue ?>" size="13" maxlength="13" />
</div></td>
<td width="139" bgcolor="#CCFFCC"><span class="Estilo15">Email :</span></td>
<td width="103" bgcolor="#CCFFCC"><div align="left">
<input name="email" type="text" class="est_cont2" id="email" value="<?php echo $email ?>" size="25" maxlength="10" />
</div></td>
</tr>
<tr>
<td bgcolor="#CCFFCC"><span class="Estilo13">Valor Credito:</span></td>
<td bgcolor="#CCFFCC"><div align="left">
<input name="valor_credito" type="text" class="est_cont2" id="valor_credito" value="<?php echo $valcon ?>" size="18" maxlength="18"/>
</div></td>
<td bgcolor="#CCFFCC"><span class="Estilo15">Valor Juridica:</span></td>
<td bgcolor="#CCFFCC"><div align="left">
<input name="valor_juridica" type="text" class="est_cont2" id="valor_juridica" value="<?php echo $numcuo ?>" size="3" maxlength="3" />
</div></td>
<td bgcolor="#CCFFCC"><span class="Estilo15">Valor Debitar:</span></td>
<td bgcolor="#CCFFCC"><div align="left">
<input name="valor_debitar" type="text" class="est_cont2" id="valor_debitar" value="<?php echo $valcuo ?>" size="18" maxlength="18"/>
</div></td>
</tr>
<tr>
<td bgcolor="#CCFFCC"><span class="Estilo13">Numero De Cuotas:</span></td>
<td bgcolor="#CCFFCC"><div align="left">
<input name="sal" type="text" class="est_cont2" id="sal" value="<?php echo $salant ?>" size="18" maxlength="18" />
</div></td>
<td bgcolor="#CCFFCC"><span class="Estilo15">Cuotas Pendientes :</span></td>
<td bgcolor="#CCFFCC"><div align="left">
<input name="cuotap" type="text" class="est_cont2" id="cuotap" value="<?php echo $cupen ?>" size="3" maxlength="3"/>
</div></td>
<td bgcolor="#CCFFCC"><span class="Estilo15">Cuotas Descontadas:</span></td>
<td bgcolor="#CCFFCC"><div align="left">
<input name="nue" type="text" class="est_cont2" id="nue" value="<?php echo $salnue ?>" size="18" maxlength="18" />
</div></td>
</tr>
</table>
<p>
<input name="guardar" type="submit" class="Estilo3" id="guardar" value="Guardar" />
</p>
</div>
</form>
</body>
</html>