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 vote334 views2 answers
Where clause with paginate laravel multiple column
PHP
2 votes342 views1 answer
Migration bool type eloquent orm
PHP
1 vote300 views1 answer
Empty func php
PHP
6 votes321 views1 answer
How do decode base64 php
PHP
0 vote333 views1 answer
Disconnect with button click php
PHP
1 vote333 views1 answer
Start server in laravel
PHP
34 votes318 views6 answers
Format date in php
PHP
3 votes388 views2 answers
Wp do sql query from function
PHP Wordpress
0 vote308 views1 answer
Class 'PHPUnit_Framework_TestCase' not found in vendor
PHP
1 vote308 views1 answer
Shoulder blade technical name
PHP