I wrote this form to make a front-end form fill in the table for the store locator plus plug-in.
\nI need to take the sl_address and sl_city fields and have them geocode for sl_longitude and sl_latitude.<\/p>\n
also, the first time someone goes to the page it submits an empty line in my database table.<\/p>\n
I am newbie, so sorry if this very simple.<\/p>\n
<?php
\n \/* Template Name: Add Venue *\/
\nget_header();
\n?> <\/p>\n
<div id=”primary”>
\n<div id=”content” role=”main”> <\/p>\n
<form id=”form1″ name=”form1″ method=”post” action=””>
\n<input type=”hidden” name=”sl_id” id=”sl_id” \/>
\n<br class=”clear” \/>
\n<label for=”sl_store”>Venue<\/label><input type=”text” name=”sl_store” id=”sl_store” \/>
\n<br class=”clear” \/>
\n<label for=”sl_address”>Address<\/label><input type=”text” name=”sl_address” id=”sl_address” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_address2″ id=”sl_address2″ \/>
\n<br class=”clear” \/>
\n<label for=”sl_city”>City, State, Zip<\/label><input type=”text” name=”sl_city” id=”sl_city” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_state” id=”sl_state” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_zip” id=”sl_zip” \/>
\n<br class=”clear” \/>
\n<label for=”sl_country”>Country<\/label><input type=”text” name=”sl_country” id=”sl_country” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_latitude” id=”sl_latitude” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_longitude” id=”sl_longitude” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_tags” id=”sl_tags” \/>
\n<br class=”clear” \/>
\n<label for=”sl_description”>Description<\/label><textarea name=”sl_description” id=”sl_description” cols=”45″ rows=”5″><\/textarea>
\n<br class=”clear” \/>
\n<label for=”sl_email”>Email<\/label><input type=”text” name=”sl_email” id=”sl_email” \/>
\n<br class=”clear” \/>
\n<label for=”sl_url”>Website<\/label><input type=”text” name=”sl_url” id=”sl_url” \/>
\n<br class=”clear” \/>
\n<label for=”sl_hours”>Hours<\/label><textarea name=”sl_hours” id=”sl_hours” cols=”45″ rows=”5″><\/textarea>
\n<br class=”clear” \/>
\n<label for=”sl_phone”>Phone<\/label><input type=”text” name=”sl_phone” id=”sl_phone” \/>
\n<br class=”clear” \/>
\n<label for=”sl_fax”>Fax<\/label><input type=”text” name=”sl_fax” id=”sl_fax” \/>
\n<br class=”clear” \/>
\n<label for=”sl_image”>Image<\/label><input type=”file” name=”sl_image” id=”sl_image” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_private” id=”sl_private” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_neat_title” id=”sl_neat_title” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_linked_postid” id=”sl_linked_postid” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_pages_url” id=”sl_pages_url” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_pages_on” id=”sl_pages_on” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_option_value” id=”sl_option_value” \/>
\n<br class=”clear” \/>
\n<input type=”hidden” name=”sl_lastupdated” id=”sl_lastupdated” \/>
\n<br class=”clear” \/>
\n<input type=”submit” name=”sl_submit” id=”sl_submit” value=”Submit” \/>
\n<br class=”clear” \/>
\n<\/form><\/p>\n
<?php \/\/Post Params
\n$sl_id = $_POST[‘sl_id’];
\n$sl_store = $_POST[‘sl_store’];
\n$sl_address = $_POST[‘sl_address’];
\n$sl_address2 = $_POST[‘sl_address2’];
\n$sl_city = $_POST[‘sl_city’];
\n$sl_state = $_POST[‘sl_state’];
\n$sl_zip = $_POST[‘sl_zip’];
\n$sl_country = $_POST[‘sl_country’];
\n$sl_latitude = $_POST[‘sl_latitude’];
\n$sl_longitude = $_POST[‘sl_longitude’];
\n$sl_tags = $_POST[‘sl_tags’];
\n$sl_description = $_POST[‘sl_description’];
\n$sl_email = $_POST[‘sl_email’];
\n$sl_url = $_POST[‘sl_url’];
\n$sl_hours = $_POST[‘sl_hours’];
\n$sl_phone = $_POST[‘sl_phone’];
\n$sl_fax = $_POST[‘sl_fax’];
\n$sl_image = $_POST[‘sl_image’];
\n$sl_private = $_POST[‘sl_private’];
\n$sl_neat_title = $_POST[‘sl_neat_title’];
\n$sl_linked_postid = $_POST[‘sl_linked_postid’];
\n$sl_pages_url = $_POST[‘sl_pages_url’];
\n$sl_pages_on = $_POST[‘sl_pages_on’];
\n$sl_option_value = $_POST[‘sl_option_value’];
\n$sl_lastupdated = $_POST[‘sl_lastupdated’]; <\/p>\n
?>
\n<?php \/\/Query <\/p>\n
\/\/INSERT
\n $query = ” INSERT INTO bqk_store_locator ( sl_id, sl_store, sl_address, sl_city, sl_country, sl_description, sl_email, sl_url, sl_hours, sl_phone, sl_fax, sl_image ) VALUES ( ‘$sl_id’, ‘$sl_store’, ‘$sl_address’, ‘$sl_city’, ‘$sl_country’, ‘$sl_description’, ‘$sl_email’, ‘$sl_url’, ‘$sl_hours’, ‘$sl_phone’, ‘$sl_fax’, ‘$sl_image’ ) “;
\n $result = mysql_query($query); <\/p>\n
if( $result )
\n {
\n \techo ‘Success’;
\n }
\n else
\n {
\n \techo ‘Query Failed’;
\n }<\/p>\n
?>
\n<\/div><!– #content –>
\n<\/div><!– #primary –>
\n<?php get_footer(); ?><\/p>\n","protected":false},"template":"","class_list":["post-4421573","topic","type-topic","status-closed","hentry","topic-tag-database","topic-tag-geocoding"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4421573","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":0,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/4421573\/revisions"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=4421573"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}