Deleting ID

JHallam

Hey people 😉

I've searched the forums, but no joy

Basically the problem I have is deleting data from mysql.

I have this script on my delete.php -


<?php 
$idtodelete = (int)$_POST['deleteID']; 
if($idtodelete == 0) 
{ 
    print "Don't mess with me"; 
    exit; 
} 

$db = "";
$dbconnection = mysql_connect("", "", "") or
die ('I can’t connect to the database.');
mysql_select_db($db,$dbconnection); 
$query = "DELETE FROM table WHERE ID=$idtodelete";  

$result = mysql_query($query);  

if(mysql_affected_rows()) 
{ 
    echo "Data is sucessfully deleted"; 
} 
else 
{ 
    echo "Error Deleting record"; 

}

The script from button to delete record -

<head>

<script language="javascript">
	function doDelete(delid)
{
	if(confirm("Are you sure you want to delete the record " + delid))
	{
		var e = document.getElementById('deleteID');
		document.theform.deleteID.value = delid;
		document.theform.submit();
		return true;
	}
	else
	{
		return false;
	}
}

</script>


<body>
<a href="javascript:doDelete(<?php print $row['ID']; ?>);">Delete</a>

The problems are -

I don't want it to actually open another url in the window, I just want it to confirm, then delete / refresh (if posible)
The script isn't deleting, it's not even passing the ID to URL like - delete.php?ID=1

Thanks for even looking at the problem and thank you for any replies!

tuf-web_co_uk

when using urls to pass information you want to use the GET method, not POST, this could be the reason why the id isnt passing

$idtodelete = (int)$_POST['deleteID'];

should be

$idtodelete = (int)$_GET['deleteID'];

HTH

AstroTeg

If you're not getting the ID in the URL, do you have your form method set to "get"? Or do you wish to use "POST" - if you use post, you will not see the variable in the URL.

For #1, its a matter of having your delete code run and then having it pass off to the code that displays the current page the user is on - either using include() or using a browser redirect.

JHallam

Hey, firstly guys thanks for the input, appreciate it immensely

I checked the form and it was set to post, so now its GET, so I tried it...and it passes the value perfectly, just ends up NOT deleting it and displaying "Don't mess with me"

(which I set just incase someone was going to mess with the URL in the address bar)
that was only for security purposes, so it's not actually deleting, which I'm confused about...any ideas?

AstroTeg - for #1, could you give me an example?

Bare with me, I know php, just not that well lol This is my first CMS and it's toughie than first expected! haha

Thanks guys, so much!

JHallam

Could someone please help? I really need some help 🙁

Thanks and hopefully someone can help me