Closed

PHP MySql incremental query filter

The goal of this project is to build a php/mysql page(s) that provides users feedback of how their filter changes affect the Qty of records selected on a report builder web app. This will be used as a proof of concept demonstrating an efficient method so you may build your own test data so long as the qty of records and primary key data type match what is described below. I do not care about the styling of the page and can be very basic with only enough fields to demonstrate the filtering process.

----

I currently have a PHP/mysql web application that lets users select large lists of street addresses based on various filters they create. It is a 2 page process in which they first enter criteria about which addresses they want by location (ie county, zip code, city, etc) . When they click to the next page, it shows them the current count of how many addresses they have selected, and also a count of how many distinct zip codes are in their selection. Each address is identified by a unique address_id that is a 4byte INT. This first selection typically ranges from 10,000 to 200,000 records but potentially as high as 10,000,000 records.

On the next page, they can choose to keep or exclude addresses from their selection that also appear on any of their previous saved lists. For instance, they might have a list called "Bad Addresses" that they want any overlap excluded from their current selection, and they might have another saved list called "High Margins" and they only want to keep addresses from the current selection that exist on the "High Margins" list. These saved lists are typically 1,000 to 20,000 addresses but can get up towards 2,000,000 addresses.

I would like to determine the most efficient way to incrementally narrow down the address_ids to keep. I currently build the SQL statement incrementally and end up running the SQL statement multiple times as each page builds onto it, but I'm thinking there is likely a better way to just store the resultant address_ids of the first query, and then filter that list down based on the address_ids in the selected lists. However, I'm not sure if that should be done using Temporary Tables in mysql or some kind of stored session variable in PHP.

Please state what experience you have building a similar solution and which method you think would be better and why.

Skills: MySQL, PHP, Software Architecture

See more: what is selection criteria, php web app builder, php mysql app builder, php codes list, php application builder, key selection criteria, how to create a php application, how to address the selection criteria, how to address selection criteria, how to address key selection criteria, build mysql query, build app in php, application web php mysql, address the selection criteria, address selection criteria, php mysql application, build query filters, app php mysql, mysql select filter, Web app builder, mysql select statement, sql statement stored, create report php using mysql, php test page, mysql web project

About the Employer:
( 93 reviews ) Brandon, United States

Project ID: #5029048

17 freelancers are bidding on average $222 for this job

hits

We are a team of developers with expertise and experience in PHP and MySql. We have worked on many forms that have a number of search fields to filter data. Regarding filtering from huge number of records, we have h More

$263 USD in 3 days
(873 Reviews)
8.8
rajeshsonisl

Hello, With 99% completion rate, 650+ successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 !!)... you can never go wrong choosing me :) I look forward to your reply. More

$360 USD in 2 days
(456 Reviews)
7.3
AcuityInfotech

Hi, We’ve had a good look at your project description and we’re very interested in providing a solution . We are a professional development company headquartered in Virginia and have more than 600 jobs under ou More

$206 USD in 5 days
(26 Reviews)
6.7
scriptphp87

Hello, I am a professional programmer for web programming with php language to build the system website, Besides, I also expert in MySQL , HTML,HTML5,CSS, JS I'm alway top in Vietnam freelancer [url removed, login to view] More

$206 USD in 3 days
(89 Reviews)
6.6
powertech

Hi, I read the requirement and I think I understand that. Have you tried to use the subquery to filter? This way we do not need run sql multiple times.

$210 USD in 5 days
(60 Reviews)
6.5
seekdeveloper

Hi, I have read your post and understood the requirement. I have good experience in handling Wordpress/Magento/Joomla/Drupal/Yii framework/Javascript/MySQL/HTML5/CSS3/PHP/ Kindly go through my works to choos More

$257 USD in 3 days
(35 Reviews)
6.4
bigdognec

Hello, I have done something similar for an insurance company who wanted to view temporary changes and impact before pushing the data to live but the difference was that we had a Java applet and so established a cli More

$210 USD in 5 days
(85 Reviews)
6.0
abhius

Hello Sir :) Gone through the description. You use either jquery database or arrays for the best performance. I am confident to complete this job proficiently. Have expertise in resolving such points, for the pas More

$215 USD in 5 days
(68 Reviews)
5.9
digidreamstech

Hi, I had read your description. I would suggest to use a single stored procedure to do this task. Could you show me your current working example so that I can give you proper feedback about this. Thanks

$147 USD in 3 days
(21 Reviews)
5.5
virals2583

Hello Sir, I reviewed your initial task-requirement and truly believe we can help you on this project. We have very strong experience, 10+ years in php, mysql, ajax - website development and programming. Please visi More

$222 USD in 5 days
(15 Reviews)
5.4
Champian

Let Champian handle this for you. Hi, I am working as a freelancer website designer and developer, I have 5+ years of experience in design and programming joomla, PHP, Wordpress. Here is my profile on Joomlancer More

$263 USD in 3 days
(26 Reviews)
5.4
VRWebSolutions

VRZ Solutions prides itself for being instrumental in developing global Internet based presence for many small and large businesses. The teams of professionals at the helm of affairs in our company have already c More

$216 USD in 10 days
(2 Reviews)
4.0
freelancer5299

Hello, i have checked your project and would like to have your project. I am confident to fulfill your requirements in timely manner, along with quality work. Please check your pmb.

$144 USD in 3 days
(13 Reviews)
4.0
pointlogic

Hello..We have gone through the details you have provided and would be pleased to work on this with you to deliver the results that you have expected and We are sure you will not be disappointed if you give us this More

$189 USD in 8 days
(16 Reviews)
3.2
vijaywebsol

Please have a look at the work profile of our PHP, HTML & WordPress developers [url removed, login to view] , [url removed, login to view] , , [url removed, login to view] , [url removed, login to view] , More

$412 USD in 5 days
(4 Reviews)
3.0
mituld

Hi Ready to Start i had more than 7 year experience in word press and php and html and css and mysql Thanks

$200 USD in 7 days
(3 Reviews)
2.2
gchatzipapas

I shall propose making a trigger a pl/sql method. It is a little program inside your database that it will be "triggered" when user want to do your goal. I you want to hire me please email me :

$222 USD in 2 days
(0 Reviews)
0.0
SajjadHussain14

Hi, I have developed similar application which search by Region,Country, City and some other filter criteria. You can visit this link for better understanding. [url removed, login to view] 1- A More

$222 USD in 5 days
(0 Reviews)
0.0
perksolution

We have gone throuh your requirements. We have a team of expertise in PHP/mysql and smart phone application development. We can make your project in most efficient and reliable [url removed, login to view] are hopefully that you will f More

$222 USD in 7 days
(0 Reviews)
0.0