Php wpdb foreach

get_header();
function get_records()
{
	//$con=connectsql();
	$records=$wpdb->query("SELECT * FROM $wpdb->posts WHERE post_type = 'elements' AND post_status = 'publish'");
	$all=array();
	while($data=$records->fetch_assoc())
	{
		$all[]=$data;
	}
	return $all;
}

Source: wordpress.org

$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

10 votes256 views6 answers
Laravel eloquent with
PHP
14 votes255 views3 answers
Change returning datetime timezone to recalculate with user timezone laravel
PHP
5 votes245 views2 answers
Mac install php-fpm
PHP
7 votes241 views2 answers
Last recode of DB using laravel
PHP Laravel
1 vote269 views1 answer
Laravel add timestamps to existing table
PHP Laravel
0 vote243 views1 answer
Php remove path from string url
PHP
0 vote275 views1 answer
Laravel collection shuffle
PHP Laravel
2 votes226 views2 answers
Check number is positive or negative in php
PHP
6 votes229 views5 answers
Laravel disable cors
PHP
0 vote288 views1 answer
Laravel get previous route without domain
PHP Laravel