DEBER 28

FRANCISCO MUNOZ
CATEDRATICO Ing. Juan Espinoza

CONEXION A BASE DE DATOS
<?php
$conexion=mysql_connect("localhost","CONEXIONBDD","admin");
if(!$conexion){
die('NO SE PUDO ESTABLECER LA CONEXION'.mysql_error());
}
else{
echo("CONEXION SATISFACTORIA");
}
mysql_select_db("BDDAGENDA", $conexion);

?>

EDITAR

<?php
if(isset($_POST["btn1"])){
$btn=$_POST["btn1"];

if($btn=="Listar"){

$sql="select * from agenda";
$cs=mysql_query($sql,$conexion);
echo"<center>
<table border='3'>
<tr>
<td>Codigo</td>
<td>Nombre</td>
<td>Apellido</td>
<td>Edad</td>
<td>Telefono</td>
<td>Direccion</td>
<td>Ciudad</td>
<td>Sexo</td>

</tr>";
while($resul=mysql_fetch_array($cs)){
$var=$resul[0];
$var1=$resul[1];
$var2=$resul[2];
$var3=$resul[3];
$var4=$resul[4];
$var5=$resul[5];
$var6=$resul[6];
$var7=$resul[7];
echo "<tr>

<td>$var</td>
<td>$var1</td>
<td>$var2</td>
<td>$var3</td>
<td>$var4</td>
<td>$var5</td>
<td>$var6</td>
<td>$var7</td>
<td><a href='actualizar.php' name='btn1'>Modificar</a></td>
</tr>";
}
ECHO "<H1><CENTER>LISTA</CENTER></H1>";
//echo '<td>'.'<a href="actualizar.php" value="Editar">'.'Modificar'.'</a>'.'</td>';
echo "</table>

</center>";

}
}
?>

ELIMINAR

<?php
if(isset($_POST["btn1"])){
$btn=$_POST["btn1"];

if($btn=="Eliminar"){

$sql="delete * from agenda";
$cs=mysql_query($sql,$conexion);
echo"<center>
<table border='3'>
<tr>
<td>Codigo</td>
<td>Nombre</td>
<td>Apellido</td>
<td>Edad</td>
<td>Telefono</td>
<td>Direccion</td>
<td>Ciudad</td>
<td>Sexo</td>

</tr>";
while($resul=mysql_fetch_array($cs)){
$var=$resul[0];
$var1=$resul[1];
$var2=$resul[2];
$var3=$resul[3];
$var4=$resul[4];
$var5=$resul[5];
$var6=$resul[6];
$var7=$resul[7];
echo "<tr>

<td>$var</td>
<td>$var1</td>
<td>$var2</td>
<td>$var3</td>
<td>$var4</td>
<td>$var5</td>
<td>$var6</td>
<td>$var7</td>
<td><a href='eliminar.php' name='btn1'>Eliminar</a></td>
</tr>";
}
ECHO "<H1><CENTER>LISTA</CENTER></H1>";
echo "</table>

</center>";

}
}
?>