$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 vote185 views1 answer
Format a number with leading zeros in php
PHP
0 vote163 views1 answer
Laravel bd query
PHP
0 vote149 views1 answer
Cakephp find_in_set
PHP
0 vote144 views1 answer
Twig superglobal request
PHP
-1 vote184 views2 answers
Laravel eloquent update multiple records
PHP
3 votes241 views1 answer
Laravel validation number greater than 0
PHP
0 vote177 views1 answer
Alter mysql 8 user root phpmyadmin first install
PHP
0 vote182 views2 answers
Check if user has role twig
PHP
0 vote167 views2 answers
How to upload two files on same form different path in codeigniter
PHP
0 vote183 views1 answer
Créer projet laravel
PHP Laravel