$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

7 votes37 views3 answers
Php array flip
PHP
1 vote51 views1 answer
Migration create symfony
PHP Symfony
6 votes42 views1 answer
Wordpress get_date
PHP Wordpress
0 vote43 views2 answers
Laravel log could not be opened fix
PHP Laravel
0 vote30 views1 answer
Selecting values from database
PHP
4 votes55 views2 answers
Laravel please provide a valid cache path
PHP Laravel
0 vote42 views1 answer
How to get all the records with same ID in laravel
PHP Laravel
2 votes39 views2 answers
Laravel 5.8 cors
PHP Laravel
0 vote35 views2 answers
Remove number after decimal in php
PHP
9 votes36 views1 answer
Php string to uppwe
PHP