Getting errors on mysql returned array

Question

We are using following code for setters.

            if (is_numeric($id)) {

            global $db;

            $product = $db->query('SELECT id, name, code, amount FROM products WHERE id = ' . $id . ' LIMIT 1');

            print_r($product);
            echo $product['name'];

            if (!empty($product)) {

                $this->cId = $product['id'];

                $this->cName = $product['name'];

                $this->cDuration = $product['code'];

                $this->cCost = $product['amount'];

            }

            else return false;

        }

    }

But its giving following output with notices...

Array ( [0] => Array ( [id] => 2 [name] => Gaming [code] => 12 [amount] => 20000 ) )

Notice: Undefined index: name in root//class.products.php on line 26

Notice: Undefined index: id in root/class.products.php on line 30

What are we doing wrong, please help, thanks.

Use $product[0]['name'] instead of $product['name']. Your db-abstraction layer expects to return a whole resultset, not just a single row. — Wrikken
– Wrikken, Commented Mar 29, 2011 at 23:35

Mike Lewis · Accepted Answer · 2011-03-29 23:35:07Z

2

$product actually contains an array of an array, in which you want to access the first one by doing $product[0]

You want to do this instead:

$product[0]['id']

$product[0]['name']

and so on.

answered Mar 29, 2011 at 23:35

Mike Lewis

64.3k20 gold badges144 silver badges111 bronze badges

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

1 Comment

deceze Over a year ago

@seoppc It's not a trick if it's the necessary solution. :-P

deceze · Accepted Answer · 2011-03-29 23:36:19Z

1

Your array has a nested array, so you'd need to access it using $product[0]['name']. There's still no key 'duration' or 'fee' in there though.

answered Mar 29, 2011 at 23:36

deceze♦

525k89 gold badges806 silver badges954 bronze badges

Comments

Alp · Accepted Answer · 2011-03-29 23:36:16Z

0

It's a subarray. You can access it with $product[0]['id'] for example `

answered Mar 29, 2011 at 23:36

Alp

29.8k29 gold badges123 silver badges204 bronze badges

Collectives™ on Stack Overflow

Getting errors on mysql returned array

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related