I have a form on my front-page. It sends the entered address to Google API and returns the JSON to wp_options. That works fine. I am using update_option to do that, so it rewrites the meta_key each time. How would I go about having each address entered remain?
$address = esc_html( $_POST['address'] );
//assign JSON object to var using geocodeing function('address') input
$address_results = gmap_geocode($address);
// transfer data to options array
$options['py_name'] = $py_username;
$options['address'] = $address;
$options['coords'] = $address_results;
// create and name the option_name and set fields with $options array
update_option( 'row_name', $options );
wp_options
table because usually the whole table is loaded into memory as it is the settings. If you have a lot of submissions, you could run out of runtime memory. The good practice is to create a new post type and then save each submission as a new post with the various fields saved as post meta.