[HELP]Top Stats PhP + DB + Problem

Bobi · July 8, 2010

Hello i try to connect my web page to my DB but i have problem

I have already top pvp script like this :

I have already config my script

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title></title>
    </head>
    <body>
        <?php
//---------CONFIGS---------//
$title="Top PvP";  // Page Title Here
$type="1"; //Type 1 
$server="already"; // MySQL IP
$user="Already"; //MySQL Username
$password="already"; //MySQL Password
$database="already; //MySQL Database
$top="100"; 
//-----END OF CONFIGS-----//



if ($title) {
print("<head><title>$title</title></head>");
}
else {
print("<head><title>No Page Title</title></head>");
}
mysql_connect("$server", "$user", "$password") or die(mysql_error());
mysql_select_db("$database") or die(mysql_error());

if($type == '1'){
$result = mysql_query("SELECT char_name,pvpkills FROM characters where pvpkills>0 and accesslevel=0 order by pvpkills desc")
or die(mysql_error());
echo "<center><h3>Top $top PvP Players</h3></center><table border=10 align=center><tr> <th>Character</th> <th>Top Kills</th> </tr>";
$sum1=0;
while($row = mysql_fetch_array( $result )) {
	$name = $row['char_name'];
	$pvpkills = $row['pvpkills'];
	if ($sum1<$top) {
	echo "<tr><td align=center>$name</td><td align=center>$pvpkills</td></tr>";
	$sum1++;
	}
}
}

else {
echo "<center>Please config the variable $type. Make it <b>1</b> for Top Status</center>";
}
?>
    </body>
</html>

but when i open this page i got error:

PHP Error Message

Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 111 in /home/a2349266/public_html/top.php on line 27

Free Web Hosting
Lost connection to MySQL server at 'reading initial communication packet', system error: 111

when i open my phpmyadmin i see...

localhost

    * Server version: 5.0.51a-24+lenny3
    * Protocol version: 
    * Server: Localhost via UNIX socket
    * User: *****@localhost
    * MySQL charset: UTF-8 Unicode (utf8)

so how to make my top pvp script work ?

Bobi · July 8, 2010

bump

come on anyone

Assassina · July 8, 2010

try to turn off ur firewall and press refreash on firefox :)

Tryskell · July 8, 2010

$server="already"; // MySQL IP
$user="Already"; //MySQL Username
$password="already"; //MySQL Password
$database="already; //MySQL Database

Erm, you edited your post to change that infos to show your script on MXC, or it's like that in your php...? Cause if you have that in your script, it's won't work lol.

Second, can you access your mySQL data with navicat/phpMyAdmin ? If you haven't any db access, that show your problem...

Third, localhost must have at least a localhost line. Whatever are others line.

127.0.0.1          localhost

Fourth, what is your network topology ? You test all in the same PC ? What software you use ? You try reach a far-away server ? Explain...

And if I can give you a hint, for developer-cases, uses a AIO server solution, like WAMP/LAMP (solid and easy). It will avoids all PHP/mySQL/Apache installation, config and problems.

Bobi · July 8, 2010

$server="already"; // MySQL IP
$user="Already"; //MySQL Username
$password="already"; //MySQL Password
$database="already; //MySQL Database
Erm, you edited your post to change that infos to show your script on MXC, or it's like that in your php...? Cause if you have that in your script, it's won't work lol.

Second, can you access your mySQL data with navicat/phpMyAdmin ? If you haven't any db access, that show your problem...

Third, localhost must have at least a localhost line. Whatever are others line.
127.0.0.1          localhost
Fourth, what is your network topology ? You test all in the same PC ? What software you use ? You try reach a far-away server ? Explain...

And if I can give you a hint, for developer-cases, uses a AIO server solution, like WAMP/LAMP (solid and easy). It will avoids all PHP/mySQL/Apache installation, config and problems.

i have already config my script where is IP,DB,Login,Pass...

Second, can you access your mySQL data with navicat/phpMyAdmin ? what? i dont understand this.

I use Linux this is my dedicated server.

Tryskell · July 8, 2010

As security, be sure than IP, username, psw and database are the good too... No spaces "like_that ".

----

Well according to what I read, it's come from your host.

http://forums.mysql.com/read.php?52,151255,151255#msg-151255

Apparently, it can comes too if your host got a problem :

http://www.appnitro.com/forums/topic/cant-connect-to-database-mysql-system-error-111

And according to the last topic :

I suggest to contact your hosting tech support.

Gl,

Tryskell.

[HELP]Top Stats PhP + DB + Problem

Question

Bobi

5 answers to this question

Recommended Posts

Bobi

Assassina

Tryskell

Bobi

Tryskell

Create an account or sign in to comment

Create an account

Sign in

Posts

Topics

Browse

Activity

Store