Skip to content

connect script to site

Featured Replies

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 ?
 

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.

  • Author
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 

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.

  • Author
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? 

<?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 :)

  • Author
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)

$servername = "server_ip";

add the server's IP address 22.22.22.222

  • Author
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 by Red-Hair-Shanks

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 ?

  • Author
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 by Red-Hair-Shanks

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

it says that you have wrong ip added 

you added 4564561515 as IP

  • Author
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

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 

 

  • Author
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 "

    ";
?>

Create an account or sign in to comment

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.