Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p><strong>Note</strong>: this answer is for Express 2. See <a href="https://stackoverflow.com/a/12008719/21115">here</a> for Express 3.</p> <p>If you're using connect/express, you should use the <a href="https://github.com/senchalabs/connect/blob/master/lib/middleware/bodyParser.js" rel="nofollow noreferrer">bodyParser middleware</a>: It's described in the <a href="http://expressjs.com/guide.html" rel="nofollow noreferrer">Expressjs guide</a>.</p> <pre><code>// example using express.js: var express = require('express') , app = express.createServer(); app.use(express.bodyParser()); app.post('/', function(req, res){ var email = req.param('email', null); // second parameter is default }); </code></pre> <p>Here's the original connect-only version:</p> <pre><code>// example using just connect var connect = require('connect'); var url = require('url'); var qs = require('qs'); var server = connect( connect.bodyParser(), connect.router(function(app) { app.post('/userlogin', function(req, res) { // the bodyParser puts the parsed request in req.body. var parsedUrl = qs.parse(url.parse(req.url).query); var email = parsedUrl.email || req.body.email;; }); }) ); </code></pre> <p>Both the querystring and body are parsed using <a href="https://github.com/visionmedia/node-querystring" rel="nofollow noreferrer">Rails-style parameter handling (<code>qs</code>)</a> rather than the <a href="http://nodejs.org/docs/v0.4.6/api/querystring.html" rel="nofollow noreferrer">low-level <code>querystring</code> library</a>. In order to parse repeated parameters with <code>qs</code>, the parameter needs to have brackets: <code>name[]=val1&amp;name[]=val2</code>. It also supports nested maps. In addition to parsing HTML form submissions, the bodyParser can parse JSON requests automatically.</p> <p><strong>Edit</strong>: I read up on express.js and modified my answer to be more natural to users of Express.</p>
    singulars
    1. This table or related slice is empty.
    1. POHow to retrieve POST query parameters?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USCommunity
    1. USyonran
    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
    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. VTUpMod
    1. COHmm ok. i try the bodyParser(). the doc says i can get it from req.query() but i got nothing. that's very weird. I have no problem with Get tho.
      singulars
      1. PO
      1. USmurvinlai
    2. CONo, req.query is ONLY the GET params. You get the POST data through req.body. The function req.params() includes them both.
      singulars
      1. PO
      1. USyonran
    3. COA stray click downvoted this answer accidentally without me noticing! Now StackOverflow won't let me change it. Esp. frustrating as this was helpful...I upvoted another of your good answers that I wasn't explicitly looking for to make up for it. :)
      singulars
      1. PO
      1. USHostileFork
 

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