Profile Query Submit

Question

I have the following code:

<?php

$id=$_GET['id'];$id=str_replace('_',' ',$id);

global $wpdb;
$res = $wpdb->get_results("SELECT * FROM `agents` WHERE `name`='".$id."'");
foreach ($res as $row) {
  $name = $row->name;
  echo $name;
}
?>

When I hit submit the profiles display the following URL: http://www.website.com/profile/?id=first_last

Is there a way to display the url like this: http://www.website.com/profile/first-last/

Thank you,

John

Answer 1

You can use htaccess rewriting

# BEGIN WordPress
<IfModule mod_rewrite.c>
RewriteEngine On
RewriteBase /

RewriteRule ^profile/(.*) /profile/?id=$1 [L] 

RewriteRule ^index\.php$ - [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule . /index.php [L]
</IfModule>
# END WordPress

or Wordpress page_rewrite_rules:

You can add this block of code into your theme’s functions.php file.

add_filter( 'page_rewrite_rules', 'my_page_rewrite_rules' );
function my_page_rewrite_rules( $rewrite_rules )
{
    // The most generic page rewrite rule is at end of the array
    // We place our rule one before that
    end( $rewrite_rules );
    $last_pattern = key( $rewrite_rules );
    $last_replacement = array_pop( $rewrite_rules );
    $rewrite_rules +=  array(
        'profile/([0-9]+)/?$' => 'index.php?pagename=profile&id=$matches[1]',
        $last_pattern => $last_replacement,
    );
    return $rewrite_rules;
}

Wordpress Codex: http://codex.wordpress.org/Rewrite_API/add_rewrite_rule

Documentation: http://www.hongkiat.com/blog/wordpress-url-rewrite/