$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

10 votes334 views3 answers
Check count in laravel
PHP
1 vote402 views1 answer
Laravel set config value dynamically
PHP Laravel
1 vote346 views3 answers
Php check connection to database
PHP
0 vote353 views1 answer
Laravel migration unknown column type double requested
PHP
0 vote379 views1 answer
Validate file count with validate in laravel
PHP Laravel
4 votes327 views1 answer
Php self
PHP
0 vote326 views3 answers
Caculator
PHP
0 vote362 views1 answer
Resubmit on refresh php
PHP
0 vote333 views1 answer
The post function wordpress
PHP
0 vote325 views1 answer
$tmpmembershipfee = MembershipFee::orderBy('created_at','DESC') ->first();
PHP