drbuowqe02101 2016-05-20 14:01
浏览 38

PHP和mysql以按日期分组的WhatsApp样式显示聊天消息

Can anyone guide me on how to display all messages from my chat database table in WhatsApp format Grouping Messages by Date i.e

[Today]

Janet:How are?

Jon: Am fine and you

[ Yesterday ]

John: Go to bed please

Janet: Okay dear, Good nite

[19 May, 2016 ]

John: Go to bed please

Janet: Okay dear, Good nite

Mysql:

CREATE TABLE IF NOT EXISTS `chat` (
  `id` int(10) unsigned NOT NULL,
  `from` varchar(255) NOT NULL DEFAULT '',
  `to` varchar(255) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  `sent_by` varchar(111) NOT NULL,
  `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `recd` int(10) unsigned NOT NULL DEFAULT '0'
) ENGINE=MyISAM AUTO_INCREMENT=229 DEFAULT CHARSET=latin1;  

PHP:

$result = mysql_query("SELECT *FROM (SELECT * FROM `chat` WHERE `from` = '$my_id' AND `to` = '$chat_with' OR `from` = '$chat_with' AND `to` = '$my_id' ORDER BY `created`  DESC  LIMIT $start, $limit )tmp 
ORDER BY tmp.created ASC") or die(mysql_error());

while($row = mysql_fetch_array($result)){
print"$row['from']";
 echo parse_smileys(make_clickable(nl2br(stripslashes($row['message']))), $smiley_folder);
  print"$row['created'] @ $msg_time";
}
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 目详情-五一模拟赛详情页
    • ¥15 有了解d3和topogram.js库的吗?有偿请教
    • ¥100 任意维数的K均值聚类
    • ¥15 stamps做sbas-insar,时序沉降图怎么画
    • ¥15 买了个传感器,根据商家发的代码和步骤使用但是代码报错了不会改,有没有人可以看看
    • ¥15 关于#Java#的问题,如何解决?
    • ¥15 加热介质是液体,换热器壳侧导热系数和总的导热系数怎么算
    • ¥100 嵌入式系统基于PIC16F882和热敏电阻的数字温度计
    • ¥15 cmd cl 0x000007b
    • ¥20 BAPI_PR_CHANGE how to add account assignment information for service line