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 vote170 views1 answer
Yii::app()->request->get yii1
PHP
0 vote180 views2 answers
Where are WordPress Pages and Posts Stored
PHP Wordpress
0 vote168 views1 answer
Php post variables to another page with submit button php
PHP
0 vote157 views1 answer
Php curl detect 404
PHP
4 votes186 views2 answers
Laravel DB wherein
PHP Laravel
5 votes175 views2 answers
Laravel jetstream livewire
PHP
57 votes162 views6 answers
File_get_contents php
PHP
0 vote133 views1 answer
Laravel wordpress reset password
PHP Laravel
0 vote162 views3 answers
Method Illuminate\Database\Eloquent\Collection
PHP
11 votes196 views6 answers
Woocommerce php get product attributes
PHP