我正在回顯數據庫中的數據，并嘗試將其顯示在另一個 div 內的 div 內。但它沒有顯示在正確的 div 內。我試圖將其放在You said: ? Hello ?2hrs姓名和個人資料圖片旁邊。我找不到它的問題。沒有錯誤。有人可以幫幫我嗎 ？消息.php：<div class="user_convos convos_column" id="convos">? ??? ? <h4>Conversations</h4>? ? <br>? ? <div class='loaded_conversations' style='position: absolute;'></div>? ? <?php echo $message_obj->getConvos(); ?>? ??<a href="messages.php?u=new">New Message</a><br><br></div>樣式.css：.user_found_messages {padding-left: 10px;padding-top: 10px;height: auto;border-bottom: 1px solid #d9d9d9;}.user_found_messages:hover {background-color: #F2F2F2;color: #669999;}.user_found_messages img {height: 105px;float: left;margin-top: 1px;?margin-right: 5px;?}
1 回答
人到中年有點甜
TA貢獻1895條經驗 獲得超7個贊
首先把線去掉
echo "<br>";
從getLatestMessage函數中 - 這會添加一個您不想要的新行。
其次，將該函數中的所有 echo 轉換為字符串連接，然后從函數返回字符串 - 這使您可以更好地控制在何處使用它生成的結果。
第三，嘗試在user_found_messagesdiv 內回顯消息數據 - 因為 div 是塊級元素，通常也會開始一個新行（除非 CSS 規則告訴它們不要這樣做）。
所以，我想是這樣的：
public function getLatestMessage ($userLoggedIn, $user2) {
$query = $this->con->prepare('SELECT body, user_to, date FROM messages WHERE
user_to = ? AND user_from = ? OR user_to = ? AND user_from = ? ORDER BY id DESC LIMIT 1');
$query->bind_param("ssss", $userLoggedIn, $user2, $user2, $userLoggedIn);
$query->execute();
//$query->bind_result($body, $user_to, $date);
$query_result = $query->get_result();
$msg = ""; //to hold the message data
if ($row = $query_result->fetch_assoc()) { //don't need a while here because we've limited the query to one record
//Timeframe
$date_time_now = date("Y-m-d H:i:s");
$start_date = new DateTime($row['date']); //Time of post
$end_date = new DateTime($date_time_now); //Current time
$interval = $start_date->diff($end_date); //Difference between dates
if($interval->y >= 1) {
if($interval->y == 1)
$time_message = $interval->y . "yr"; //1 year ago
else
$time_message = $interval->y . "yrs"; //1+ year ago
}
else if ($interval-> m >= 1) {
if($interval->d == 0) {
$days = " ago";
}
else if($interval->d == 1) {
$days = $interval->d . "d";
}
else {
$days = $interval->d . "d";
}
if($interval->m == 1) {
$time_message = $interval->m . "month";
}
else {
$time_message = $interval->m . "months";
}
}
else if($interval->d >= 1) {
if($interval->d == 1) {
$time_message = "Yesterday";
}
else {
$time_message = $interval->d . "d ";
}
}
else if($interval->h >= 1) {
if($interval->h == 1) {
$time_message = $interval->h . "hr";
}
else {
$time_message = $interval->h . "hrs";
}
}
else if($interval->i >= 1) {
if($interval->i == 1) {
$time_message = $interval->i . "m";
}
else {
$time_message = $interval->i . "m";
}
}
else {
if($interval->s < 30) {
$time_message = "Just now";
}
else {
$time_message = $interval->s . " seconds ago";
}
}
$msg .= ($row['user_to'] == $userLoggedIn) ? "They said: " : "You said: ";
$msg .= ' ';
$msg .= $body = $row['body'];
$msg .= ' ';
$msg .= $time_message ;
$msg .= ' ';
}
return $msg;
}
public function getConvos () {
$userLoggedIn = $this->user_obj->getUsername();
$return_string = "";
$convos = array();
$query = mysqli_query($this->con, "SELECT user_to, user_from FROM messages WHERE user_to='$userLoggedIn' OR
user_from='$userLoggedIn' ORDER BY id DESC");
while ($row = mysqli_fetch_array($query)) {
$user_to_push = ($row['user_to'] != $userLoggedIn) ? $row['user_to'] : $row['user_from'];
if(!in_array($user_to_push, $convos)) {
array_push($convos, $user_to_push);
}
}
foreach ($convos as $username) {
$user_found_obj = new User($this->con, $username);
$latest_message_details = $this->getLatestMessage($userLoggedIn, $username);
$return_string .= "<a href='messages.php?u=$username'><div class='user_found_messages'>
<img src='" . $user_found_obj->getProfilePic() .
"' style='border-radius: 5px; margin-right: 5px;'>
". $user_found_obj->getFirstAndLastName() ."<br/>".
$latest_message_details . "</div></a>";
}
return $return_string;
}
- 1 回答
- 0 關注
- 129 瀏覽
添加回答
舉報
0/150
提交
取消