Advertisement
manchumahara

Zipcode Table

Aug 5th, 2012
145
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.12 KB | None | 0 0
  1. CREATE TABLE IF NOT EXISTS `racecd_cbzipcode` (
  2.   `zipcode` varchar(5) NOT NULL,  
  3.   `latitude` double DEFAULT NULL,
  4.   `longitude` double DEFAULT NULL,
  5.   KEY `zipcode` (`zipcode`)
  6. ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  7.  
  8.  
  9. global  $wpdb;
  10. $wpdb->cbzipcode = $wpdb->prefix.'cbzipcode';
  11. function zipcodes_exists($field, $value) {
  12.     global $wpdb;
  13.         if($field == 'zipcode') { $value = $value;}
  14.         if(empty($value)) return false;
  15.     if ( !$result = $wpdb->get_row( $wpdb->prepare("SELECT * FROM $wpdb->cbzipcode WHERE $field = %s", $value) ) )
  16.         return false;  
  17.     return $result;
  18. }
  19.  
  20. function zipcodes_latlng($value) {
  21.     global $wpdb;
  22.         $field = 'zipcode';
  23.         if(empty($value)) return false;
  24.     if ( !$result = $wpdb->get_row( $wpdb->prepare("SELECT latitude, longitude FROM $wpdb->cbzipcode WHERE $field = %s", $value) ) )
  25.         return false;
  26.     return $result;
  27. }
  28.  
  29. //access data
  30. $latlng = zipcodes_latlng($zipcode);
  31.     if($latlng != false){
  32.         update_user_meta($user_id, "latitude", $wpdb->prepare($latlng->latitude));
  33.         update_user_meta($user_id, "longitude", $wpdb->prepare($latlng->longitude));
  34.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement