
Open
Posted
•
Ends in 6 days
Paid on delivery
My app already handles sign-in with username and password and stores everything in a relational database (MySQL/PostgreSQL). I have three tables: • users • doctors What I need now is the logic that, immediately after a successful login, returns only the doctors connected to that specific user. The same rule must apply to every page, API endpoint, or query that surfaces doctor data, so a user never sees records that aren’t theirs. 1. Adjust the current queries or create a middleware/service layer that filters by user_id from the session/token. 2. Provide clear comments or brief documentation so I can extend the filter when I add new roles. 3. Deliver tested code (SQL statements, ORM scope, or framework middleware—whichever fits) that plugs straight into my existing codebase. If you’ve implemented row-level security or scoped queries before, this will be quick work. Just make sure the logged-in user’s context drives every doctor lookup, and you’ll have met the requirement.
Project ID: 40419076
26 proposals
Open for bidding
Remote project
Active 7 secs ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
26 freelancers are bidding on average $49 USD for this job

Hi, I am Nabeel Abid, a software engineer with 10+ years of experience in web and software development. I have a deep understanding of various technologies and frameworks, including JavaScript, Python, and React, which enables me to deliver robust and scalable solutions tailored to client needs. I take pride in my problem-solving abilities and my knack for collaborating with cross-functional teams to meet project deadlines efficiently. I am excited about the opportunity to contribute to your project and bring my expertise in full-stack development to the table. I understand the critical nature of quality and timeliness in software delivery, and you can count on me to meet and exceed your expectations while maintaining open lines of communication throughout the project lifecycle. Looking forward to the possibility of working together! Regards, Nabeel Abid
$81 USD in 5 days
6.8
6.8

Scoping doctor records to the authenticated user is exactly the kind of row-level filtering I've built multiple times in Laravel, Express, and Django projects. My approach: I'll introduce a reusable middleware or service layer that extracts the user_id from your session or JWT token, then applies it as a mandatory WHERE clause (or ORM scope) on every doctor query—login response, API endpoints, and any future pages. I'll add clear inline comments and a short guide explaining how to extend this pattern when you introduce roles like admin or clinic manager. I've done this before and can start immediately—happy to review your schema today.
$10 USD in 1 day
6.5
6.5

Hi, I saw your need to return only the doctors tied to the logged‑in user. That’s clear and easy to integrate into your existing MySQL/PostgreSQL setup. I’ve built similar row‑scoped logic before for PHP APIs and ORMs. I can slot in clean filtering tied to session or token context. I’d keep it simple: • Add a lightweight middleware that resolves user_id once • Apply a shared filter to all doctor queries • Update your SQL or ORM scopes to enforce user_id on every lookup • Add comments so you can extend it later for roles I can start right away and this should take a short amount of time after reviewing your files. Do you already have a central place in your PHP code where the authenticated user context is resolved, or is it scattered across handlers? Greetings, Slavko
$200 USD in 6 days
5.5
5.5

Greetings, I see that you need a way to ensure that each user can only access their specific doctors after logging in. This requires implementing a filtering mechanism that ties doctor records to individual users based on their session or token. To tackle this, I would adjust your current queries or set up a middleware layer that checks the user_id against the doctors' records. This way, every time a user tries to access doctor data, they will only see what belongs to them. I’ll make sure to include clear comments and documentation so you can easily extend this for future roles. With my experience in PHP, SQL, and backend development, I can provide tested code that integrates seamlessly into your existing setup. Your goal for secure, user-specific data access will be met effectively. Best regards, Muhammad Arshman
$54 USD in 4 days
4.7
4.7

I ALREADY MADE SIMILAR PROJECT LIKE THAT BEFORE. I will deliver the SQL queries and Python middleware needed to filter doctor records by user_id for your MySQL or PostgreSQL database. 10+ years Advanced Excel experience, Certified VBA Programmer, MBA.
$10 USD in 1 day
4.8
4.8

