$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

0 vote206 views1 answer
How to call a function in model from a controller
PHP
6 votes228 views2 answers
Php check if entire array are in another array
PHP
12 votes241 views2 answers
Tomorrow carbon laravel
PHP Laravel
0 vote224 views1 answer
How to login laravel passport with postman
PHP
0 vote214 views1 answer
Copy file from one directory to another Laravel
PHP Laravel
0 vote248 views1 answer
Wordpress featured image show
PHP Wordpress
3 votes214 views1 answer
Laravel eloquent increment
PHP
0 vote282 views1 answer
Sass download for windows
PHP
23 votes229 views6 answers
Laravel validation messages
PHP Laravel
7 votes206 views2 answers
Laravel how to check if there are record exists
PHP