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

0 vote272 views1 answer
He PHP exec() function must be enabled.
PHP
0 vote267 views1 answer
Make fa icon bigger bootstrap
PHP
0 vote294 views1 answer
Mysqli_test
PHP
7 votes365 views3 answers
Wordpress echo the date in post
PHP Wordpress
9 votes341 views7 answers
How to get plugin directory path in wordpress
PHP Wordpress
0 vote284 views1 answer
Laravel get relation camelcase api
PHP
0 vote309 views1 answer
Nova laravel image
PHP
1 vote291 views1 answer
Http error 500 phpmyadmin
PHP
1 vote236 views1 answer
Php unset multiple values
PHP
0 vote398 views2 answers
Drupal 8 add message
PHP Drupal