Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `racecd_cbzipcode` (
- `zipcode` varchar(5) NOT NULL,
- `latitude` double DEFAULT NULL,
- `longitude` double DEFAULT NULL,
- KEY `zipcode` (`zipcode`)
- ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
- global $wpdb;
- $wpdb->cbzipcode = $wpdb->prefix.'cbzipcode';
- function zipcodes_exists($field, $value) {
- global $wpdb;
- if($field == 'zipcode') { $value = $value;}
- if(empty($value)) return false;
- if ( !$result = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->cbzipcode WHERE $field = %s", $value) ) )
- return false;
- return $result;
- }
- function zipcodes_latlng($value) {
- global $wpdb;
- $field = 'zipcode';
- if(empty($value)) return false;
- if ( !$result = $wpdb->get_row( $wpdb->prepare("SELECT latitude, longitude FROM $wpdb->cbzipcode WHERE $field = %s", $value) ) )
- return false;
- return $result;
- }
- //access data
- $latlng = zipcodes_latlng($zipcode);
- if($latlng != false){
- update_user_meta($user_id, "latitude", $wpdb->prepare($latlng->latitude));
- update_user_meta($user_id, "longitude", $wpdb->prepare($latlng->longitude));
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement