Проблем с код!

kristiqn2 · 6 Август 2011

Здравейте,
Преди 2-3 дена попитах в една тема за поздрави от сайта и стана намерих отговор,но когато качих сайта на платен хост и ми изписва това:Unknown MySQL server host 'http' (1)
ето и целия код на страница:

PHP:

				<?php
				session_start();
				include("function_poll.php"); 
				require ("config.php");
				?> 
				<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
				<html xmlns="http://www.w3.org/1999/xhtml">
				<head>
				<title>Radio Extreme - Вашето музикално желание !</title>
				<link href="style.css" rel="stylesheet" type="text/css">
				<meta http-equiv="Content-type" content="text/html; charset=windows-1251" />
				<meta http-equiv="Content-Language" content="bg" />
				<meta name="author" content="" />
				<meta name="coder" content="Kristiqn Todorov" />
				<meta name="copyright" content="" />
				<meta name="description" content="" />
				<meta name="keywords" content="" />
				<link rel="stylesheet" type="text/css" href="style.css" />
				<link rel="shortcut icon" href="images/favicon.ico" />
				
				</head>
				<body>
				<div id="web">

						<div id="top"></div>
						<div id="mid">
								<div id="headtop"></div>
								<div id="headmid">
										<div id="sitename"><img src="images/radio-xix.jpg"></div>
										<div id="banner"><A href='http://hb-gaming.info/' target=' blank'><IMG src='http://prikachi.com/images/729/2808729z.png' BORDER='0'></A>
				</div>
								</div>
								<div id="headbottom"></div>

								
								<div id="lmenu"></div>
								<div id="cmenu"><center>
										<div class="link"><a href="index.php">Начало</a></div>
										<div class="link"><a href="http://94.156.170.132:8000/listen.pls" target=' blank'>Свали Радио</a></div>
										<div class="link"><a href="pozdravi.php">Поздрави</a></div>
										<div class="link"><a href="chat.php">Онлайн Чат</a></div>
										<div class="link"><a href="dj.php">Водещи</a></div>
										
								</div>
								<div id="rmenu"></div>
								<div id="left">
										<div class="thebox1">
												<div class="lbox"></div><div class="cbox">Слушай Онлайн</div><div class="rbox"></div>
												<div class="box1"><br /><center><object id="Player" classid="clsid:22D6F312-B0F6-11D0-94AB-0080C74C7E95" codebase="http://activex.microsoft.com/activex/controls/mplayer/en/nsmp2inf.cab#Version=6,4,5,715" standby="Loading Microsoft® Windows® Media Player components..." type="application/x-oleobject" vspace="0" width="200" align="absmiddle" height="52" hspace="0">
					  <noembed><a href='http://178.169.144.144:2222/live.m3u</noembed>

					  
					  <param name="FileName" value="http://178.169.144.144:2222/live.m3u">

					  <param name="ShowControls" value="true">
					  <param name="ShowStatusBar" value="true">
					  <param name="Autostart" value="true">
					  <param name="ShowPositionControls" value="False">
					  <param name="ShowTracker" value="false">
					  <param name="InvokeURLs" value="True">
					  <param name="ShowGotoBar" value="false">

					  <param name="ShowDisplay" value="false">
					  <param name="AutoSize" value="false">

									  <embed type="application/x-mplayer2" pluginspage="http://www.microsoft.com/Windows/MediaPlayer/" src="http://178.169.144.144:2222/live.m3u" name="Player" autostart="true" showcontrols="true" showstatusbar="true" showdisplay="false" showpositioncontrols="False" showtracker="false" invokeurls="True" showgotobar="false" autosize="false" width="190" height="92">    
					</object><br /><br /><br /><br /></center></div>
										</div>

										<div class="thebox1">
												<div class="lbox"></div><div class="cbox">Радио Статистика</div><div class="rbox"></div>
								<div class="box1"><center><br /><b>В момента радиото е: 
				<?php
				// Change these to your online/offline messages //
				$online = "<font color=green>Онлайн</font>"; // Displays when stream is online
				$offline = "<font color=red>Офлайн</font>"; // Displays when stream is offline
				// don't edit below //
				$ip = "178.169.144.144";
				$port = "2222";
				$fp = @fsockopen($ip,$port,$errno,$errstr,1);
				if (!$fp) 
						{ 
						$status = $offline;
						} 
						else
						{ 
						fputs($fp, "GET /7.html HTTP/1.0\r\nUser-Agent: Mozilla\r\n\r\n");
						while (!feof($fp)) 
								{
								$info = fgets($fp);
								}
						$split = explode(',', $info);
						if ($split[1] == "0" )
								{
								$status = $offline;
								}
						else
								{
								$status = $online;
								}
						}
				echo $status;
				?>
				</div>


				<div class="thebox1">
				<div class="lbox"></div><div class="cbox">В момента свири:</div><div class="rbox"></div>
				<div class="box1">
				<? 
				// ОТДОЛУ ПИШЕТЕ ИП ТО и ПОРТА 
				$open = @fsockopen("178.169.144.144","2222"); 

				if ($open) { 

				fputs($open,"GET /7.html HTTP/1.1\nUser-Agent:Mozilla\n\n"); 

				$read = fread($open,1000); 
				$text = explode(",",$read); 

				$text = $text[6]; 

				} else { $text="Connection Refused!"; } 
				echo " " .$text; 
				?> 
				<br /><br /><br /><br /><br /><br /><br /></center></div>
                </div>
                </div>
                </div>
				
						<div id="right">
								<div class="thebox2">
										<div class="lbox"></div><div class="cbox2">Поздрави</div><div class="rbox"></div>
										<div class="box2">
										<center>
                <?php
                if(isset($_POST['add']))
				{
                {
                $time = time();
                $content = addslashes(strip_tags($_POST['content']));
                $author = addslashes(strip_tags($_POST['name']));
                $q = "INSERT INTO pozdravi (`content`,`author`) VALUES ('$content', '$author')";
				mysql_query($q) or die (mysql_error());
				
				{
				print "Успешно изпратено!";
				}
				
				}
				}
				?>
				<?php
				{
				if(!isset($_POST['add']));
				}
				?>
				</center>
										
		<Center>
						<form method="post" action="">
						 <div align="center">Име:</div> <input type="text" name="name" />
						 <div align="center">Поздрав:</div> <textarea name="content" cols="30" rows="5"></textarea><br />
						 <input type="submit" name="add" value="Изпрати" />
										<form>
		</Center>
		</div>
								</div>
						
								<div class="thebox2">
										<div class="lbox"></div><div class="cbox2">Специална реклама</div><div class="rbox"></div>
										<div class="box2"><center><A href='http://devil-cs.info/' target=' blank'><IMG src='http://prikachi.com/images/766/2807766V.jpg' Width='435' BORDER='0'></A>

		</center></div>
								</div>

						</div>
						
						
						<div id="right2">
								<div class="thebox1">
										<div class="lbox"></div><div class="cbox">Анкета</div><div class="rbox"></div>
										<div class="box1"><Center><?php @poll(); ?>
								</div>

								<div class="thebox1">
										<div class="lbox"></div><div class="cbox">Гласувайте за нас</div><div class="rbox"></div>
										<div class="box1"><center><a href="http://bgtop.net/in.php/1312568124" target="_blank"><img src="images/bg top.jpg" alt="BGtop" title="Елате в .: BGtop.net :. Топ класацията на българските сайтове и гласувайте за този сайт!" border="0" /></a></center></div>
								</div>
						</div>
				</div>
				<div id="bottom">Всички права запазени © <a href="http://radio-extreme.info/pozdravi-a.php">Radio-Extreme</a>
		
