$wpdb foreach

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 vote267 views1 answer
Get advanced custom field value in wordpress
PHP
0 vote363 views1 answer
Laravel\Socialite\Two\InvalidStateException
PHP Laravel
7 votes272 views3 answers
Php round to whole number
PHP
0 vote263 views1 answer
Blade loop last
PHP
6 votes291 views1 answer
Php import function from another file
PHP
3 votes313 views4 answers
Round() laravel
PHP Laravel
0 vote265 views1 answer
Call Route from controller larvel 8
PHP
1 vote288 views2 answers
Php validate credit card expiration date
PHP
6 votes281 views3 answers
Ubuntu 20.04 how to install npm
PHP
0 vote320 views1 answer
Language_attributes for wordpress
PHP