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

0 vote295 views1 answer
Mysqli_test
PHP
4 votes308 views1 answer
Db enable query log
PHP
4 votes290 views2 answers
How to create access token in laravel
PHP
19 votes316 views5 answers
Php check string
PHP
0 vote284 views1 answer
Wordpress check if page is password protected
PHP
1 vote282 views3 answers
Print query statement in laravel
PHP
0 vote362 views1 answer
Set config key dynamic laravel
PHP Laravel
0 vote333 views1 answer
How to create compomemt in laravel livewire
PHP Laravel
0 vote278 views1 answer
Get page name wp
PHP
2 votes318 views4 answers
Failed to clear cache. make sure you have the appropriate permissions. laravel
PHP