CNC type nazvanie.html

Question

When creating an article in a separate field in the database, the title of the article fits into my transliteration. But how to make the article open not at http://site.ru/articles.php?id=ID, but at http://site.ru/nazvanie.html ? The article is displayed as

if($id) { $counts = @ mysql_result(mysql_query('SELECT COUNT(*) FROM `articles` WHERE `id`='.$id.' AND `moderation`="1";'), 0); if($counts==0) { echo '<div class="alert alert-error">Статьи не существует!</div>'; echo '</article>'; require 'system/foot.php'; exit; } $row = mysql_fetch_assoc(mysql_query("SELECT * FROM `articles` WHERE `id`='".$id."' AND `moderation`='1'"));

Deleted 351 one five 13 · Accepted Answer · 2012-08-04T07:25:56

In the .htaccess file, in the root of the site, add an entry

  RewriteEngine On RewriteRule ^(.*)\.html$ /articles.php?name=$1 [L]

And slightly change the query to the database. Instead

 id='.$id.'

to write

 translite_name="'.mysql_escape_string($_GET['name']).'"

Something like this: $ row = mysql_fetch_assoc (mysql_query ("SELECT * FROM articles WHERE translite_name =" '. Mysql_escape_string ($ _ GET [' name ']).' "AND moderation = '1'"));
if (! $ row ['ID']) {echo '<div class = "alert alert-error"> Articles do not exist! </ div>';

johniek_comp johniek_comp 2,228 3 18 43 · Answer 2 · 2012-08-04T05:24:54

 RewriteEngine On RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteCond %{REQUEST_FILENAME} !-l RewriteRule ^(.*)$ articles.php?id=$1 [L,QSA]

when typing http://site.ru/nazvanie.html

 $_GET["id"] = "nazvanie.html";

If you do it then it works only this way - site.ru/nazvanie.html?id=ID

CNC type nazvanie.html

2 answers 2

More articles: