$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

3 votes154 views1 answer
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add index `users_userable_type_userable_id_index`(`userable_type`, `userable_id`)
PHP
1 vote158 views1 answer
Config smp gamil laravel
PHP
4 votes216 views4 answers
Laravel current timestamp
PHP
4 votes159 views2 answers
Laravel eloquent sum column
PHP Laravel
20 votes165 views1 answer
Run php dev server
PHP
1 vote142 views2 answers
Php weekdays
PHP
1 vote172 views3 answers
Laravel get input from request
PHP Laravel
7 votes183 views2 answers
Artisan in route in laravel
PHP Laravel
1 vote208 views1 answer
What is app_env in laravel
PHP Laravel
7 votes173 views4 answers
Laravel blade uppercase
PHP