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

5 votes224 views2 answers
Laravel groupby and latest
PHP
0 vote257 views2 answers
Laravel bootstrap nav active
PHP Laravel
0 vote279 views1 answer
Php var_dump more readable
PHP
0 vote237 views1 answer
What is the name of scripting engine in PHP?
PHP
0 vote227 views4 answers
How i can send by database table in laravel full calendar
PHP
10 votes260 views6 answers
Format time laravel
PHP Laravel
2 votes249 views2 answers
How to add data to the request object in laravel
PHP
30 votes257 views3 answers
Random key generator php
PHP
3 votes275 views2 answers
Laravel .htaccess settings
PHP Laravel
1 vote265 views1 answer
Wp get field taxonomy
PHP Wordpress