Databases
StackOverflow2013
Postsdbo
POCollect form data for ajax submission
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POCollect form data for ajax submission
    primarykey
    data
    text
    <p>I have a database which has over 50 items in it which need to be checked and possibly edited. I have a web page which pulls the data from the database using php and displays it as values in a webform. Then I have a series of submit buttons at the bottom of the page, depending on what the user wants to do. Each button uses an onclick method to call a javascript function.</p> <p>In the case where some changes need to be made, the user will make edits directly in the webform. For example, in a textarea, the value of the textarea will display the current content of the database item. The user can then edit the content. Clicking a "Save Changes" button calls an ajax function to send the data back to the server using a POST request. </p> <p>The problem I am having, probably simple to someone who knows how, is how to collect all the updated data from the different form components to send to the server in the variable "FormData" below (presumably an array). Is there a way to do this all at once, or do I have to step through every one of the form elements and add them to the array one by one? "msg" refers to a <code>&lt;div id="msg"&gt;&lt;/div&gt;</code> where a message from the server page will be displayed.</p> <p>My ajax function so far is:</p> <pre><code>function callsave() { var xmlHttp, FormData; xmlHttp = new XMLHttpRequest; xmlHttp.onreadystatechange = function () { if (xmlHttp.readyState == 4 &amp;&amp; xmlHttp.status == 200) { document.getElementById("msg").innerHTML = xmlHttp.responseText; } } xmlHttp.open("POST", "savechanges.php", true); xmlHttp.setRequestHeader("Content-Type", "application/x-www-form-urlencoded"); xmlHttp.send(FormData); } </code></pre> <p>The submit button at the end of the form is:</p> <pre><code>&lt;input type="button" value="Save Changes" id="save" onClick="callsave();"&gt; </code></pre> <p>Many thanks for pointing me in the right direction. BTW, this is my first ajax coding.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USArturs
    1. USJohn
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POCollect form data for ajax submission
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    2. VO
      singulars
      1. POCollect form data for ajax submission
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. POCollect form data for ajax submission
      1. USuser2173353
      1. VTFavorite
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload