header('Content-Type: text/html; charset=utf-8');
mb_internal_encoding('utf-8');
print"
";
///
function Slug($word){
// масив за кодиранена урл адреса
$encode_array = array( 'а' => 'a',
'б' => 'b',
'в' => 'v',
'г' => 'g',
'д' => 'd',
'е' => 'e',
'ж' => 'j',
'з' => 'z',
'и' => 'i',
'й' => 'i',
'к' => 'k',
'л' => 'l',
'м' => 'm',
'н' => 'n',
'о' => 'o',
'п' => 'p',
'р' => 'r',
'с' => 's',
'т' => 't',
'у' => 'u',
'ф' => 'f',
'х' => 'h',
'ц' => 'ts',
'ч' => 'ch',
'ш' => 'sh',
'щ' => 'sht',
'ъ' => 'y',
'ю' => 'iu',
'я' => 'ia',
'А' => 'A',
'Б' => 'B',
'В' => 'V',
'Г' => 'G',
'Д' => 'D',
'Е' => 'E',
'Ж' => 'J',
'З' => 'Z',
'И' => 'I',
'Й' => 'I',
'К' => 'K',
'Л' => 'L',
'М' => 'M',
'Н' => 'N',
'О' => 'O',
'П' => 'P',
'Р' => 'R',
'С' => 'S',
'Т' => 't',
'У' => 'U',
'Ф' => 'F',
'Х' => 'H',
'Ц' => 'Ts',
'Ч' => 'Ch',
'Ш' => 'Sh',
'Щ' => 'Sht',
'Ъ' => 'Y',
'Ю' => 'Iu',
'Я' => 'Ia',
'ь' => 'y',
'?' => 'u',
'n' => 'n',
'a' => 'a',
'e' => 'e',
'i' => 'i',
'o' => 'o',
'u' => 'u',
'a' => 'a',
'N' => 'N',
'E' => 'E',
'I' => 'I',
'O' => 'O',
'U' => 'U',
'A' => 'A',
'.' => '',
',' => '',
'-' => '',
'\'' => '',
'"' => '',
':' => '',
';' => '',
'@' => '',
'!' => '',
'#' => '',
'$' => '',
'%' => '',
'^' => '',
'&' => '',
'*' => '',
'(' => '',
')' => '',
'{' => '',
'}' => '',
'[' => '',
']' => '',
'?' => '',
'\\' => '',
'/' => '',
' ' => '-');
// всички букви малки
$word = strtolower($word);
// заместване на името с кодираното име
return str_replace(array_keys($encode_array),array_values($encode_array),$word);
}
///
$dbhost = "localhost";
$dbname = "goguide_bg";
$dbuser = "goguide_bg"; // user s prava za pipane po bazata
$dbpass = "fixMePls!";
$dbcon=mysql_connect("$dbhost", "$dbuser", "$dbpass")
or die("Няма връзка с базата");
mysql_query("SET NAMES utf8");
mysql_query("SET COLLATION_CONNECTION='utf8_general_ci'");
mysql_select_db("$dbname");
//iztochvane na STATII
$query = "SELECT title,id,image,display_date,content,author,master_category_id FROM articles WHERE 1 ORDER BY display_date DESC LIMIT 0,10";
$result = mysql_query($query);
for ($i =0; $i < mysql_affected_rows(); $i++){
$row_array = mysql_fetch_array($result);
$broiach++;
$url=Slug($row_array[title]);
$title = str_replace("&", "", $row_array[title]);
$title = str_replace("\"", "", $title);
$kratko_opisanie=mb_substr((strip_tags($row_array[content])),0,500);
//$kratko_opisanie=strip_tags($row_array[content]);
//$kratko_opisanie=preg_replace('/[^a-zA-Z0-9_ %\[\]\.\(\)%&-]/s', '', $kratko_opisanie);
$data_i_cahs=gmdate(DATE_RSS, strtotime($row_array['display_date']));
// 1 - Градска култура
// 2 - Кой какво защо koi-kakvo-zashto
// 3 - Ревю revu
if($row_array[master_category_id]=1){$cat_perfix="gradska-kultura";}
elseif($row_array[master_category_id]=2){$cat_perfix="koi-kakvo-zashto";}
elseif($row_array[master_category_id]=3){$cat_perfix="revu";}
if($broiach==1){print"$data_i_cahs
goguide.bg
http://goguide.bg/rss-statii.php
GoGuide RSS
";}
print"
-
$title
http://goguide.bg/$cat_perfix/$row_array[id]-$url
<img src="http://www.goguide.bg/upload/articles/inner/$row_array[image]" /><p>
http://goguide.bg/$cat_perfix/$row_array[id]-$url
$data_i_cahs
GoGuide.bg
news
";
// Thu, 18 Apr 2013 08:00:34 +0300
}
print"
";
?>