
Closed
Posted
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
115 proposals
Remote project
Active 13 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
115 freelancers are bidding on average $51 USD for this job

Hello, As a seasoned software developer at Our Software, specializing in database programming and PHP, I am confident that I can seamlessly integrate the functionality you require into your existing codebase. My wealth of experience makes me well-versed in handling complex and relational databases such as yours, MySQL/PostgreSQL. I can quickly adjust the current queries or craft a middleware/service layer to filter doctor data based on user_id, ensuring only the relevant records are returned after login. Moreover, equipping your codebase with scalable extensions is also my cup of tea. I understand the importance of clear comments and concise documentation to enable seamless integrations with new roles in the future. My expertise ensures that these modifications would be a breeze, welcoming any enhancements without disturbing your current system. Lastly, my proficiency in PHP and software development is complimented by a strong emphasis on testing throughout the development process to ensure no stone goes unturned. If you're looking for security-oriented row-level filtering or scoped queries that guarantee each user's privacy and exclusivity over their doctor list, I'm confident I can deliver and exceed your expectations. With our collaborative spirit and commitment to excellent customer service, choosing me would mean well-crafted solutions tailored perfectly for your needs. Let's turn your project into reality together! Thanks!
$55 USD in 1 day
8.6
8.6

Hello I have several years of experience with PHP programming, MySQL and Web Development I have read your requirements and I have ideas how to returns only the doctors connected to that specific user. It may take even less than 30 minutes of working time
$32.75 USD in 1 day
8.0
8.0

Hi there, I’ve read your “Per-User Doctor List Access” need and I’m confident I can implement a robust, scalable, and auditable per-user scope across all data access. With 15+ years in PHP, SQL (MySQL/PostgreSQL), and API-driven architectures, I’ve built row-level access layers, middleware filters, and ORM scopes that ensure every doctor lookup runs under the logged-in user’s context. I’ll deliver a small, documented service layer or middleware that filters by user_id from the active session or token and apply it consistently across queries, endpoints, and views. What I’ll deliver: - A reusable scope/middleware layer that automatically attaches user_id context to every doctor query. It will plug into your existing codebase with minimal changes and work for SQL, ORM, or raw queries. - Clear in-code comments and lightweight docs to extend the filter for new roles. - Tested SQL statements, ORM scopes, or framework middleware ready to drop into your project. If you use PostgreSQL row-level security, I’ll provide a compatibility path; otherwise I’ll implement a portable filter that works everywhere. I’ve shared an initial estimate based on your description, and once we go over a few technical or functional details, I’ll confirm the exact cost and delivery schedule. What is your current authentication flow (session-based or token/JWT) and which ORM/framework are you using (Laravel, Doctrine, Eloquent, raw SQL, etc.) to implement the per-user Doctor data scoping? Asad
$55 USD in 1 day
8.3
8.3

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.6
6.6

Ready to start now --- I cam implement these logics right now. Give me opportunity to show you good result. Thanks
$25 USD in 1 day
6.5
6.5

Hello Dear! Greetings from Toriqul Global Solutions! We are a reliable and experienced web design & development company led by Engineer Toriqul Islam (B.Sc. in CSE, RUET), with over 10 years of proven industry experience delivering quality digital solutions. At Toriqul Global Solutions, we build modern, user-friendly, high-performance websites focused on simplicity, elegance, and functionality to boost engagement and business growth. I have some questions——— 1. What framework or raw PHP are you using? 2. Do you use sessions or JWT for auth? Technologies We Use: Custom Websites Development Using ======>Full Stack Development. 1. HTML5 2. CSS3 3. Bootstrap4 4. jQuery 5. JavaScript 6. AngularJS 7. React JS 8. Node.js 9. WordPress 10. PHP 11. Ruby on Rails 12. MYSQL 13. Laravel 14. .NET 15. CodeIgniter 16. React Native 17. SQL / MySQL 18. Mobile app development 19. Python 20. MongoDB and more skills What will you get? • Responsive design on All Devices •Reusable components •Clean code •Timely delivery tested •Clear communication We would be honored to discuss your project requirements and help bring your ideas to life. Thank you for your time and consideration. Warm Regards, Toriqul Global Solutions
$30 USD in 2 days
6.2
6.2

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

Hi, I can see the core issue clearly—right now your app is validating login using session (username), but doctor queries are not scoped by user_id, which means any user can potentially access all records. Also, your doctors table doesn’t currently enforce a proper user relationship, so filtering isn’t consistently applied. I have 8+ years of experience in PHP/MySQL systems and have implemented row-level access control in similar applications. I’ll fix this by introducing a clean user-based filtering layer that ensures every query (pages, APIs, AJAX calls) always respects the logged-in user context. My approach: – Add proper user_id mapping in the doctors table – Store user_id securely in session after login – Update all queries to enforce WHERE user_id = ? – Create a reusable function/middleware so future features automatically follow the same rule – Test across all endpoints to ensure no data leakage I’ll keep changes minimal so it plugs into your existing codebase without breaking anything, and I’ll document it clearly so you can extend it later. I can start immediately and deliver a clean, secure fix.
$30 USD in 1 day
5.6
5.6

Hi, I can help you to do what you want I am a passionate software developer with more than 10 years of Experience in Sql Database and administrative Apps please contact me to discuss more Thanks so much and I wish you have a nice day
$50 USD in 1 day
5.4
5.4

Hi, You already have auth in place — this just needs proper query scoping so each user only sees their own doctors. I can implement a clean solution using a global scope or middleware that automatically filters by user_id across all queries and endpoints. I’ll structure it in a way that’s easy to extend (roles, permissions later), with clear comments and minimal changes to your current codebase. The solution will be tested and plug directly into your existing setup. Quick question: are you using Laravel Eloquent models for the doctors table, or mostly raw queries?
$60 USD in 3 days
5.2
5.2

