Help Website Connection To Database

[Innos]

Hello,

 

How can my website access my server database in order for me to be able to show how many players are online, top pvpers and etc.?

 

Thanks in advance!

[Tessa]

Connection via the PDO driver:

$con = new \PDO('mysql:dbname=l2jdb;host=localhost', 'username', 'password');

Connection via the MySQLi driver:

$con = new \mysqli('loaclhost', 'root', 'qwerty', 'l2jdb');

MySQLi's procedural style:

$con = mysqli_connect("localhost","root","qwerty","l2jdb");

Take a look at http://php.net

[Nightw0lf]

use PDO

and $con = new \PDO('mysql:dbname=l2jdb;host=localhost:3306', 'username', 'password');

you can change port with this addition btw for a +1 security reason

but the question was how to access

 

open the port 3306

pass it from firewall

create a user in navicat that will access the database from outside

make hes ip wildcard %

if your ip is changing after a router restart install a no-ip

and use in your site your ip or no-ip to connect your sql codes

[Innos]

Thanks for your answers, but how can I implement these in Ubuntu 14? (my host) Shall I use putty and if yes, what I press? Btw my website is hosted in a free host(hostinger) and not in server. How can I do as you said?

 

Sorry but I am new to this and need answers suited to a newbie. 

 

Thanks a lot!

Edited March 27, 2015 by Innos

[Tessa]

For the counter you can use something like this:

$con = new \PDO('mysql:host=localhost;dbname=l2jdb', 'root', '');
$num = $con->query('SELECT COUNT(*) FROM characters WHERE online = 1');
echo $num->fetchColumn();

If your hosting includes php, you shouldn't have any problems.

Edited March 27, 2015 by Tessa