Ho trovato un esempio su apache3000,
per effettuare l'eliminazione di un record.
L'ho modificato e adattato ma non funziona piu'
La pagina in php comprende in realtà tre pagine.
La prima consente di visulizzare i record e inizia con
if (!link)
La seconda chiede conferma dell'eliminazione di un record
...e dovrebbe iniziare con
elseif(link == "avviso")
La terza effettua il cancellamento del record suddetto
elseif(link == "del")
Il problema mi appare quando provo a cliccare sul pulsante elimina della prima pagina con action=PHP_INFO?link=avviso. infatti la pagina viene ricaricata ma invece di chiedermi conferma dell'eliminazione mi riappaiono tutti i record.
Posto il codice:
Codice PHP:
<?php
if (!$link){
include("dati.txt");
//Stampo l'intestazione che accoglierà il logo e i link
echo"
<html>
<head>
<title>CIAO</title>
<link REL='stylesheet' TITLE='Default' HREF='../style.css' TYPE='text/css' MEDIA='screen'>
<style type='text/css'>
</style>
</head>
<body>
<div align='center'>
<center>
<table border='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='600' cellpadding='0' bgcolor='#F5F5F5' height='102'>
<tr>
<td width='1' bgcolor='#DCDCDC' rowspan='5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
<td height='1' width='598' bgcolor='#DCDCDC'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
<td width='1' bgcolor='#DCDCDC' rowspan='5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
</tr>
<tr>
<td height='20' width='598'>
<p align='right' class='arial8pt'><font color='#999999'>© Copyright 2005</font></td>
</tr>
<tr>
<td height='52' width='598'>
<p align='center'>
[img]../images/logo.gif[/img]</td>
</tr>
<tr>
<TD width=598 height=30>
<P class=arial align=center>[B]<FONT color=#999999>[ </FONT>
[url='']HOME[/url]
<FONT color=#999999>
] - [ [url='inserisci.php']INSERISCI[/url]
] - [ [url='lettura.php']MODIFICA/ELIMINA[/url]
]</FONT>[/B]
[img]../trasparent.gif[/img]</P></TD>
</tr>
<tr>
<td height='1' width='598' bgcolor='#F5F5F5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
</tr>
</table>
</center>
</div>";//chiudo l'intestazione
$i=1;
$link=mysql_connect("$db_host","$db_login","$db_pass") or die ("Non riesco a connettermi a $db_host");
mysql_select_db ($database, $link) or die ("Non riesco a selezionare il db $database
");
$tutto = "SELECT * FROM ristorante GROUP BY id_img";
$query = mysql_query ($tutto,$link) or die ("Non riesco ad eseguire la richiesta $tutto");
while ($valori = mysql_fetch_array ($query)){
$a1 = $valori["id_img"];
$a2 = $valori["minifoto"];
$a3 = $valori["foto"];
// Preparo la tabella per accogliere i dati/foto
echo "
<div align='center'>
<center>
<table border='0' cellspacing='0' width='600' cellpadding='0' style='border-collapse: collapse' bordercolor='#111111' height='112' bgcolor='#F5F5F5'>
<tr>
<td rowspan='4' width='1' bgcolor='#DCDCDC' height='100%'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]
</td>
<td bgcolor='#DCDCDC' height='12' width='598' colspan='4'>
<p class='arial'>[b]<font color='#ffffff'>Foto n°$i</font>[/b]
</td>
<td rowspan='4' width='1' bgcolor='#DCDCDC' height='100%'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
</tr>
<tr>
<td height='100' width='125' rowspan='2' align='center'>
[img]foto/$a2[/img]
</td>
<td height='100' width='125' rowspan='2' align='center'>
[img]foto/$a3[/img]
</td>
<td height='60' width='95'>
<form action='modifica.php' method='post'>
<input type='hidden' name='i' value=$i>
<input type='hidden' name='id' value=$a1>
<input type='hidden' name='miniphoto' value=$a2>
<input type='hidden' name='photo' value=$a3>
<p class='red10'>
<input type='submit' value=Modifica>
</td>
</tr>
</form>
<tr>
<td height='40' width='95' valign='top'>
<form action=$PATH_INFO?link=avviso method='post'>
<input type='hidden' name='id' value='$a1'>
<input type='hidden' name='i' value='$i'>
<input type='hidden' name='miniphoto' value='$a2'>
<input type='hidden' name='photo' value='$a3'>
<p class='red10'>
<input type='submit' value=Elimina>
</td>
</tr>
</form>
</table>
</center>
</div>";
$i++;}//chiudo ciclo while
echo"
<div align='center'>
<center>
<table border='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#EFEFEF' width='600' cellpadding='0' bgcolor='#DCDCDC' height='12'>
<tr>
<td>
<p class='arial8pt'><font color='#999999'></font><font color='#FFFFFF'>© Copyright 2005[img]../trasparent.gif[/img]
</font></td>
</tr>
</table>
</center>
</div>
</body>
</html>";}
//chiudo la stampa della pagina LETTURA.PHP se $link non e' attivo
//*********************************************************************************************************************
//Se link = "avviso" allora mi stampa:
elseif ($link == "avviso"){
echo"
<html>
<head>
<title>CIAO</title>
<link REL='stylesheet' TITLE='Default' HREF='../style.css' TYPE='text/css' MEDIA='screen'>
<style type='text/css'>
</style>
</head>
<body>
<div align='center'>
<center>
<table border='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='600' cellpadding='0' bgcolor='#F5F5F5' height='102'>
<tr>
<td width='1' bgcolor='#DCDCDC' rowspan='5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
<td height='1' width='598' bgcolor='#DCDCDC'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
<td width='1' bgcolor='#DCDCDC' rowspan='5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
</tr>
<tr>
<td height='20' width='598'>
<p align='right' class='arial8pt'><font color='#999999'>© Copyright 2005</font></td>
</tr>
<tr>
<td height='52' width='598'>
<p align='center'>
[img]../images/logo.gif[/img]</td>
</tr>
<tr>
<TD width=598 height=30>
<P class=arial align=center>[B]<FONT color=#999999>[ </FONT>
[url='HR/']HOME[/url]
<FONT color=#999999>
] - [[url='inserisci.php']INSERISCI[/url]
] - [[url='lettura.php']MODIFICA/ELIMINA[/url]
]</FONT>[/B]
[img]../trasparent.gif[/img]</P></TD>
</tr>
<tr>
<td height='1' width='598' bgcolor='#F5F5F5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
</tr>
</table>
</center>
</div>
<div align='center'>
<center>
<table border='0' cellspacing='0' width='600' cellpadding='0' style='border-collapse: collapse' bordercolor='#111111' height='100' bgcolor='#F5F5F5'>
<tr>
<td rowspan='2' width='1' bgcolor='#DCDCDC' height='100'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
<td width='598' height='85' align='center'>
<p class='arial'>[b]<font color='#336699'>Attenzione!!!
Si sta scegliendo di eliminare la <font color='#f16818'>FOTO N°$i</font>
Vuoi proseguire?</font>[/b]</td>
<td rowspan='2' width='1' bgcolor='#DCDCDC' height='100'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]</td>
</tr>
<tr>
<td width='598' height='15' valign='bottom'>
<table border='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='598' cellpadding='0' height='15'>
<tr>
<td width='299' align='right' height='15' valign='bottom' class='arial'>
<form method='POST' action=$PATH_INFO?link=eli>
<input type='hidden' name='identificativo' value='$id'>
<input type='hidden' name='i' value=$i>
<p class='red10'>
<input type='submit' value='Sì'></p>
</form>
</td>
<td width='299' height='15' valign='bottom' class='arial'>
<form method='POST' action='lettura.php'>
<p class='red10'>
<input type=submit value='No'></p>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<div align='center'>
<center>
<table border='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#EFEFEF' width='600' cellpadding='0' bgcolor='#DCDCDC' height='12'>
<tr>
<td>
<p class='arial8pt'><font color='#999999'></font>
<font color='#FFFFFF'>© Copyright 2005 [img]../trasparent.gif[/img]
</font>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>";}//chiudo la stampa della pagina se $link = "avviso"
//*********************************************************************************************************************
//Se link = "eli" allora mi stapa:
elseif ($link == "eli"){
include("dati.txt");
$link=mysql_connect("$db_host","$db_login","$db_pass") or die ("Non riesco a connettermi a $db_host");
mysql_select_db ($database, $link) or die ("Non riesco a selezionare il db $database
");
$tutto1 = "SELECT minifoto, foto FROM realizzazioni WHERE ID=$identificativo";
$result1 = mysql_query ($tutto1,$link) or die ("Non riesco ad eseguire la richiesta $tutto");
while ($ciao = mysql_fetch_array ($result1)){
$p1= $ciao ["minifoto"];
$p2= $ciao ["foto"]; }
$dir=$_SERVER["DOCUMENT_ROOT"] . "/foto/";
unlink("$dir$p1");
unlink("$dir$p2");
$ric_sql = "DELETE from realizzazioni where ID='$identificativo'";
mysql_db_query("$database", "$ric_sql") or die ("Non riesco ad eseguire la richiesta $ric_sql");
mysql_close ($link);
echo "
<html>
<head>
<title>CIao</title>
<link REL='stylesheet' TITLE='Default' HREF='../style.css' TYPE='text/css' MEDIA='screen'>
<style type='text/css'>
</style>
<meta http-equiv=refresh content=3;url=PATH_INFO>
</head>
<body>
<div align='center'>
<center>
<table border='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#111111' width='600' cellpadding='0' bgcolor='#F5F5F5' height='100'>
<tr>
<td width='1' bgcolor='#DCDCDC' rowspan='5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]
</td>
<td height='1' width='598' bgcolor='#DCDCDC'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]
</td>
<td width='1' bgcolor='#DCDCDC' rowspan='5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]
</td>
</tr>
<tr>
<td height='20' width='598'>
<p align='right' class='arial8pt'><font color='#999999'>© Copyright 2005</font></td>
</tr>
<tr>
<td height='50' width='598'>
<p align='center'>
[img]../images/logo.gif[/img]
</td>
</tr>
<tr>
<TD width=598 height=30>
<P class=arial align=center>[B]<FONT color=#999999>[ </FONT>
[url='HR/']HOME[/url]
<FONT color=#999999>
] - [[url='inserisci.php']INSERISCI[/url]
] - [[url='lettura.php']MODIFICA/ELIMINA[/url]
]</FONT>[/B]
[img]../trasparent.gif[/img]</P></TD>
</tr>
<tr>
<td height='1' width='598' bgcolor='#F5F5F5'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]
</td>
</tr>
</table>
</center>
</div>
<div align='center'>
<center>
<table border='0' cellspacing='0' width='600' cellpadding='0' style='border-collapse: collapse' bordercolor='#111111' height='80' bgcolor='#F5F5F5'>
<tr>
<td rowspan='2' width='1' bgcolor='#DCDCDC' height='80'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]
</td>
<td width='598' height='80' align='center'>
<p class='arial'>[b]<font color='#336699'>
<font color='#f16818'>FOTO N°$i</font>
Eliminata con successo!!</font>[/b]</td>
<td rowspan='2' width='1' bgcolor='#DCDCDC' height='80'>
<p class='arial8pt'>
[img]../trasparent.gif[/img]
</td>
</tr>
</table>
</center>
</div>
<div align='center'>
<center>
<table border='0' cellspacing='0' style='border-collapse: collapse' bordercolor='#EFEFEF' width='600' cellpadding='0' bgcolor='#DCDCDC' height='12'>
<tr>
<td>
<p class='arial8pt'><font color='#999999'></font><font color='#FFFFFF'>© Copyright 2005[img]../trasparent.gif[/img]</font>
</td>
</tr>
</table>
</center>
</div>
</body>
</html>";}
?>