Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You might find it easier to just add a check function on the server to check for a valid session. Even if the cookie is there, it doesn't mean they haven't logged out and the session cookie is sent back and forth with every request.</p> <p>That said, if you want to access the cookies from the client, they are attached to the document as a single string value. You can access them at document.cookies. I would look at the documentation and source of the ExtJS cookies utility for some inspiration about how to go about finding your cookie in that string.</p> <p><a href="http://docs.sencha.com/extjs/4.1.3/#!/api/Ext.util.Cookies" rel="nofollow">Ext.util.Cookies Documentation</a></p> <p><a href="http://docs.sencha.com/extjs/4.1.3/source/Cookies.html#Ext-util-Cookies" rel="nofollow">Ext.util.Cookies Source</a></p> <p>Essentially the process is to go through each letter in the cookie string, take a substring out to the length of the session key's name, see if it matches, then pull the data between the next equals sign and semicolon. Then you un-percent-encode the value and you're good to go.</p> <p><strong>Edit</strong> To ping the server, you just make an Ajax request somewhere along the application loading process before the first view is shown. The launch function is a pretty natural place I think:</p> <pre><code>Ext.application({ name: 'App', requires: [], models: [], stores: [], views: [], controllers: [], .... launch: function () { //Check with the server Ext.Ajax.request({ //Proxy Settings url: 'path/to/check/script.php', //Callbacks success: function (response, opts) { // process server response here response = Ext.JSON.decode(response.responseText); if(response &amp;&amp; response.success === true) { //Load the normal first view Ext.Viewport.add(Ext.create('App.view.Main'); } else { //Load the login view Ext.Viewport.add(Ext.create('App.view.LoginForm'); } }, failure: function (response, opts) { //Notify of network failure } }); } }); </code></pre> <p>As far as what to do in the script on the server side, it is dependent on what language you are developing in and what you are authenticating against. If it's just a database of usernames and passwords then when the user first logs in, start a session, and store a session variable for their userID and password. In the check function, make sure they are still valid by first checking if a current session exists, and then re-authenticating against your database (in case you or someone else canceled their account while the session was still valid). Then just send back a json response that says whether or not they are logged in, and includes any relevant user information needed to make your app work.</p>
    singulars
    1. This table or related slice is empty.
    1. POSencha Touch 2: Checking cookie on app launch
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USStephen Tremaine
    1. USStephen Tremaine
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COThanks for the advice! So are you saying upon App launch, I should ping the server to make sure the user is logged in as well as check for cookies?
      singulars
      1. PO
      1. USdennismonsewicz
    2. COYes, pinging the server is what I always do and would recommend. If you're using sessions like it sounds like you are, checking if they are logged in on the server does use cookies (they're sent back and forth in the http requests each time). The server pulls the session id from the cookie in the http request, checks if it's still tracking that id, and whether or not it's expired. I'm sure that's somewhat language/environment dependent but I'm pretty sure that's the general idea behind user tracking in most web development stacks.
      singulars
      1. PO
      1. USStephen Tremaine
    3. COAwesome! Thanks so much! Anyway you can provide an example of pinging the server on app launch?
      singulars
      1. PO
      1. USdennismonsewicz
 

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