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: 555

  • Since: 2010/12/27


Hi

can someone help me:

Xoops 2.5.7.2
php 5.6.19

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

why does
...
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: 11544

  • Since: 2004/4/23


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

So in this case, try:

$GLOBALS['xoopsDB']->fetchArray
Support XOOPS => DONATE
Use 2.7.x | Docs | Modules | Bugs
3
goffy
Re: xoopsDB and mysql_fetch_assoc

  • 2016/8/8 17:44

  • goffy

  • Just can't stay away

  • Posts: 555

  • Since: 2010/12/27


hi mamba

works, thank you

one additional basic question:
what should be used:
global $xoopsDB;
...
$result = $xoopsDB->query($sql);
...
or
...
$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: 11544

  • Since: 2004/4/23


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

$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.7.x | Docs | Modules | Bugs

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Donat-O-Meter

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