In Progress

Wordpress MySQL AJAX Form Plugin

I am interested in having a small Wordpress Plugin created which will allow me to display a form on a page, which interacts with a MySQL database. Here are the project requirements:

1. Form 1 displays the following fields:

- Load Record (dropdown - containing list of existing records in db)

- Load Button

- Create New Button

2. Form 2 displays the following fields:

- ID (readonly textbox - 10 characters)

- Full Name (editable textbox - 30 characters)

- Employed (radio button - displays a yes/no radio button choice)

- Favorite Color (dropdown - displays the choices: Red, Green, Blue)

- Save Changes Button

3. User can select an existing database record from Form 1, click Load button, and Form 2 is populated with the data from the selected record.

4. User can click the Create New button on Form 1, and Form 2 is blanked out, ready to receive input for a new record

5. User can enter/edit data in Form 2, click the Save Change button, and:

5a: If new record, then performs an insert into the MySQL database

5b: If existing record, then performs an update in the MySQL database

6. Error message is displayed if database cannot be accessed

7. Confirmation message is displayed whenever a record is loaded, updated, or inserted.

8. MySQL Database contains the following structure (can be changed if necessary to support the other project requirements):

CREATE TABLE IF NOT EXISTS `information` (

`id` int(10) NOT NULL AUTO_INCREMENT,

`fullname` varchar(30) NOT NULL,

`employed` char(1) DEFAULT NULL,

`favorite_color` varchar(20) DEFAULT NULL,

PRIMARY KEY (`id`)

)

9. Form 1 and 2 can be a single Form is easier or more efficient.

10. Form(s) are displayed on Wordpress Page using shortcode

12. Form(s) update as appropriate to display loaded records and confirmation messages, using AJAX / JQuery

Thanks for your interest!

Skills: AJAX, Javascript, MySQL, PHP, WordPress

See more: wordpress mysql form, using ajax, wordpress mysql php, mysql dropdown, load information from mysql, php mysql display existing table, display form data wordpress page, input dropdown php, jquery ajax message, wordpress mysql insert data, dropdown radio, mysql characters, php form dropdown list, save form data wordpress form, jquery load mysql, php editable form mysql, ajax list list mysql, php shortcode wordpress error, wordpress editable user page, editable mysql, jquery save database php, php mysql load table, create wordpress plugin jquery, mysql inserted, mysql save data

About the Employer:
( 4 reviews ) Colorado Springs, United States

Project ID: #5247613

Awarded to:

safakerol

Hello i am a jquery expert with strong skills in ajax and wordpress. I crated several plugins. I can build this for you.

$171 USD in 2 days
(50 Reviews)
4.8

9 freelancers are bidding on average $155 for this job

ranganalx

Do you have a mockup on how the form is supposed to look like? Hoping to hear from you. I'm keen to work on this.

$226 USD in 15 days
(315 Reviews)
7.0
akinwale

Hello, I have reviewed your requirements and I can implement a complete solution for you within 5 days. I have over 9 years of experience with PHP development and I have worked with Wordpress in the past. Quality work More

$250 USD in 5 days
(69 Reviews)
6.2
novaemp

Hello, sir I'm interested with your project. I'll do it for you. I can do it well more than you could guess. :) References: [url removed, login to view], [url removed, login to view], [url removed, login to view], http More

$206 USD in 3 days
(59 Reviews)
5.2
sameerali661

A proposal has not yet been provided

$40 USD in 3 days
(7 Reviews)
3.0
espsofttech

hello i can do this with great perfection and timely manner as per your requirement. please discuss in message. you can check my previous work at [url removed, login to view], [url removed, login to view], [url removed, login to view] , pursesva More

$150 USD in 2 days
(9 Reviews)
2.7
solutnprovider

Hi, i hv good working knoeledge of php, mysql and Ajax, can provide u best service, Please msg me to discuss things. regards

$155 USD in 3 days
(3 Reviews)
0.8
endlesswish

Hi, I am sure all of other bidders are project manager or sales person so they are not capable to give you reasonable estimate. I am an individual and professional developer who is holding always 100% completion rate.. More

$150 USD in 3 days
(7 Reviews)
0.3
rafaelnadal

hello i read all the requirements and ready for work it is very interesting task for me and also easy on so you can check my portfolio i am web developer

$90 USD in 3 days
(0 Reviews)
0.0
excel66

A proposal has not yet been provided

$111 USD in 3 days
(0 Reviews)
0.0