How can a Save button outside a form in PHP be used to submit form data to a database?

To submit form data to a database using a Save button outside a form in PHP, you can use JavaScript to gather the form data and then send it to a PHP script that handles the database insertion. This can be achieved by using AJAX to make an asynchronous request to the PHP script when the Save button is clicked. The PHP script will then receive the form data, sanitize it to prevent SQL injection, and insert it into the database. 

```php
<!-- HTML form -->
<form id="myForm">
  <input type="text" name="data1">
  <input type="text" name="data2">
</form>

<!-- Save button outside form -->
<button id="saveBtn">Save</button>

<script>
document.getElementById('saveBtn').addEventListener('click', function() {
  var formData = new FormData(document.getElementById('myForm'));
  
  var xhr = new XMLHttpRequest();
  xhr.open('POST', 'save_data.php', true);
  xhr.onload = function() {
    if (xhr.status >= 200 && xhr.status < 300) {
      alert('Data saved successfully');
    } else {
      alert('Error saving data');
    }
  };
  xhr.send(formData);
});
</script>
```

In the PHP script (save_data.php), you can retrieve the form data using $_POST, sanitize it, and insert it into the database. Remember to use prepared statements or parameterized queries to prevent SQL injection.

Keywords

PHP form submission database AJAX event handling

Related Questions