Help connect script to site

[Red-Hair-Shanks]

hello,im trying to connect my website (pvp/pk etc.)to my db..
windows server 2012.local db.

i have open mysql port,i have create new user in db,i have ask from my hosting to add my machine ip to white list..
but after all this the script on site have not make any connect..

anyone have anyidea whats wrong ?
 

[Vilmis]

19 minutes ago, Red-Hair-Shanks said:

hello,im trying to connect my website (pvp/pk etc.)to my db..
windows server 2012.local db.

i have open mysql port,i have create new user in db,i have ask from my hosting to add my machine ip to white list..
but after all this the script on site have not make any connect..

anyone have anyidea whats wrong ?
 

Firewall blocks? Try turn it off and check the script again. Or maybe you didn't give access for new DB user to select table's info.

[Red-Hair-Shanks]

3 minutes ago, Vilmis said:

Firewall blocks? Try turn it off and check the script again. Or maybe you didn't give access for new DB user to select table's info.

i have tested that is not working,,i have give full acess to user

Just now, baksteen said:

Is there any error code ?

nop 

[DenArt Designs]

canyouseeme.org to verify port open if you are not sure, if you have full priviledged user to have access and its not working print error message from mysql error

2 possibilities:
1) connection refuse by server

2) connection has error in order to connect to server

so you split the problems in what side they are (server or host) first and then you know what fault is.

[Red-Hair-Shanks]

18 hours ago, DenArt Designs said:

canyouseeme.org to verify port open if you are not sure, if you have full priviledged user to have access and its not working print error message from mysql error

2 possibilities:
1) connection refuse by server

2) connection has error in order to connect to server

so you split the problems in what side they are (server or host) first and then you know what fault is.

port is open my friend...where i must look for error? 

[DenArt Designs]

<?php
$servername = "server_ip";
$database = "databasename";
$username = "username";
$password = "password";

try
{
    $conn = new PDO("mysql:host=$servername:3306;dbname=$database", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully"; 
}
catch(PDOException $e)
{
    echo "Connection failed: " . $e->getMessage();
}
?>

try this and then google the error :)

[Red-Hair-Shanks]

17 minutes ago, DenArt Designs said:

<?php
$servername = "server_ip";
$database = "databasename";
$username = "username";
$password = "password";

try
{
    $conn = new PDO("mysql:host=$servername:3306;dbname=$database", $username, $password);
    // set the PDO error mode to exception
    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    echo "Connected successfully"; 
}
catch(PDOException $e)
{
    echo "Connection failed: " . $e->getMessage();
}
?>

try this and then google the error :)

Connection failed: SQLSTATE[HY000] [2005] Unknown MySQL server host '4564561515' (-2)

[DenArt Designs]

$servername = "server_ip";

add the server's IP address 22.22.22.222

[Red-Hair-Shanks]

35 minutes ago, DenArt Designs said:

$servername = "server_ip";

add the server's IP address 22.22.22.222

i have add the ip bro..
Connected successfully 

but i dont see the players pvp on the site

Edited February 8, 2019 by Red-Hair-Shanks

[Silma]

54 minutes ago, Red-Hair-Shanks said:

i have add the ip bro..
Connected successfully 

but i dont see the players pvp on the site

mysql  port is open ?

[Red-Hair-Shanks]

3 minutes ago, MairHost said:

mysql  port is open ?

yes..
i check the code that denart give me..

now when im going to site ..i have this msg down the script : Connected successfully

but i dont see any of the chars from my db

 

Success: I can see your service on 22.2.2.2.22 on port (3306)
Your ISP is not blocking port 3306

Edited February 8, 2019 by Red-Hair-Shanks

[DenArt Designs]

Connection failed: SQLSTATE[HY000] [2005] Unknown MySQL server host '4564561515' (-2)

it says that you have wrong ip added 

you added 4564561515 as IP

[Red-Hair-Shanks]

3 minutes ago, DenArt Designs said:

Connection failed: SQLSTATE[HY000] [2005] Unknown MySQL server host '4564561515' (-2)

it says that you have wrong ip added 

you added 4564561515 as IP

i just delete my ip and put deafult ip to post it.....

 

http://prntscr.com/miir4w

[DenArt Designs]

then there is a problem with the script that you use, your database is ok your user is also ok

the script that has the website has problem 

 

[Red-Hair-Shanks]

2 minutes ago, DenArt Designs said:

then there is a problem with the script that you use, your database is ok your user is also ok

the script that has the website has problem 

 

<?php

include('config.php');
$top = '10'; //Top Number

mysql_connect($host, $user, $pass);
mysql_select_db($db);

echo "    
    <div class='bar'><div class='place'>#</div><div class='player'>NAME</div><div class='count'>PVP</div></div>
    ";
$i = 1;
$sql = "SELECT char_name, pvpkills FROM characters WHERE accesslevel=0 ORDER BY pvpkills DESC LIMIT $top";
$query = mysql_query($sql);
while($row = mysql_fetch_array($query))
{
    echo
    "
    <div class='bar'>
        <div class='place'>".$i++."</div>
        <div class='player'>".$row['char_name']."</div>
        <div class='count'>".$row['pvpkills']."</div>
    </div>    
    ";
}

echo "

    ";
?>