Wpdb get results foreach

$results=$wpdb->get_results("SELECT * FROM your_table_name WHERE id LIKE' . $id . ';");
foreach($results  as $key => $row) {
// each column in your row will be accessible like this
$my_column = $row->column_name;}

Source: wordpress.stackexchange.com

$wpdb foreach

	$records=$wpdb->query("SELECT * FROM $wpdb->posts WHERE post_type = 'elements' AND post_status = 'publish'");

	while($data=$records->fetch_assoc())
	{
		print_r($data);
	}
	
}

Source: wordpress.org

Similar codes

-2 votes117 views1 answer
Wp get category by id
PHP
1 vote73 views1 answer
How to run php server ubuntu
PHP
0 vote104 views1 answer
Wordpress ftp functions.php
PHP
5 votes125 views3 answers
Laravel display error message
PHP Laravel
2 votes336 views1 answer
Wordpress display all variables
PHP Wordpress
3 votes114 views10 answers
Traductor
PHP
1 vote138 views2 answers
Php check array is not associative
PHP
28 votes125 views5 answers
Get current year php
PHP
2 votes105 views4 answers
Php sort reverse
PHP
1 vote107 views1 answer
Get taxonomy name in singhle post
PHP