PHP MySQL JavaScript Advanced Search and jqxGrid jQuery Plugin

Closed

Description

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 3 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 jQuery plugin 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]

3. With the above results when someone clicks on a row I need a form to allow them to edit every row.

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 - 3 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 filter row options, jqxgrid php mysql, php jquery advanced search, php mysql jquery database advanced search, jquery jqxgrid mysql page, advanced search jquery php mysql, jquery php mysql advanced search, search plugin jquery, schema form, people search work, jquery search plugin, jquery 1.11 2, html 5 grid, grid html 5, build mysql query, advanced search results, m communications, javascript to edit page, javascript page edit, javascript max, edit page javascript, index php id, php usa, php mysql javascript jquery, php html javascript

Project ID: #2658717

Awarded to:

wsfreelanzer

HI, i am PHP Developer. I reviewed your i can do this project. Please check more details on private message. Thanks, Raj

$80 USD in 1 day
(41 Reviews)
5.7

18 freelancers are bidding on average $174 for this job

minhhoangduc

Thank you for inviting me, I'm a PHP, CSS, HTML, JQuery expert certified professional coder and having a lot of experience with this jobs. Please check my resume. Please let me help you do your project. Thanks More

$200 USD in 2 days
(481 Reviews)
7.9
webedeveloper

Experienced and serious team specializing in open sources like wordpress, joomla, Open Cart, PHP Frameworks like Yii, Zend, CakePHP, CodeIgniter, Seagull, Symfony and more with latest web trends and standards. Our tea More

$220 USD in 5 days
(80 Reviews)
6.8
keiespro

I can do it. ready to start now.

$250 USD in 3 days
(123 Reviews)
6.3
webzin

Hi Have Gone through your requirement and understood, we are very sure that we can do your needs with your entire satisfaction. We have left a PMB for you plz feel free to have a look over there. Thnx Ram Webzin I More

$250 USD in 7 days
(52 Reviews)
6.2
Soolved

Hi, I can do this project for you. And pls check your pmb for more detail. many thank.

$180 USD in 5 days
(67 Reviews)
6.1
techwelfare

Hi we checked your requirement,We could develop as per your need. u could check that out. we would work till your satisfaction. Thanks & Regards Techwelfare Please check inbox for our previous work.

$158 USD in 5 days
(41 Reviews)
5.9
leomedina01

**** Hi sir, I have done a similar project recently. More details in pmb. I'm an experienced Web Developer having worked for 4+ years with PHP, Java, Solr/Lucene, Sphinx Search, Smarty, MySQL, SQL Server, ASP, JavaScr More

$140 USD in 2 days
(49 Reviews)
5.7
mdjavedakhtar

hi thanks for invitation please check pmb

$150 USD in 3 days
(22 Reviews)
5.3
profyguy

we can just do it. alex.

$249 USD in 2 days
(32 Reviews)
5.1
Manhoc

Expert in PHP. PLease check inbox. Thanks, Sushil

$150 USD in 2 days
(23 Reviews)
4.7
mywebdeveloper

We have an example for you that we developed for a project :).. please check pmb for all

$200 USD in 5 days
(2 Reviews)
4.5
esafeguard

Hi. I'm a JavaScript/AJAX expert and PHP programmer. Ready to start work. Regards.

$250 USD in 5 days
(9 Reviews)
4.3
xenixphp

please check pmb....thanks

$200 USD in 4 days
(4 Reviews)
3.7
samypogs

I can do it sir..

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

Ready to start right now......please consider my bid ......

$70 USD in 2 days
(6 Reviews)
2.2
yuvsharma

Please check PMB

$200 USD in 3 days
(1 Review)
2.1
TianXiong

I can start your job immediately and finish it very shortly.

$80 USD in 2 days
(0 Reviews)
0.0
kingryan

i'm new here but i have a good experiences in php and sql i hope you choose me for the job but to make it clear what you want i search with filters of tables ? thanks

$150 USD in 3 days
(0 Reviews)
0.0