What are the best practices for storing values from radio buttons in PHP forms in a normalized database?

When storing values from radio buttons in PHP forms in a normalized database, it's important to ensure that the data is properly sanitized to prevent SQL injection attacks. One approach is to store the selected value as an integer representing the option chosen, rather than storing the actual text of the option. This helps in keeping the database normalized and reduces redundancy. 

// Assuming $selectedOption contains the value selected from the radio buttons
$selectedOption = $_POST['radio_option']; // Assuming 'radio_option' is the name attribute of the radio buttons

// Sanitize the input to prevent SQL injection
$selectedOption = intval($selectedOption);

// Now you can insert $selectedOption into your normalized database table
// For example:
$query = "INSERT INTO options_table (selected_option) VALUES ($selectedOption)";
// Execute the query using your database connection

Keywords

PHP radio buttons forms normalized database data storage

Related Questions