JQUERY/AJAX Dynamic Row MySQL insert/update/delete

Completado Publicado Aug 2, 2014 Pagado a la entrega
Completado Pagado a la entrega

Hey there, I have a script based on this model ([url removed, login to view]) working fine just straight JQUERY - PHP/MySQL.

I like this however, I am wanting the data to post via AJAX. I am a little weak when it comes to building arrays and need assistance with this part. I have included my DB structure and an outline of process I would like to have happen. I want the user to be able to enter an the Name, TimeStart( mySQL DATETIME), TimeFinish (mySQL DATETIME), and Price. I have other tabs submitting data via AJAX however no arrays being used, and its the array part that gets me confused.

This should be a really solution for someone versed in AJAX and working with dynamic rows building that data into an array and inserting/updating/ or deleting from mySQL.

Process:

User fills in the row of data (name, dateS, dateF, cost), then selects to add a new row (this row dynamically create and allow the user to enter another row of data.) Once all rows of data are created dynamically, user will submit these rows to the database. I have included mySQL structure as well as the form and the layout I want it to appear. Let me know if you can do this I would love to have this done today!

I also have another JQUERY/AJAX/Dynamic situation I need to get coded as well involving a mutiple image upload and gallery display script that I will use you for if this one is good.

MySQL Structure -

rID (primary int 8 autoincrement)

pID (taken from the $_SESSION['someID'];)

pName varchar255

pDateS DATETIME (Y-m-d H:i:s)

pDateF DATETIME (Y-m-d H:i:s)

pCost varchar255

Form Data-

<fieldset id="addRatesPropertyForm">

<div id="itemRows">

Rate Name: <input type="text" name="rName" /><br />

Date Start: <input type="date" name="rDateS" />

Date End: <input type="date" name="rDateF" /><br />

Rate Price: &nbsp;$<input type="text" name="rCost" size="6" />

Min Nights: <input type="text" name="minNights" /><br />

<input onClick="addRow([url removed, login to view]);" type="button" class="button orange" value="Add Rate Timeline" />

<br />

<hr />

<button id="bindRates_Submit" name="ok" class="green button">Bind these Rates to Property</button>

</fieldset>

AJAX MySQL PHP Arquitectura de software

Nº del proyecto: #6267563

Sobre el proyecto

6 propuestas Proyecto remoto Activo Aug 2, 2014

Adjudicado a:

siddhu1986

Hi, Experienced Web Developer. Good with PHP/MySQL/AJAX. I can fix the issue for you in good time :) Regards, Sid

$98 USD en 0 días
(212 comentarios)
6.8

6 freelancers están ofertando un promedio de $111 por este trabajo

vgulshan

A proposal has not yet been provided

$111 USD en 2 días
(7 comentarios)
3.0
Junaid315

Hello i am mysql and jquery expert i do such assignments all day please hire me for best results.....

$138 USD en 3 días
(0 comentarios)
0.0
princerae2010

A proposal has not yet been provided

$88 USD en 1 día
(0 comentarios)
0.0
rocksbadu

A proposal has not yet been provided

$111 USD en 1 día
(0 comentarios)
0.0