$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 vote312 views1 answer
Js redirect in php
PHP
2 votes291 views3 answers
How to get a whole number from decimal in php
PHP
0 vote297 views1 answer
How to start on row 2 spreadsheet inserting to database using php
PHP
0 vote349 views1 answer
Italic text in laravel notification
PHP Laravel
22 votes300 views4 answers
Laravel orWhere
PHP
6 votes287 views3 answers
Disable foreign key laravel
PHP
4 votes321 views1 answer
Laravel relation of relation
PHP
1 vote348 views1 answer
Get advanced custom field value in wordpress
PHP Wordpress
25 votes308 views6 answers
Laravel carbon date format
PHP
7 votes330 views3 answers
Php info file
PHP