Kuzirashi
ASP.NET MVC, JS-SPA, PHP, NODE
- Joined
- Jul 24, 2010
- Messages
- 772
- Reaction score
- 157
Skrypt mo?na wykorzysta? np. do od?wie?ania statusu co ile? czasu, je?eli po??czy si? go z ajaxem. Tutaj kod, kt?ry najlepiej wklei? w /system/. Tworzymy nowy plik .php i wklejamy:
Reput mile widziany.
Zabraniam kopiowania zawarto?ci na inne fora/serwisy.
PHP:
<?php
/* KUZIRASHI'S ONLINE PLAYERS *
* ------------------- CONFIG *
*/
require '../config.php';
/* END OF CONFIG *
* - - CONNECTION *
* - - - - CLASS *
*/
class Connection {
public function connect ($host, $user, $pass, $db) {
if(!$this->connection = new mysqli($host, $user, $pass)) {
throw new Exception('Nie uda?o si? po??czy?.');
}
if (!$this->connection->select_db($db)) {
throw new Exception('Nie uda?o si? wybra? bazy ' . $db);
}
}
public function ammount ($q) {
if (!$this->result = $this->connection->query($q)) {
throw new Exception('Zapytanie nie powiod?o si?. Pow?d: ' . $this->connection->error);
} else {
if (!$this->numer = $this->result->num_rows) {
throw new Exception('Nie uda?o si? policzy? wierszy.');
} else {
$this->result->close();
return $this->numer;
}
}
}
function close () {
if (!$this->connection->close()) {
throw new Exception('Nie uda?o si? zamkn??.');
}
}
}
/* END OF CONNECTION CLASS *
* BEGIN OF USER INTERFACE *
*/
$connection = new Connection;
try {
$connection->connect($config['database']['host'], $config['database']['login'], $config['database']['password'], $config['database']['database']);
// QUERY
$result = $connection->ammount('SELECT `id` FROM `players` WHERE `online` = 1');
// OUTPUT RESULT
echo $result;
// CLOSE CONNECTION
$connection->close();
} catch (Exception $e) {
// ECHO OUT ERRORS IF ANY
echo 'B??dy: ', $e->getMessage(), "\n";
}
/* - END OF USER INTERFACE *
* - - - - - END OF SCRIPT *
* - - - - - BY KUZIRASHI *
* - - - - - - GG: 4760316 *
* - - KUZIRASHI@INTERIA.PL *
*/
?>
Reput mile widziany.
Zabraniam kopiowania zawarto?ci na inne fora/serwisy.
Notka moderatorska: |
+10pkt do konkursu! |