Ability to handle multiple clients (customers)

Question

0.00/5 (No votes)

See more:

i have created a tool that that takes the input and after validating gives the O/p, i have done the programming in PHP and Python and i have connected the tool with SQL server.....when a user gives a i/p it goes to a table_name "Input_Value" in SQL Server then my tool fetches the data and validate it, after validating result goes to Table_name "Output_Value".when another user gives I/p table values get deleted of previous user........if two user tries to validate their value at same time then result mix with each other.
so what logic can i use so multiple user can work on my tool same time and they will get their result separately.

What I have tried:

now i am using logic for one user only. i have one "input_table" and "output_value" table. when another user tries or same users tries again previous values get deleted and new values take places....what if multiple users tries at same time.

Posted 10-Feb-17 18:02pm

Member 12994465

Updated 10-Feb-17 18:27pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Peter Leow · Answer 1 · 2017-02-10T18:27:00

Based on your design, in a multi-user environment, the first i/p that comes in may get deleted by next immediate subsequent i/p before it can be picked up for validation. and there is no way to be certain that an output from a validation originated from a particular input. Furthermore, if you do not want to keep the trails of the inputs and the corresponding outputs, why use a database?
Anyway, think of this design if you insist:

input table              output table
input_id (primary key) ---|     output_id (primary key)
input_data                |     output_data
datatime                  |---- input_id
                                datetime

Introduction to database design[^]
1NF, 2NF, 3NF and BCNF in Database Normalization | DBMS Tutorial | Studytonight[^]