How can i get a variable with php?

[MrSky 0]

Hi guys!

How can i show a variable from mysql on fluxcp with php?

I.e. show #cashpoint on fluxcp?

[evilpuncker 504]

show the result of the query in php

[Stickhead 0]

$sql = "SELECT *value* FROM {$server->loginDatabase}.*cashpointTable* ORDER BY id DESC ";

$sth = $server->connection->getStatement($sql);

$sth->execute();

$cash = $sth->fetchAll();

 

here is a sample

[MrSky 0]

I want show people cash on Donate page of fluxcp, instead of credit point

<span class="balance-text">ROPs</span><span class="balance-amount"><?php echo number_format(ropS) ?></span>

[MrSky 0]

 

here is a sample 

 

I'm trying this now, but dont show

<?php 		$sql = "SELECT *value* FROM {$server->loginDatabase}.`global_reg_value` where `account_id` = `2000000` and `str` = `#CASHPOINTS`"; 		$sth = $server->connection->getStatement($sql);		$sth->execute();		$cash = $sth->fetchAll();	?>	<span class="balance-text">ROPs</span>	<span class="balance-amount"><?php echo number_format($cash) ?></span>

Edited November 10, 2014 by MrSky

[MrSky 0]

Anyone can help?

[Stickhead 0]

well if you research you can get it right but for now i will give you the answer

 

 

 

$sql = "SELECT value FROM {$server->loginDatabase}.global_reg_value WHERE account_id=? and str ='#CASHPOINTS'";

$sth = $server->connection->getStatement($sql);

$sth->execute(array($session->account->account_id));

$res = $sth->fetch();

$curr_points = $res->value;

 

use this echo

 

<?php echo $curr_points; ?>

 

hope this helps

Edited November 13, 2014 by Stickhead

[MrSky 0]

hope this helps

Thnx man, i searched but never found a complet one