So I did this and I get XML code for one of the records but, there should be three records. Do you know where I went wrong?
<?php require_once('Connections/sdpc_i.php'); ?>
<?php require_once('webassist/mysqli/rsobj.php'); ?>
<?php require_once('webassist/mysqli/queryobj.php'); ?>
<?php require_once('webassist/mysqli/authentication.php'); ?>
<?php
if ("" == "") {
$RestrictAccess = new WA_MySQLi_Auth();
$RestrictAccess->Action = "restrict";
$RestrictAccess->Name = "sdpc_login";
$RestricAccessRedirect = "error.php";
if (function_exists("rel2abs")) $RestricAccessRedirect = $RestricAccessRedirect?rel2abs($RestricAccessRedirect,dirname(__FILE__)):"";
$RestrictAccess->FailRedirect = $RestricAccessRedirect;
$RestrictAccess->execute();
}?>
<?php
$state = $_GET['state'];
$agreement_typesID = $_GET['agreement_typesID'];
$category = $_GET['category'];
$query = new WA_MySQLi_RS("query",$sdpc_i,0);
$query = "SELECT * from ((SELECT agreement_typesID, agreement_name, state, description, category as thecategory, latest, public, concat('https://sdpc.a4l.org/agreements/',file_pdf) as agreement_file_pdf, concat('https://sdpc.a4l.org/agreements/',file_doc) as agreement_file_doc FROM agreement_types where state = '$state' and agreement_typesID = $agreement_typesID and category = '$category') t1 left join (SELECT * FROM agreement_vendor_types) t8 on (t1.agreement_typesID = t8.agreement_typesID) left join (SELECT * from clause_agreement_type) t2 on (t1.agreement_typesID = t2.agreement_typesID or t2.agreement_type_vendorID = t8.agreement_type_vendorID) left join (SELECT * from contract_clauses) t3 on (t3.clauseID = t2.clauseID) left join (select * from clause_obligation) t4 on (t4.clause_agreement_typeID = t2.clause_agreement_typeID) left join (SELECT * from obligations) t5 on (t5.obligationID = t4.obligationID) left join (SELECT * from obligation_benchmark) t6 on (t4.clause_obligationID = t6.clause_obligationID) left join (SELECT *, benchmarkID as thebenchmarkID from benchmarks) t7 on (t6.benchmarkID = t7.benchmarkID))";
$result = $sdpc_i->query($query);
// Associative array
$row=mysqli_fetch_array($result,MYSQLI_ASSOC);
// Free result set
mysqli_free_result($result);
mysqli_close($sdpc_i);
function to_xml(SimpleXMLElement $object, array $row)
{
foreach ($row as $key => $value) {
if (is_array($value)) {
$new_object = $object->addChild($key);
to_xml($new_object, $value);
} else {
// if the key is an integer, it needs text with it to actually work.
if ($key == (int) $key) {
$key = "$key";
}
$object->addChild($key, $value);
}
}
}
$xml = new SimpleXMLElement('<data/>');
to_xml($xml, $row);
print $xml->asXML();
header('Content-Type: application/xml; charset=utf-8');
header('Content-Language: en');
header('Cache-Control: no-store, no-cache, must-revalidate');
header("Content-Length: ".filesize($filename));
header("Date: ".gmdate('D, d M Y H:i:s T'));
?>