Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I'm not sure you actually have a question... But it seems like you probably just need some help on how to tell which pop up to display.</p> <p>in your:</p> <pre><code>$(".popup").live("click",function(){}) </code></pre> <p>you can use the special "this" variable to determine which of your day's was clicked.</p> <p>eg. </p> <pre><code>$(".popup").live("click",function(){ console.log('you clicked', this); //to get the date id (your formatdate) from this var dateClicked = $(this).parent().parent().attr('id'); //have to do parent() twice because you put your .popup under &lt;div class='title'&gt; }) </code></pre> <p>To make it easier.. you should consider changing your click event to use .date_has_event instead of .popup so you could do this instead:</p> <pre><code>$(".date_has_event").live("click",function(){ var dateClicked = $(this).attr('id'); }) </code></pre> <p>once you know you which day was clicked, you probably want to render that day's popup's content (the list of events for that day) in your popup window.</p> <p>That's where you should use an ajax request sent to some backend code which is basically the php code you already have shoved behind your (that stuff under your #popupContact). You should move that code out somewhere.. in say a "getEvents.php"</p> <p>eg.</p> <pre><code>$(".date_has_event").live("click",function(){ var dateClicked = $(this).attr('id'); $.ajax({ type: "GET", url: "getEvents.php", dataType: "json", data: "date="+dateClicked, success: function(data){ //fill your popup with the data received } }) }) </code></pre> <p>I think that should be enough to get you on your way. Good luck.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to tell which JQUERY popup to display
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USone sad monkey
    1. USone sad monkey
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to tell which JQUERY popup to display
      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. VTAcceptedByOriginator
    1. COthanks monkey think this will be a big help, just one question. How do i translate results into JSON and then translate the JSON array back into HTML to insert into a DIV??
      singulars
      1. PO
      1. USrudawg
    2. COyou don't have to use "json" for your ajax requests. It can return straight HTML (which should be easier for you). just change the $.ajax() request's dataType to "html" and then in your success function(data), 'data' will just be your straight HTML code.. so you can just do $('#popup').html(data) otherwise.. you have to go through the json object and convert those to html. So your success function would have something like: for( var i in data){ html += '<li>Event:'+data[i]+'</li>' }
      singulars
      1. PO
      1. USone sad monkey
 

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