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.


874 posts

Ultimate Geek
+1 received by user: 121

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
3415 posts

Uber Geek
+1 received by user: 405

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







874 posts

Ultimate Geek
+1 received by user: 121

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:



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.

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