Create a searchable/sortable/selectable table based on records from 2 MySQL Tables

Cancelado Publicado hace 6 años Pagado a la entrega
Cancelado Pagado a la entrega

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

You can see my test page here:

[login to view URL]

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

Nº del proyecto: #14634290

Sobre el proyecto

45 propuestas Proyecto remoto Activo hace 6 años

45 freelancers están ofertando un promedio de $517 por este trabajo

TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W Más

$526 USD en 10 días
(266 comentarios)
8.9
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 Más

$480 USD en 10 días
(357 comentarios)
8.8
rajeshsonisl

Hello! With 98% to 99% completion rate, 1000+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... Más

$555 USD en 10 días
(1061 comentarios)
8.9
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 Relevant Skills and Experience Javascript Más

$463 USD en 15 días
(474 comentarios)
8.3
imagicaworld

hello Relevant Skills and Experience I am very expert in SQL Proposed Milestones $277.5 USD - m $277.5 USD - m

$555 USD en 10 días
(209 comentarios)
7.9
Infenixwebs

Re-create and optimize a searchable/sortable/selectable table based on records from 2 MySQL Tables Relevant Skills and Experience Hi, I have experience in web projects, if you check my reviews you will see that I have Más

$600 USD en 20 días
(145 comentarios)
7.6
libxml1

Hi. I can speed up the current code. I'm available, contact me any time. Relevant Skills and Experience Full stack web developer. Proposed Milestones $300 USD - Payment

$300 USD en 3 días
(48 comentarios)
7.4
csajit

HELLO THERE, I AM INTERESTED IN WORKING ON THIS PROJECT. PLEASE CHECK MY REVIEWS AND THEN DECIDE ON ME. LOOKING FOR A LONG TERM RELATIONSHIP. -------------- THANKS, AJIT Relevant Skills and Experience Over 200+ P Más

$400 USD en 7 días
(288 comentarios)
6.8
prashushinde9

Hello, We have accomplished 90% of the project which is similar of your requirement. All we need 10% customization as per your requirement set and specifications. I want to discuss in personal chat in order to explore Más

$515 USD en 10 días
(55 comentarios)
7.1
dghq123

Hi there.. I have read your project details completely and willing to do it for you... Check our recent reviews for our quality work on on time delivery. Also let me tell you that we have team of expert Full Stack Más

$600 USD en 10 días
(82 comentarios)
6.8
onkarkulkarni8

We already developed a similar project which matches your requirements(not 100%). Please get in touch to discuss more and start. Relevant Skills and Experience Final discussion in chat. Proposed Milestones $250 USD - Más

$250 USD en 10 días
(91 comentarios)
6.7
Vahe7777

I have very reasonable and successful experience in the following: - 6 PHP+MySQL, node.js, JavaScript + Ajax sites: small auction site for car dealer, site for selling coupons for local shops and corporate site for in Más

$700 USD en 10 días
(33 comentarios)
6.1
devanshai

Hello Sir, Gone through your requirement , I am pretty sure will deliver you the same project as per your requirement. Hope to have quick discussion over project . Relevant Skills and Experience Quality is never an Más

$555 USD en 10 días
(22 comentarios)
5.7
imphasys

I can turn your requirement in a way that represents your brand and appeals to your target audience. Whether you need a simple app or complex app I or my team can make the transition with ease. Relevant Skills and Exp Más

$250 USD en 15 días
(92 comentarios)
7.1
rambanstola

Would query caching work. We could preheat the query if the data is not going to change a lot. Relevant Skills and Experience php, mysql Proposed Milestones $277.5 USD - first_milestone $277.5 USD - second_milestone

$555 USD en 10 días
(75 comentarios)
5.9
artifexonline

Hi, I have reviewed your requirement and I can do this job as per your requirement. We have huge expertise in WORDPRESS ,Payment gateway, Laravel, Node.Js , React.Js, CakePHP, Codeigniter, Angular.js, Bootstrap, AP Más

$555 USD en 10 días
(33 comentarios)
5.8
oliviainfotech

Hi greetings of the day I am a Experienced PHP Developer based out in Chennai,India. My experience revolves around development of web and mobile applications,Ecommerce websites. Relevant Skills and Experience I believ Más

$555 USD en 10 días
(115 comentarios)
5.9
BizVenture

I'm a senior mobile & web providing customized solution in mobile apps and website development having experience since 6+ years. I've vast experiences and latest technologies with my energetic effort. I'm also a flex Más

$555 USD en 10 días
(14 comentarios)
5.3
codemaster7

Hi, I had a look on your page and I would suggest to use DataTables instead of TableSorter. You will have all existing filters and features. I can also add more features and a better template. Relevant Skills and Exp Más

$444 USD en 10 días
(39 comentarios)
5.2
AlexanderBulei

Hey Employer! I can help you with your page/project. Relevant Skills and Experience + Advanced skills on jquery/bootstrap/ajax + 8 years of experience + php & mysql + European guy + fats and clean code :) Proposed Mi Más

$555 USD en 7 días
(43 comentarios)
5.3