Ecco il codice...
Codice PHP:<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Visualizza</title>
<script type="text/javascript">
function Reload(objForm) {
objForm.action="<?=$PHP_SELF?>";
objForm.submit();
}
</script>
</head>
<body>
<p align="center">[b]<font face="Trebuchet MS" size="6" color="#0000FF">Allievi</font>[/b]</p>
<input type="submit" onClick="location.href='inserisci.php'" value="Inserisci un allievo" name="B1">
<?php
include 'connessione.inc';
$link=mysql_connect("localhost","root");
$database=mysql_select_db("moto",$link);
$id = $_POST['cas0'];
$nome=$_POST['cas1'];
$cognome=$_POST['cas2'];
$cat=$_POST['cas3'];
$tel1=$_POST['cas4'];
$tel2=$_POST['cas5'];
$via=$_POST['cas6'];
$loc=$_POST['cas7'];
$isc=$_POST['cas8'];
$finito=$_POST['cas9'];
$checkbox=$_POST['check'];
//print_r($checkbox);
$operazione=$_POST['mod'];
if($operazione=='Modifica')
{
$mod="update allievo set all_nome='".$nome."',all_cognome='".$cognome."' , all_categoria='".$cat."' , all_tel1= '".$tel1."', all_tel2='".$tel2."' , all_via= '".$via."', all_localita='".$loc."' , all_iscritto='".$isc."' where id =".$id;
//print_r($mod);
update($mod);
}
elseif ($operazione=='Elimina')
{
$del="delete from allievo where id =".$id;
delete($del);
}
//print_r($id);
//print_r($operazione);
if($checkbox=='cliccato'){
$sql="select * from allievo";
//print_r("yea");
}
else{
$sql="select * from allievo where all_terminato=1";
}
$tutto=select($sql);
echo "<table border=1 align=center width=100%>";
while ($valori=mysql_fetch_array($tutto)) {
echo "<form action='visualizza.php' method='get'>";
echo "<tr>";
//for ($i=0;$i< mysql_num_fields($tutto)-1;$i++) {
//echo("<td><input type='text' name='cas".($i+1)."' value='".$valori[$i+1]."' size='17'></td>");
echo("<td><input type='hidden' name='cas0' value='".$valori[0]."'></td>");
echo("<td><input type='text' name='cas7' value='".$valori[7]."' size='20'></td>");
echo("<td><SELECT NAME='cas8'><OPTION VALUE='".$valori[8]."'>".$valori[8]."<OPTION VALUE='Massimo'>Massimo<OPTION VALUE='Michel'>Michel<OPTION VALUE='SG3' >SG3</SELECT></td>");
echo("<td><input type='checkbox' name='cas9' id='cas9'value='".$valori[9]."'></td>");
echo("<td><input type='checkbox' name='cas9' id='cas9'value='l'>mm</td>");
echo("<td width='10%'><input type='submit' name='mod' value='Modifica' value='".$valori[0]."' size='5'></td>");
echo("<td width='10%'><input type='submit' name='mod' value='Elimina' value='".$valori[0]."' size='5'></td>");
echo "</tr>";
echo "</form>";
}
echo "</table>";
mysql_free_result($tutto);
mysql_close();
//onclick='".redirect('visualizza.php',0)."'
?>
</body>
</html>
Rispondi quotando