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

3 votes219 views2 answers
How to rename a table element in laravel
PHP
0 vote274 views1 answer
Php array of states in Nigeria
PHP
2 votes218 views2 answers
Laravel websockets
PHP
4 votes238 views2 answers
Php authentication
PHP
2 votes236 views3 answers
Create new user fortify action how it work laravel 8
PHP
1 vote209 views3 answers
Php syntax
PHP
14 votes259 views6 answers
Update query in laravel eloquent
PHP
0 vote240 views2 answers
Laravel livewire-datatable delete column pop up issue
PHP Laravel
0 vote244 views1 answer
Laravel validatrion check should be null
PHP
0 vote261 views1 answer
Php count matching words in two strings
PHP