Android Question MULTIPLE ACCOUNT

G

Gandy5

Member
I am creating a church app that allows a user to register an account and login into the account. In the dashboard the logged in user is supposed to register himself as a member then save the record in the database.
How do i design my database and query the database so that the user after every return to his account will have his records displayed. at the same time have a record of all members registered.

Thanks for your help in advance.
 
Sort by date Sort by votes

MarkusR

Well-Known Member
Licensed User
Longtime User
for user table
UserId
Name
PasswordHash
Mail
Address
Phone
DateCreated
DateModified
Enabled

id fields are typically auto increment.

other tables with his records can have a reference to UserId as filter

u are using a remote database?
 
Upvote 0
G

Gandy5

Member
MarkusR said:
for user table
UserId
Name
PasswordHash
Mail
Address
Phone
DateCreated
DateModified
Enabled

id fields are typically auto increment.

other tables with his records can have a reference to UserId as filter

u are using a remote database?
Click to expand...
please what is the "Enabled" for?
 
Upvote 0
G

Gandy5

Member
MarkusR said:
for user table
UserId
Name
PasswordHash
Mail
Address
Phone
DateCreated
DateModified
Enabled

id fields are typically auto increment.

other tables with his records can have a reference to UserId as filter

u are using a remote database?
Click to expand...
thank you
 
Upvote 0

MarkusR

Well-Known Member
Licensed User
Longtime User
Gandy5 said:
Thank you..Please can i get a query example for how to retrieve the data from the database whenever the user logs in.
Click to expand...

the basic query is
SELECT fieldname1,fieldname2 or * for all
FROM tablename
WHERE condition as example UserId=?
ORDER BY fieldname

the ? will be replaced by a argument which you gave the Query Method separate.
 
Upvote 0
You must log in or register to reply here.

Similar Threads

  • Article
Android Example [B4XPage Video] Full tutorial on building Membership Registration App
Replies
16
Views
3K
Theera
S
  • Question
Android Question Re: To develop one Invoice project
Replies
3
Views
1K
sivakrith
S
  • Question
Android Question How do I load multiple customlistviews on to may main activity?
Replies
6
Views
1K
MrKim
P
  • Question
Android Question choosing which database to useDatabase
Replies
12
Views
1K
KMatle
  • Locked
  • Question
Android Question Multiple CheckBox in CustomListView
Replies
9
Views
3K
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…