Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>According to your structure, this should make your friendly hashes:</p> <pre><code>var pathname = $(this).find('a')[0].href.split('/'), l = pathname.length; pathname = pathname[l-1] || pathname[l-2]; window.location.hash = "#!" + pathname; </code></pre> <p><a href="http://jsfiddle.net/e7E73/1/" rel="nofollow"><strong>Demo</strong></a> <hr> Now to make the URLs shareable, you will need to execute a hash check on DOM ready and load the corresponding content.</p> <p>If all the pages are in the same directory, you can do it directly:</p> <pre><code> $(function() { var hash = window.location.hash; //checks if hash exists and is hash bang if (hash &amp;&amp; hash.substring(0, 2) === '#!') { hash = hash.substring(2); //removes leading #! $('#content').load('path/to/' + hash); } }); </code></pre> <p><a href="http://jsfiddle.net/e7E73/3/show/#!test5" rel="nofollow"><strong>Demo</strong></a></p> <p>If the pages aren't all in the same directory, you'll need to map the hashes to the addresses.</p> <pre><code>$(function() { var hashmap = { 'test5': 'http://foobar.baz/fooz/test5', 'anotherTest': 'http://foobar.baz/barz/anotherTest', }; var hash = window.location.hash; //checks if hash exists and is hash bang if (hash &amp;&amp; hash.substring(0, 2) === '#!') { hash = hash.substring(2); //removes leading #! if (hashmap[hash]) { //checks if hash exist in the hash map $('#content').load(hashmap[hash]); } } }); </code></pre> <p><a href="http://jsfiddle.net/e7E73/8/show/#!test5" rel="nofollow"><strong>Demo</strong></a></p> <p>I'm using alerts in the demos above as the loading will fail. Of course you have to adapt/replace the <code>$('#content').load</code> by your preferred load method.</p>
    singulars
    1. This table or related slice is empty.
    1. POwindow.location.hash is undefined for ajax loaded content
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USFabrício Matté
    1. USFabrício Matté
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POwindow.location.hash is undefined for ajax loaded content
      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. COWoaw, I was only waiting for the first part of your answer... Thank you very much! I'm trying the shareable part but I'm not sure I'm adding it the right way. Here is what the console returns when I refresh a page `Uncaught Error: Syntax error, unrecognized expression: #TagSelectah a[href=#!test4]`. I suspect a conflict with a plugin I'm using (filterable.pack.js) since filterable already adds a hash when I select an element in the "#TagSelectah" list. I'll dig around it...
      singulars
      1. PO
      1. USwyem
    2. COI tried to remove the filterable plugin and it still isn't working, but I think it because the container is loaded only on click event. I think the solution is to make it open if a hash is detected on the address bar when the page is loading... What do you think about it? Could you help me writing this? Here is a jsfiddle so you know what I'm really dealing with. http://jsfiddle.net/RF6df/19/
      singulars
      1. PO
      1. USwyem
    3. COMake an empty container so it is always there. Not too sure what you're trying to achieve though.
      singulars
      1. PO
      1. USFabrício Matté
 

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