<script  type="text/javascript">

</script>
<noscript><a href="http://www.tyxo.bg/?124346" title="Tyxo.bg counter" target="_blank"><img src="http://cnt.tyxo.bg/124346" width="80" height="15" border="0" alt="Tyxo.bg counter" /></a></noscript>

		</div>
		</div>
		</body>
		</html>

tedo96 · 6 Август 2011

Това ти е от конфиг файла, сигурно. Там където си писал някакъв адрес трябва да е localhost.

kristiqn2 · 6 Август 2011

еми нали трябва да се свържа с хостинга като напиша localhost ще работи ли?

kristiqn2 · 6 Август 2011

ето го config.php:

PHP:

<?php

$server = "localhost";
$username = "root";
$password = "a";
$db_name = "radio-anketa";
$pass_admin = "a";


$connect = mysql_connect($server, $username, $password) or die (mysql_error());
mysql_select_db($db_name, $connect) or die (mysql_error());

mysql_query("SET NAMES cp1251");
?>

но иначе на хоста ми е <?php

PHP:

$server = "radio-extreme.info";
$username = "radioemp_1";
$password = "a";
$db_name = "radioemp_1";
$pass_admin = "a";


$connect = mysql_connect($server, $username, $password) or die (mysql_error());
mysql_select_db($db_name, $connect) or die (mysql_error());

mysql_query("SET NAMES cp1251");
?>

tedo96 · 6 Август 2011

Да, там трябва да пише localhost.

PS: Махни си паролите от горния пост!

topchokt · 6 Август 2011

MySQL хоста ти най-вероятно е localhost. В 99% е такъв. Кой хостинг използваш?

kristiqn2 · 6 Август 2011

smshosting.bg

tedo96 · 6 Август 2011

kristiqn2 каза:
smshosting.bg

Да, там трябва да напишеш localhost. Пробвай!

Ev0luti0N · 6 Август 2011

$server = "localhost";
$username = "radioemp_1";
$password = "a";
$db_name = "radioemp_1";
$pass_admin = "a";

$connect = mysql_connect($server, $username, $password) or die (mysql_error());
mysql_select_db($db_name, $connect) or die (mysql_error());

mysql_query("SET NAMES cp1251");
?>
Никога не си пиши там домейн името. Няма да стане. И двете са на разлчини сървъри. :idea:

Проблем с код!

kristiqn2

Registered

tedo96

Registered

kristiqn2

Registered

kristiqn2

Registered

tedo96

Registered

topchokt

Registered

kristiqn2

Registered

tedo96

Registered

Ev0luti0N

Registered