PHP Function returning mysql_fetch_assoc() results in index based array?

Question

this is my first post here, in the past I found all my questions already solved. Not this time so please help me :-)!

Why is $returned_assoc_arr holding an index based array instead of the associative?
I also tried it with a reference public function &fetch_assoc($res) but without luck?
Is there any way to fix this? I really need this to be an associative array..

I hope I explained everything quite well and some Senior PHP Coders can help with this.

Here we go with the code snippets:

file1.php

public function fetch_assoc($res) {
  $assoc_arr = mysql_fetch_assoc($res);
  echo "<pre>";
  print_r($assoc_arr);
  echo "</pre>";
  return $assoc_arr;
}

file2.php

$returned_assoc_arr = $foo->fetch_assoc($res);
echo "<pre>";
print_r($returned_assoc_arr);
echo "</pre>";

Output from file2.php:

Array
(
    [id] => 42
    [Client] => 1
    [DebtorAccountNumber] => 1234512345
    [OrderDate] => 2001-04-03 02:00:00
    [Status] => 1
    [Comment] => this is a comment
    [CreatedBy] => 1
    [Reference] => 2083137729
)

Array
(
    [0] => 42
    [1] => 1
    [2] => 1234512345
    [3] => 2001-04-03 02:00:00
    [4] => 1
    [5] => this is a comment
    [6] => 1
    [7] => 2083137729
)

Are you absolutely sure that this is all the code that's working on the data? As what you're describing shouldn't be happening. — Yoshi
– Yoshi, Commented Jun 18, 2011 at 7:54
This code sample doesn't make any sense. Your method has an access modifier, which requires the method class to be defined within a class, but your method call of fetch_assoc, does not relate to the class with which the method is in. I therefore echo Yoshi's sentiments, are yu sure you are using this method when working on the data? — GordyD
– GordyD, Commented Jun 18, 2011 at 8:16

Headshota · Accepted Answer · 2011-06-18 08:38:29Z

1

The method fetch_assoc is a member function of a class. (it's invoked on the containing object, which must be instantiated first)

what you are using in file2 is a ordinary function fetch_assoc, which definitely is different than the function described in file1.

answered Jun 18, 2011 at 8:38

Headshota

21.4k13 gold badges63 silver badges82 bronze badges

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

2 Comments

hNz Over a year ago

Yes i'm sure I changed to code snipped it was misstyped by my self.. I'm calling the method fetch_assoc() from an object ($foo). I really don't know why this is like that.. still have not figured out why..

Robin Over a year ago

Most of the array functions will remove associative keys, so there is something happening that we cannot see in your snippets. Can you post more of your code (or the complete set) to pastebin.

Collectives™ on Stack Overflow

PHP Function returning mysql_fetch_assoc() results in index based array?

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related