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 votes146 views4 answers
Get base url in wordpress
PHP
4 votes163 views4 answers
Carbon get difference between two dates in years and months
PHP
0 vote144 views1 answer
File could not be downloaded: Unable to find the wrap per "https" - did you forget to enable it when you configured PHP? failed to open stream: No such file or directory
PHP
1 vote133 views1 answer
Php sign with private key
PHP
5 votes132 views3 answers
'mix' is not recognized as an internal or external command
PHP
0 vote146 views1 answer
Radio button select in php
PHP
1 vote165 views2 answers
Fillable vs guarded laravel
PHP Laravel
9 votes160 views2 answers
Php check if object has key
PHP
1 vote149 views2 answers
Laravel session put method
PHP
0 vote151 views2 answers
How to make diffrent php pages have diffrent styles
PHP