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}"; } }