/
class_events.php
49 lines (46 loc) · 1.42 KB
/
class_events.php
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
<?php
// load configuration file
require_once('config.php');
require_once('function.php');
class events
{
// database handler
private $mMysqli;
// class constructor
function __construct()
{
// connect to the database
$this->mMysqli = new mysqli(DB_HOST, DB_USER, DB_PASSWORD, DB_DATABASE);
}
function getEvents()
{
// what SQL query you want executed?
$query = "SELECT event_name, event_startdate, event_city, event_address, event_id FROM events WHERE event_startdate >= CURDATE( )";
// execute the query
$result = $this->mMysqli->query($query);
while ($row = $result->fetch_array(MYSQLI_ASSOC))
{
$event_id = $row['event_id'];
$event_names = $row['event_name'];
$url = "event.php?event_id=".($event_id);
$title = $event_names;
do_html_url($url, $title);
$this->event_startdate = $row['event_startdate'];
$this->event_city = $row['event_city'];
$this->event_address = $row['event_address'];
echo ' '.$row['event_startdate'] . '<br/>';
echo ' '.$row['event_city'] . ' ' .$row['event_address']. '<br/>';
$a = $row['event_startdate'];
$b = $row['event_city'];
echo $a.$b;
}
$result->close();
}
// class destructor, closes database connection
public function __destruct()
{
// close the database connection
$this->mMysqli->close();
}
}
?>