With over a decade of experience in MERN stack, Ruby on Rails, and ASP.NET web development, I stand fully equipped to solve your application's unique challenge. How will you benefit from entrusting me with your project? It’s straightforward: with my extensive knowledge in backend development and database management (including MySQL/PostgreSQL), I have hands-on experience dealing with relational databases just like you're proposing for this project. I have successfully completed numerous projects similar to yours, involving query modifications or middleware creation for implementing data security access at a granular level. Therefore, handling the "Per-User Doctor List Access" task will be second nature to me. To further ease your concerns, after delivering the project and integrating it seamlessly into your existing codebase, I'll provide comprehensive comments and brief documentation. You will be able to confidently extend the functionality to accommodate new roles without any hitches in the future. Let's make this happen--I'm looking forward to leveraging my problem-solving skills and agile methodology mastery for your project's success!
$50 USD in 2 days
4.2
4.2

Hello, I understand you need robust per-user doctor data access that is enforced across all endpoints after login, with clear, extendable documentation for future roles. I can implement a secure, scalable solution that ties every doctor query to the authenticated user context and provides drop-in ready SQL/ORM middleware, plus documentation for future role expansion. Solution: - Implement row-level security or a scoped query layer in your existing stack (PostgreSQL with PHP) to filter doctors by the authenticated user_id present in session/token. - Provide a reusable middleware/service that attaches user_id to all doctor data queries (REST endpoints, GraphQL, ORM scopes). - Add policy comments and a concise docs section showing how to extend filters for new roles. - Ensure existing tests pass and deliver sample SQL, ORM scopes, and PHP middleware with inline comments. Deliverables: - SQL/DDL snippets and ORM scope/middleware code that enforces user-scoped doctor access - Example API request/response paths illustrating the user-scoped results - In-code comments plus a short README snippet for extension to new roles - Tests or test stubs to validate that only the logged-in user’s doctors are returned Budget + timeline: - Budget: 60 USD - Timeline: 2-3 days References (portfolio): - https://www.freelancer.com/u/zarminagull189 - [4-5 relevant project links from my portfolio, focusing on web development, PHP, SQL, API design, and backend architecture] Best regards, Thanks,
$55 USD in 1 day
3.2
3.2

Hi there, I can implement the logic you need to ensure that each user only accesses their associated doctors immediately after login and across all relevant queries. With my background in PHP and database management, especially with MySQL and PostgreSQL, I'm well-equipped to adjust your existing queries or create a middleware layer that filters by user_id from the session. I’ve successfully implemented similar row-level security in previous projects, ensuring that user context drives data access seamlessly. My approach will include clear comments and documentation for easy future role extension, along with delivering thoroughly tested code that integrates smoothly with your current codebase. Could you clarify if you have any specific preferences for how the documentation should be structured? Thank you.
$56 USD in 7 days
3.3
3.3

Hello, I can implement robust per-user doctor data isolation that plugs into your existing login flow and relational database setup (MySQL/PostgreSQL). My plan: after a successful login, enforce a user-scoped context (user_id) across every data surface, whether SQL, ORM, or API layer, so no doctor record can be surfaced to another user. I’ll provide a flexible, documented approach you can extend for new roles: - Option 1: Middleware/Service layer that injects the current user context and applies a universal filter on doctor queries and endpoints. - Option 2: ORM-scoped queries or global query filters that automatically append WHERE doctor.user_id = :currentUserId. - Option 3: Optional database-level safeguard with Row-Level Security (where supported) for defense in depth. Deliverables: - Fully tested SQL statements and/or ORM scopes ready to drop into your codebase. - Clear inline comments and a brief developer guide describing how to extend the filter to future roles. - Example usage for PHP-based stacks (PDO/ORMs) and highlights for MySQL and PostgreSQL. Why this works: the logged-in user context is the single source of truth driving all doctor lookups, so every page, API, or query remains isolated to the user’s doctors. I’ll ensure the integration is incremental and review-friendly, so you can grow the access rules without breaking existing endpoints. Best regards,
$55 USD in 1 day
1.9
1.9

