Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>It seems that you don't have a clear vision of sessions and cookies!</p> <p>No body can change the session contents except your code (beside attacks). So you can store everything (reasonable) like <code>user id</code> or <code>username</code> that you need to access frequently. in cookies you must store some obfuscated information that you can recognize user later when he/she tries to access your page. so based on cookie content you can regenerate users session (ie. re-login user automatically). Just to note that user CAN change cookies content so it must not be something simple like <code>user id</code> for security reason.</p> <p>I just give you a simple example, it's far from perfect but not so bad! you may need to tailor it to fit your scenario: </p> <p>here you can create cookie content like this:</p> <pre><code>$salt = substr (md5($password), 0, 2); $cookie = base64_encode ("$username:" . md5 ($password, $salt)); setcookie ('my-secret-cookie', $cookie); // and later to re-login user you do: $cookie = $_COOKIE['my-secret-cookie']; $content = base64_decode ($cookie); list($username, $hashed_password) = explode (':', $hash); // here you need to fetch real password from database based on username. ($password) if (md5($password, substr(md5($password), 0, 2)) == $hashed_password) { // you can consider use as logged in // do whatever you want :) } </code></pre> <p>UPDATE: </p> <p>I wrote <a href="http://boynux.com/consumers-system-trusted-database/" rel="nofollow">this article</a> that covers this concept. Hope it helps.</p>
    singulars
    1. This table or related slice is empty.
    1. POPHP login session and cookie
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMartin
    1. USBoynux
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POPHP login session and cookie
      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. VTAcceptedByOriginator
    1. COThanks for the clarification ; can you give a best practice for the use of cookies to re-login a user? I can't figure out how I would proceed...
      singulars
      1. PO
      1. USAdam Strudwick
    2. COcheck update! the code is written on the fly! so if you see typo or bugs I'm sorry for that try to fix it or tell me the problem
      singulars
      1. PO
      1. USBoynux
    3. COThanks, it seems a good approach. What do you think of this: http://fishbowl.pastiche.org/2004/01/19/persistent_login_cookie_best_practice/ ? Seems excellent to me. But is it obsolete?
      singulars
      1. PO
      1. USAdam Strudwick
 

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