Android Question MULTIPLE ACCOUNT

[Gandy5]

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.

 

[MarkusR]

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?

 

[Gandy5]

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?

Yes

 

[Gandy5]

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?

please what is the "Enabled" for?

 

[DonManfred]

please what is the "Enabled" for?

user is enabled or not.

It ALL depends on YOUR requirements... Define all the fields you need.

 

[Gandy5]

th

user is enabled or not.

It ALL depends on YOUR requirements... Define all the fields you need.

Thank you..Please can i get a query example for how to retrieve the data from the database whenever the user logs in.

 

[Gandy5]

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?

thank you

 

[DonManfred]

https://www.b4x.com/android/forum/threads/b4x-documentation-booklets.88985/#content
Read the booklets. There are SQL Examples included.

 

[Gandy5]

https://www.b4x.com/android/forum/threads/b4x-documentation-booklets.88985/#content
Read the booklets. There are SQL Examples included.

thank you for the help

 

[MarkusR]

Thank you..Please can i get a query example for how to retrieve the data from the database whenever the user logs in.

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.

 

[Gandy5]

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.

Thank you MarkusR