[SOLVED] How to execute sql code in php

[steviez]

Hi,

 

I need the following code to be executed when a user clicks on the delete button:

 

<?php
if(!$UsErId)

{

$redirect = $SITEURL."login.php";

header("Location:$redirect");

}

  session_start();
  if (isset($_SESSION['$UsErId'])) {
    $sql = "DELETE FROM user WHERE id = '{$_SESSION['$UsErId']}'";
    if (mysql_query($sql)) {
      $redirect = $SITEURL."logout.php";
      header("location:$redirect");
    } else {
      echo "Delete failed";
    }
  }
?>

 

How is this done? The button when pressed will delete a user from the database.

 

Thanks

[papaface]

something like

<?php

if	(isset($_POST['delete']))
{
$delete = $_POST['delete'];

if	($delete == "yes")
	{
	$sql = "DELETE FROM user WHERE id = '{$_SESSION['$UsErId']}'";
	if (mysql_query($sql)) 
		{
	  $redirect = $SITEURL."logout.php";
	  header("location:$redirect");
		} 
	else
		{
		 echo "Delete failed";
		}

	}
else
	{
	echo "You chose not to delete the record";
	}
}

?>
<form action="<?= $_SERVER['PHP_SELF'] ?>" method="post">
<input name="delete" type="submit" value="yes" />
<input name="delete" type="submit" value="no" />
</form>

I wrote it quite quickly so there may be some minor errors.

[steviez]

Thank you that worked a treat! i dont suppose anyone could help me with the next problem in this puzzle?

 

When the user is deleted from the database i am wanting all their images, uploads etc to be deleted at the same time. Is this possable and if so how?

 

Thanks

[Jessica]

If you have their user id associated with those uploads, just DELETE FROM uploads WHERE userid = '$id'

[steviez]

I already have one query tho:

 

$sql = "DELETE FROM user WHERE id = '$UsErId'";

 

how do i make it do two or three more sql querys at once?