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.


BigMal

996 posts

Ultimate Geek

ID Verified
Trusted

#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
Zeon
3916 posts

Uber Geek

Trusted

  #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




Speedtest 2019-10-14




BigMal

996 posts

Ultimate Geek

ID Verified
Trusted

  #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





News and reviews »

Air New Zealand Starts AI adoption with OpenAI
Posted 24-Jul-2025 16:00


eero Pro 7 Review
Posted 23-Jul-2025 12:07


BeeStation Plus Review
Posted 21-Jul-2025 14:21


eero Unveils New Wi-Fi 7 Products in New Zealand
Posted 21-Jul-2025 00:01


WiZ Introduces HDMI Sync Box and other Light Devices
Posted 20-Jul-2025 17:32


RedShield Enhances DDoS and Bot Attack Protection
Posted 20-Jul-2025 17:26


Seagate Ships 30TB Drives
Posted 17-Jul-2025 11:24


Oclean AirPump A10 Water Flosser Review
Posted 13-Jul-2025 11:05


Samsung Galaxy Z Fold7: Raising the Bar for Smartphones
Posted 10-Jul-2025 02:01


Samsung Galaxy Z Flip7 Brings New Edge-To-Edge FlexWindow
Posted 10-Jul-2025 02:01


Epson Launches New AM-C550Z WorkForce Enterprise printer
Posted 9-Jul-2025 18:22


Samsung Releases Smart Monitor M9
Posted 9-Jul-2025 17:46


Nearly Half of Older Kiwis Still Write their Passwords on Paper
Posted 9-Jul-2025 08:42


D-Link 4G+ Cat6 Wi-Fi 6 DWR-933M Mobile Hotspot Review
Posted 1-Jul-2025 11:34


Oppo A5 Series Launches With New Levels of Durability
Posted 30-Jun-2025 10:15









Geekzone Live »

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



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.