Insert SEO title in combination with Insert_ID

I have difficulties with a insert form.

I would like to insert a SEO capable title (titletext-titletext-titletext) and append the Insert_ID (titletext-titletext-titletext-Insert_ID).

How do I do append the Insert_ID?

Thanks for your help in advance.

Marcel

I don't quite understand the question. Are you inserting into a database? Is this a new record in the database or are you updating an existing record?

Why are you appending the Insert_ID and where is the Insert_ID coming from?

I need to get a better grasp of what you are doing so I can give the appropriate solution.

Sorry, not be clear enough.

I'm trying to insert a new record in the database for a CMS content. I have a form with title, content text, etc. I would like to create automatically the title to use as url (title text title text => title-text-title-text). I created a function for this which works pretty well. To be sure there is no duplicate entry, I wanted to append the ID of the entry. I thought I could manage to integrate the variable you use for redirection [Insert_ID]. This obviously does not work.

I could manage the problem with update but not with insert a new record.

Any idea?

I hope I was a little bit clearer now :-)

The Insert_ID is the value of the unique key generated when the insert takes place. It can't be appended at the time of insert because it doesn't exist until after the insert.

You can always append the unique key from the database when displaying the record. Why is a unique value important when inserting?

The unique value is important because I want to use it as ID for the purpose of a SEO friendly URL. For this reason it must be unique.

http://www.domain.de/nachricht/legionellen-im-trinkwasser-122/

instead of

http://www.domain.de/nachricht/122/

You could still append the ID to the SEO friendly URL and parse it out to display the record from it. Just filter based on the parsed id rather than the title.

This could be the solution for my problem.

Do you have an example of how to do this? How do I parse it out?

This is the code I use for: http://www.domain.de/nachricht/122/

$colname_content = "83";
if (isset($_GET['id_cms'])) {
$colname_content = $_GET['id_cms'];
}
mysql_select_db($database_webcocms, $webcocms);
$query_content = sprintf("SELECT webcocms_content.id_cms, webcocms_content.id_verkn_cms, webcocms_content.sort_cms, webcocms_content.titel_cms, webcocms_content.text_cms, webcocms_anmeldung.Vorname, webcocms_anmeldung.Nachname, webcocms_content.visible_cms, webcocms_content.insert_cms, webcocms_content.update_cms FROM webcocms_content INNER JOIN webcocms_seiten ON webcocms_content.id_verkn_cms = webcocms_seiten.id_seite INNER JOIN webcocms_anmeldung ON webcocms_content.verfasser_cms = webcocms_anmeldung.Nr WHERE webcocms_content.id_cms = %s AND webcocms_content.id_verkn_cms = webcocms_seiten.id_seite AND visible_cms = 1 ORDER BY webcocms_content.insert_cms DESC", GetSQLValueString($colname_content, "text"));
$content = mysql_query($query_content, $webcocms) or die(mysql_error());
$row_content = mysql_fetch_assoc($content);
$totalRows_content = mysql_num_rows($content);

.htaccess:

Options +FollowSymLinks
RewriteEngine On
RewriteCond %{REQUEST_URI} !^/(admin|kundenportal|zaehlerablesung)
RewriteRule ^([^/]*)/$ ?id=$1 [L]
RewriteRule ^([^/]*)/([^/]*)/$ ?id=$1&id_cms=$2 [L]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_URI} !(.*)/$
RewriteRule ^(.*)$ http://%{HTTP_HOST}/$1/ [L,R=301]
Options +SymLinksIfOwnerMatch

It looks like you are passing the reference to the page using: id_cms

So you can strip the id off the end of it with (assuming you add a dash and the id to the end of the links):

<?php

$_GET['Unique_ID'] = substr($_GET['id_cms'],strrpos($_GET['id_cms'],"-")+1);

?>

Then you can filter the recordset with the 'Unique_ID' url parameter which will have the value of the stripped off id from the end of the link.

Thank you Ray!!

It works like a charm!