001.<?php
002. $connection = null;
003.
004. function connectToDatabase()
005. {
006. $serverName = "127.0.0.1";
007. $userName = "root";
008. $password = "1234";
009. $databaseName = "sms";
010.
011.
012. $GLOBALS["connection"] = mysql_connect($serverName, $userName, $password);
013. if ($GLOBALS["connection"] == null)
014. {
015. echo mysql_error() . "<br>";
016. return false;
017. }
018.
019. try
020. {
021. mysql_select_db($databaseName);
022. }
023. catch (Exception $exc)
024. {
025. echo (mysql_error() . "<br>");
026. return false;
027. }
028.
029. return true;
030. }
031.
032. function closeConnection ()
033. {
034. try
035. {
036. mysql_close($GLOBALS["connection"]);
037. }
038. catch (Exception $exc)
039. {
040.
041. }
042. }
043.
044.
045. function insertMessage ($recipient, $messageType, $messageText)
046. {
047. $query = "insert into ozekimessageout (receiver,msgtype,msg,status) ";
048. $query .= "values ('" . $recipient . "', '" . $messageType . "', '" . $messageText . "', 'send');";
049. mysql_query("SET NAMES UTF8");
050. $result = mysql_query ($query);
051. if (!$result)
052. {
053. echo (mysql_error() . "<br>");
054. return false;
055. }
056.
057. return true;
058. }
059.
060. function showOutgoingMessagesInTable()
061. {
062. $query = "select id,sender,receiver,senttime,receivedtime,operator,status,msgtype,msg from ozekimessageout;";
063. mysql_query("SET NAMES UTF8");
064. $result = mysql_query ($query);
065. if (!$result)
066. {
067. echo (mysql_error() . "<br>");
068. return false;
069. }
070.
071. try
072. {
073. echo "<table border='1'>";
074. echo "<tr><td>ID</td><td>Sender</td><td>Receiver</td><td>Sent time</td><td>Received time</td><td>Operator</td>";
075. echo "<td>Status</td><td>Message type</td><td>Message text</td></tr>";
076. while ($row = mysql_fetch_assoc($result))
077. {
078. echo "<tr>";
079.
080. echo "<td>" . $row["id"] . "</td>";
081. echo "<td>" . $row["sender"] . "</td>";
082. echo "<td>" . $row["receiver"] . "</td>";
083. echo "<td>" . $row["senttime"] . "</td>";
084. echo "<td>" . $row["receivedtime"] . "</td>";
085. echo "<td>" . $row["operator"] . "</td>";
086. echo "<td>" . $row["status"] . "</td>";
087. echo "<td>" . $row["msgtype"] . "</td>";
088. echo "<td>" . $row["msg"] . "</td>";
089.
090. echo "</tr>";
091. }
092. echo "</table>";
093. mysql_free_result($result);
094. }
095. catch (Exception $exc)
096. {
097. echo (mysql_error() . "<br>");
098. return false;
099. }
100.
101. return true;
102. }
103.
104. function showIncomingMessagesInTable()
105. {
106. $query = "select id,sender,receiver,senttime,receivedtime,operator,msgtype,msg from ozekimessagein;";
107. mysql_query("SET NAMES UTF8");
108. $result = mysql_query ($query);
109. if (!$result)
110. {
111. echo (mysql_error() . "<br>");
112. return false;
113. }
114.
115. try
116. {
117. echo "<table border='1'>";
118. echo "<tr><td>ID</td><td>Sender</td><td>Receiver</td><td>Sent time</td><td>Received time</td><td>Operator</td>";
119. echo "<td>Message type</td><td>Message text</td></tr>";
120. while ($row = mysql_fetch_assoc($result))
121. {
122. echo "<tr>";
123.
124. echo "<td>" . $row["id"] . "</td>";
125. echo "<td>" . $row["sender"] . "</td>";
126. echo "<td>" . $row["receiver"] . "</td>";
127. echo "<td>" . $row["senttime"] . "</td>";
128. echo "<td>" . $row["receivedtime"] . "</td>";
129. echo "<td>" . $row["operator"] . "</td>";
130. echo "<td>" . $row["msgtype"] . "</td>";
131. echo "<td>" . $row["msg"] . "</td>";
132.
133. echo "</tr>";
134. }
135. echo "</table>";
136. mysql_free_result($result);
137. }
138. catch (Exception $exc)
139. {
140. echo (mysql_error() . "<br>");
141. return false;
142. }
143.
144. return true;
145. }
146.?>
