Go pro Author: ifyouknowit.com Version: 1.0 Author URI: http://www.ifyouknowit.com/ Donate link: http://www.ifyouknowit.com/ */ class mapWorks{ private $my_plugin_screen_name; private static $instance; static function GetInstance() { if (!isset(self::$instance)) { self::$instance = new self(); } return self::$instance; } public function PluginMenu() { $this->my_plugin_screen_name = add_menu_page( 'MAP Works', 'MAP Works', 'manage_options', __FILE__, array($this,'RenderPage') ); add_submenu_page(__FILE__, 'Add entities', 'Add entities', 'manage_options', __FILE__.'/addentities',array($this,'fn_addscreen')); } public function mygeocode($address){ $mybase_url = "https://maps.googleapis.com/maps/api/geocode/json?"; $request_url = $mybase_url . "&address=" . urlencode(trim($address)); if(extension_loaded("curl") && function_exists("curl_init")) { $cURL = curl_init(); curl_setopt($cURL, CURLOPT_URL, $request_url); curl_setopt($cURL, CURLOPT_RETURNTRANSFER, 1); $resp_json = curl_exec($cURL); curl_close($cURL); } else{ $resp_json = file_get_contents($request_url) or die("url not loading"); } $resp = json_decode($resp_json, true); $status = $resp['status']; $lat = (!empty($resp['results'][0]['geometry']['location']['lat']))? $resp['results'][0]['geometry']['location']['lat'] : "" ; $lng = (!empty($resp['results'][0]['geometry']['location']['lng']))? $resp['results'][0]['geometry']['location']['lng'] : "" ; if(strcmp($status, "OK") == 0){ $geocode_pending = false; $lat = $resp['results'][0]['geometry']['location']['lat']; $lng = $resp['results'][0]['geometry']['location']['lng']; } else { $lat=''; $lng=''; } $info['lat']=$lat; $info['lng']=$lng; return $info; } public function fn_addscreen(){ global $wpdb; if(isset($_POST['eid'])){ $eid = $_POST['eid']; $table_name = $wpdb->prefix . 'mapworks_tbl'; $edits=$wpdb->get_results("SELECT * FROM ".$table_name." WHERE id = $eid",ARRAY_A); } $did = $_POST['did']; if($did){ $table_name = $wpdb->prefix . 'mapworks_tbl'; $wpdb->delete($table_name,array('id'=>$did)); $location=get_site_url()."/wp-admin/admin.php?page=mapworks/mapworks.php"; echo ""; exit(); } if(isset($_POST['save'])){ $address=$_POST['street'].','.$_POST['city'].','.$_POST['state'].','.$_POST['country']; $info=$this->mygeocode($address); $table_name = $wpdb->prefix.'mapworks_tbl'; $eid = $_POST['eid']; if($eid){ $x=$wpdb->update( $table_name, array( 'time' => current_time('mysql'), 'yourname' => $_POST['yourname'], 'city' => $_POST['city'], 'state' => $_POST['state'], 'country' => $_POST['country'], 'street' => $_POST['street'], 'latitude' => $info['lat'], 'longitude' => $info['lng'], ), array('id'=>$eid) ); $location=get_site_url()."/wp-admin/admin.php?page=mapworks/mapworks.php"; echo ""; exit(); } else { $wpdb->insert( $table_name, array( 'time' => current_time('mysql'), 'yourname' => $_POST['yourname'], 'city' => $_POST['city'], 'state' => $_POST['state'], 'country' => $_POST['country'], 'street' => $_POST['street'], 'latitude' => $info['lat'], 'longitude' => $info['lng'], ) ); $location=get_site_url()."/wp-admin/admin.php?page=mapworks/mapworks.php"; echo ""; } } else { ?>

Add locations

Name
'>
Street
City
State
Country
prefix . 'mapworks_tbl'; $results=$wpdb->get_results("SELECT * FROM ".$table_name." WHERE street LIKE '%$stext%'",ARRAY_A); ?>

List of entities

NameStreetCityStateCountryLatLongAction
Edit | Delete
InitPlugin(); global $jal_db_version; $jal_db_version = '1.0'; function mapworks_install() { global $wpdb; global $mapworks_db_version; $table_name = $wpdb->prefix . 'mapworks_tbl'; $charset_collate = $wpdb->get_charset_collate(); $sql = "CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, yourname tinytext NOT NULL, city varchar(55) DEFAULT '' NOT NULL, state varchar(55) DEFAULT '' NOT NULL, street text NOT NULL, country varchar(55) DEFAULT '' NOT NULL, latitude varchar(55) DEFAULT '' NOT NULL, longitude varchar(55) DEFAULT '' NOT NULL, UNIQUE KEY id (id) ) $charset_collate;"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta($sql); add_option('mapworks_db_version', $mapworks_db_version ); $installed_ver = get_option("mapworks_db_version" ); if ( $installed_ver != $mapworks_db_version ) { $table_name = $wpdb->prefix . 'mapworks_tbl'; $sql = "CREATE TABLE $table_name ( id mediumint(9) NOT NULL AUTO_INCREMENT, time datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, yourname tinytext NOT NULL, city varchar(55) DEFAULT '' NOT NULL, state varchar(55) DEFAULT '' NOT NULL, street text NOT NULL, country varchar(55) DEFAULT '' NOT NULL, latitude varchar(55) DEFAULT '' NOT NULL, longitude varchar(55) DEFAULT '' NOT NULL, UNIQUE KEY id (id) );"; require_once( ABSPATH . 'wp-admin/includes/upgrade.php' ); dbDelta( $sql ); update_option("mapworks_db_version",$mapworks_db_version ); } } function mapWorks_install_data() { global $wpdb; $welcome_name = 'Mr. WordPres'; $welcome_text = 'Congratulations, you just completed the installation!'; $yourname = 'Prakash'; $city = 'Bangalore'; $state = 'Karnatak'; $country = 'India'; $street = '8/63 URS Nilay,Celebrity Road,Doddatgor,Electronic City,Phase I'; $table_name = $wpdb->prefix.'mapworks_tbl'; $wpdb->insert( $table_name, array( 'time' => current_time('mysql'), 'yourname' => $welcome_name, 'city' => $city, 'state' => $state, 'country' => $country, 'street' => $street, ) ); } register_activation_hook( __FILE__, 'mapWorks_install' ); register_activation_hook( __FILE__, 'mapWorks_install_data'); function mapworks($stext=''){ global $wpdb; $table_name = $wpdb->prefix . 'mapworks_tbl'; if($stext!=''){ $results=$wpdb->get_results("SELECT * FROM ".$table_name." WHERE street LIKE '%$stext%'",ARRAY_A); } else { $results=$wpdb->get_results("SELECT * FROM ".$table_name,ARRAY_A); } foreach($results as $row){ ?>
Name:
Address:
'.$row['city'].'
'.$row['state'].'
'.$row['country'];?>
Lat:
Long:
'' ),$atts,'mapworks'); $stext=$atts['stext']; ob_start(); $options = get_option('plugin_options'); if(!$options['allow_default_front']){ return ''; } global $wpdb; $table_name = $wpdb->prefix . 'mapworks_tbl'; if($stext!=''){ $results=$wpdb->get_results("SELECT * FROM ".$table_name." WHERE street LIKE '%$stext%'",ARRAY_A); } else { $results=$wpdb->get_results("SELECT * FROM ".$table_name,ARRAY_A); } foreach($results as $row){ ?>
Name:
Address:
'.$row['city'].'
'.$row['state'].'
'.$row['country'];?>
Lat:
Long: