Searchable/sortable/selectable table based on MySQL results

In Progress Posted 6 years ago Paid on delivery
In Progress

I have 2 MySQL tables which are being queried to populate a Tablesorter table.

You can see my test page here:

[url removed, login to view]

From that, you can click on a name (ie CUAN LAW) and it expands to show information. And you can then search by the results at the top of the page or by the column names.

As you can see it is extremely slow.

I am looking for someone to streamline the process already in place or to rewrite it in a better system/way.

I also need the ability to add a few more fields (most likely in the boat info area) so when you select the boats you want and fill in the custom fields (things like special message and rate info) and then click the Create quote button it then creates a quote page based on that information.

For now I just need help (or a rewrite) of this page/functionality.

But if I find the right partner I would love to also have help with the create quote page and some other projects I have on my plate.

So to sum up.

I either need help with the existing code to speed it up and add some new functionality.

OR

A new system that can query 2 tables and return a dataset and then populate a table with that information. The table should be searchable by multiple external fields (example: location, pax, heads) and sortable by all headers.

You should be able to click on one of the results and it will bring up more information about that line item and also have some fields you can fill in.

All results will have a check box by them so when you click a button the selected line items and all custom data entered for that item get posted to another page.

Thank you.

JavaScript MySQL PHP

Project ID: #14634560

About the project

20 proposals Remote project Active 6 years ago

Awarded to:

aadilahlawat42

Hello Sir, I've gone through the test page and requirements. I have Experience of more than 6 years in creating and customizing Web themes, extensions, application and plugins and framework like Codeigniter . I am w More

$7 USD / hour
(11 Reviews)
3.9

20 freelancers are bidding on average $8/hour for this job

webbookstudio

Hello, my name is Michael. I represent Ukrainian based IT-company Webbook Inc that provides services in the IT-sphere for international business. We were carefully reviewing the requirements of the job description, so More

$5 USD / hour
(138 Reviews)
8.1
mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$6 USD / hour
(382 Reviews)
8.2
toseef3

Dear sir, I have read the job requirements very care fully and would like to share that we have 5+ years of experience in Enterprise, web and smartphone app development. We have completed dozens of websites for our More

$7 USD / hour
(63 Reviews)
7.4
ieota

We @ IEOTA TECHNOLOGIES have lot of exposure and experience in development for past 4 years served for several clients across the globe. We have fabulous developers who have extreme knowledge in coding and vast experie More

$5 USD / hour
(25 Reviews)
5.7
phpdeveloper11

I have over 12 years experience in web development. And i saw your test page and its very very slow in loading i doubt there are lots of queries fired out there specially inner queries for each record and that can s More

$8 USD / hour
(31 Reviews)
5.5
Webtronix786

Extremely interested, I read the requirements and understand them. I will guarantee desired result and satisfaction 100%. Regards, Mansoor.

$8 USD / hour
(2 Reviews)
5.3
munjalmayank

A proposal has not yet been provided

$11 USD / hour
(61 Reviews)
4.6
ukgolang

Wow. That's slow a really slow! The fix should be pretty simple, I will be able to you resolve the load time.

$33 USD / hour
(2 Reviews)
1.9
aimindonesia

Hi, i probably need 2 days to research about your system I have build big query and optimise mysql before

$5 USD / hour
(1 Review)
0.0
alexaofficial

I am familiar with optimized mysql querying. I have already done these in majority of my projects. I have experience in php too.

$8 USD / hour
(0 Reviews)
0.0