-
Notifications
You must be signed in to change notification settings - Fork 0
/
functions.php
executable file
·121 lines (84 loc) · 3.22 KB
/
functions.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
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
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
<?php
//GLOBALS
$link = NULL;
//Connect Database
function connectDb($host,$database,$user,$password) {
$mysql_host = $host;
$mysql_database = $database;
$mysql_user = $user;
$mysql_password =$password;
$link=mysql_connect($mysql_host,$mysql_user,$mysql_password);
if (!$link)
{
echo "Please try later.";
}
else
{
mysql_select_db($mysql_database,$link);
mysql_query("SET NAMES UTF8");
}
}
//Get Event
function getEvents($id){
$query = "SELECT * FROM events WHERE id='".$id."'";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
//Get a list of Questionnaires per Event
function getQuestionnaire($eid){
$query = "SELECT * FROM survey_questions WHERE eventId='".$eid."'";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
//Get a list of Choices per Question ( Anket )
function getChoices($qid){
$query = "SELECT * FROM survey_question_choice WHERE question_id='".$qid."'";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
//Get the list of unique Questionnaires
function getAllQuestionnaire(){
$query = "SELECT id,title FROM events WHERE status=0";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
function getAllEvent(){
$query = "SELECT id,title,description,date FROM events WHERE status=1 order by date asc";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
//Gets News from the database
function getReadNews(){
$query = "SELECT * FROM news Where status=1 ORDER BY id DESC LIMIT 6";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
//Gets one News from the database
function getaNews($id){
$query = "SELECT * FROM news WHERE id='".$id."'";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
function searchUser($searching){
$query = "SELECT firstname,lastname,email FROM users WHERE CONCAT_WS(' ', firstname, lastname ) LIKE '%".$searching."%' and user_role IN(2,3)";
$result = mysql_query($query) or trigger_error(mysql_error()." ".$query);
return $result;
}
//This function converts to UTF8
function utf8_for_xml($string){
return preg_replace('/[^\x{0009}\x{000a}\x{000d}\x{0020}-\x{D7FF}\x{E000}-\x{FFFD}]+/u',' ', $string);
}
//Exceprt the content for the given word count
function summary($textOrHtml, $maxWords) {
$text = strip_tags($textOrHtml, "<b></b><i></i>");
$words = preg_split("/\s+/", $text, $maxWords+1);
if (count($words) > $maxWords) { unset($words[$maxWords]); }
$output = join(' ', $words);
return $output;
}
//Converts the given date to YMD format
function convertDateFormat($date){
$date = date('Y-m-d', strtotime($date));
return preg_replace('/\s+/', '', $date);
}
?>