PHP/MYSQL Database algorithm
- or -
Post a project like this3505
$50
- Posted:
- Proposals: 8
- Remote
- #563048
- Awarded
Web Applications (PHP | Laravel | Go | MySQL | Javascript | jQuery | React), Mobile Apps (React Native | Android), Microservices, System Analysis, DBs, Data Science, Machine Learning, Deep Learning
Bay Minette
QA Testing Mobile Application Develpment ,Content writing, Webdesign ,SEO,Digital Marketing etc
Bangalore
Brochure, Flyer, Corporate Identity, Webdesign, PHP, MySQL, NodeJS, WordPress, Android, iOS, Content Writing, Angular JS,
Indore
411950456806536236539491562722663489752806756711
Description
Experience Level: Intermediate
This is a general travel routes of employees
Need simple database algorithm with a few fields for a demo project. simple User Interface required. Following is how it works. There are lines named X, Z, A, B.
A user named Jack adds a route (eg: X2 to Z4) and it will get saved in the database. There will be several different routes added this way. eg: B4 to X9, Z3 to B9 etc
I search for a route (eg: X4 to Z1) and if there is an EXACTLY similar route in the database, it will get displayed. For example, if I search for X4 to Z1 and there are two users who have saved the same route in the database, it will get displayed.
If there are no exact routes, the system will first find ALL routes with the same starting point (in this case X4). Let's say the system finds 8 routes with same starting points. It will display them in the respective sequence of decreasing distances. Eg: the search result would be like follows:
X4 to Z1 Peter (exact route)
X4 to Z1 Sam (exact route)
X4 to Z3 Simon
X4 to XZ Sonia
PS: Note that these all routes would be fed through the ADD functionality
Another eg: If I search for B2 to A6, the results would be as follows:
B2 to A6 Mark (exact route, if it exists)
B2 to ABX Bruce
B2 to ABX Reena (trimmed route; the original route of Reena was B2 to X8. Whenever there is a junction and the uer is going in a different direction, trim his route and show only the route that falls in the search criteria)
B2 to ABX Mario (original route: B2 to Z5)
B2 to ABX Pablo (original route: B2 to Z5)
Note that there would be 3-4 such lines and around 100 coordinates.
Need simple database algorithm with a few fields for a demo project. simple User Interface required. Following is how it works. There are lines named X, Z, A, B.
A user named Jack adds a route (eg: X2 to Z4) and it will get saved in the database. There will be several different routes added this way. eg: B4 to X9, Z3 to B9 etc
I search for a route (eg: X4 to Z1) and if there is an EXACTLY similar route in the database, it will get displayed. For example, if I search for X4 to Z1 and there are two users who have saved the same route in the database, it will get displayed.
If there are no exact routes, the system will first find ALL routes with the same starting point (in this case X4). Let's say the system finds 8 routes with same starting points. It will display them in the respective sequence of decreasing distances. Eg: the search result would be like follows:
X4 to Z1 Peter (exact route)
X4 to Z1 Sam (exact route)
X4 to Z3 Simon
X4 to XZ Sonia
PS: Note that these all routes would be fed through the ADD functionality
Another eg: If I search for B2 to A6, the results would be as follows:
B2 to A6 Mark (exact route, if it exists)
B2 to ABX Bruce
B2 to ABX Reena (trimmed route; the original route of Reena was B2 to X8. Whenever there is a junction and the uer is going in a different direction, trim his route and show only the route that falls in the search criteria)
B2 to ABX Mario (original route: B2 to Z5)
B2 to ABX Pablo (original route: B2 to Z5)
Note that there would be 3-4 such lines and around 100 coordinates.
Alexia R.
98% (24)Projects Completed
34
Freelancers worked with
28
Projects awarded
34%
Last project
16 Dec 2014
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies