deleteperson.php

来自「一个页面界面的邮件程序」· PHP 代码 · 共 58 行

<?php
require_once("../inc/constants.inc.php");
require_once("../inc/properties.inc.php");
require_once("../inc/tools.inc.php");
require_once("../inc/db.inc.php");

header('Content-type: text/xml;');

if (!isset($_SESSION['user'])) {
	die();
}

if (isset($_POST['id']))
	$param = $_POST;
else if (isset($_GET['id']))
	$param = $_GET;
else
	die("Attribute 'id' not found ! Can't delete somebody");

$idperson = $param['id'];

// Protection
if ($idperson == $_SESSION['user'])
	die("Can't delete myself !!!");


$sql = "DELETE FROM `address` WHERE idperson = $idperson";
$result = mysql_query($sql) or die("Error in SQL : " . $sql);


$sqlContact = "SELECT id FROM `contact` WHERE idperson = $idperson";
$resultContact = mysql_query($sqlContact) or die("Error in SQL : " . $sqlContact);
if ($resultContact && mysql_num_rows($resultContact) > 0) {
	while ($lineContact = mysql_fetch_assoc($resultContact)) {
		$sql = "DELETE FROM `mailing_list_contact` WHERE idcontact = ". $lineContact["id"];
		$result = mysql_query($sql) or die("Error in SQL : " . $sql);
	}
}

$sql = "DELETE FROM `contact` WHERE idperson = $idperson";
$result = mysql_query($sql) or die("Error in SQL : " . $sql);

$sql = "DELETE FROM `contact` WHERE idperson = $idperson";
$result = mysql_query($sql) or die("Error in SQL : " . $sql);

$sql = "DELETE FROM `user_person` WHERE idperson = $idperson";
$result = mysql_query($sql) or die("Error in SQL : " . $sql);

$sql = "DELETE FROM `person` WHERE id = $idperson";
$result = mysql_query($sql) or die("Error in SQL : " . $sql);


$dom = new DOMDocument('1.0', ENCODING);
$root = $dom->appendChild(new DOMElement('response'));
$root->setAttribute("idDeleted", $idperson);

echo $dom->saveXML();
?>