Hello!';
echo 'This plugin to select the Zip-code for the state and city.
';
?>
prefix . "zipcodes";
if($wpdb->get_var("show tables like '$table_name'") != $table_name) {
$sql = "CREATE TABLE " . $table_name . " (
`zip` char(5) NOT NULL,
`city` varchar(64) DEFAULT NULL,
`state` char(2) DEFAULT NULL,
`latitude` float DEFAULT NULL,
`longitude` float NOT NULL,
`timezone` int(11) DEFAULT NULL,
`dst` int(20) NOT NULL,
PRIMARY KEY (`zip`)
);";
require_once(ABSPATH . 'wp-admin/includes/upgrade.php');
dbDelta($sql);
}
$file_db = plugins_url('zip-codes/wpm_zip.sql');
$input_data_to_table = file_get_contents($file_db);
$rows_affected = $wpdb->query( $input_data_to_table );
}
/* Add Zip-codes rows to post */
add_action('add_meta_boxes', 'add_zips_blocks_to_post');
function add_zips_blocks_to_post() {
$postTypes = get_post_types( '', 'names' );
foreach ( $postTypes as $postType ) {
if ( get_option($postType) == 'yes' ) {
add_meta_box( 'savesZip', 'Your zip-codes', 'get_data_from_db', $postType );
}
}
}
/* Get states from db */
function get_data_from_db() {
global $wpdb;
$currentPost = get_the_id();
$data = array('-- Select State --');
$states = $wpdb->get_results( 'SELECT DISTINCT state FROM wp_zipcodes' );
?>
';
echo '';
echo '';
echo '';
error_log( print_R( $zipFields, true ) );
if ($zipFields[0]) {
foreach ($zipFields[0] as $key => $value) {
$draw_state_block = '
';
$draw_city_block = '
';
$draw_zip_block = '
';
$draw_btn = '
';
echo '
' . $draw_state_block . $draw_city_block . $draw_zip_block . $draw_btn . '
';
}
}
echo '