-
Notifications
You must be signed in to change notification settings - Fork 0
/
openconn.php
50 lines (45 loc) · 1.53 KB
/
openconn.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
<?php
$dbhost = "appserver-01.alunos.di.fc.ul.pt";
$dbuser = "asw001";
$dbpass = "aswAGR2020";
$dbname = "asw001";
// Cria a ligação à BD
$conn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
// Verifica a ligação à BD
if (mysqli_connect_error()) {
die("Database connection failed: " . mysqli_connect_error());
}
// function fetch_user_chat_history($from_user_id, $to_user_id, $conn){
// $query = "
// SELECT * FROM chat_message
// WHERE (from_user_id = '".$from_user_id."'
// AND to_user_id = '".$to_user_id."')
// OR (from_user_id = '".$to_user_id."'
// AND to_user_id = '".$from_user_id."')
// ORDER BY timestamp DESC
// ";
// // $statement = $conn->prepare($query);
// $result = mysqli_query($conn, $query);
// $output = '<ul class="list-unstyled">';
// foreach($result as $row){
// $user_name = '';
// if($row["from_user_id"] == $from_user_id){
// $user_name = '<b class="text-success">You</b>';
// }
// else{
// $user_name = '<b class="text-danger">'.get_user_name($row['from_user_id'], $conn).'</b>';
// }
// $output .= '
// <li style="border-bottom:1px dotted #ccc">
// <p>'.$user_name.' - '.$row["chat_message"].'
// <div align="right">
// - <small><em>'.$row['timestamp'].'</em></small>
// </div>
// </p>
// </li>
// ';
// }
// $output .= '</ul>';
// return $output;
// }
?>