Is it advisable to save the formula input by the user in a database via an HTML form for reuse?

It can be advisable to save the formula input by the user in a database via an HTML form for reuse if you want to store and retrieve the formulas for future use. This can be useful for users who frequently use the same formula or for data analysis purposes. By saving the formula in a database, you can easily retrieve it when needed without the user having to input it again. 

<?php
// Assuming you have already established a database connection

if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $formula = $_POST['formula'];

    // Save the formula input by the user in a database table
    $sql = "INSERT INTO formulas (formula) VALUES ('$formula')";
    if (mysqli_query($conn, $sql)) {
        echo "Formula saved successfully!";
    } else {
        echo "Error: " . $sql . "<br>" . mysqli_error($conn);
    }
}
?>

<form method="post" action="">
    <label for="formula">Enter Formula:</label><br>
    <input type="text" id="formula" name="formula"><br><br>
    <input type="submit" value="Save Formula">
</form>

Keywords

PHP HTML form database user input formula

Related Questions