close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

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

Thread began 5/18/2020 5:26 pm by lr_leal239405 | Last modified 5/27/2020 10:46 pm by Ray Borduin | 59 views | 10 replies |

lr_leal239405

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

lr_leal239405

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

lr_leal239405

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

Sign in to reply to this post

lr_leal239405

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.

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post
Did this help? Tips are appreciated...

lr_leal239405

ok

Sign in to reply to this post

Ray BorduinWebAssist

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

Sign in to reply to this post
Did this help? Tips are appreciated...

lr_leal239405

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.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...