How to use drupal to query databases? -Php Tutorial

How to get all entity_id whose vote_source is 1, get all fields in the video table through entity_id, and return. I am not very familiar with php. please help me.

How to obtain all entity_id whose vote_source is 1,
Then, get all the fields in the video table using entity_id and return.
I am not very familiar with php. please help me.

Reply content:

How to obtain all entity_id whose vote_source is 1,
Then, get all the fields in the video table using entity_id and return.
I am not very familiar with php. please help me.

Php$ Ids = db_query ('select entity_id FROM votes WHERE vote_source = 1')-> fetchCol (); $ nodes = node_load_multiple ($ ids ); print $ nodes-> {$ field_name} ['und'] [0] ['value'];