how i restrict a user that have already entered a data into?

Question

i create a signup page after sign up user go to a page that is complete your profile. when user complete the profile data will be stored in data base. i want that if user completed the profile than they cannot again entered data into a page. if user again try to enter the data page will not allowed to that user to again enter data and show message to user you have already completed your profile. how i restrict the user? any one tell me how?

Vinay Singh · Answer

Hi Simply you can do one thing. In profile page just check whether logined user detail there in User profile table or not. if he is having record on that case just disable the submit button . ---------Or---------------- After loading all the records in profile page. When user click on submit button on that case just check weather user have record in profile table or not. if it's having then skip the code or function which save profile data.

Bilawal Niaz · Answer

i resolve my problem. Another is: What is the querry of percentage in database? If I have a table in database I want that querry who show me % that how many percent record of data in a table? If i have a table CitizenDetail in this table i have a 450 records what is the querry to find percentage of 450 recordsI want that querrywho show me %That how many percent record of data in a table?

Karthik Elumalai · Answer

Hi Bilawal Niaz this is fully my idea hope it will give some direction for you. You can just add one more column in database table column(name = status)  so once user completed the profile in the save button click event you can add a value to that column as completed or done something like this. so next time when the same user try to enter datayou can easily restrict them based on the value in this database column value. kindly let me know your suggestion Thanks karthik