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 vote119 views1 answer
How unique field in table in phpmyadmin
PHP
2 votes123 views1 answer
Retrieving a cookie in php
PHP
11 votes185 views3 answers
Php number format
PHP
4 votes119 views1 answer
Laravel install production
PHP
0 vote183 views1 answer
Laravel where has query
PHP Laravel
0 vote174 views2 answers
Wordpress truncate text
PHP Wordpress
37 votes131 views4 answers
Foreign key in laravel migration
PHP
0 vote135 views1 answer
Wordpress make new publish button
PHP
3 votes134 views2 answers
How to remove duplicates in a sorted array
PHP
0 vote136 views10 answers
Event handler with worker laravel
PHP Laravel