Hi, I’ve reviewed your requirement and attachment carefully. You need to ensure that after login, each user can only access doctors linked to their own `user_id`, and this rule must be consistently enforced across all pages, APIs, and queries to prevent any cross-user data exposure. I can implement this by adding a centralized middleware/service layer that automatically applies user-based filtering using the logged-in user’s context. This will ensure all doctor-related data is securely scoped at the backend level and works consistently throughout the system. The solution will be: * Secure (proper user-level data isolation) * Scalable (easy to extend for roles like admin/doctor) * Clean and maintainable * Directly integrated into your existing MySQL/PostgreSQL setup or ORM I will also make sure the code is well-structured and commented so you can easily extend it in the future. I’m ready to start immediately once you confirm your backend stack. Best Regards, Abhishek
$50 USD in 7 days
5.2
5.2

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.9
4.9

Hi, I am a backend developer with 8 years of rich experience in software development, with a background in PHP, SQL, MySQL, PostgreSQL, database programming, API development, and access-control logic. I can update your login-driven doctor access so every query, page, and API endpoint returns only doctors linked to the authenticated user. I’ll add scoped SQL or middleware/service filtering by user_id, keep it easy to extend for future roles, and include clear comments with tested code that fits your existing database structure. I'm an individual freelancer and can work on any time zone you want. Please contact me with the best time for you to have a quick chat. Looking forward to discussing more details. Thanks. Emile.
$90 USD in 7 days
4.7
4.7

As an experienced Full Stack Developer and Database specialist, I am confident that I am the best fit for your Per-User Doctor List Access requirement. I have an extensive background in designing efficient database schemas, managing large datasets with databases such as MySQL and PostgreSQL, and delivering well-tested, production-ready backend systems. Additionally, my strong knowledge of API development will enable me to seamlessly integrate the necessary logic into your existing codebase. During my time at i2c Inc., a global fintech company, I developed Java Spring Boot microservices that processed millions of monthly transactions, so I know how crucial data security is. The service layer or middleware I create for you will ensure that users only see their relevant doctor records while being scalable enough to extend filter roles if needed in the future. In summary, if you hire me for this project, you'll benefit from not only my skills in backend and full-stack development but also an understanding of building systems with data privacy as the foremost concern. All of this will result in a timely delivery of quality work that meets and exceeds your expectations — every time. Let's get started!
$50 USD in 1 day
4.6
4.6

Dear Client, I’m an experienced full-stack developer with over 10 years of experience in web and mobile application development, specializing in building scalable, responsive, and high-performance solutions for diverse business needs. I understand you are looking for a reliable developer to build or improve your project, including web or mobile applications similar to CRM, dashboards, or APIs, and I have worked on similar solutions successfully. My skills in React, Vue, Laravel, PHP, Python, REST APIs, and database design ensure efficient and high-quality delivery. Feel free to share more details or ask questions. I’m ready to refine my approach to match your exact requirements. Looking forward to working with you. Best regards, Md Ruhul Ajom
$35 USD in 2 days
5.4
5.4

With my extensive experience in API and backend development, particularly in working with MySQL and PostgreSQL, I am well-equipped to handle the complexities of your project. I can integrate the necessary logic into your existing code to ensure that after a user logs in successfully, only the doctors connected to them are displayed. This includes not just the initial login page but every subsequent page, API endpoint, or query that retrieves doctor data; protecting user security and privacy throughout their experience on your app. A key benefit of working with me is my focus on scalability and future-proofing. I understand the importance of clear comments and documentation in enabling a smooth transition when adding new roles or extending existing filters. You can rely on my thorough approach to deliver code that is readily testable, reusable, and easily adaptable as your requirements evolve or grow. Previously, I have successfully implemented row-level security and scoped queries, making me confident about delivering what you need efficiently. My deep understanding of SQL statements, ORM scope, and framework middleware means the end-result will seamlessly plug into your system while maintaining a user-context-driven approach towards doctor lookups. Plus, my familiarity with Linux, Git, Docker, CI/CD will ensure a streamlined integration process without any hiccups. Let's make this project a reality!
$50 USD in 7 days
4.7
4.7

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

I can help you design and implement secure, per-user access to doctor lists that fits cleanly into your existing authentication and relational database setup. This will ensure each user only sees the doctors they are allowed to access, without disrupting your current login flow. I’ve built similar permission and role-based access layers for healthcare-related apps, where data isolation and correct mapping between users, profiles, and resources is critical. That includes designing the right table relationships, queries, and middleware to enforce access rules consistently across the app. My approach would be to review your current schema, define the access rules (per user, per role, or per group), then extend the data model and API logic so doctor lists are filtered safely at the database and application layer. I would love to chat more about your project! Regards
$50 USD in 7 days
4.1
4.1

Tegucigalpa, Honduras
Payment method verified
Member since Mar 26, 2015
$10-30 USD
$10-30 USD
$30-250 USD
$10-30 USD
$10-30 USD
$30-250 USD
$30-250 USD
₹12500-37500 INR
€250-750 EUR
$250-750 USD
$750-1500 USD
₹12500-37500 INR
$8-15 USD / hour
€12-18 EUR / hour
$3000-5000 USD
£250-750 GBP
$10-30 USD
$30-250 USD
€8-30 EUR
$10-30 USD
$250-750 USD
$250-750 USD
$30-250 USD
₹600-1500 INR
₹400-750 INR / hour