REDDIO
Power Member
Estou a tentar apagar utilizadores, no entanto quando carrego em delete aparece a mensagem a dizer que foi apagado com sucesso, mas na verdade não apagou na base de dados.
Gostaria que dessem uma vista de olhos no codigo, porque não estou a encontrar o erro.
Apagar_utilizador.php:
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="agencia_de_viagens"; // Database name
$tbl_name="utilizadores"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// select record from mysql
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><table width="400%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Apagar Utilizadores</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id utilizador</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Nome</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF"> </td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['ID_UTILIZADOR']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['NOME']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['EMAIL']; ?></td>
<td bgcolor="#FFFFFF"><a href="apaga.php?Id=<? echo $rows['ID_UTILIZADOR']; ?>">delete</a></td>
</tr>
<?
// close while loop
}
// close connection;
mysql_close();
?>
</table></td>
</tr>
</table>
apaga.php:
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="agencia_de_viagens"; // Database name
$tbl_name="utilizadores"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// get value of id that sent from address bar
$id=$_GET['ID_UTILIZADOR'];
// Delete data in mysql from row that has this id
$sql="DELETE FROM $tbl_name WHERE ID_UTILIZADOR='$ID_UTILIZADOR'";
$result=mysql_query($sql);
// if successfully deleted
if($result){
echo "Deleted Successfully";
echo "<BR>";
echo "<a href='Apagar_utilizador.php'>Back to main page</a>";
}
else {
echo "ERROR";
}
// close connection
mysql_close();
?>
Gostaria que dessem uma vista de olhos no codigo, porque não estou a encontrar o erro.
Apagar_utilizador.php:
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="agencia_de_viagens"; // Database name
$tbl_name="utilizadores"; // Table name
// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// select record from mysql
$sql="SELECT * FROM $tbl_name";
$result=mysql_query($sql);
?>
<table width="400" border="0" cellspacing="1" cellpadding="0">
<tr>
<td><table width="400%" border="0" cellpadding="3" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td bgcolor="#FFFFFF"> </td>
<td colspan="4" bgcolor="#FFFFFF"><strong>Apagar Utilizadores</strong> </td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF"><strong>Id utilizador</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Nome</strong></td>
<td align="center" bgcolor="#FFFFFF"><strong>Email</strong></td>
<td align="center" bgcolor="#FFFFFF"> </td>
</tr>
<?php
while($rows=mysql_fetch_array($result)){
?>
<tr>
<td bgcolor="#FFFFFF"><? echo $rows['ID_UTILIZADOR']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['NOME']; ?></td>
<td bgcolor="#FFFFFF"><? echo $rows['EMAIL']; ?></td>
<td bgcolor="#FFFFFF"><a href="apaga.php?Id=<? echo $rows['ID_UTILIZADOR']; ?>">delete</a></td>
</tr>
<?
// close while loop
}
// close connection;
mysql_close();
?>
</table></td>
</tr>
</table>
apaga.php:
<?php
$host="localhost"; // Host name
$username="root"; // Mysql username
$password=""; // Mysql password
$db_name="agencia_de_viagens"; // Database name
$tbl_name="utilizadores"; // Table name
// Connect to server and select databse.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
// get value of id that sent from address bar
$id=$_GET['ID_UTILIZADOR'];
// Delete data in mysql from row that has this id
$sql="DELETE FROM $tbl_name WHERE ID_UTILIZADOR='$ID_UTILIZADOR'";
$result=mysql_query($sql);
// if successfully deleted
if($result){
echo "Deleted Successfully";
echo "<BR>";
echo "<a href='Apagar_utilizador.php'>Back to main page</a>";
}
else {
echo "ERROR";
}
// close connection
mysql_close();
?>