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 vote167 views2 answers
Laravel has one through relationship
PHP
38 votes169 views6 answers
Capitalize in php
PHP
0 vote120 views1 answer
Laravel, if ->get() array is not emtpy
PHP Laravel
1 vote165 views3 answers
Php class
PHP
13 votes177 views5 answers
How to change validation message in laravel
PHP Laravel
3 votes158 views3 answers
Php stristr
PHP
2 votes174 views1 answer
Laravel where update query
PHP Laravel
0 vote150 views2 answers
Readable var dump php
PHP
3 votes159 views2 answers
Php mysql search database and display results
PHP
0 vote162 views1 answer
Get if bowser supports webp php
PHP