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 vote216 views1 answer
Laravel where doesn't have
PHP Laravel
0 vote186 views1 answer
Laravel create token Trying to get property 'id' of non-object
PHP
0 vote177 views1 answer
Php remove slash from string
PHP
0 vote169 views1 answer
Check if object has method php
PHP
2 votes174 views1 answer
How to make a model in folder in laravel
PHP
1 vote153 views1 answer
I+= in php
PHP
0 vote209 views1 answer
Intl extension php ubuntu
PHP
0 vote163 views1 answer
WooCommerce: Add Content to a Specific Order Email
PHP
35 votes156 views6 answers
Convert string to lowercase in php
PHP
7 votes207 views3 answers
Laravel random query
PHP Laravel