how to fetch the current user data in phpfox

Question

Topic: Fetch current user(some particular fields) data from the DB and display it on the Welcome Screen.

Explaination of UI : On the Registration Page, A dropdown would appear. As the user selects an option, it would trigger an event to fetch user image to show on the welcome page.

I have put following code in (pages.process) module

  function getUserId($iUserId)
        {
        $aRows = $this->database()->select('p.image_path')->from($this->_sTable, 'p')
->Join(Phpfox::getT('user') , 'u', ' p.page_id = u.college_name') -> 
        where('u.college_name = p.page_id AND u.user_id = ' . 
    (int)$iUserId)->execute('getRows');
            return $aRows;
            }

The data will selected from User & Pages Table, and will be used to show the user image. Please suggest.

Zong · Accepted Answer · 2014-05-30 13:50:43Z

1

There is a service to get user details by is

$user_id = Phpfox::getUserId();
$aRow  = Phpfox::getService('user')->getUser($user_id);

This will give you user details

edited May 30, 2014 at 13:50

Zong

6,2585 gold badges34 silver badges46 bronze badges

answered May 6, 2014 at 12:46

Ankit Agrawal

6,1246 gold badges27 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Purefan · Accepted Answer · 2014-04-05 09:50:31Z

For performance, check if the page you are altering already has the information you need, maybe you dont need to query the database in ajax if the page, when being created, already has that info and you can store it in javascript.

Since you mentioned an ajax situation (trigger an event on drop down to query the database), then you need to include a JS file (my suggestion since you can do this from a plugin), there are other ways but this is the best in my opinion. Please read my article about plugins if you need help with writing one. My suggestion is to write a plugin to include your JS file in the page.

In the JS file you can call a "controller function" like this:

$.ajaxCall('mymodule.myfunction', 'param1=value1&param2=value2');

this would run the function "myfunction" in the file /module/mymodule/include/component/ajax/ajax.class.php From this ajax file you can call "service functions" and send code to the browser, for example:

$value = Phpfox::getService('mmodule')->someOtherFunction();
$this->call('alert("' . $value . '");');

Hope it helps

Collectives™ on Stack Overflow

how to fetch the current user data in phpfox

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related