I have completed a full USA cities database, is a huge database containing every city in the USA.

I used a function to place every city as an object in it.
I have created a template that I plan to use as a static page
My goal is to type the URL and get to the city page without me having to make a page for each and have them stored in my WordPress page.
here is where I’m stuck:
Every object has already a URL pointed to it.
it works if I go to my WordPress admin, make a page select the parent(state), then select the template.
This will be problematic in the long run because I will have too many pages, it might get confusing.

Since I’m directing the URL from the data base to the page to make minor changes like city name and state.

Thanks for reading community and have a great day!

/****THIS FUNCTION CONTROLS THE CITY DATA BASE!*****/
function get_city_info() {
	 $_SERVER['REQUEST_URI'];
	$city_info = [

		'/colorado/denver/' => [
			'city' => 'Denver',
			'state' => 'Colorado',
			'description' => 'Denver description',
			'links' => [
				'choppers' => '',
				'bikes' => '',
				'cars' => '',
				'something' => ''
			]
		]
,

		'/california/irvine/' => [
			'city' => 'Irvine',
			'state' => 'California',
			'description' => 'Irvine description',
			'links' => [
				'choppers' => '',
				'bikes' => '',
				'cars' => '',
				'something' => ''
			]
		]
	];

	$default = [
		'city' => '',
		'state' => '',
		'description' => '',
		'links' => [
		]
	];
	return isset($city_info[$_SERVER['REQUEST_URI']]) ? $city_info[$_SERVER['REQUEST_URI']] : $default;

}
/***********************************************************/
<?php /*template Name: city-pages*/ ?>

<?php get_header(); ?>

<?php
/** Themify Default Variables
 *  @var object */
global $themify; ?>

<!--this code prints the information of the cities data base-->
<?php  
  $city_info = get_city_info();
  echo'<pre>';print_r($city_info);echo'</pre>';
?>
<!--END OF CODE-->

<!-- layout-container -->
<div id="layout" class="pagewidth clearfix">

  <?php themify_content_before(); // hook ?>
  <!-- content -->
  <div id="content" class="clearfix">
    <?php themify_content_start(); // hook ?>

    <?php
    /////////////////////////////////////////////
    // 404
    /////////////////////////////////////////////
    if(is_404()): ?>
    <h1 class="page-title"><?php _e('404','themify'); ?></h1>
    <p><?php _e( 'Page not found.', 'themify' ); ?></p>
    <?php if( current_user_can('administrator') ): ?>
      <p><?php _e( '@admin Learn how to create a <a href="https://themify.me/docs/custom-404" target="_blank">custom 404 page</a>.', 'themify' ); ?></p>
    <?php endif; ?>
  <?php endif; ?>

  <?php
    /////////////////////////////////////////////
    // PAGE
    /////////////////////////////////////////////
  ?>
  <?php if ( ! is_404() && have_posts() ) : while ( have_posts() ) : the_post(); ?>
    <div id="page-<?php the_ID(); ?>" class="type-page">

      <!-- page-title -->
      <?php if($themify->page_title != "yes"): ?>

        <time datetime="<?php the_time( 'o-m-d' ); ?>"></time>
        <?php themify_theme_page_title(); ?>
      <?php endif; ?>
      <!-- /page-title -->


      <!--page content for template-->

      <h1>Welcome to <?php echo $city_info['city'] ?> and <?php echo $city_info['state'] ?> Page</h1>
      <p>Looking for a high-quality motorcycles<?php echo $city_info['state'] ?> for the <?php echo $city_info['city'] ?> yourself or someone you love? We have a wealth of knowledge on bikes and choppers.</p>
      <br>
      <h3><?php echo $city_info['city'] ?> most used substances are:</h3>
      <ul>
      <?php

        foreach ($city_info['links'] as $bike => $url) {
          echo '<li><a href="'.$url.'">'.$bike.'</a></li>';  

        }

       ?>
     </ul>
     <p>Although the majority of bike clubs in <?php echo $city_info['state'] ?> are are so plentiful in <?php echo $city_info['city'] ?>.</p>

     <!--END OF CODE FOR CITY PAGES-->


     <div class="page-content entry-content">

      <?php if ( $themify->hide_page_image != 'yes' && has_post_thumbnail() ) : ?>
        <figure class="post-image"><?php themify_image( "{$themify->auto_featured_image}w={$themify->image_page_single_width}&h={$themify->image_page_single_height}&ignore=true" ); ?></figure>
      <?php endif; ?>

      <?php the_content(); ?>

      <?php wp_link_pages(array('before' => '<p class="post-pagination"><strong>'.__('Pages:','themify').'</strong> ', 'after' => '</p>', 'next_or_number' => 'number')); ?>

      <?php edit_post_link(__('Edit','themify'), '[', ']'); ?>

      <!-- comments -->
      <?php if(!themify_check('setting-comments_pages') && $themify->query_category == ""): ?>
        <?php comments_template(); ?>
      <?php endif; ?>
      <!-- /comments -->

    </div>
    <!-- /.post-content -->

  </div><!-- /.type-page -->
<?php endwhile; endif; ?>

<?php
    /////////////////////////////////////////////
    // Query Category
    /////////////////////////////////////////////
?>
<?php if($themify->query_category != ''): ?>

  <?php
      // Categories for Query Posts or Portfolios
  $categories = '0' == $themify->query_category? themify_get_all_terms_ids($themify->query_taxonomy) : explode(',', str_replace(' ', '', $themify->query_category));
  $qpargs = array(
    'post_type' => $themify->query_post_type,
    'tax_query' => array(
      array(
        'taxonomy' => $themify->query_taxonomy,
        'field' => 'id',
        'terms' => $categories
        )
      ),
    'posts_per_page' => $themify->posts_per_page,
    'paged' => $themify->paged,
    'order' => $themify->order,
    'orderby' => $themify->orderby
    );
    ?>

    <?php
    query_posts(apply_filters('themify_query_posts_page_args', $qpargs)); ?>

    <?php if(have_posts()): ?>

      <?php
        /////////////////////////////////////////////
        // Entry Filter
        /////////////////////////////////////////////
      if ( ('portfolio' == $themify->query_post_type || 'post' == $themify->query_post_type )&& ( count( $categories ) > 1 ) && 'slider' !== $themify->post_layout && (!isset($themify->post_filter) || $themify->post_filter=='yes')) : ?>
      <?php get_template_part( 'includes/filter', 'portfolio' ); ?>
    <?php endif; // portfolio query ?>

    <!-- loops-wrapper -->
    <div id="loops-wrapper" class="loops-wrapper <?php echo esc_attr( themify_theme_query_classes() ); ?>">

      <?php while( have_posts() ) : the_post(); ?>

        <?php get_template_part( 'includes/loop', $themify->query_post_type ); ?>

      <?php endwhile; ?>

    </div>
    <!-- /loops-wrapper -->

    <?php if ( themify_is_query_page() ) : ?>
      <?php if ( $themify->page_navigation != 'yes' ): ?>
        <?php get_template_part( 'includes/pagination' ); ?>
      <?php endif; // show page navigation ?>
    <?php endif; // is query page ?>

  <?php endif; // have_posts() ?>

  <?php wp_reset_query(); ?>

<?php endif; // is query page ?>

<?php themify_content_end(); // hook ?>
</div>
<!-- /content -->
<?php themify_content_after(); // hook ?>

<?php
  /////////////////////////////////////////////
  // Sidebar
  /////////////////////////////////////////////
if ($themify->layout != 'sidebar-none'): get_sidebar(); endif; ?>



</div>
<!-- /layout-container -->

<?php get_footer(); ?>

Read more here: I have completed a USA city data base. how to make static pages out of it?


Solution:

If you know the solution of this issue, please leave us a reply in Comment section, to update the question.


Wordpress related questions and answers: