I need to get the Index Of a php Do While to update the right record via Ajax

I have a form which has a while statement. On each record I have an input form field in which you can change the price, which when tabbed performs an AJAX call that Updates the record in the db. It works, but only only on the last record always because I don't know how to get the Index Of the record I'm changing onBlur and pass that value. Actually, I need it to get the ID of the Record and pass it on to the AJAX function and the PHP file handling the update. Let me know when you have time. It's a simple thing for you that I don't know how to do. That's as far as I got it. You'll see a SESSION which grabs the last record ID, which I know is wrong, but I don't know how to pass the ID value of the record from the one I update on the input field otherwise.

There are a bunch of ways you could do it. You could have a <form> tag on each row and then have a hidden form element that contains the ID and then your javascript could find the parent form for the selected price and then drill back down into that form to find the associated hidden form element to include it in your AJAX form submission.

I have a few more glitches to resolve before I present finalized working form to my boss on Thursday. I tried what you said above. It's already encased in a form so I added the hidden field and tried to get it on the AJAX but not working yet. However I have a few more things (been here countless hours) that I need to resolve.

1) I need to create an auto PDF,to which I applied same code as we did (you helped me with on another form and it works), but I've changed all the variables for this form but I'm getting the http 500 error when I try to run.

2) For some reason the CKEditor field won't get into the db even though I have the id and name applied correctly.

3) It won't upload file even though I have the Multi part form and all the fields named correctly

4) I have a button to email the form when it's done submitting but it cuts off after a URI value is passed.

I think once I finish these 4 items, I will be able to finalize usable form.

Anyways, I have to run out but I wanted to give you an overview. I can give you access maybe but I have turn out for now.

Thank you.

We should set up a premier support ticket and do screen sharing to look into these issues. It shouldn't take more than an hour to debug and fix all of them.

ok. let me know what time is good for you Thanks.

Let me know if we can try these tonight. It's probably going to take at most an hr. I know exactly the four issues which I'm quite sure will take you a few min each (there's 4). I just need to show it to you so you can put in the right code.My meeting is tomorrow am so if I can get at least two out of four it would be great. Thanks.

I'm available tonight... just post a good number and time to reach you, or call me using the number at the bottom of the site.

ok

Yes. I'm available today until 5pm pst. You can just call me when you are ready to schedule.

On this function here:

<script>
function changeOptsQty(str,optid,opttotalprice) {
if (str == "") {
document.getElementById("TotalOptsPrice").innerHTML = "";
return;
} else {
xmlhttp = new XMLHttpRequest();
xmlhttp.onreadystatechange = function() {
if (this.readyState == 4 && this.status == 200) {
document.getElementById("TotalOptsPrice").innerHTML = this.responseText;
}
};
xmlhttp.open("GET","changeOptsQty.php?q="+str + "&OptIDhid=" + optid + "&OptTotalPrice=" + opttotalprice ,true);
xmlhttp.send();
}
}
</script>

Where does the optid vaue parameter come from? I'm trying to do the next one opttotalprice but it doesn't work for me. So, if I understand where the optid comes from, maybe I can get it to work.

This is the line with the link:

echo "<td>" . "<input type='number' " . "min='1'". "class='formTextfield_Small' ". " . 'id='qtyopt' " . "name='qtyopt' " . "value='" . $WADAoptionalsrecords->getColumnVal('quantity') . "' " . "onBlur=changeOptsQty(this.value,".$WADAoptionalsrecords->getColumnVal('optional_id').")" . ">". "</td>";


Thanks.