Buying PHP + jQuery Ajax

Hi Guys,

I need someone to write some php and jquery code. The work is quite simple, write the php and jQuery code for a page to edit the following MySQL table:

CREATE TABLE `checks` (

`id` INT(11) NOT NULL AUTO_INCREMENT,
`user_id` INT(11) NOT NULL,
`active` CHAR(1) NOT NULL,
`type` INT(11) NOT NULL,
`host` VARCHAR(200) NOT NULL,
`port` INT(11) NOT NULL,
`path` VARCHAR(250) NOT NULL,
`resolution` INT(11) NOT NULL,

PRIMARY KEY (`id`),
FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
KEY (`active`),
KEY (`resolution`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

`id` is hidden to the user. It's used to identify the check.

`user_id` is hidden to the user. It comes from a cookie called user_id. You should filter the records to only show what is relevant the current user.

`active` is a checkbox. It's stored as 'Y' or 'N' in the database. If it's N, the line should be dimmed.

`type` is a multiple selection choice. It can be 1 for 'port' or 2 for 'web'.

`host` is a string.

`port` is a multiple selection choice. It can be 80 for 'http', 443 for 'https' or 25 for 'smtp'.

`path` is a string

`resolution` is a multiple selection choice. It can be 5 for '5 mns', 10 for '10 mns', 15 for '15 mns', 20 for '20 mns', 30 for '30 mns' or 60 for '1 hour'.

There will be 2 php files:
- checks.php which will display the page
- checks.ajax.php which will handle the ajax calls

You need to use following technology:
- MySQL using ezSQL (http://justinvincent.com/ezsql)
- jQuery (http://jquery.com/)
- jQuery UI (http://jqueryui.com/)
- DataTables (http://www.datatables.net/)

ezSQL will be used to access the database.

DataTables will be used to display the list. You should assume that this list will be very large, so it needs to be managed on server side. There's a DataTables example that show how to do that.

There should be a button to add a new check. That button will open a jQuery UI window with a form to add the check.

There should be a button to add a new check. That button will open a jQuery UI window with a form to add the check.

There should be a button to delete the selected check. That button will open a jQuery UI window to ask for confirmation before deleting the check.

The whole thing should use jQuery UI theme roller so the appearance can easily be changed.

PM with a bid if you are interested.

Cheers,
JB

 

Also, there's going to be more work after that one.

 

Got someone working on that