How can i get approval of admin

Step 1: First user will upload a document and insert record one in your table. In that table make a column status as column and update the value as "Pending".

Create table(UserID int, Status tinyint, Comments varchar(200));

Step 2: Then send an e-mail to Admin, records are waiting for your approval. If you don't have e-mail functionality, no problem. Display all records to Admin which are in pending mode status (Step1).

Step 3: Admin will login and approve records which will make change record's status in table as approved. Once it is approved it go live or you can implement your own logic. Next time when Admin will login it will show only pending records.

Hope this suggestion will help you.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

11y ago
thank u
Sanjay Sabariya11y ago
nice explanation manas.
Susanta Rout11y ago
follow manas mohapatra's step you will get answer
Manas Mohapatra11y ago
Step 1: First user will upload a document and insert record one in your table. In that table make a column status as column and update the value as "Pending".

Create table(UserID int, Status tinyint, Comments varchar(200));

Step 2: Then send an e-mail to Admin, records are waiting for your approval. If you don't have e-mail functionality, no problem. Display all records to Admin which are in pending mode status (Step1).

Step 3: Admin will login and approve records which will make change record's status in table as approved. Once it is approved it go live or you can implement your own logic. Next time when Admin will login it will show only pending records.

Hope this suggestion will help you.