blocks|key|225370|text|您可以创建通知表，如下所示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|225371|from_user+%7C+to_user+%7C+notification+%7C+seen|code-block|syntax|javascript|225372|然后，当您想要通知用户时，只需添加一条包含所需信息的记录，并将seen设置为0+/+false。|offset|length|style|CODE|225373|然后，当用户读取通知时，将该参数设置为1+/+true。|225374|示例：|225375|from_user+%7C+to_user+%7C+notification+%7C+seen
++++-++++++++++-++++++++++-+++++++++++-|225376|用户john通知用户jeff：|225377|from_user+%7C+to_user+%7C+notification+%7C+seen
+++john++++++jeff+++++++whatever..++++0|225378|用户jeff阅读了通知：|225379|from_user+%7C+to_user+%7C+notification+%7C+seen
+++john++++++jeff+++++++whatever..++++1++|225380|entityMap^0|0|0|V|4|12|1|16|5|0|J|1|N|4|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@$I|15|J|16|K|L]|$I|17|J|18|K|L]|$I|19|J|1A|K|L]]|9|@]|A|$]]|$1|M|3|N|5|6|7|1B|8|@$I|1C|J|1D|K|L]|$I|1E|J|1F|K|L]]|9|@]|A|$]]|$1|O|3|P|5|6|7|1G|8|@]|9|@]|A|$]]|$1|Q|3|R|5|D|7|1H|8|@]|9|@]|A|$E|F]]|$1|S|3|T|5|6|7|1I|8|@]|9|@]|A|$]]|$1|U|3|V|5|D|7|1J|8|@]|9|@]|A|$E|F]]|$1|W|3|X|5|6|7|1K|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1L|8|@]|9|@]|A|$E|F]]|$1|10|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|11|$]]

You can create a notification table such as:

<pre><code>from_user | to_user | notification | seen
</code></pre>

and then whenever you want to notify a user you just add a record with the needed informations and set <code>seen</code> to <code>0</code> / <code>false</code>.

Then when the user reads the notification you set that parameter to <code>1</code> / <code>true</code>.

Example:

<pre><code>from_user | to_user | notification | seen
 - - - -
</code></pre>

User john notify user jeff:

<pre><code>from_user | to_user | notification | seen
 john jeff whatever.. 0
</code></pre>

User jeff read the notification:

<pre><code>from_user | to_user | notification | seen
 john jeff whatever.. 1 
</code></pre>

blocks|key|3098477|text|为什么不在一个名为"+notifications“的表中列出所有通知呢？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3098478|id+%7C+user_id+%7C+from_user_id+%7C+notification|code-block|syntax|javascript|3098479|通知id=通知id+for?|3098480|from_user_id+|unordered-list-item|3098481|
|3098482|user_id=谁是通知for？|3098483|3098484|from_user_id=谁发送了通知？|3098485|3098486|3098487|
=+the+message|3098488|然后作为伪代码：|3098489|//+Create+a+notification+from+User+A+to+User+B
$this->db->insert+('notifications',+array+('user_id'+=>+$friends_id,+'from_user_id'+=>+$current_user_id,+'notification'+=>+$message));

+//+The+meanwhile,+on+your+home+page+or+somewhere,+wherever+you+want+to+display+notifications
+$this->db->where+('user_id',+$current_user_id)
+$notifications+=+$this->db->get+('user_id');
+foreach+($notifications+as+$notification)
+{
+++++++++//+Display+the+notification+as+needed
+++++++++//+Optionally+delete+the+notification+as+it+is+displayed+if+it+is+a+"one+off"+alert+only
+}|3098490|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|13|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|14|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|15|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|16|8|@]|9|@]|A|$]]|$1|N|3|O|5|K|7|17|8|@]|9|@]|A|$]]|$1|P|3|M|5|6|7|18|8|@]|9|@]|A|$]]|$1|Q|3|R|5|K|7|19|8|@]|9|@]|A|$]]|$1|S|3|M|5|6|7|1A|8|@]|9|@]|A|$]]|$1|T|3|-4|5|K|7|1B|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1C|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1D|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|D|7|1E|8|@]|9|@]|A|$E|F]]|$1|10|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|11|$]]

Why not just list all the notifications in a table called "notifications"

<pre><code>id | user_id | from_user_id | notification
</code></pre>

<ul>
<li>id = notification id</li>
<li>user_id = who is the notification for?</li>
<li>from_user_id = who sent the notification? </li>
<li>notification = the message</li>
</ul>

Then as pseudocode:

<pre><code>// Create a notification from User A to User B
$this-&gt;db-&gt;insert ('notifications', array ('user_id' =&gt; $friends_id, 'from_user_id' =&gt; $current_user_id, 'notification' =&gt; $message));

 // The meanwhile, on your home page or somewhere, wherever you want to display notifications
 $this-&gt;db-&gt;where ('user_id', $current_user_id)
 $notifications = $this-&gt;db-&gt;get ('user_id');
 foreach ($notifications as $notification)
 {
 // Display the notification as needed
 // Optionally delete the notification as it is displayed if it is a "one off" alert only
 }
</code></pre>

blocks|key|228994|text|扩展Jeffrey的答案：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|228995|id++%7C++from_user+%7C+to_user+%7C+notification+%7C+seen+%7C+timestamp
+-+++++++++-++++++++++-++++++++++-+++++++++++-+++++++++-|code-block|syntax|javascript|228996|时间戳将帮助您识别特定通知发生的时间。还可以通过使用timeago.js或Livestamp.js扩展脚本来创建time+moment|offset|length|228997|它还将帮助您创建通知时间表，并且通知的维护将更加简单。|228998|entityMap|0|LINK|mutability|MUTABLE|url|http://timeago.yarp.com/|1|http://mattbradley.github.io/livestampjs/^0|0|0|Q|A|0|11|C|1|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@$I|Z|J|10|1|11]|$I|12|J|13|1|14]]|A|$]]|$1|K|3|L|5|6|7|15|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|16|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]|U|$5|P|Q|R|A|$S|V]]]]

Extending Jeffrey's Answer :

<pre><code>id | from_user | to_user | notification | seen | timestamp
 - - - - - -
</code></pre>

timestamp will help you to identify at which moment particular notification occurred. You may also able to create time moment by extending your script with <a href="http://timeago.yarp.com/" rel="nofollow">timeago.js</a> or <a href="http://mattbradley.github.io/livestampjs/" rel="nofollow">Livestamp.js</a>

It will also help you to create a notification timeline and maintenance of notification would be simpler.

I am currently working on a mobile app that lets you ask friends for favourites, it's a HTML5 frontend and a PHP backend. I am stuck as to what the best way is to build a notifications system, more-so the database schema than the actual code itself.

The mobile application flow is as follows:

<ul>
<li>A User asks for a favour</li>
<li>The user can choose to; notify all friends, notify favourite friends or notifdy closeby friends</li>
<li>Depending on what the user chose, people are notified</li>
</ul>

What is the best way to do this in PHP and MySQL? I'm not really asking for anyone to write me the PHP code, but rather map out the most ideal MySQL table and fields schema instead as that is what I am currently stuck on. Thanks in advance for your help.

Best Way To Build A Multi-Notification System in PHP

数据库

MySQL

HTML5

我目前正在开发一款手机应用程序，它可以让你向朋友询问自己最喜欢的东西，它是一个HTML5前端和一个PHP后端。我被困在最好的方法是什么来构建通知系统，更多的是数据库模式而不是实际代码本身。移动应用流程如下：用户请求用户可以选择的；通知所有朋友，通知最喜爱的朋友或通知用户选择的内容，人们会收到通知用PHP和MySQL做这...

问用PHP构建多通知系统的最佳方法
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用PHP构建多通知系统的最佳方法EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问用PHP构建多通知系统的最佳方法
EN