Sql, Object vs String/Array

Question

Why does this produce an object?

$sql = $this->db->query("
  SELECT 'product_id'
  FROM " . DB_PREFIX . "product_to_category
  WHERE category_id = '" . $this->db->escape($category['category_id']) . "'
");

And how to I get a string/array instead?

From Opencart Related: Object of class stdClass could not be converted to string

According to usage and table name it is class from OpenCart. — Kirzilla
– Kirzilla, Commented Jun 25, 2012 at 17:45
Yeah it's Opencart, I think they used CodeIgniter to build it. What other info will be helpful? — Cleverbot
– Cleverbot, Commented Jun 25, 2012 at 17:50
@Cleverbot, see /admin/models/country.php - there are a lot of good examples about working with db layer. Also, there a lot of examples in other model files. PS: Don't forget to escape string data. — Kirzilla
– Kirzilla, Commented Jun 25, 2012 at 17:54

biziclop · Accepted Answer · 2012-06-25 17:41:03Z

2

Assuming CodeIgniter:

http://codeigniter.com/user_guide/database/queries.html

$this->db->query();

The query() function returns a database result object when "read" type queries are run, which you can use to show your results.

You can process the result set rows as array, using result_array:

http://codeigniter.com/user_guide/database/results.html

$query = $this->db->query("YOUR QUERY");

foreach ($query->result_array() as $row){
   echo $row['title'];
   echo $row['name'];
   echo $row['body'];
}

answered Jun 25, 2012 at 17:41

biziclop

14.6k3 gold badges52 silver badges66 bronze badges

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

1 Comment

Cleverbot Over a year ago

I get "Call to undefined method stdClass::result_array()". It's totally bizarre I'm not getting a string/array like it normally does.

Cleverbot · Accepted Answer · 2012-06-25 18:26:57Z

1

$sql = $this->db->query("
  SELECT 'product_id'
  FROM " . DB_PREFIX . "product_to_category
  WHERE category_id = '" . $this->db->escape($category['category_id']) . "'
");
$rows = $sql->rows; //array of all returned values
$row = $sql->row; //first row

I highly recommend you to use var_dump($sql) to investigate what public object fields could be useful for you.

*Fixed syntax

edited Jun 25, 2012 at 18:26

Cleverbot

5743 silver badges10 bronze badges

answered Jun 25, 2012 at 18:09

Kirzilla

16.6k27 gold badges89 silver badges131 bronze badges

4 Comments

Cleverbot Over a year ago

That totally turned it into an array thanks!! One other thing, what if my return is a single string? should I cut out "$rows = #sql->$rows;"?

Kirzilla Over a year ago

$query = $this->db->query("SELECT COUNT(*) AS total FROM " . DB_PREFIX . "country"); return $query->row['total']; Note $query->row, not $query->rows.

Cleverbot Over a year ago

That works but I was looking to extract a single string value from the database, or a single string value from the array from the database. When I try your initial method it just gives me the name of the value as opposed to the value itself.

Cleverbot Over a year ago

This is my dump: 'Array ( [0] => Array ( [product_id] => product_id ) [1] => Array ( [product_id] => product_id ) [2] => Array ( [product_id] => product_id ) )'

Cleverbot · Accepted Answer · 2012-06-26 19:00:41Z

0

You have an error in your query syntax, you put SELECT 'product_id' and you should not have apostrophies there.

$sql = $this->db->query("
  SELECT 'product_id'
  FROM " . DB_PREFIX . "product_to_category
  WHERE category_id = '" . $this->db->escape($category['category_id']) . "'
");

You need to make this change.

$sql = $this->db->query("
  SELECT product_id
  FROM " . DB_PREFIX . "product_to_category
  WHERE category_id = '" . $this->db->escape($category['category_id']) . "'
");

answered Jun 26, 2012 at 19:00

Cleverbot

5743 silver badges10 bronze badges

Collectives™ on Stack Overflow

Sql, Object vs String/Array

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related