$wpdb foreach

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 vote316 views2 answers
Php example
PHP
24 votes360 views4 answers
Clear cache command in laravel controller
PHP
0 vote328 views2 answers
Dynamic Carousel in Laravel not working displays only one image
PHP
0 vote383 views1 answer
Displaying dates using php code
PHP
0 vote321 views1 answer
Check date php
PHP
11 votes321 views2 answers
Woocommerce get product id
PHP
0 vote282 views1 answer
Php postgresql number of rows
PHP
1 vote392 views1 answer
Phpstorm serial key 2020.2.3
PHP
0 vote299 views1 answer
Int to char php
PHP
12 votes461 views4 answers
Wordpress get post thumbnail
PHP Wordpress