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 vote249 views1 answer
Guzzlehttp/guzzle version with laravel-websockek
PHP Laravel
0 vote236 views1 answer
Escape class wordpress
PHP Wordpress
0 vote222 views2 answers
Php variables examples
PHP
0 vote214 views1 answer
Générer des nombres aléatoires décimaux en php
PHP
0 vote254 views1 answer
Laravel signed Route custom domain
PHP Laravel
0 vote216 views1 answer
Drupal 8 entity query
PHP
72 votes222 views5 answers
How do I get PHP errors to display
PHP
1 vote224 views1 answer
SQLSTATE[HY000]: General error: 1005 Can't create table ``.`labels` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table `labels` add constraint
PHP
49 votes237 views6 answers
Laravel migrate seed
PHP
0 vote237 views1 answer
Laravel get limited character of string
PHP