Next.js Applied Jobs Page (Real Project) | Fetch User Applications with MySQL + Drizzle

📂 Source Code
👉 GitHub Repo: https://github.com/thapatechnical/job-portal-nextjs

----------------------------------------------------------------------------------
In this video we build the Applied Jobs page for our Next.js Job Portal project. Applicants can now see all jobs they have already applied for in their dashboard.

Now when an applicant logs in and clicks on the Applied Jobs menu in their dashboard, they will see all the jobs they have already applied to — displayed as clean job cards.

In this video we will:

• Understand the logic behind fetching applied jobs
• Ensure the user is authenticated before fetching data
• Query the database using Drizzle ORM joins
• Match userId with applicantId
• Retrieve data from jobApplications, jobs, and employers tables
• Render the applied jobs dynamically in the UI

This brings our Next.js Job Portal project very close to completion.

Perfect for developers learning:

Next.js Full Stack Development
Drizzle ORM
MySQL Database
Real World Project Architecture
------------------------------------------------------------------------------------
🔗 Useful Playlists

📘 Next.js Full Stack Playlist:
https://youtube.com/playlist?list=PLwGdqUZWnOp0lwvSBaIzzgV9X0ZiZ-42O&si=aQ_TNBNNx5L7V_bn

⚛️ React.js Playlist:
https://youtube.com/playlist?list=PLwGdqUZWnOp1Rab71vx2zMF6qpwGDB2Z1&si=sDZRxsYNetYmojKd

💻 TypeScript Playlist:
https://youtube.com/playlist?list=PLwGdqUZWnOp0xfHQFmlL52b_6-QZ0mnk_&si=c4jfsd5ElDC1p0A5
------------------------------------------------------------------------------------
💸 Get All My YouTube Videos' Source Code for just ₹199! Grab Now - https://thapatechnical.shop/source-code

📺 Watch the complete Node.JS Playlist here :https://youtube.com/playlist?list=PLwGdqUZWnOp3KELplHtc-RnJ5xTUPqdgH&si=_ob8F88HYxCdspup

🔥 Access Source Code, PPT & Notes here for Free : https://www.thapatechnical.com/2024/11/introduction-to-nodejs.html
------------------------------------------------------------------------

🚀 Boost Your Skills with these Pre-Requisite Videos:

🔗 Best HTML Course - https://youtu.be/5ccq_nLHneE
🔗 Best CSS Course - https://youtu.be/MSICFljRcb4
🔗 JavaScript Basics Course Part 1 - https://youtu.be/13gLB6hDHR8
🔗 JavaScript Advanced Course Part 2 - https://youtu.be/YwsOCN8woA8

------------------------------------------------------------------------
💸 Build Your Own E-commerce Website for Free! - https://www.thapatechnical.com/2024/03/build-complete-ecommerce-website-using.html

------------------------------------------------------------------------
✌️ Join Us!

🚀 Become a Member: Unlock perks, free source code, and more Join Now : https://www.youtube.com/channel/UCwfaAHy4zQUb2APNOGXUCCA/join
📷 Connect on Instagram: https://www.instagram.com/thapatechnical
🗨️ Join Our Discord Server: Hang out with fellow programmers Discord Link: https://discord.gg/MdScmCsua6

------------------------------------------------------------------------

⌛TIMELINE⏳
0:00 Introduction to Applied Jobs Page
0:16 Preview of the Applied Jobs Dashboard UI
1:20 Support the Channel
1:40 Project Folder Structure
2:35 Understanding the Query Logic
5:10 Ensuring the User is Logged In
5:30 Fetching Applicant Applied Job Details
9:50 Rendering Database Data in the UI
11:55 What's Coming in the Next Video