$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 vote210 views2 answers
Laravel form put method
PHP Laravel
0 vote198 views1 answer
How to change php to html
PHP
2 votes270 views1 answer
Laravel 8 previous page
PHP Laravel
1 vote184 views2 answers
Insert data using mysqli in php
PHP
1 vote159 views1 answer
Phpmailer doesnt work
PHP
1 vote256 views1 answer
Start server in laravel
PHP Laravel
0 vote160 views1 answer
Finding second highest number in array
PHP
2 votes174 views3 answers
Add data to the collection laravel
PHP
1 vote173 views1 answer
Session cakephp
PHP
0 vote190 views1 answer
Wordpress disable edit files
PHP Wordpress