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

1 vote455 views1 answer
Break and continue in laravel
PHP Laravel
4 votes338 views5 answers
Php run command line
PHP
4 votes346 views2 answers
Wordpress order by
PHP
0 vote322 views1 answer
Laravel schedule run
PHP Laravel
0 vote332 views2 answers
Laravel migration change column order
PHP
0 vote297 views2 answers
Carbon get all days in month
PHP
0 vote411 views1 answer
Laravel range query
PHP Laravel
0 vote395 views2 answers
Laravel pagination layout issue
PHP Laravel
0 vote347 views1 answer
Ile_put_contents(/opt/bitnami/apache2/htdocs/bootstrap/cache/services.php): failed to open stream: Permission denied
PHP
1 vote352 views3 answers
How to store array in variable php
PHP