Wenn die Datenspalte Buchstaben enthält irgendwo, dan ist es eien Varchar-Spalte und keine interger-(Zahlen)-Spalte, aleo ... 007 ist like "0%" ... 800XE ist LIKE "8%"
und bedenke, du hast jetzt noch das Problem das du quasie ÄÖÜ auch noch Navigieren müstest
darum ... hl2fn ....
Code: Alles auswählen
/***********************************************************************
* Headline 2 FileName -- umwandeln
**********************************************************************/
function hl2fn($headline, $low=0)
{
$headline = hl2fn2(trim($headline));
if ( $low ) $headline = strtolower( $headline );
return( $headline );
}
/***********************************************************************
* Headline 2 Subdomain -- umwandeln
**********************************************************************/
function hl2fn2($headline)
{
$headline= str_replace(chr(153), ' TM', $headline );
$headline= str_replace(chr(232), 'e', $headline );
$headline= str_replace(chr(233), 'e', $headline );
$headline= str_replace(chr(234), 'e', $headline );
$headline= str_replace(chr(235), 'e', $headline );
$headline= str_replace(chr(174), 'R', $headline );
$headline= str_replace('â', 'a', $headline );
$headline= str_replace('é', 'e', $headline );
$headline= str_replace('€', 'e', $headline );
$headline= str_replace('`', ' ', $headline );
$headline= str_replace('²', '2', $headline );
$headline= str_replace('_', ' ', $headline );
$headline= str_replace('"', ' ', $headline );
$headline= str_replace("'", ' ', $headline );
$headline= str_replace('*', ' ', $headline );
$headline= str_replace('%20',' ',$headline );
$headline= str_replace('%2B',' ',$headline );
$headline= str_replace('%', ' ', $headline );
$headline= str_replace('+', ' ', $headline );
$headline= str_replace('?', ' ', $headline );
$headline= str_replace('!', ' ', $headline );
$headline= str_replace('&', ' ', $headline );
$headline= str_replace('@', ' ', $headline );
//$headline= str_replace('|', ' ', $headline );
$headline= str_replace(',', ' ', $headline );
$headline= str_replace('=', ' ', $headline );
// $headline= str_replace('-', '', $headline );
$headline= str_replace('<', ' ', $headline );
$headline= str_replace('>', ' ', $headline );
$headline= str_replace('«', ' ', $headline );
$headline= str_replace('»', ' ', $headline );
$headline= str_replace('{', ' ', $headline );
$headline= str_replace('[', ' ', $headline );
$headline= str_replace('(', ' ', $headline );
$headline= str_replace(')', ' ', $headline );
$headline= str_replace(']', ' ', $headline );
$headline= str_replace('}', ' ', $headline );
$headline= str_replace("'", ' ', $headline );
$headline= str_replace(';', ' ', $headline );
$headline= str_replace(':', ' ', $headline );
$headline= str_replace('ß', 'ss', $headline );
$headline= str_replace('ä', 'ae', $headline );
$headline= str_replace('ö', 'oe', $headline );
$headline= str_replace('ü', 'ue', $headline );
$headline= str_replace('Ä', 'AE', $headline );
$headline= str_replace('Ö', 'OE', $headline );
$headline= str_replace('Ü', 'UE', $headline );
$headline= str_replace('à', 'a', $headline );
$headline= str_replace("\n", ' ', $headline );
$headline= str_replace("\r", ' ', $headline );
$headline= str_replace("\", ' ', $headline );
$headline= str_replace('/', ' ', $headline );
$headline= str_replace('#', ' ', $headline );
$headline= trim ( $headline );
$i=strlen($headline);
while($i--)
{
if ( ord($headline{$i})>127 ) $headline{$i}=' ';
}
$headline= str_replace(' ', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('--', '-', $headline );
$headline= str_replace('|-', '|', $headline );
$headline= str_replace('-|', '|', $headline );
$headline= str_replace('||', '|', $headline );
return($headline);
}
function hl2sub($headline)
{
$headline=hl2fn2($headline);
$headline= str_replace(".", "-", $headline );
return($headline);
}