Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I presume you want a means of alerting user A, when user B 'friends' him/her without requiring a page refresh?</p> <p>This requires "AJAX". AJAX stands for Asynchronous Javascript and XML, but this is an overloaded term now-a-days with the actual exchange data structure often using JSON instead of XML. JSON is JavaScript Object Notation. Anyway, the idea is that your webpage--without being refreshed--can make periodic calls to your server to get new or updated information to update the display with. With PHP and jQuery, you'll want to first set up the AJAX call on your page like this:</p> <pre><code>$(function() { // on document ready function updateAlerts() { $.ajax({ url : "/check.php", type : "POST", data : { method : 'checkAlerts' }, success : function(data, textStatus, XMLHttpRequest) { var response = $.parseJSON(data); // Update the DOM to show the new alerts! if (response.friendRequests &gt; 0) { // update the number in the DOM and make sure it is visible... $('#unreadFriendRequestsNum').show().text(response.friendRequests); } else { // Hide the number, since there are no pending friend requests $('#unreadFriendRequestsNum').hide(); } // Do something similar for unreadMessages, if required... } }); setTimeout('updateAlerts()', 15000); // Every 15 seconds. } }); </code></pre> <p>This will, every 15 seconds, make a request to your server at the url /check.php on the same domain as the origin of the webpage. The PHP should query your database and and return the number of unread friend requests. Perhaps something like this:</p> <pre><code>&lt;?php function isValid(session) { // given the user's session object, ensure it is valid // and that there's no funny business // TO BE IMPLEMENTED } function sanitize(input) { // return CLEAN input // TO BE IMPLEMENTED } // Be sure to check that your user's session is valid before proceeding, // we don't want people checking other people's friend requests! if (!isValid(session)) { exit; } $method = sanitize($_POST['method']); switch ($method) { case 'checkAlerts' : // Check DB for number of unread friend requests and or unread messages // TO BE IMPLEMENTED $response = ['friendRequests' =&gt; $num_friend_requests, 'messages' =&gt; $num_unread_messages ]; return json_encode( $response ); exit; case 'someOtherMethodIfRequired' : // ... exit; } ?&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POHow to develop alert system like facebook using PHP and Jquery?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USmkoistinen
    1. USmkoistinen
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to develop alert system like facebook using PHP and Jquery?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COI dont understand can you explain little more?
      singulars
      1. PO
      1. USAlex Mathew
    2. COHow is that? =)
      singulars
      1. PO
      1. USmkoistinen
    3. COthks.....this really helps...
      singulars
      1. PO
      1. USAlex Mathew
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload