Template and htacess Wordpress page

Question

In Wordpress:

On a template page:

I have a link: <a href="http://localhost/wpcurso/exercicios-questoes/?id='.$row->id_exercicio.' " >' . $row->titulo . '</a>

That points to another template page: <?php /* Template Name: exercicios-questoes */ ?>

How to make this link friendly URL to the second template page?

My htacess is the Worpress standard:

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /wpcurso/
RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /wpcurso/index.php [L]
</IfModule>

# END WordPress

Answer 1

You need to request a GET in the functions of your theme and validate in the database if it matches this id, the title you pass is optional because you don’t need to pass, with PHP will get the id as follows $_GET('id'); if you assign this GET in a variable you will receive the id you passed in the URL, until then it is ok, then make an SQL query with WHERE id = '$id' As follows the example of Where I gave and see if it returns true or false, if return the exercise/question data just make the listing of it on this page. Follow a practical example of this:

if(isset($_GET['id']) && !empty($_['id'])){
         $id = $_GET['id'];

         global $wpdb; //Chamando função de banco do Wordpress para fazer uma consulta

      // Fazendo uma consulta e atribuindo a uma variável distinta
      $var = $wpdb->get_results('SELECT * FROM tabela WHERE id = '.$id);

      // Vendo o retorno da consulta  
      print_r($var);
      die;

}