|
|
$dbname = 'mgline';
$dbuser = 'reader';
$dbpass = '123read321';
$dbhost = '92.43.0.8';
$URL = $_SERVER['REQUEST_URI'];//Получаем полный URL
$URL = substr($URL, 0, strpos($URL, '?'));
?>
|
$letters = array('А','Б','В','Г','Д','Е','Ё','Ж','З','И','Й','К','Л','М','Н', 'О','П','Р','С','Т','У','Ф','Х','Ц','Ч','Ш','Щ','Ъ','Ь','Ы','Э','Ю','Я');
foreach ($letters as $letter){
print "$letter ";
}
?>
|
| Код | Направление | Цена руб/мин |
if(array_key_exists('l', $_GET)){
$letter = substr(iconv('utf-8','windows-1251//IGNORE',$_GET['l']), 0, 1);
}else{
$letter = "Р";
}
$link = mysql_connect("$dbhost:3306","$dbuser","$dbpass");
if(!$link){echo "Database access error.\n";exit;}
$result = mysql_select_db("$dbname");
mysql_set_charset('cp1251',$link);
if(!$result){echo "Error selecting database '$dbname'.\n";exit;}
$result = mysql_query("select dialprefix,destination,rateinitial from cc_ratecard where idtariffplan = 10 order by destination");
while ($text = mysql_fetch_assoc($result)) {
// $dest = iconv('windows-1251','utf-8//IGNORE',$text['destination']);
$dest = $text['destination'];
if(substr($dest, 0, 1) == $letter){
print "| ".$text['dialprefix']." | ".$dest." | ".$text['rateinitial']." | ";
}
}
mysql_free_result($result);
?>
|