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 vote261 views1 answer
Php add element to beginning of associative array
PHP
0 vote236 views1 answer
Laravel vreeze
PHP Laravel
0 vote216 views1 answer
Wp get user meta
PHP Wordpress
1 vote195 views1 answer
Phpexcel set row height
PHP
22 votes222 views1 answer
Php difference between two dates in years months and days
PHP
0 vote191 views1 answer
Redirect with compact laravel
PHP Laravel
0 vote258 views1 answer
Deleting all files inside a directory laravel 8
PHP Laravel
1 vote189 views3 answers
Check image exist or not in laravel
PHP
0 vote207 views1 answer
Wp php get rows number from mysql
PHP Wordpress
0 vote187 views1 answer
Php laravel rount price to 99
PHP