online casino games.Claim Your Free 999 Pesos Bonus Today

Resolved

(@rogersundstrom)

With $bandinfo->find(‘name ASC’, -1); I will find all “name” in my Pods(‘bandname’)
How should my codes be if I only want to find all “name” there one of my Pods(‘bandname’) field(’eme_band’) = 1

My code today

<?php
$slug = pods_url_variable('last');
$bandinfo = pods('bandnamn');
$bandinfo->find('name ASC', -1);
$total_bandinfo = $bandinfo->getTotalRows();

     //initialize data array
    $bandinfo_data = array(); 
    //loop through all records and load into data array
    while ($bandinfo->fetch()) {
        $bandname = $bandinfo->field('name');
        $get_data = array(

            'bandnamn' => $bandinfo->field('name'),
            'slug' => $bandinfo->field('slug'),
            'artal' => $bandinfo->field('artal'),

        );
        if(!empty($bandname)) { 
            $bandinfo_data[0][$bandname][] = $get_data;
        }
   }
?>

The page I need help with: [log in to see the link]

Viewing 10 replies - 1 through 10 (of 10 total)

Plugin Author Jory Hogeveen
(@keraweb)

1 year, 11 months ago

Hi @rogersundstrom

I’m not sure I fully understand the question, could you elaborate?
And since this is about the find method, please also read the documentation: https://docs.pods.io/code/pods/find/

I see are not passing an array into find. The first parameter should be an array of params, not a string.

Cheers, Jory
Plugin Support Paul Clark
(@pdclark)

1 year, 11 months ago
@rogersundstrom
```
<?php

$bandinfo = pods( 'bandname' );
$bandinfo->find( [
	'where' => 't.eme_band = 1',
] );
```
…should do it.
Thread Starter rogersundstrom
(@rogersundstrom)

1 year, 11 months ago
Hi Jory

Unfortunately, I was probably a little unclear and I guess I don’t fully understand my own code ??

I think I understand now that $bandinfo->find(‘name ASC’, -1); only sort data ascending.

What I want is only to get data from my array if $bandinfo->field(’eme_band’) is equal with value 1.

$bandinfo->field(’eme_band’) gives me value of either 0 or 1.

Thanks
- This reply was modified 1 year, 11 months ago by rogersundstrom.
Plugin Author Jory Hogeveen
(@keraweb)

1 year, 11 months ago

Hi @rogersundstrom

Please read the documentation to understand the function ??

The code from @pdclark should work but I think it’s important to understand code before copy/paste it in your project.

Cheers, Jory

Thread Starter rogersundstrom
(@rogersundstrom)

1 year, 11 months ago

Hi @pdclark

Your example should do the thing but of some reasons I only see 15 of 692 rows.
Strange…

Thread Starter rogersundstrom
(@rogersundstrom)

1 year, 11 months ago

Hi @jory

I promise to read and learn more to understand the function ??

Cheers,
Roger

Plugin Contributor Scott Kingsley Clark
(@sc0ttkclark)

1 year, 11 months ago

By default, find() will only return 15 records. You can specify more with the 'limit' option documented at https://docs.pods.io/code/pods/find/ or you can make use of pagination too using https://docs.pods.io/code/pods/pagination/
Thread Starter rogersundstrom
(@rogersundstrom)

1 year, 11 months ago
Thanks @sc0ttkclark
```
$params = array(
    'limit' => -1, 
    'where' => 't.eme_band = 1',
);
$bandinfo->find( $params );
```
Did the trick. How can I sort it in Swedish alphabetical order?
We have ??? in our alphabet, now ?? comes behind a and ? comes behind o
- This reply was modified 1 year, 11 months ago by rogersundstrom.
Plugin Contributor Scott Kingsley Clark
(@sc0ttkclark)

1 year, 11 months ago

Try using the 'orderby' option. If that orders incorrectly, you may want to consider what your database tables are storing content as — this may be helpful in understanding how that works too https://stackoverflow.com/a/5529052/19080750

Plugin Support Paul Clark
(@pdclark)

1 year, 11 months ago

Also note in the linked thread that utf8_swedish_ci sorts ??? at the end of the alphabet. If you want them to be next to their non-accented variants, you’ll need to load the posts into an array and sort with PHP. See https://stackoverflow.com/a/31670749 for an example of how that is done.