function generateSeoURL($string, $wordLimit = 0){
$before = array('I', 'ı', 'ğ', 'ü', 'ş', 'ö', 'ç', 'İ', 'Ğ', 'Ü', 'Ö', 'Ç', 'Ş'); // , '\'', '""'
$after = array('i', 'i', 'g', 'u', 's', 'o', 'c', 'i', 'g', 'u', 'o', 'c','s'); // , '', ''
$string = str_replace($before, $after, $string);
$separator = '-';
if($wordLimit != 0){
$wordArr = explode(' ', $string);
$string = implode(' ', array_slice($wordArr, 0, $wordLimit));
}
$quoteSeparator = preg_quote($separator, '#');
$trans = array(
'&.+?;' => '',
'[^\w\d _-]' => '',
'\s+' => $separator,
'('.$quoteSeparator.')+'=> $separator
);
$string = strip_tags($string);
foreach ($trans as $key => $val){
$string = preg_replace('#'.$key.'#i'.('UTF8_ENABLED' ? 'u' : ''), $val, $string);
}
$string = Transliterator::create('tr-lower')->transliterate($string);
return trim(trim($string, $separator));
}
function s2p($sinematurk){
return 173 * (int) ($sinematurk);
}
function p2s($programizle){
return (int) ($programizle / 173);
}
function list_movies_az(){
$myData = "";
$myData .= "
";
$myData .= "
Film arşivi:
";
$letters = array("A", "B", "C", "Ç", "D", "E", "F", "G", "Ğ", "H", "I", "İ", "J", "K", "L", "M", "N", "O", "Ö", "P", "Q", "R", "S", "Ş", "T", "U", "Ü", "V", "W", "Y", "Z");
foreach ($letters as $letter) {
$myData .= ''.$letter.' ';
}
$myData .= '# ';
$myData .= "";
return $myData;
}
function list_actors_az(){
$myData = "";
$myData .= "";
$myData .= "
Oyuncu arşivi:
";
$letters = array("A", "B", "C", "Ç", "D", "E", "F", "G", "Ğ", "H", "I", "İ", "J", "K", "L", "M", "N", "O", "Ö", "P", "Q", "R", "S", "Ş", "T", "U", "Ü", "V", "W", "Y", "Z");
foreach ($letters as $letter) {
$myData .= ''.$letter.' ';
}
$myData .= '# ';
$myData .= "";
return $myData;
}
?>
Fatal error: Uncaught mysqli_sql_exception: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '.$letter.'%' ORDER BY actor_name LIMIT 0, 50' at line 1 in /home/u478970948/domains/programizle.com/public_html/actor_list.php:31
Stack trace:
#0 /home/u478970948/domains/programizle.com/public_html/actor_list.php(31): mysqli_query()
#1 {main}
thrown in /home/u478970948/domains/programizle.com/public_html/actor_list.php on line 31