Hi, I can do this project perfectly. I understand you need a professional e-commerce website design with proper stock/product structure and a clean, modern layout using CSS. I have experience building responsive online stores with organized product displays, smooth navigation, and conversion-focused UI design. I will create a fast, mobile-friendly design with clear product categories, well-structured layout, and a simple shopping experience that makes it easy for users to browse and understand stock availability. I can start immediately and will fully commit to the deadline, doing my best to deliver a result that is clean, stable, and aligned with your expectations. Rasul
$50 USD in 7 days
1.4
1.4

Hi there, THE CHALLENGE is ensuring seamless integration of the user-specific doctor list access logic into the existing app architecture without causing any disruptions to the current functionalities. This will require a deep understanding of the database structure and the ability to implement the necessary adjustments to the queries or middleware in a way that maintains data security and integrity. Additionally, providing clear documentation for future scalability and ensuring thorough testing to guarantee the reliability of the implemented solution will be crucial in this project. Regards, Matheus
$50 USD in 7 days
0.6
0.6

Hi, I can quickly implement a secure, scalable solution to ensure each user only accesses their own doctor records across your entire application. What I’ll deliver: Centralized filtering logic based on authenticated user_id (session/JWT) Clean integration via middleware/service layer or ORM scopes (depending on your stack) Updated queries to enforce strict user-level data isolation Reusable structure so future roles/permissions can be added بسهولة Well-commented, production-ready code Tested endpoints to guarantee no cross-user data leakage Approach: I’ll enforce row-level access control at the application layer (and optionally database level if needed), ensuring every doctor query is automatically scoped to the logged-in user—no exceptions. If you're using a specific framework (Node, Laravel, Django, etc.), I’ll tailor the solution to fit seamlessly into your existing architecture. This is straightforward and I can deliver it cleanly and quickly. Let’s get it done. Best regards, Terry Tobin.
$30 USD in 1 day
0.4
0.4

The core challenge with your project is ensuring that users only see doctor records tied to their accounts, which is critical for data security and user experience. After a successful login, I can implement a middleware solution that filters doctor queries by the logged-in user's ID, ensuring that every API call or page only returns relevant data. I’ve handled similar logic in past projects, particularly around row-level security and scoped queries in MySQL and PostgreSQL environments. I’ll provide clean, well-commented code that fits directly into your existing architecture, making it easy for you to adjust for future user roles. One thought: consider a simple logging mechanism to track access attempts. It can help identify unauthorized access patterns down the line. I can deliver the initial version in about 5 days. What does success look like for you at the end of this project?
$25 USD in 3 days
0.0
0.0

Hello, With my extensive experience in full-stack web development and back-end expertise in MySQL and PostgreSQL, I am more than equipped to tackle your project. Having worked on similar scenarios like yours - implementing role-based access control and customer segmentation - I understand the importance of providing users with a tailored experience, which we can achieve by filtering doctor data based on the user's context. My knowledge extends beyond standard web development, as I'm well-versed in ORM scopes and security measures like row-level access, which will be beneficial for implementing the logic you required. I will integrate this efficiently into your existing codebase to ensure a seamless functioning of the API endpoints, pages, and queries that display doctor information. Moreover, by leveraging my AI and machine learning skills, I can envision using them to further enhance your app in the future. In short, my proficiency is not limited to just solving this immediate challenge but extends to creating a robust architecture for future development too. Let's connect and discuss how we can make this project come alive. Thanks!
$10 USD in 2 days
0.0
0.0

Hello, As an experienced backend developer with a keen interest in building reliable systems, I am well-prepared to tackle your Per-User Doctor List Access project. Having worked on similar tasks involving APIs, relational databases and user authentication, I understand the essence of data security and privacy. My proficiency in SQL, MySQL, and PHP aligns perfectly with your requirements. I am familiar with developing scoped queries and implementing row-level security. This means that I will be able to deliver a solution that ensures only the doctors connected to a specific user are displayed throughout your app's pages and API endpoints. Apart from this critical functionality, my code is highly maintainable and scalable, qualities essential for any long-term project like yours. With me on board, you can expect not just optimized SQL statements and rock-solid ORM scopes but also comprehensive documentation that makes it easier for you to extend the filter when new roles are added. Let me combine my skills and mindset to provide you with tested code that seamlessly integrates with your existing codebase! Thanks!
$10 USD in 7 days
0.0
0.0

Hello I have read your project carefully and understand what’s the problem described in Per-User Doctor List Access based on My app already handles sign-in with username and password and stores everything in a relational database (MySQL/PostgreSQL). From what I understand, you are looking for a solution involving API Development, Software Development, SQL, Database Management, PostgreSQL, Database Programming, MySQL, PHP, Software Architecture and Backend Development, and I can help you with that. My approach to solving this would be: • First, analyze the requirements in Per-User Doctor List Access in detail to avoid missing anything • Design a clear and scalable solution based on API Development, Software Development, SQL, Database Management, PostgreSQL, Database Programming, MySQL, PHP, Software Architecture and Backend Development • Implement step by step and ensure everything is tested and stable before delivery This approach ensures the final result directly solves the issue described in your project without unnecessary revisions. If needed, I can also suggest improvements to make the system more efficient and scalable. Looking forward to your response and happy to clarify anything about My app already handles sign-in with username and password and stores everything in a relational database (MySQL/PostgreSQL). Best regards
$10 USD in 4 days
0.0
0.0

Since your auth is already in place, adding per-user doctor list access is mostly a database join and a middleware check. I would add a user_doctors pivot table, filter the query by the logged-in user's ID, and expose it through a clean API endpoint. Can start today and have it working in two days. The numbers shown are based on the post as written and will firm up once we walk through the full scope. Want me to send a quick plan?
$54 USD in 3 days
0.0
0.0

Hi there, I read your requirements carefully, and I can help add secure per-user doctor access logic so each logged-in user only sees the doctors connected to their own account. I’ll review your current login/session or token flow, then update the doctor queries using the authenticated user_id. Depending on your current database structure, I can implement this with a direct user_id column, a user-doctor relation table, ORM scope, middleware, or service-layer filter. The same rule will be applied across pages, APIs, and any backend query that returns doctor data. I’ll also add clear comments/documentation so the logic can be extended later for new roles or permissions. Before handoff, I’ll test login-based access to confirm users cannot view, fetch, or access doctor records that do not belong to them. Cost: $60 || Timeline: 1 day Payment and timeline details can be discussed further to align with your expectations. I’d be happy to help secure this access layer cleanly and quickly. Best regards, Oluwatobi Okedairo
$60 USD in 1 day
0.0
0.0

Hi You’re not just asking for a one-off query fix - you want every doctor lookup (pages, APIs, background jobs) to respect the logged-in user’s context so data never leaks. That’s the right way to think about it. I’ve implemented this pattern before using a service + query-scope approach, where the user ID is derived only from the session/JWT and injected once, then enforced everywhere: -DB relationship + indexed user_id -ORM scopes or repository filters that can’t be accidentally bypassed -Optional middleware / global scope to future-proof new endpoints -Clear comments so adding roles (admin, shared access) is trivial later
$50 USD in 2 days
0.0
0.0

Tegucigalpa, Honduras
Payment method verified
Member since Mar 26, 2015
$10-30 USD
$10-30 USD
$10-30 USD
$10-30 USD
$10-30 USD
$250-750 USD
£250-750 GBP
₹75000-150000 INR
₹400-750 INR / hour
₹12500-37500 INR
$750-1500 USD
₹600-1500 INR
£20-250 GBP
$1000-25000 USD
$250-750 USD
₹1500-12500 INR
€3000-5000 EUR
$2-8 USD / hour
₹250000-500000 INR
₹12500-37500 INR
$30-250 USD
$30-250 USD
$10-5000 USD
€250-750 EUR
$250-750 USD