Looper from Custom DB Table

[gstertz]

I have a custom database table with info I’d like to display. Is it possible to do this with loopers?

[tristup]

Hi @gstertz,

Thanks for reaching out.
What you are trying can be done using the Custom Looper which is a custom function that returns the values you want. You can go through the following thread where the custom loopers are explained.

Sidebar menu to show child pages of parent

OK thanks, but what you have suggested would be specific to the about section and its child pages wouldn’t it? It was more if there was a way of adding a query that I can put on a Pro > Layout which would then show all the child pages of the parent, regardless of which section you were in. So if I was in the community for instance each of those pages would show all the other children of the parent page. Hope that makes sense - as I say the code from WPBeginners does the job but it would be gr…

Display All Child Pages-Looper Provider

[Screenshot 2021-02-24 at 15.38.33] Hi there, Loving the new update, thanks for all your hard work on creating such a comprehensive theme. I am working on a portfolio page at the moment and have decided to use your new looper feature to pull in content. I am using pages for project write ups, and want to display all the child pages on the projects page. I’ve gotten as far as setting up a row as a looper provider, and setting the columns within as consumers. Working perfectly on the first thr…

Reading elements of a looper

Dear @tristup, thanks a lot. I am not quite sure where to plug in that looper provider in my workflow / hierarchy of elements and loopers on the page. But looking at this code, I am thinking that there should be a similar cs_custom_looper code that directly performs my end goal. Could you try and help me out with that as well? This custom code should work very similar to the built-in “Current Post Terms”. The built-in function accepts one argument (“Taxonomy”), and it returns all terms of the…

Custom Looper params with dynamic content

Hey Daniele, One way to do this is by adding post_id key in your JSON, for example I’ve the following JSON in my looper provider’s param’s field: { "url" : "https://your-api/", "post_id": "425", "title": "Combined data" } For that I’ve the following code in my child theme’s functions.php add_filter( 'cs_looper_custom_my_data', function( $result, $params ) { return $params; }, 10, 2); Now for instance If I have to use it in a Headline element, I can simply turn on the Link option and…

I would also suggest you go through the following article to understand the Custom Looper.

Loopers | Themeco Docs

Loopers

Hope it helps.
Thanks

[gstertz]

Thank you! I made this and it works!

add_filter( 'cs_looper_custom_clients', function( $result, $params ) {
global $wpdb;

// Corrected table name
$table_name = $wpdb->prefix . 'crm_clients';
$clients = $wpdb->get_results("SELECT * FROM $table_name");

$result = [];
foreach ($clients as $client) {
	$result[] = [
		'client_id' => $client->client_id,
		'first_name' => $client->client_first_name,
		'last_name' => $client->client_last_name,
		'email' => $client->client_email,
		'phone' => $client->client_phone,
		'address_1' => $client->client_address_1,
		'address_2' => $client->client_address_2,
		'city' => $client->client_city,
		'state' => $client->client_state,
		'zip' => $client->client_zip,
		'brand_1' => $client->client_brand_1,
		'brand_2' => $client->client_brand_2,
		'tags' => $client->client_tags,
		'lists' => $client->client_lists,
	];
} return $result; }, 10, 2);

And using these looper keys:

{{dc:looper
key=“client_id”}}
{{dc:looper
key=“first_name”}}
{{dc:looper
key=“last_name”}}
{{dc:looper
key=“email”}}
{{dc:looper
key=“phone”}}
{{dc:looper
key=“address_1”}}
{{dc:looper
key=“address_2”}}
{{dc:looper
key=“city”}}
{{dc:looper
key=“state”}}
{{dc:looper
key=“zip”}}
{{dc:looper
key=“brand_1”}}
{{dc:looper
key=“brand_2”}}
{{dc:looper
key=“tags”}}
{{dc:looper
key=“lists”}}

[marc_a]

Hey @gstertz,

We’re glad that you’re able to figure it out.

Cheers!