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

17 votes189 views2 answers
Mysql replace a character in a string
PHP
21 votes194 views3 answers
Query sql in php
PHP
1 vote195 views2 answers
Laravel 8 seeding
PHP
2 votes163 views1 answer
Laravel delete confirm link
PHP
3 votes267 views2 answers
Where_in codeigniter
PHP CodeIgniter
0 vote189 views1 answer
Php back to original site
PHP
8 votes202 views1 answer
Laravel validation string type
PHP Laravel
10 votes201 views6 answers
Laravel Pagination
PHP Laravel
3 votes218 views3 answers
Laravel notification
PHP
0 vote201 views1 answer
Argument 1 passed to Illuminate\Database\Grammar::parameterize()
PHP