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 vote198 views1 answer
Yii2 gridview action change urls
PHP
0 vote239 views1 answer
Laravel DB facade relations
PHP Laravel
0 vote202 views1 answer
How to update a table based on three columns laravel
PHP Laravel
0 vote182 views1 answer
Wordpress post type template
PHP
0 vote222 views1 answer
Cakephp extract array
PHP
5 votes193 views6 answers
New laravel 8 project
PHP
4 votes231 views4 answers
Php add to associative array
PHP
0 vote217 views1 answer
How to get webhook response in laravel
PHP
0 vote246 views1 answer
How to open php file from pycharm in chrome
PHP
44 votes180 views3 answers
Mcrypt_decrypt php 7.2
PHP