Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I've found that, for when I've forgotten something, <a href="http://www.tizag.com/" rel="nofollow noreferrer">Tizag.com</a> to be pretty useful, a simple tutorial -though it is simple, so I don't know how useful it might be to you- is here, at: <a href="http://www.tizag.com/phpT/examples/formex.php" rel="nofollow noreferrer"><a href="http://www.tizag.com/phpT/examples/formex.php" rel="nofollow noreferrer">http://www.tizag.com/phpT/examples/formex.php</a></a>, which provides a walk-through with some explanation of the choices made.</p> <p>Javascript libraries,</p> <ol> <li><a href="http://www.jquery.com/" rel="nofollow noreferrer">jQuery</a>.</li> <li><a href="http://mootools.net/" rel="nofollow noreferrer">mootools</a>.</li> <li><a href="http://www.bbc.co.uk/glow/" rel="nofollow noreferrer">Glow</a> (from the BBC, open source and very backwards-compatible).</li> </ol> <p><hr /> <strong>Edited in response to comment</strong></p> <p>More reliable php references to help you get started:</p> <ol> <li><a href="http://www.php.net/manual/en/getting-started.php" rel="nofollow noreferrer">Getting started</a> (<a href="http://www.php.net/" rel="nofollow noreferrer">php.net</a>)</li> <li><a href="http://www.php.net/manual/en/tutorial.forms.php" rel="nofollow noreferrer">forms tutorial</a> (as above, at <a href="http://www.php.net/" rel="nofollow noreferrer">php.net</a>)</li> </ol> <p>The problem I'm finding with php/forms tutorials (outside of books) is that there's some crazy mis-use of -to my mind, ymmv, etc...- xhtml tags inside of forms, completely disregarding the concept of -mentioned elsewhere- <a href="http://en.wikipedia.org/wiki/Semantic_HTML" rel="nofollow noreferrer">semantic (x)html</a>. I think that when reading the tutorials the key is to maintain a critical mind and try to be alert to the ab-, or mis-, uses:</p> <pre><code>&lt;form action="this_page.php" method="post" enctype="form/multipart"&gt; &lt;p&gt;This is a label &lt;input value="this is the input" /&gt;&lt;/p&gt; &lt;p&gt;&lt;input type="submit" value="submit" /&gt;&lt;/p&gt; &lt;/form&gt; </code></pre> <p>may be <em>valid</em>, but to my mind it's hideously wrong<sup>1</sup>. I'm amazed that there aren't more easily available and up-to-date resources.</p> <p><hr /> <strong>1:</strong> To my mind it should be something closer to:</p> <pre><code>&lt;form action="this_page.php" method="post" enctype="form/multipart"&gt; &lt;fieldset&gt; // to associate relevant groups of label/input pairs &lt;label&gt;This is a label&lt;/label&gt; &lt;input value="this is the input" /&gt; &lt;/fieldset&gt; &lt;fieldset&gt; &lt;input type="submit" value="submit" /&gt; &lt;/fieldset&gt; &lt;/form&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POTables were deprecated? And JavaScript has libraries? Help me catch up!
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDavid Thomas
    1. USDavid Thomas
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POTables were deprecated? And JavaScript has libraries? Help me catch up!
      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. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COUnfortunately this makes the same mistakes as every other awful beginners' PHP tutorial I've met. Unreadable lack of indentation or differentation between HTML and PHP, HTML laboriously stitched together and echoed instead of using the language's own templating facilities, cross-site-scripting holes caused by lack of htmlspecialchars... I'd love to see a PHP tutorial that doesn't encourage bad practice from the word go.
      singulars
      1. PO
      1. USbobince
    2. COYou have a valid point; I hadn't realised it was that bad when I recommended it. I'm disturbed by my -apparent- blindness to hideous practice. And -see updated answer- it seems even php.net's manual isn't immune. *weird*
      singulars
      1. PO
      1. USDavid Thomas
    3. COThe edited answer that distinguishes between the first, correct example and the second, good example is exactly what I'm looking for. Thanks!
      singulars
      1. PO
      1. USWang
 

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