/** * Execute query and sql query * * @return xml if the query is a Select, a result message if not */ function executeSQL($sql, $db) { $query_type = explode(" ", trim($sql)); $result = $db->Execute($sql); if (!$result) { die('\\nInvalid query: ' . $sql . ' ' . mysql_error()); } switch (strtoupper($query_type[0])) { case "SELECT": if ($result->RecordCount() > 0) { $xml = '<xml>'; while (!$result->EOF) { $xml .= '<object>'; /*print_r($result->fields);*/ foreach ($result->fields as $fieldname => $fieldvalue) { if (!empty($fieldvalue)) { $xml .= '<' . $fieldname . '>' . sanitizeStringForXML($fieldvalue) . '</' . $fieldname . '>'; } } $xml .= '</object>'; $result->MoveNext(); } $xml .= '</xml>'; } else { $xml = "<xml></xml>"; } //$xml="\nNo record for your query!"; return $xml; break; /*case "INSERT": break; case "DELETE": break; */ /*case "INSERT": break; case "DELETE": break; */ default: // In the case no objects is return, return an OK message $xml = "\nQuery successfully processed!"; return $xml; break; } //End switch }
$req_select_2 .= "'0.00' AS discount_tax_rate "; $req_select_2 .= "FROM " . TABLE_ORDERS . " ordr "; $req_select_2 .= "LEFT OUTER JOIN " . orders_total . " tot ON (ordr.orders_id=tot.orders_id \n AND tot.class='ot_coupon') "; $req_select_2 .= "WHERE ordr.orders_status = '1' AND tot.value>0 "; $req_select_2 .= "AND ordr.orders_id = '" . $fieldvalue . "' "; $result_select_2 = $db->Execute($req_select_2); if ($result_select_2->RecordCount() > 0) { $xml2 = ""; foreach ($result_select_2->fields as $fieldname2 => $fieldvalue2) { if (!empty($fieldvalue2)) { $xml2 .= '<' . $fieldname2 . '>' . sanitizeStringForXML($fieldvalue2) . '</' . $fieldname2 . '>'; } } } } $xml .= '<' . $fieldname . '>' . sanitizeStringForXML($fieldvalue) . '</' . $fieldname . '>'; } } $xml .= $xml1; $xml .= $xml2; $xml .= '</object>'; $result2->MoveNext(); } $xml .= '</xml>'; echo $xml; header('Content-type: text/xml'); //echo executeSQL($req_select_1, $db); $db->close(); ?>