How can PHP be used to save data from multiple form submissions in a database when the ID of the first form is not known?

When saving data from multiple form submissions in a database without knowing the ID of the first form, you can generate a unique identifier for each submission using PHP. One way to do this is by using a combination of timestamp and a random string to create a unique ID for each form submission. 

<?php
// Generate a unique ID for the form submission
$unique_id = time() . '_' . uniqid();

// Retrieve data from the form submission
$data1 = $_POST['data1'];
$data2 = $_POST['data2'];

// Connect to the database
$conn = new mysqli('localhost', 'username', 'password', 'database');

// Insert data into the database
$stmt = $conn->prepare("INSERT INTO submissions (id, data1, data2) VALUES (?, ?, ?)");
$stmt->bind_param("sss", $unique_id, $data1, $data2);
$stmt->execute();

// Close the database connection
$stmt->close();
$conn->close();
?>

Keywords

PHP form submissions database unknown ID data saving

Related Questions