Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.




889 posts

Ultimate Geek
+1 received by user: 127

Trusted

Topic # 97097 10-Feb-2012 13:52
Send private message

Hi,

I'm trying to add a few new user fields to my small website that can be displayed below the greeting on the joomla login module.

I want to show:

Opening Balance (a fixed value differing per user and stored in the user database) 

Return on Investment (a fixed value, the same for each user and stored in the database)

and a current balance (a calculated value based on the opening balance multiplied by the Return on Investment).

Using PHPmyadmin I have added openingBalance to the jos_user table and have populated each users opening balance.

I have added ROI to the jos_user table and have populated it for each user with the same ROI (is there a smarter way to do this as this value is the same for everyone).

My question is how do I show the opening and current balances in the frontend of the login module and how do I format the opening and current balance to be in the format $X,XXX.XX ?

 I'm sure its only a couple of lines of code but PHP is horribly confusing to me.

 My goal is to show the following in the login module:

 Hi, Bob,

Your opening balance is $X,XXX.XX

Your current balance is $X,XXX.XX

[logout]

 

Thanks.

Create new topic
3446 posts

Uber Geek
+1 received by user: 441

Trusted

  Reply # 579765 10-Feb-2012 13:56
Send private message

If these are static values per user your probably best to use something like Community Builder which gives you custom fields per user







889 posts

Ultimate Geek
+1 received by user: 127

Trusted

  Reply # 579773 10-Feb-2012 14:04
Send private message

Zeon: If these are static values per user your probably best to use something like Community Builder which gives you custom fields per user


Understood but how do I multiply and format the output?

The opening balance would be static per user.

The return on investment would be the same for every user and I would update this manually via sql query.

I need to read the users opening balance from the database and then multiply it by the ROI to give the current balance.  Should be simple but PHP looks like egyptian hieroglyphics to me :-)

Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

NZ and France seek to end use of social media for acts of terrorism
Posted 24-Apr-2019 12:13


Intel introduces the 9th Gen Intel Core mobile processors
Posted 24-Apr-2019 12:03


Spark partners with OPPO to bring new AX5s smartphone to New Zealand
Posted 24-Apr-2019 09:54


Orcon announces new always-on internet service for Small Business
Posted 18-Apr-2019 10:19


Spark Sport prices for Rugby World Cup 2019 announced
Posted 16-Apr-2019 07:58


2degrees launches new unlimited mobile plan
Posted 15-Apr-2019 09:35


Redgate brings together major industry speakers for SQL in the City Summits
Posted 13-Apr-2019 12:35


Exported honey authenticated on Blockchain
Posted 10-Apr-2019 21:19


HPE and Nutanix partner to deliver hybrid cloud as a service
Posted 10-Apr-2019 21:12


Southern Cross and ASN sign contract for Southern Cross NEXT
Posted 10-Apr-2019 21:09


Data security top New Zealand consumer priority when choosing a bank
Posted 10-Apr-2019 21:07


Samsung announces first 8K screens to hit New Zealand
Posted 10-Apr-2019 21:03


New cyber-protection and insurance product for businesses launched in APAC
Posted 10-Apr-2019 20:59


Kiwis ensure streaming is never interrupted by opting for uncapped broadband plans
Posted 7-Apr-2019 09:05


DHL Express introduces new MyDHL+ online portal to make shipping easier
Posted 7-Apr-2019 08:51



Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.