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

18 votes209 views1 answer
Specified key was too long; max key length is 767 bytes (s
PHP
0 vote194 views1 answer
Php get start of today
PHP
0 vote215 views1 answer
Php mod real numbers
PHP
0 vote209 views1 answer
Delete record without a page refresh with ajax in php
PHP
1 vote209 views1 answer
Failed to connect to github.com port 443: Connection timed out
PHP
0 vote211 views1 answer
Laravel event generate
PHP
0 vote240 views1 answer
Encode in laravel api
PHP
0 vote216 views2 answers
Ã„ convert orignal character php
PHP
0 vote240 views1 answer
Get user symfony
PHP Symfony
50 votes232 views6 answers
Laravel add column to table
PHP