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. General XOOPS.org forums / 
  3. Technology, Tools, Best Practices 
  4.  / xoopsDB and mysql_fetch_assoc
Register
1
goffy
xoopsDB and mysql_fetch_assoc

  • 2016/8/8 15:27

  • goffy

  • Just can't stay away

  • Posts: 554

  • Since: 2010/12/27


Hi

can someone help me:

Xoops 2.5.7.2
php 5.6.19

This code works:
le="color: #000000"><?php $sql = 'SELECT * FROM piwik_site;'; $result = $xoopsDB->query($sql); while ($row = mysql_fetch_assoc($result)) { echo "result row:".$row['name']; }


why does
le="color: #000000"><?php ... while ($row = mysqli_fetch_assoc($result)) { ...

not working?
Quote:
Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, resource given in...
2
Mamba
Re: xoopsDB and mysql_fetch_assoc

  • 2016/8/8 16:39

  • Mamba

  • Moderator

  • Posts: 11521

  • Since: 2004/4/23


First, if possible, avoid any direct MySQL command, instead, use XOOPS.

So in this case, try:

le="color: #000000"><?php $GLOBALS['xoopsDB']->fetchArray
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
3
goffy
Re: xoopsDB and mysql_fetch_assoc

  • 2016/8/8 17:44

  • goffy

  • Just can't stay away

  • Posts: 554

  • Since: 2010/12/27


hi mamba

works, thank you

one additional basic question:
what should be used:
le="color: #000000"><?php global $xoopsDB; ... $result = $xoopsDB->query($sql); ...

or
le="color: #000000"><?php ... $result = $GLOBALS['xoopsDB']->query($sql); ...

or is this equal?
4
Mamba
Re: xoopsDB and mysql_fetch_assoc

  • 2016/8/8 23:28

  • Mamba

  • Moderator

  • Posts: 11521

  • Since: 2004/4/23


Both are the same, but the trend is to use more:

le="color: #000000"><?php $GLOBALS['xoopsDB']


as it shows in the code that the object or variable you're working with, is "GLOBAL", so it will make future code refactoring easier.
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

Post Reply

      
5 - 1 = ?  
Input the result from the expression
Maximum attempts you can try: 10
* = Required

Search

Advanced Search

Recent Posts

Who's Online

185 user(s) are online (136 user(s) are browsing Support Forums)

Members: 0

Guests: 185

more...

Donat-O-Meter

Stats
Goal: $15.00
Due Date: Jul 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $15.00
Make donations with PayPal!

Latest GitHub Commits