How can dropdown menu values from an SQL table be saved in another table using PHP?

To save dropdown menu values from an SQL table in another table using PHP, you can retrieve the selected value from the dropdown menu using $_POST, then insert that value into the desired table in the database using SQL queries. 

<?php
// Retrieve the selected dropdown value from the form
$selectedValue = $_POST['dropdown_menu'];

// Connect to the database
$connection = mysqli_connect('localhost', 'username', 'password', 'database_name');

// Insert the selected value into another table
$query = "INSERT INTO another_table (column_name) VALUES ('$selectedValue')";
mysqli_query($connection, $query);

// Close the database connection
mysqli_close($connection);
?>

Keywords

PHP SQL dropdown menu database data insertion

Related Questions