PHP Access object property from CI result object

Question

This is my code, I'm searching the table names which ends with keyword called '_countries'.

I'm getting a result also but I do not know how to get table name from that result.

This is the code the fetches the query result:

$sql="show tables like '%_countries'";
$result=$this->db->query($sql);
foreach ($result -> result() as $delete) {
    print_r( $delete);
}

The print_r()'s result is:

stdClass Object ( [Tables_in_test (%_countries)] => news_countries )

news_countries is the result which I need.

This is how I'm trying to access the property inside the loop:

$delete->table_name;
$delete->name;
$delete->Tables_in_test;

But above codes did not give result I need.

Undefined property: stdClass::$table_name this error when i try with $delete->table_name; — Thamaraiselvam
– Thamaraiselvam, Commented Jan 22, 2015 at 7:28
weird property name, try $delete->{'Tables_in_test (%_countries)'} — Kevin
– Kevin, Commented Jan 22, 2015 at 7:29

Kevin · Accepted Answer · 2015-01-22 07:32:30Z

1

You could also try to use reset() in this case:

foreach ($result->result_array() as $delete) {
    $name = reset($delete);
    echo $name;
}

answered Jan 22, 2015 at 7:32

Kevin

41.9k12 gold badges57 silver badges72 bronze badges

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

4 Comments

Thamaraiselvam Over a year ago

it works like charm , and please upvote my question ,it will be useful for some other people

Kevin Over a year ago

@Thamaraiselvam i think another way is selecting it thru INFORMATION_SCHEMA, plus, you get to choose your own alias for that column name, i just can't test it since i don't have CI on my env, anyways, glad this helped,

Thamaraiselvam Over a year ago

Okay , Thank you for your wonderful helping . i will try with INFORMATION_SCHEMA also

Kevin Over a year ago

something like: SELECT TABLE_NAME` AS table_name FROM information_schema.TABLES WHERE TABLE_NAME LIKE '%countries%'`

Collectives™ on Stack Overflow

PHP Access object property from CI result object

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related