public static function getDateActivity($date) { $rows = Queries::getAllRows(Database::$table_track); foreach ($rows as $row) { if (strpos($row['date'], $date) !== false) { $ips[] = $row['ip']; $pages[] = $row['page']; } } return array($ips, $pages); }
<html> <body> <ul> <?php include 'includes.php'; Tracking::track(basename(filter_input(INPUT_SERVER, 'PHP_SELF'))); $rows = Queries::getAllRows(Database::$table_pages); if ($rows) { foreach ($rows as $row) { $owners[] = $row['owner']; $titles[] = $row['title']; $descriptions[] = $row['description']; $goals[] = $row['goal']; $amounts[] = $row['amount']; } for ($i = 0; $i < count($titles); $i++) { $title = $titles[$i]; echo "<li><a href='userpage.php?title={$title}'>{$titles[$i]} by {$owners[$i]} - {$amounts[$i]}/{$goals[$i]}</a></li>"; } } else { echo "Error receiving data from database"; } ?> </ul> </body> </html>