summaryrefslogtreecommitdiff
path: root/htdocs/src/Source.inc.php
blob: e869d20f10557341d4304c0ae55cca543251eb8f (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
<?php

/* Foursquare Community Site
 * 
 * Copyright (C) 2011 Foursquare Church.
 * 
 * Developers: Jesse Morgan <jmorgan@foursquarestaff.com>
 *
 */

require_once "base.inc.php";

class Source {
    private $info;


    public function __construct($info=null) {
        $this->info = $info;
    }

    public static function getSources() {
        $db = getDatabase();

        $query = "SELECT * FROM source ORDER BY name";

        $rows = $db->fetchAssocRows($query);
       
        $result = array();
        foreach ($rows as $row) {
            $source = new Source($row);
            $result[] = $source;
        }

        return $result;
    }

    public static function getById($id) {
        $where = "id='$id'";

        return Source::getSource($where);
    }

    private static function getSource($where) {
        $query = "SELECT * FROM source WHERE $where";

        $db = getDatabase();
        
        $row = $db->fetchAssocRow($query);

        if ($row) {
            $source = new Source();
            $source->info = $row;

            return $source;

        } else {
            return false;
        }
    }

    public function save() {
        $db = getDatabase();

        // TODO: Implement Save
    }

    public function getId() {
        return $this->info['id'];
    }

    public function getName() {
        return htmlspecialchars($this->info['name']);
    }
}

?>