We have 3 requirements in this job:
1- Add a column Named (USERCODE) in the users table in the database which contains the sum of 1999+ID and to add the letter R at the left ( example : userID = 1 ---> usercode = R2000 , userID = 2 ---> usercode = R2001, ... etc) and to be located next to the userid column.
2- Change the "username" column to be "Referral_Id" , So the users have to enter a valid referral id when registering to the website ( referral id = existing usercode ) and to be required field.
Notice: the referral id shown in the table should be the value of the userID not the value of the usercode
3- Add new columns to the users table and to the registration form (when required)
*first name
*last name
*gender (as shown in the attached photo)
*date of birth (as shown in the attached photo)
*country (as shown in the attached photo)
*mobile number (as shown in the attached photo)
*registered at (auto time&date stamp)
*activated at (auto time&date stamp)
NOTE THAT we need a documentation of all the changes made and which files affected by that changes.
Hello Sir!
I am php and sql expert. I can modify your login and registration page as per your requirement and I can also write documentation of changes.
Please initiate PMB (Message Board) and discuss further.
Thanks.
$50 USD dalam 2 hari
4,9 (54 ulasan)
5,0
5,0
7 freelancer menawar dengan rata-rata $39 USD untuk pekerjaan ini
hi
I read your requirements. I can work on this.
I have good hands on experience with php, MySQL, jQuery, ajax.
I assure you the quality work and top performance.
Thanks and regards
pratik