display value from fetched array

Question

I want to display value from fetched array from database I want to display only field_data_field_videoicon_node_entity_type

global $user;
$uid = $user->uid;
$result = db_query("SELECT node.title AS node_title, node.nid AS nid,  node.created AS node_created,  'node' AS field_data_field_videoicon_node_entity_type, 'node' AS field_data_field_customername_node_entity_type
FROM {node} node LEFT JOIN {field_data_field_customervideo} field_data_field_customervideo ON node.nid = field_data_field_customervideo.entity_id AND field_data_field_customervideo.entity_type = 'node' WHERE (( (node.status = 1 OR (node.uid = 1 AND 1 <> 0 AND 1 = 1) OR 1 = 1) AND (node.type IN  ('customerspeach')) )) ORDER BY node_created DESC LIMIT 3 OFFSET 0")->fetchAll(); 
// Printing result.
print_r($result);

$result returns

Array ( 
    [0] => stdClass Object ( 
        [node_title] => client speach 2 
        [nid] => 65 
        [node_created] => 1473758768 
        [field_data_field_videoicon_node_entity_type] => node
        [field_data_field_customername_node_entity_type] => node 
    ) 
    [1] => stdClass Object ( 
        [node_title] => Customer Speak 
        [nid] => 62
        [node_created] => 1472720228
        [field_data_field_videoicon_node_entity_type] => node
        [field_data_field_customername_node_entity_type] => node 
    ) 
)

try iterating over the array of results, You have an array of objects. foreach($results as $result){ echo $result->field_data_field_videoicon_node_entity_type; } — ArtisticPhoenix
– ArtisticPhoenix, Commented Sep 14, 2016 at 6:02

urfusion · Accepted Answer · 2016-09-14 06:03:08Z

1

This is object array. You can retrieve data by using -> arrow sign.

foreach($result as $data){
    echo $data -> field_data_field_videoicon_node_entity_type;
}

answered Sep 14, 2016 at 6:03

urfusion

5,4995 gold badges56 silver badges91 bronze badges

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

Collectives™ on Stack Overflow

display value from fetched array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related