Actualizar Registros
Código PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
$conection = mssql_connect("servidor","usuari","password") or die ("No es pot connectar amb el servidor");
mssql_select_db("desempeno", $conection);
$_GET['id'];
$sql = mssql_query("select * from competencias where id= '".$_GET['id']."'") or die ('Invalid query: ' . mssql_error());
while ($row = mssql_fetch_array($sql))
{
$i=$row["id"];
$c=$row["codigo"];
$d=$row["descripcion"];
$def=$row["deficiente"];
$m=$row["mejorable"];
$s=$row["satisfactorio"];
$n=$row["notable"];
$o=$row["optimo"];
$des=$row["des_ampliada"];
$t=$row["tipo"];
$te=$row["texto"];
}
?>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link type="text/css" media="screen" rel="stylesheet" rev="stylesheet" href="../../imagenes/estilos.css" />
<script> window.onload = function() {window.moveTo(0,0); window.resizeTo(screen.width,screen.height);} </script>
<script type = "text/javascript" src = "scripts/funciones.js"></script>
<title>Evaluación del desempeño</title>
</head>
<body>
<form name = "competencies" action = "professionals7.php" method = "post">
<div name="logo">
<img src="../../imagenes/S.jpg" alt="logo" width="500" height="122" align="middle" name="log"/>
</div>
<div name = "titol" id = "titul">
<h2> Mantenimenieto de Competencias </h2>
</div>
<div name = "introduccio" id="intro">
<span>
<input name = "identificador" type="hidden" value="<?php echo $i;?>" />
<label for="codi">Codigo</label> <input type="text" name="codica" size="" maxlength="3" id="cod" class="caixa" readonly="true" value="<?php echo $c;?>"/>
<div id="desc"><label for="descripcio"> Descripción </label><textarea name="descripci" id="descripc" cols="40" rows="5"><?php echo $d;?></textarea></div>
</span>
<span>
<div id="def"><label for="deficient"> Deficiente </label> <textarea name="deficien" id="deficie" cols="40" rows="5"><?php echo $def;?></textarea></div>
<div id="mill"><label for="millorable"> Mejorable </label> <textarea name="millorabl" id="millorab" cols="40" rows="5"><?php echo $m;?></textarea></div>
</span>
<span>
<div id="sat"><label for="satisfactori"> Satisfactorio </label> <textarea name="satisfactor" id="satisfacto" cols="40" rows="5"><?php echo $s;?></textarea></div>
<div id="not"><label for="notable"> Notable </label> <textarea name="notabl" id="notab" cols="40" rows="5"><?php echo $n;?></textarea></div>
</span>
<span>
<div id="opt"><label for="optim"> Optimo </label> <textarea name="opti" id="opt" cols="40" rows="5"><?php echo $o;?></textarea></div>
<div id="desa"><label for="desampl"> D.A </label> <textarea name="desamp" id="desam" cols="40" rows="5"><?php echo $des;?></textarea></div>
</span>
<span>
<div id="rd"><label for="especifica"> Específica / Genérica </label> <input type="text" name="tipo" id="tipo_e" value="<?php echo $t;?>"/></div>
<br />
<br />
<br />
<div id="txt"><label for="test"> Texto </label> <textarea name="tex" id="te" cols="40" rows="5"><?php echo $te;?></textarea></div>
</span>
</div>
<div name = "boto" id="botons">
<span>
<!--<button onclick="actualitzar();"> <img src='../../imagenes/actualitzar.jpg' width ="50" height ="50" alt="Acutlizar registro"/></button>-->
<input type="submit" value = "enviar" class="boton" />
</span>
</div>
</form>
</body>
<?
mssql_close($conection);
?>
</html>
Código PHP:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?php
$conection = mssql_connect("servidor","usuari","password") or die ("No es pot connectar amb el servidor");
mssql_select_db("desempeno", $conection);
echo "El valor del identificador es: ".$_POST['identificador'];
$sql = mssql_query("select * from competencias where id = '".$_POST['identificador']."'") or die ('Invalid query: ' . mssql_error());
while ($row = mssql_fetch_array($sql))
{
$i=$row["id"];
$c=$row["codigo"];
$d=$row["descripcion"];
$def=$row["deficiente"];
$m=$row["mejorable"];
$s=$row["satisfactorio"];
$n=$row["notable"];
$o=$row["optimo"];
$des=$row["des_ampliada"];
$t=$row["tipo"];
$te=$row["texto"];
}
mssql_query("update competencias set codigo='".$_POST['codica']."', descripcion='".$_POST['descripci']."', deficiente='".$_POST['deficien']."', mejorable='".$_POST['millorabl']."', satisfactorio='".$_POST['satisfactor']."', notable='".$_POST['notabl']."', optimo='".$_POST['opti']."', des_ampliada='".$_POST['desamp']."', tipo='".$_POST['tipo']."', texto='".$_POST['tex']."' where id='".$_POST['identificador']."'" ,$conection);
mssql_close($conection);
?>
<script> window.close(); </script>