如何回显包含用户ID的数据库中的行？

Question

So I have a database called invoices and I have the user id in there and the date, I would like the user to be able to see all his invoices but not the others. So like my database is setup like

id | userid | amount | date | status

and I want the user to see his own invoices, how would I do that?

Answer 1

That can be done with the query:

SELECT * FROM invoices WHERE userid = [the userid of the user];

You can also select specific columns of those rows like:

SELECT amount FROM invoices WHERE userid = [the userid of the user];

If you want more help, you'll have to explain what specifically you need help with!

Hope this helps!

Helpful Source - SQLCOURSE

Edit

Oh I see what you mean!

When you create a user (using the INSERT command), you can use RETURNING to ask for information from the rows you just created/populated:

INSERT INTO invoices (userid, amount, date, status) VALUES ([some userid], [some amount], [some date], [some status]) RETURNING id;

This is assuming id is populated by a serial input. You can also ask for any or all of the other rows you just populated. For example:

INSERT INTO invoices (id, userid, amount, date, status) VALUES ([some id], [some userid], [some amount], [some date], [some status]) RETURNING *;