PHP Database::retrieve_where Examples

Example #1

File: details.php Project: harryrickards/harryrickards

<?php

require_once "functions.php";
require_once "gChart.php";
print_header();
if (!isset($_GET['tag'])) {
    print "Station tag needs to be passed via GET, and it wasn't";
    exit;
}
$tag = $_GET['tag'];
$db = new Database("localhost", "user", "pass", "db");
$db->table = "stations";
$stations_result = $db->retrieve_where('tag', $tag, 1, 0);
foreach ($stations_result as $value) {
    $name = $value->name;
}
$time = time();
$time = $time - $time % 120;
$db->table = "counts";
$counts_results = $db->retrieve_where('tag', $tag, 999999999999, 0);
$i = 0;
foreach ($counts_results as $value) {
    if ($value->timestamp == $time) {
        $p_in = $value->p_in;
    }
    if ($value->timestamp <= $time) {
        if ($i % 15 == 0 || $value->timestamp == $time) {
            $data[] = $value->p_in;
            if ($i % 90 == 0) {
                $timestamps[] = date('H:i', $value->timestamp);
            }