PHP MySQL JavaScript Advanced Search and jqxGrid results

In Progress

I have a MySQL table with the following schema:

"parents" (all form elements)

ID: 1 / TYPE: dropdown / NAME: parent1

ID: 2 / TYPE: checkboxgroup / NAME: parent2

ID: 3 / TYPE: radiogroup / NAME: parent3

ID: 4 / TYPE: textfield / NAME: parent4

ID: 5 / TYPE: textbox / NAME: parent5

"childs" (all option elements)

ID: 1 / CHILDOF: 1 / NAME: child1

ID: 2 / CHILDOF: 1 / NAME: child2

ID: 3 / CHILDOF: 1 / NAME: child3

ID: 4 / CHILDOF: 2 / NAME: child1

ID: 5 / CHILDOF: 2 / NAME: child2

ID: 6 / CHILDOF: 2 / NAME: child3

ID: 7 / CHILDOF: 3 / NAME: child1

ID: 8 / CHILDOF: 3 / NAME: child2

"data" (stores selections)

ID: 1 / timestamp: 10/12/2012 / parent1:child1 / parent2:child1 / parent3:child2

ID: 2 / timestamp: 10/12/2012 / parent1:child3 / parent2:child2 / parent3:child1

ID: 3 / timestamp: 10/12/2012 / parent1:child1 / parent2:child1 / parent3:child1

ID: 4 / timestamp: 10/12/2012 / parent1:child2 / parent2:child3 / parent3:child2

The above data is used to build a form that is stored in the table 'data". I need 2 things built:

1. a search page that will do an advanced search like this:

- displays a drop down box where people can select the field they want to search, i.e. "parent1" and using JavaScript add a text box so that they can enter their text query.

- a (+) plus sign that the user will click on to add another search filter, meaning if clicked it will add another "parent" and list it's options if multiple options are stored in the "childs" table.

- the search filters will be ordered horizontally for "AND" filters and vertically for "OR" filters like the following example.

parent1=child1 AND parent2=child1 AND parent3=child2

OR

parent1=child2

OR

parent1=child3

2. The result from the search query will be displayed using the jqxGrid at [url removed, login to view] (see the Filtering Row demo)

- the grid should be sortable by enabling the option in the variables

- each result will be linked to a page and a unique variable like this i.e. [url removed, login to view]

IMPORTANT:

- The database as well as the basic HTML will be provided. This project is for a demo so there is no fancy data or design needed.

- I'm only considering bids with 1 or 2 days max deadlines.

- you must prove to me that YO CAN UNDERSTAND DIRECTIONS and that we can have clear communications.

- you must DELIVER ON TIME if you want to keep working with me

- while developing you should be AVAILABLE AT ALL TIMES on Skype or via email

- send me SAMPLES OF YOUR WORK if you want to be considered.

- sorry but if you have zero feedback is a no-no for now

- the project SHOULD BE FINISHED by Thursday night EST (I'm in USA) so keep that in mind when bidding.

Skills: Javascript, jQuery / Prototype, MySQL, PHP

See more: jqxgrid clear, jqxgrid php, jqxgrid search, grid javascript php mysql advanced search, advanced search javascript mysql, schema form, people search work, html 5 grid, grid html 5, build mysql query, advanced search results, m communications, javascript max, index php id, php usa, php html javascript, php grid, mysql index, mysql dropdown, jqxgrid, childs, build query filters, send email php mysql, html email mysql, mysql select filter

Project ID: #2645448

Awarded to:

zeeyawebdesign

Really interested see ..ready to start right now.

$160 USD in 2 days
(58 Reviews)
6.0

5 freelancers are bidding on average $182 for this job

vsscomputers

Hi, Please check inbox for details and samples of our works done

$200 USD in 2 days
(59 Reviews)
6.0
scriptphp87

Hello Please read more than private message thank you

$200 USD in 2 days
(38 Reviews)
5.7
webisyours0602

Consider it done.

$200 USD in 2 days
(4 Reviews)
3.8
ocean1310

We are an excellent IT Consulting & Services company with excellence in Technology, Software Development and Support services.

$80 USD in 2 days
(9 Reviews)
3.5
samypogs

Let me do it sir.. I cant finish it today if you want.. 101% GOOD QUALITY!

$200 USD in 1 day
(3 Reviews)
3.3
webdeverdotnet

Hello, Los-Angeles based PHP/SQL wizard here, I am available for work immediately and can provide you with this script by thursday, please contact my PMB for more details.

$150 USD in 2 days
(3 Reviews)
3.3
kaalee

Hi we are ready to start

$200 USD in 2 days
(0 Reviews)
0.0