How can a PHP form be used to enter and store product information in an Access database?

To enter and store product information in an Access database using a PHP form, you can create an HTML form with input fields for the product details. When the form is submitted, the PHP script can connect to the Access database using the ODBC driver and insert the submitted data into the appropriate table. 

<?php
// Establish connection to Access database
$conn = odbc_connect('Driver={Microsoft Access Driver (*.mdb)};Dbq=path/to/your/database.mdb', '', '');

// Check if the form is submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Retrieve form data
    $product_name = $_POST['product_name'];
    $price = $_POST['price'];
    $description = $_POST['description'];

    // Insert data into the database
    $query = "INSERT INTO products (product_name, price, description) VALUES ('$product_name', '$price', '$description')";
    odbc_exec($conn, $query);

    // Close connection
    odbc_close($conn);
}
?>

<form method="post" action="">
    <label for="product_name">Product Name:</label>
    <input type="text" name="product_name" id="product_name"><br><br>

    <label for="price">Price:</label>
    <input type="text" name="price" id="price"><br><br>

    <label for="description">Description:</label>
    <textarea name="description" id="description"></textarea><br><br>

    <input type="submit" value="Submit">
</form>

Keywords

PHP form submission Access database SQL injection data validation

Related Questions