Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>Here's my full code. I pretty much rewrote the whole thing, so I appologize if the coding style differs too much:</p> <pre><code>&lt;?php // Output our CSS code echo '&lt;style type="text/css" media="screen"&gt; .error { color: red; } &lt;/style&gt;'; // Define our variable $problem = false; // Check if the form has been submitted if (isset($_POST['submitted'])) { // If either user or password are empty, we have a problem if (empty($_POST['username']) || empty($_POST['password'])) { $problem = TRUE; } // If there is no problem, username is user, and password is abc123, we're good if (!$problem &amp;&amp; $_POST['username']=='user' &amp;&amp; $_POST['password']=='abc123') { // Print our login message echo 'Thank you for logging in!&lt;br /&gt;'; } // Ok, there's either a problem or the username or password is wrong, so no entry for them else { echo '&lt;p class="error"&gt;No entry!&lt;/p&gt;'; } } ?&gt; &lt;form action="login.php" method="post"&gt; Username: &lt;input type="text" name="username" size="20" value="&lt;?php if (isset($_POST['submitted']) &amp;&amp; !empty($_POST['username'])) { echo $_POST['username']; } ?&gt;" /&gt; &lt;?php if (isset($_POST['submitted']) &amp;&amp; empty($_POST['username'])) { echo '&lt;span class="error"&gt;Please enter a username!&lt;/span&gt;'; } ?&gt; &lt;br /&gt;Password: &lt;input type="password" name="password" size="20" value="&lt;?php if (isset($_POST['submitted']) &amp;&amp; !empty($_POST['password'])) { echo $_POST['password']; } ?&gt;" /&gt; &lt;?php if (isset($_POST['submitted']) &amp;&amp; empty($_POST['password'])) { echo '&lt;span class="error"&gt;Please enter the password!&lt;/span&gt;'; } ?&gt; &lt;br /&gt;&lt;input type="submit" value="Log in" /&gt; &lt;br /&gt;&lt;input type="hidden" name="submitted" value="true" /&gt; &lt;/form&gt; </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POphp log in form with messages and date and time
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USJohn
    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. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COthank you for your code as well... I really am trying to learn (imagine that!) so it is super helpful to see different codes!
      singulars
      1. PO
      1. USChris
    2. COOk, not to be a pest, but I just have 2 questions. After looking at your code (and running it a couple of times) I was wondering if there is anyway that the input fields can go away after you submit? (That seems like it will be important in the future on other forms I build). My other question would be if the input fields do disappear, is there a way to have the 'enter a password/username' appear alone without the 'no entry' message appear on top? I know that doing those 2 extra elements would require the if loops to change, i'm just not sure which loops to change. Anyone have any suggestions?
      singulars
      1. PO
      1. USChris
    3. COLate-ish reply: Make the input fields check if `$_POST['submitted]` is set (if it has been submitted before, it will be). Instead of outputting the form as HTML, have PHP echo it ONLY if it is NOT true (meaning it has not yet been submitted).
      singulars
      1. PO
      1. USJohn
 

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