$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

0 vote250 views2 answers
Php decrement variable
PHP
0 vote314 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel
2 votes318 views3 answers
Laravel check empty string
PHP
2 votes272 views3 answers
Ternary in php
PHP
6 votes321 views1 answer
Laravel eloquent whereDateBetween
PHP Laravel
-1 vote289 views10 answers
Loop array
PHP
0 vote284 views1 answer
Laravel blank page
PHP
0 vote269 views1 answer
Laravel update order field sample
PHP
0 vote277 views1 answer
How to check if query is successfully inserted laravel
PHP
2 votes264 views1 answer
Laravel artisan create criteria
PHP