Devam Ediyor

Jquery autocomplete

Hello,

I need a PHP page scripted that takes form input from a user. The design of the page doesn't matter; I will move your code into my own page design. I require someone with php/mysql/jquery knowledge as I don't want the page to refresh as queries to the database occur.

Data to be captured in the form:

-Incident Number (textbox)

-Short Description (Text area)

-Start Date and Time (textbox - but on click it pops up a jquery datepicker and timepicker [Black and grey theme])

-End Date and Time (textbox - but on click it pops up a jquery datepicker and timepicker [Black and grey theme])

-Priority (Drop down list... I will add my own values but for now one option can be 1 and the other 2)

-Link to Investigation (drop down list... options queried from a mysql table displayed below)

-Link to CI (textbox with autcomplete and an add button)

---------------------

More Details

---------------------

*** Link to investigation drop down ***

Values in the "Link to investigation" drop down list are read from a mysql database called "Problem Management". The connection string to connect to this database already exists and can be included in the script that you code for me by include('[url removed, login to view]'). The table in the database is called "problem". Among other fields in this table, the three fields that need to be queried are

*problem_id (Primary Key)

*problem_number

*problem_short

So the HTML code for the drop down field will need to be

<option value=$problemdisplay[problem_id]>$problemdisplay[problem_number] - $problemdisplay[problem_short]</option>

_______________________________________________________

*** "Link to CI" - jquery autocomplete text box ***

Using jquery's autocomplete text box functionality I would like to type in certain values into a text box and have suggestions made based on my input. The suggestions should come from another mysql table which i will detail in a moment. When the user selects one of the suggestions they can click the add button. Each time they click the add button, their selection should appear below the autocomplete button with button beside it saying remove. Users can continue to add/remove entries but each time they add or remove, their selections are not yet committed to a database (which I will detail in a moment). No Refreshing please, all to be done with jquery with all background processing. Users can only pick suggestions; if they type something that is not a suggestion - it is not to be committed back to the database from which the suggestions come from.

table for which suggestions should come from "ci" - same database via [url removed, login to view] as above

Suggestions should be based on ci_name

Fields:

*ci_id (primary key)

*ci_name

_____________________________________________________

*** Submitting the form ***

When the user submits the form; four things need to occur

1 - A table called "incident" needs to be inserted with:

*incident_id (int)(pk) <-- This is autoincrement so no need to specify

*incident_number (int) <-- From the Incident Number textbox above

*incident_short (text) <-- From the Short Description text area above

*incident_start (datetime) <-- From Start Date and time above

*incident_end (datetime) <-- From End Date and time above

*incident_priority (int) <-- From Priority drop down list above)

2 - The table called rel_incident_problem needs to be updated with a new record:

*rel_incident_problem_id (int)(pk) <-- This is autoincrement so no need to specify

*incident_id (int) <-- From the incident_id generated by the previous query where incident details were inserted into the incident table

*problem_id (int) <-- From the problem_id that was active in the drop down box

3 - The table called rel_incident_ci needs to be inserted with a new record for each CI that was added via the autocomplete text box

*rel_incident_ci_id (int)(pk) <-- This is autoincrement so no need to spcecify

*incident_id (int) <-- From the incident_id generated by the query where incident details were inserted into the incident table

*ci_id (int) <-- From the CI that was added

4 - After successful submission there should be a message on the top of the page stating that the query was successful or was not successful. The form should be blanked so that they can insert another record.

Thanks and Regards,

Jeremy

Beceriler: jQuery / Prototype, MySQL, PHP

Daha fazlasını görün: jquery autocomplete, autocomplete jquery, jquery autocomplete php, mysql autocomplete, jquery autocomplete mysql, autocomplete php mysql, autocomplete php, jquery autocomplete table, jquery autcomplete text value, jquery timepicker, mysql database query jquery autocomplete textbox, autocomplete php form value link, jquery autocomplete php mysql, jquery autocomplete suggestions, jquery autocomplete link, jquery using autocomplete, php jquery autocomplete, jquery autocomplete box, jquery autocomplete text, autocomplete jquery mysql, jquery autocomplete refresh, jquery autocomplete using, jquery autocomplete grey text, jquery option refresh autocomplete, value options

İşveren Hakkında:
( 5 değerlendirme ) Melbourne, Australia

Proje NO: #702413

Seçilen:

dalliance

Hi, I am experienced in developing PHP, Mysql and jquery websites. I can develop that for you.

0 gün içinde 30$ USD
(1 Değerlendirme)
1.0

21 freelancer bu iş için ortalamada 81$ teklif veriyor

arnab0143

-- Please check your pm. Thanks. --

1 gün içinde 40$ USD
(68 Değerlendirme)
6.6
cristalmedia

I can deliver it online in 3 hours. Don't let other coders take your money for something that can be done really fast in a professional way. Best Regards, alejandro

1 gün içinde 40$ USD
(36 Değerlendirme)
5.3
phpSQLexpert

Hi, 6 yrs working experience in ecommerce. php & mysql expertise. Please check inbox for demo. Serious bidder. Cheers,

in 3 gün içinde100$ USD
(18 Değerlendirme)
4.6
natalik

Hi! I can do this job. Working with php/mysql, CSS/html, AJAX, jquery. I guarantee structured annotated code and responsible attitude to work. Welcome!

in 3 gün içinde70$ USD
(11 Değerlendirme)
4.5
Oldo

I can code this for you

in 2 gün içinde50$ USD
(4 Değerlendirme)
3.9
phptechselva

Having 5+ years of experience in web development. Looks forward to work with you.

in 3 gün içinde50$ USD
(1 Değerlendirme)
1.4
LeventeGal

Hi, I've 3yrs+ experience in object oriented javascript(ExtJs, jQuery)and php ajax based webapp development.

in 2 gün içinde50$ USD
(2 Değerlendirme)
1.0
blur5design

Hi plase view pmb for details.

in 2 gün içinde100$ USD
(0 Değerlendirme)
0.0
mizanurislam

Hi, I am Mizanur Islam Laskar from Bangladesh, working as a web professional on PHP/MySQL for 7 years. Please checkout your PM to learn about my offers, portfolio, etc. Thanks.

in 4 gün içinde200$ USD
(0 Değerlendirme)
0.0
ranadiplodh123

I can do it.. just give me details.

1 gün içinde 100$ USD
(1 Değerlendirme)
0.0
combattant1

Please check your pm

in 3 gün içinde80$ USD
(0 Değerlendirme)
0.0
welcomlatif

Hi, I am experienced developer have completely implemented the jquery plugin you want. It will be an easy task for me to complete.

1 gün içinde 80$ USD
(0 Değerlendirme)
0.0
zendboss

hi we always think the quality of our job we dont take any risky deadline like 1 day 2 hour we take long time but work faster ...

in 4 gün içinde120$ USD
(0 Değerlendirme)
0.0
mobihunterz

Hi, We've nearly 1.5 years experience of developing iPhone/android/windows mobile applications cum website development. We've created applications related to Book reading, Video Streamming & Play, Alarm and Slideshow a Daha fazlası

in 3 gün içinde100$ USD
(0 Değerlendirme)
0.0
mbrother

I am currently working on such kind of projects.i can complete this job within provided time frame

1 gün içinde 50$ USD
(0 Değerlendirme)
0.0
akhkharu

Greetings from Russia, We are the PHP and Ruby on Rails development company. Our major skills are Ruby on Rails agile development and PHP development with symfony and CodeIgniter frameworks. Also we are good at fro Daha fazlası

in 7 gün içinde80$ USD
(0 Değerlendirme)
3.8
shafiqkr

Having 2 years of experience in web development. Looks forward to work with you.

in 6 gün içinde100$ USD
(0 Değerlendirme)
0.0
yojako

I'm confident that I can do this job if you will give me a chance. thank you. God Bless

in 2 gün içinde50$ USD
(0 Değerlendirme)
0.0
ImpetusDrive

Please quickly check PM.

in 0 gün içinde200$ USD
(1 Değerlendirme)
0.0
oswebservice

It is easy job, allow me help you, thanks

1 gün içinde 30$ USD
(1 Değerlendirme)
0.0