$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 vote230 views1 answer
GetDoctrine
PHP
0 vote236 views1 answer
Infyom generator ignore field
PHP
0 vote342 views1 answer
Drupal 9 check if UUD is valid
PHP Drupal
15 votes225 views3 answers
Php strtoupper
PHP
0 vote257 views1 answer
Get chmod of directory php
PHP
2 votes260 views1 answer
Laravel model wherein update
PHP
0 vote302 views1 answer
PHP include causes white space at the top of the page
PHP
0 vote243 views2 answers
Php artisan app:name in laravel 6
PHP
0 vote301 views1 answer
How to index column in laravel
PHP Laravel
0 vote283 views1 answer
Eager load relationships by default in the model laravel
PHP