getbirthdays.php

一个页面界面的邮件程序

<?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();
}


$sql = "SELECT P.* FROM `person` P, `user_person` UP " .
		" WHERE P.id = UP.idperson AND UP.role != 1 AND P.birthdate != '0000-00-00' AND UP.iduser = '".$_SESSION['user'] . "'" .
		" ORDER BY DATE_FORMAT(P.birthdate, '%m'), DATE_FORMAT(P.birthdate, '%d'), P.firstname, P.lastname";
$result = mysql_query($sql) or die("Error in SQL : " . $sql);

$b = 0;

$birthdays = getBirthdays($result, $b, $begin);

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

$i = (!isset($begin)) ? 0 : $begin;
$nb = 0;
while ($nb < $b) {
	$birthday = $root->appendChild(new DOMElement('birthday'));
	$birthday->setAttribute("id", $birthdays[$i][ID]);
	$birthday->setAttribute("firstname", $birthdays[$i][FIRSTNAME]);
	$birthday->setAttribute("lastname", $birthdays[$i][LASTNAME]);
	$birthday->setAttribute("birthdateDay", $birthdays[$i][BIRTHDATE_DAY]);
	$birthday->setAttribute("birthdateMonth", $birthdays[$i][BIRTHDATE_MONTH]);
	$birthday->setAttribute("birthdateYear", $birthdays[$i][BIRTHDATE_YEAR]);
	$birthday->setAttribute("age", $birthdays[$i][AGE]);
	$i++;
	$nb++;
	if ($i >= $b)
		$i = 0;
}

echo $dom->saveXML();
?>