G Gandy5 Member Nov 13, 2019 #1 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.
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 Well-Known Member Licensed User Longtime User Nov 13, 2019 #2 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
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?
G Gandy5 Member Nov 13, 2019 #3 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... Yes Upvote 0
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... Yes
G Gandy5 Member Nov 13, 2019 #4 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
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?
DonManfred Expert Licensed User Longtime User Nov 13, 2019 #5 Gandy5 said: please what is the "Enabled" for? Click to expand... user is enabled or not. It ALL depends on YOUR requirements... Define all the fields you need. Upvote 0
Gandy5 said: please what is the "Enabled" for? Click to expand... user is enabled or not. It ALL depends on YOUR requirements... Define all the fields you need.
G Gandy5 Member Nov 13, 2019 #6 th DonManfred said: user is enabled or not. It ALL depends on YOUR requirements... Define all the fields you need. Click to expand... Thank you..Please can i get a query example for how to retrieve the data from the database whenever the user logs in. Upvote 0
th DonManfred said: user is enabled or not. It ALL depends on YOUR requirements... Define all the fields you need. Click to expand... Thank you..Please can i get a query example for how to retrieve the data from the database whenever the user logs in.
G Gandy5 Member Nov 13, 2019 #7 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 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
DonManfred Expert Licensed User Longtime User Nov 13, 2019 #8 https://www.b4x.com/android/forum/threads/b4x-documentation-booklets.88985/#content Read the booklets. There are SQL Examples included. Upvote 0
https://www.b4x.com/android/forum/threads/b4x-documentation-booklets.88985/#content Read the booklets. There are SQL Examples included.
G Gandy5 Member Nov 13, 2019 #9 DonManfred said: https://www.b4x.com/android/forum/threads/b4x-documentation-booklets.88985/#content Read the booklets. There are SQL Examples included. Click to expand... thank you for the help Upvote 0
DonManfred said: https://www.b4x.com/android/forum/threads/b4x-documentation-booklets.88985/#content Read the booklets. There are SQL Examples included. Click to expand... thank you for the help
MarkusR Well-Known Member Licensed User Longtime User Nov 13, 2019 #10 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
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.
G Gandy5 Member Nov 13, 2019 #11 MarkusR said: 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. Click to expand... Thank you MarkusR Upvote 0
MarkusR said: 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. Click to expand... Thank you MarkusR
