How can a PHP developer ensure that the database structure is normalized when storing values from radio buttons in PHP forms?

When storing values from radio buttons in PHP forms, a PHP developer can ensure that the database structure is normalized by creating a separate table to store the options for the radio buttons and then linking the selected option to the main table using a foreign key. This way, each option is stored only once in the database, reducing redundancy and ensuring data integrity. 

// Create a table to store radio button options
CREATE TABLE radio_options (
    id INT PRIMARY KEY,
    option_name VARCHAR(255)
);

// Insert options into the radio_options table
INSERT INTO radio_options (id, option_name) VALUES (1, 'Option 1');
INSERT INTO radio_options (id, option_name) VALUES (2, 'Option 2');
INSERT INTO radio_options (id, option_name) VALUES (3, 'Option 3');

// Create a main table to store form data
CREATE TABLE form_data (
    id INT PRIMARY KEY,
    option_id INT,
    FOREIGN KEY (option_id) REFERENCES radio_options(id)
);

// Insert form data with selected option
INSERT INTO form_data (id, option_id) VALUES (1, 1);

Keywords

PHP database normalization radio buttons form submission data storage

Related Questions