How to get an array?

Question

PHP

Working source code

<?php
                                $con = mysqli_connect("localhost","root","root","demo");

                                $brand_query = "SELECT * FROM xf_category";
                                $brand_query_run  = mysqli_query($con, $brand_query);

                                if(mysqli_num_rows($brand_query_run) > 0)
                                {
                                    foreach($brand_query_run as $brandlist)
                                    {
                                        $checked = [];
                                        if(isset($_GET['category']))
                                        {
                                            $checked = $_GET['category'];
                                        }
                                        ?>
                                            <div>
                                                <input type="checkbox" name="category[]" value="<?= $brandlist['id']; ?>" 
                                                    <?php if(in_array($brandlist['id'], $checked)){ echo "checked"; } ?>
                                                 />
                                                <?= $brandlist['title']; ?>
                                            </div>
                                        <?php
                                    }
                                }
                                else
                                {
                                    echo "No Brands Found";
                                }
                            ?>

Corrected for this code

<?php
                                
                                if(mysqli_num_rows($category_query) > 0)
                                {
                                    foreach($category_query as $categorylist)
                                    {
                                        $checked = [];
                                        if(isset($_GET['category']))
                                        {
                                            $checked = $_GET['category'];
                                        }
                                        ?>
                                            <div>
                                                <input type="checkbox" name="category[]" value="<?= $categorylist['id']; ?>" 
                                                    <?php if(in_array($brandlist['id'], $checked)){ echo "checked"; } ?>
                                                 />
                                                <?= $categorylist['title']; ?>
                                            </div>
                                        <?php
                                    }
                                }
                                else
                                {
                                    echo "No Categorys Found";
                                }
                            ?>

And in function.php

//Read xf_category
$sql = $pdo->prepare("SELECT * FROM xf_category");
$sql->execute();
$category_query = $sql->fetchAll(PDO::FETCH_OBJ);

I get an error

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, array given in

Tell me what I did wrong?

Answer 1

Tell me what I did wrong?

https://www.php.net/manual/ru/mysqli-result.num-ro...

result
Procedural style only: A mysqli_result object obtained with mysqli_query(), mysqli_store_result() or mysqli_use_result() or mysqli_stmt_get_result().

https://www.php.net/manual/en/pdostatement.fetchall.php

PDOStatement::fetchAll — Returns an array containing all rows in the result set

instead of mysqli_num_rows it asks for count() at worst