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

74 votes179 views6 answers
String to int php
PHP
0 vote179 views1 answer
Php how to check if page is accessed via post
PHP
0 vote198 views1 answer
Get product price wordpress
PHP Wordpress
11 votes182 views6 answers
How to print on python
PHP
2 votes208 views1 answer
Redirect from controller in laravel
PHP Laravel
0 vote202 views1 answer
"\u00e9" php
PHP
5 votes193 views3 answers
Wordpress get fiture image
PHP
0 vote171 views1 answer
Php exception message
PHP
0 vote185 views1 answer
Run phpcs from vs code for wordpress
PHP
0 vote180 views1 answer
How to remove words in contain integer php
PHP