XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. XOOPS general usage questions 
  4.  / Custom block???
Register
1
dolphino
Custom block???

  • 2003/11/14 9:41

  • dolphino

  • Just popping in

  • Posts: 7

  • Since: 2003/11/12


Hello
I´m a newcomer at using XOOPS but I have a problem.The situation is: In a database I have a table xoops_data_kli which consist of information about clients.I always need to show all information that belongs to the client. The table consists of an item user_id which is the same as the user´s XOOPS login name...
Could you anyone help me please?
2
ackbarr
Re: Custom block???

...and you want to show this information for each client in a block? Set your custom block's content type to php and try something like this:

global $xoopsUser, $xoopsDB;


//Ensure the current viewer is logged in
if ($xoopsUser) {
  //Setup SQL Query
  $sql = "SELECT * FROM " . $xoopsDB->prefix('data_kli') . " WHERE user_id = '" . $xoopsUser->getVar('uname') . "'";

  //Send SQL Query to server
  $ret = $xoopsDB->query($sql);
  
  if ($ret) {
    while ($myarr = $xoopsDB->fetchArray($ret)) {
      //Output each record returned from the db
      //Variables are avialable like this:   
      //$myarr['user_id']
    }
  } else {
    //No records returned
    return false;
  }
} else {
  //Current viewer is not logged in
  return false;
}


3
dolphino
Re: Custom block???

  • 2003/11/15 11:38

  • dolphino

  • Just popping in

  • Posts: 7

  • Since: 2003/11/12



Yes, thnx

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

286 user(s) are online (154 user(s) are browsing Support Forums)

Members: 0

Guests: 286

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits