MySQLI Query Export to XML File
I have a query below and I need to export the data on the page to an XML file. Is it possible to do this with the Dreamweaver Extension?
<?php
$agreements2 = new WA_MySQLi_RS("agreements2",$sdpc_i,0);
$agreements2->setQuery("SELECT *, clause_agreement_type.clause_agreement_typeID as theclause_agreement_typeID, clause_obligation.clause_obligationID as theclause_obligationID, obligations.obligationID as theobligationID, benchmarks.benchmarkID as thebenchmarkID, contract_clauses.clauseID as theclauseID FROM agreement_types left join clause_agreement_type on agreement_types.agreement_typesID = clause_agreement_type.agreement_typesID left join contract_clauses on contract_clauses.clauseID = clause_agreement_type.clauseID left join clause_obligation on clause_obligation.clause_agreement_typeID = clause_agreement_type.clause_agreement_typeID left join obligations on obligations.obligationID = clause_obligation.obligationID left join obligation_benchmark on clause_obligation.clause_obligationID = obligation_benchmark.clause_obligationID left join benchmarks on obligation_benchmark.benchmarkID = benchmarks.benchmarkID WHERE agreement_types.agreement_typesID = ?");
$agreements2->bindParam("i", "".(isset($_GET['agreement_typesID'])?$_GET['agreement_typesID']:"") ."", "-1"); //colname
$agreements2->execute();?>