Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Security through obscurity?</p> <p>Technically, any device could still access the application, although it would take a 'while' to do it, especially if you force a sleep (Guessing a simple combination of 10 digits would have a maximum guess time of 300+ years at a sleep of 1 second, so it's pretty unlikely someone could guess it correctly). For example:</p> <pre><code>sleep(1); // Deter brute force if ($_GET['auth'] == 'sdfjksahdkfjshadkjrfhwaoieua3487a3wt897dywydd39d87haw387d8a3hd7a8hd387wahd089afh980a3yfh983ahf398ahsdaf') { //run app } else { //throw 404 } </code></pre> <p>Save the link to the app on the devices you want to access it like so:</p> <pre><code>http://www.applocation.com/app.php?auth=sdfjksahdkfjshadkjrfhwaoieua3487a3wt897dywydd39d87haw387d8a3hd7a8hd387wahd089afh980a3yfh983ahf398ahsdaf </code></pre> <p>Lose your phone/tablet/whatever device you have a link to the app on, and security is immediately compromised, but considering you don't want to go down the password route, that would be the case anyway.</p> <p>This will cover the majority of your security needs. It's not secure, so if accessed it via a dodgey public network which people were snooping on, it's security is compromised. However it depends how secure you need it to be. If you're storing bank details/passwords on a webpage (which is a terrible idea anyway), I personally wouldn't even consider this option; 'just in case'. Although if it's fairly minor stuff that doesn't matter that much, it's absolutely fine. The main idea behind this is just to stop people from accidentally accessing things you don't want them to see.</p> <p>Besides, if you think that maybe someone has found it out, you can just update the auth string to something different anyway.</p>
    singulars
    1. This table or related slice is empty.
    1. POIs it possible to restrict PHP page to certain devices?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USMLeFevre
    1. USMLeFevre
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POIs it possible to restrict PHP page to certain devices?
      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. COThis is perfect for my needs, thanks! - Would this also deter GoogleBot etc?
      singulars
      1. PO
      1. USMike Thrussell
    2. COAs long as you never link to it, Googlebot would never find it. I'll add some extra clarification regarding its security
      singulars
      1. PO
      1. USMLeFevre
    3. COyou can add a robots.txt file to the web root to deter google indexing, google robots.txt and you should be able to find a tutorial on what to put in there to deter search indexing.
      singulars
      1. PO
      1. USPatrick Evans
 

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