Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>What I would do is setup a simple page that echos Success or Fail, then pass the information to that page from the form using an Ajax call--You can use jQuery to accomplish this goal.</p> <p>Add this to the header in either a javascript file, or a script tag:</p> <pre><code>function submitEmail() { var email = $('#emailText').val(); jQuery.post('/submission.php', { email: email },function(data){ $('#submissionResponse').html(data); },html); } </code></pre> <p>Then alter the form so that the submission button is like so:</p> <pre><code>&lt;input type="button" name="submit" value="Submit" onclick="submitEmail();" /&gt; </code></pre> <p>Then add a div below the form with the id "submissionResponse" like so:</p> <pre><code>&lt;div id="submissionResponse"&gt;&lt;/div&gt; </code></pre> <p>This way you will be able to handle the post just like you do when you change pages, but you will automatically submit the data and grab the response.</p> <hr> <p>ANOTHER EDIT:</p> <p>While I'm at it, I might as well give another way to do similar. You could, instead of using Ajax, do exactly what you do now, but direct the form to reload the current page (<code>action="&lt;?php echo $_SERVER['PHP_SELF']; ?&gt;"</code>) and then at the top of this page add</p> <pre><code>if(isset($_POST['email'])){ include('submission.php'); } </code></pre> <p>and underneath the form have:</p> <pre><code>&lt;div id="formStatus"&gt;&lt;?php echo isset($formStatusResponse) ? $formStatusResponse : null; ?&gt;&lt;/div&gt; </code></pre> <p>Two ways to accomplish the same goal. Using Ajax is faster, as it only requires the end user to load a single line of text, where as the second method requires the complete reloading of the entire page.</p>
    singulars
    1. This table or related slice is empty.
    1. POHelp me with a simple newsletter subscription form?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USTravis Weston
    1. USTravis Weston
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHelp me with a simple newsletter subscription form?
      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. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COYou could use jQuery, but it isn't really necessary, nor is it significantly shorter than native code. But that's just my opinion.
      singulars
      1. PO
      1. USDelan Azabani
    2. COjQuery is used to allow for cross browser compatibility. The use of a framework is never required, but it does make coding easier. jQuery allows you to not have to worry about compatibility, nor do you have to worry about remembering all of the nasty little details, it's all bundled into one easy to use function.
      singulars
      1. PO
      1. USTravis Weston
    3. COI'll update my original post.
      singulars
      1. PO
      1. USTravis Weston
 

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