$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 vote187 views2 answers
Wordpress profile queries
PHP
11 votes197 views4 answers
Php all keys in array
PHP
0 vote248 views1 answer
Wordpress wp_query orderby random
PHP
0 vote310 views1 answer
Wordpress check if page is password protected
PHP Wordpress
2 votes306 views2 answers
How to get previous page name in php
PHP
1 vote234 views1 answer
How to add an custom error to validater error in laravel
PHP Laravel
0 vote221 views4 answers
If ( $post_armi->have_posts() ) { while ($post_armi->have_posts() ) { $post_armi->the_post();
PHP
2 votes212 views2 answers
Hide wp admin bar for subscribers
PHP
0 vote260 views1 answer
Selecting values from database
PHP
4 votes229 views4 answers
Multiple middleware laravel
PHP