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]

  On 2/7/2019 at 5:58 PM, 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 ?
 

Expand  

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]

  On 2/7/2019 at 6:20 PM, 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.

Expand  

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

  On 2/7/2019 at 6:23 PM, baksteen said:

Is there any error code ?

Expand  

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]

  On 2/7/2019 at 11:05 PM, 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.

Expand  

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]

  On 2/8/2019 at 5:39 PM, 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 :)

Expand  

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]

  On 2/8/2019 at 6:01 PM, DenArt Designs said:

$servername = "server_ip";

add the server's IP address 22.22.22.222

Expand  

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]

  On 2/8/2019 at 6:07 PM, Red-Hair-Shanks said:

i have add the ip bro..
Connected successfully 

but i dont see the players pvp on the site

Expand  

mysql  port is open ?

[Red-Hair-Shanks]

  On 2/8/2019 at 7:01 PM, MairHost said:

mysql  port is open ?

Expand  

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]

  On 2/8/2019 at 7:10 PM, 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

Expand  

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]

  On 2/8/2019 at 7:17 PM, 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 

 

Expand  

<?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 "

    ";
?>