function getLinks($db, $links_array, $iteration)
{
$sql = "SELECT HEX(correlator) AS corr, HEX(parent_correlator) AS pcorr FROM transaction_file WHERE iteration =" . $iteration . " AND HEX(parent_correlator) IS NOT NULL ORDER BY starttime LIMIT 4999;";
//echo $sql;
if ($stmt = $db->prepare($sql)) {
/* create a prepared statement */
//if ($stmt = $db->prepare("SELECT s.context AS 'origin', d.context AS 'destination',HEX(d.correlator) AS corr,HEX(d.parent_correlator) AS pcorr FROM transaction_iter d INNER JOIN transaction_iter s ON d.parent_correlator = s.correlator")) {
/* execute query */
if ($stmt->execute()) {
/* bind result variables */
$stmt->bind_result($l_corr, $l_pcorr);
/* fetch values */
while ($stmt->fetch()) {
$temp_object = new links();
$object = $temp_object->createLink($l_corr, $l_pcorr);
//echo json_encode($object);
array_push($links_array, $object);
}
//echo json_encode($links_array);
} else {
echo "Error code ({$stmt->errno}): {$stmt->error}";
}
/* close statement */
$stmt->close();
//array_splice($links_array,0,100);
echo json_encode($links_array);
//return $links_array;
} else {
echo "Error code ({$db->errno}): {$db->error}";
}
}
