samedi 25 avril 2015

PHP PDO MYSQL - Get Array comma separated from fetchAll


I'm really stuck in this.

I need a result like (138,139,140,141,142,143,144,145), but I'm getting just a (Array,Array,Array,Array,Array,Array,Array,Array)...

My code is:

<?php
    try {
                        $dbconn = DBCONNECTION();

                        $sql = "SELECT `product_category_id`, `product_category_parent_id`, `date_available`, `status` 
                                FROM `product_category` 
                                WHERE `product_category_parent_id` = '" . $_GET['cat'] . "' 
                                AND `date_available` <= NOW() 
                                AND `status` = '1' 
                                ORDER BY `product_category_id` ASC";

                        $stmt = $dbconn -> prepare($sql);
                        $stmt -> execute();
                        $array = $stmt -> fetchAll(PDO::FETCH_ASSOC);

                        foreach($array as $row) {
                            $category[] = array($row['product_category_id']);
                        }

                        $subcategory = implode(',', $category);
                        echo $subcategory;
    }
?>

Can you please help me?

Thanks a lot!


Aucun commentaire:

Enregistrer un commentaire