Here you have an example :
<?
include("divfunc.php");
session_start();
if (!is_logged_in('devises.php','perms_administration','Devises')) {
exit;
} else {
//echo "Hello ".$SESSION["user"].", you are logged with perms as ".$SESSION["perms"].".";
}
?>
<?
//Fichier Gest_devises.php3
//echo $indice;
//echo " ".$cours;
//echo " ".$todo;
//
$conn = pg_connect("user=postgres password=postgres host=localhost dbname=dbtest");
if ($todo == "erase") {
$sql="delete from f_devises where devise='".$devise."'";
//Echo $sql;
$result = pg_Exec($conn,$sql);
}
if ($todo == "update") {
$sql="update f_devises set cours='".$cours."' where devise='" .$devise."'";
//echo $sql;
$result = pg_Exec($conn,$sql);
}
//
$result = pg_Exec($conn,"select * from f_devises order by pays");
$nbr_ligne = pg_NumRows($result);
?>
<TABLE width=100%>
<? for($i=0;$i<$nbr_ligne;$i++){ ?>
<FORM method="post" action="<? echo $PHP_SELF ?>">
<TABLE width="100%" border="0" cellspacing="0" cellpadding="1">
<TR>
<TD width=0><input type="hidden" name="devise" value="<?echo pg_result($result,$i,"devise")?>"></TD>
<TD width=0><input type="hidden" name="indice" value="<?echo $i ?>"></TD>
<TD width=0><input type="hidden" name="todo" value=""></TD>
<TD width=30><B><?php echo pg_result($result,$i,"pays")?></B></TD>
<TD width=10><input type="text" name="cours" Value=<?php echo pg_result($result,$i,"cours")?>></TD>
<TD width=20><?php echo pg_result($result,$i,"devise")?></TD>
<TD width=10>= 100€</TD>
<TD width=2><input type="image" name="zzz" src="images/modifier.png" onMouseOut="src='images/modifier.png'" onMouseOver="src='images/modifier_over.png';todo.value='update'"></TD>
<TD width=2><input type="image" name="zzz" src="images/supprimer.png" onMouseOut="src='images/supprimer.png'" onMouseOver="src='images/supprimer_over.png';todo.value='erase'"></TD>
</TR>
</TABLE>
</FORM>
<? } ?>
</TABLE>
<? pg_close($conn); ?>
