Make a Profile Endpoint for the Frontend Repo

[NtemKenyor]

We will love to get details about a User as to make his/her Profile page dynamic.

GOAL
Give a user id
We should produce more details about the user

output = {
status: successful,
user: [id: 2, username: somebody etc],
modules: 40, 50, 67,
projects: 2, 30, 102, 
msg: Connection completed,
}

the numbers in the modules and projects section represent the module and project ids respectively.

[Riya123-code]

can i work on this issue?

[NtemKenyor]

Hello @Riya123-code

Yes you can work on it. We would be glad to have you...

[Riya123-code]

Thank you , As the site link https://kwickerhub.com/ is not reachable can you please explain me the architecture of this project so it will help me to work on this issue in a much better way .

[NtemKenyor]

pls try http://kwickerhub.com we are fixing our SSL certificate.

…

On Thu, Feb 2, 2023, 09:53 Riya Palyekar ***@***.***> wrote: Thank you , As the site link https://kwickerhub.com/ is not reachable can you please explain me the architecture of this project so it will help me to work on this issue in a much better way . — Reply to this email directly, view it on GitHub <#13 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOKWIBMWKJ4HFVDB4PH4LKTWVNYX3ANCNFSM6AAAAAAQ3A3LVU> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Riya123-code]

Hello Sir,
when I am trying to register from my localhost, I am getting the error as shown below. Can you please help me out with it?

[NtemKenyor]

mailer.php is a script that sends mails to people and It uses PHPmailer and it depends on an external file called knowledge_power.php The later file contains some secrets and keys that are totally ignored by git in order to avoid security challenges. I believe the simplest way to solve the problem is to comment the mailer function or "include mailer.php" during registration/sign-up/sign-in and uncomment it after solving the issue. Hope you are doing great? And by the way, did you clone the Frontend and Backend repository?

…

Message ID: ***@***.***>

[Riya123-code]

Thank you for your reply, sir.
yes ,I have already cloned frontend and backend . Database setup is also done.
But if I comment mailer function I wont be getting email with the verification code that needs to be entered right after sign-up stage.
instead of commenting is there any other way to include knowledge_power.php? i have already installed composer but still couldn't solve this problem. Also I did not find much resources related to knowledge_power.php online.

[Riya123-code]

Hello sir,
above issue has been solved .I am able to display name and projects on profile page from clients and projects database table respectively. Can you please let me know from where can i get the below mentioned details of user as i could not find them in any database table.

user-title
user-description
age
location
status
joined date
user skills
bio
contributions
achievements

above mentioned details are currently hard coded on profile.html page.
waiting for your reply
thank you.

[NtemKenyor]

hello Riya Palyekar *Wow. Nice Job Dear...* Hope you are doing well? Once again, thank you. I think we can both deliberate on stuff here 🤗. I was thinking every other thing would be added in the addon section of the profile table as a JSON struture. Is that ok? or should we create an additional table and call it "profile"? This table would hold the details you mentioned. Please let me know. I will accept your input. Though I prefer the latter 😎

…

On Fri, Mar 24, 2023 at 10:28 AM Riya Palyekar ***@***.***> wrote: Hello sir, above issue has been solved .I am able to display name and projects on profile page from clients and projects database table respectively. Can you please let me know from where can i get the below mentioned details of user as i could not find them in any database table. user-title user-description age location status joined date user skills bio contributions achievements above mentioned details are currently hard coded on profile.html page. waiting for your reply thank you. — Reply to this email directly, view it on GitHub <#13 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOKWIBNMHXKH3NA6QJBEVMTW5VSKDANCNFSM6AAAAAAQ3A3LVU> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Riya123-code]

yes sir even i would prefer creating seperate database table 'Profile' containing only the user details mentioned above.

[NtemKenyor]

Good morning from this corner of the world. I'm supporting your move👍. Create a new table as you have said. Pls do well to inform me after making adjustments so I can update our live servers. Don't forget to add columns for (id[primary key, auto increment], user_id, addon, last_updated and other stuffs as mentioned from your previous email) in the profile table. You can also replace the old SQL database with the new one(that now includes the profile table). I'm always here to help. 😊 On Mar 26, 2023 06:03, "Riya Palyekar" ***@***.***> wrote: yes sir even i would prefer creating seperate database table 'Profile' containing only the user details mentioned above. — Reply to this email directly, view it on GitHub <#13 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AOKWIBKZ2EFSUAIJHOSFPBDW57E3TANCNFSM6AAAAAAQ3A3LVU> . You are receiving this because you authored the thread.Message ID: ***@***.***>

[Riya123-code]

ok sir

[Riya123-code]

hello sir,
can you please confirm on this profile table ? is there anything i need to add or change?