13 {
15
17 SELECT chat_id, room_id
18 FROM chat_room_messages
19 GROUP BY chat_id, room_id
20 ");
21
22 $chat_room_id_comb = array();
23
24 while ($row =
$DIC->database()->fetchAssoc(
$res)) {
25 $chat_room_id_comb[] = array($row['chat_id'], $row['room_id']);
26 }
27
28 foreach ($chat_room_id_comb as $combination) {
30 "
31 SELECT *
32 FROM chat_room_messages
33 WHERE chat_id = %s
34 AND room_id = %s",
35 array('integer', 'integer'),
36 array($combination[0], $combination[1])
37 );
38
39 $xml =
new SimpleXMLElement(
'<entries />');
40 $xml->addAttribute(
'chat_id', $combination[0]);
41 $xml->addAttribute(
'room_id', $combination[1]);
42
43 while ($row =
$DIC->database()->fetchAssoc(
$res)) {
44 $child =
$xml->addChild(
'entry', $row[
'message']);
45 $child->addAttribute('timestamp', $row['commit_timestamp']);
46 }
47
49 }
50 }
foreach($_POST as $key=> $value) $res