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

5 votes352 views3 answers
Laravel drop column if exists
PHP Laravel
0 vote287 views1 answer
Update php version in docker container
PHP
2 votes324 views2 answers
Eloquent with select
PHP
0 vote300 views1 answer
Hashing passwords in yii 1
PHP
5 votes399 views4 answers
App url laravel
PHP Laravel
3 votes348 views5 answers
Php loop object
PHP
0 vote305 views1 answer
Php back to original site
PHP
2 votes363 views3 answers
How to get the size of an uploaded file in laravel
PHP Laravel
6 votes302 views6 answers
Php iterate through objects
PHP
2 votes321 views2 answers
Php enum
PHP