$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

5 votes138 views1 answer
Redirect wordpress
PHP
0 vote127 views1 answer
How to use custome functions in laravel
PHP
3 votes160 views1 answer
Artisan to make model controller factroy seeder at once
PHP
2 votes142 views1 answer
Migrations required field laravel
PHP
43 votes156 views6 answers
Laravel create migration add column
PHP Laravel
0 vote143 views1 answer
How show livewire component in laravel
PHP
0 vote133 views1 answer
Assertequals vs assertsame
PHP
0 vote145 views2 answers
Php check if value exists in multidimensional array
PHP
12 votes169 views5 answers
Array to object php
PHP
0 vote191 views1 answer
Eloquent limit vs take
PHP