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

60 votes182 views3 answers
Print only some characters of a string in php
PHP
2 votes222 views2 answers
Get relationship data from soft delete laravel
PHP Laravel
2 votes257 views1 answer
Merubah judul menjadi slug codeigniter
PHP CodeIgniter
0 vote191 views4 answers
Wordpress get current taxonomy
PHP
7 votes182 views2 answers
Wordpress get post type
PHP
0 vote184 views1 answer
Laravel display old value in form
PHP
11 votes176 views3 answers
Cast array to object php
PHP
0 vote179 views1 answer
Many to many relationship in laravel example stackoverflow
PHP
0 vote213 views3 answers
Php to call javascript function
PHP
0 vote205 views1 answer
How to increase wp mailster attachment size
PHP