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 vote287 views1 answer
Php check if string contains words from array
PHP
1 vote306 views4 answers
In_array validation laravel
PHP Laravel
0 vote303 views1 answer
Phpstormda php faylning tepasiga avto kommet yozish
PHP
4 votes335 views1 answer
How to check query execution time in laravel
PHP Laravel
0 vote282 views2 answers
Set posts_per_page
PHP
9 votes281 views3 answers
Array push object php
PHP
-1 vote252 views1 answer
Laravel edit form select don't repeat a selected value
PHP
0 vote295 views1 answer
Your Composer dependencies require the following PHP extensions to be installed: dom, xml, xmlwriter
PHP
0 vote273 views1 answer
Php is_assoc
PHP
6 votes324 views4 answers
Laravel previous url
PHP Laravel