$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 vote290 views2 answers
Laravel get average from a column
PHP Laravel
0 vote307 views1 answer
Php list all constants
PHP
36 votes259 views6 answers
Strtolower php
PHP
8 votes264 views4 answers
Php get object class
PHP
3 votes268 views2 answers
What is the use of migration file in laravel
PHP
2 votes248 views2 answers
Laravel list of models
PHP
0 vote257 views1 answer
Syntax error, unexpected 'elseif' (T_ELSEIF)
PHP
15 votes256 views6 answers
Install laravel
PHP
6 votes226 views6 answers
Get url parameters in laravel blade
PHP
7 votes296 views2 answers
Transaction commit rollback in laravel
PHP Laravel