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 votes271 views2 answers
Gallery advanced custom fields
PHP
-1 vote300 views1 answer
Laravel orderby with relation
PHP Laravel
0 vote348 views1 answer
Upload image with watermark in codeigniter
PHP CodeIgniter
1 vote316 views2 answers
Update checkbox value in laravel
PHP Laravel
18 votes289 views5 answers
If statement in laravel blade
PHP Laravel
0 vote323 views1 answer
Php list all constants
PHP
0 vote296 views3 answers
SQLSTATE[42S02]: Base table or view not found: 1146 Table many to many in laravel
PHP Laravel
0 vote278 views2 answers
Start/php>2
PHP
0 vote309 views1 answer
Laravel create new file if not exists
PHP Laravel
0 vote256 views1 answer
Why php is not using datatype
PHP