File: /home/mckernan/public_html/iJournal/includes/fixed/dtl.php
<?php
// asset details
// init database name
$database = DB_PREFIX;
// process request
if ($sid != '')
{
// sid check
require "includes/session/sidck.php";
// init return value
$rv = '<root>' . PHP_EOL;
// fetch database name / open db
$db = '';
if ( isset($_POST['db']) ) $db = $_POST['db'];
if ( isset($_GET['db']) ) $db = $_GET['db'];
if ($db == '') die();
$database .= $db;
require "includes/db.php";
// fetch params
$id = getvar($db, 'id', 'int');
// fetch list
$query = "SELECT * FROM fixed_assets WHERE fa_id = " . $id;
if ($result = $db->query($query))
{
while ($row = $result->fetch_assoc())
{
$rv .= '<asset>' . PHP_EOL;
$rv .= '<id>' . $row['fa_id'] . '</id>' . PHP_EOL;
$rv .= '<caption>' . $row['fa_caption'] . '</caption>' . PHP_EOL;
$rv .= '<date>' . humanDate($row['fa_date']) . '</date>' . PHP_EOL;
$rv .= '<mos>' . $row['fa_mos'] . '</mos>' . PHP_EOL;
$rv .= '<cost>' . $row['fa_cost'] . '</cost>' . PHP_EOL;
$rv .= '<financed>' . $row['fa_financed'] . '</financed>' . PHP_EOL;
$rv .= '</asset>' . PHP_EOL;
}
}
// finish output
$rv .= '</root>' . PHP_EOL;
// return data
echo $rv;
die;
}
else
{
header('Server: ');
header('X-Powered-By: ');
header("HTTP/1.0 404 Not Found");
}
?>