$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

9 votes163 views4 answers
Mage log equivalent magento 2
PHP
6 votes199 views3 answers
Laravel 8 with jetstream
PHP
2 votes197 views1 answer
Laravel db does not exists
PHP Laravel
0 vote181 views1 answer
Ent_quotes in php
PHP
0 vote198 views1 answer
Php creating a subdomain automatically in cpanel
PHP
3 votes222 views2 answers
Wp do sql query from function
PHP
4 votes229 views2 answers
Pakistan standard time zone
PHP
0 vote236 views2 answers
Script inside php
PHP
0 vote177 views1 answer
Laravel 8 db like query
PHP
0 vote170 views1 answer
Get only the first two word from a string php
PHP