$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

1 vote113 views1 answer
Valet laravel
PHP Laravel
0 vote102 views1 answer
Fetch values and display in bar chart php mysql
PHP
2 votes107 views2 answers
Check if date between two dates laravel
PHP
8 votes113 views3 answers
Create migration with model laravel 8
PHP Laravel
30 votes100 views5 answers
SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
PHP
9 votes125 views5 answers
Uuid in laravel
PHP Laravel
20 votes156 views4 answers
Php all date formats
PHP
6 votes103 views2 answers
Php server function
PHP
1 vote98 views1 answer
Php multidimensional array get all values by key
PHP
0 vote107 views2 answers
Laravel display category post by slug
PHP Laravel