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

1 vote125 views1 answer
Unable to call component method
PHP
1 vote163 views3 answers
Laravel function to check if image exist or not
PHP Laravel
6 votes140 views1 answer
A2dismod php 8.0
PHP
5 votes151 views2 answers
How to make model and controller in laravel
PHP Laravel
0 vote160 views2 answers
Carbon Format date with timezone in views Laravel
PHP
0 vote169 views1 answer
Include Custom Post Types Categories to the main query
PHP
0 vote138 views1 answer
Get product price wordpress
PHP
0 vote174 views1 answer
Db connection postgres laravel
PHP
1 vote134 views1 answer
Laravel order by raw
PHP
20 votes129 views5 answers
Carbon date from format
PHP