source: extensions/MyPiwiShop/admin/product_tablereload.php @ 27568

<?php
define('PHPWG_ROOT_PATH','../../../');
include_once(PHPWG_ROOT_PATH.'include/common.inc.php');

 $query='SELECT * FROM '.MPS_PRODUCT_TABLE.' ORDER BY `order`;';
  $result = pwg_query($query);
  $products = array();
  while($row = pwg_db_fetch_assoc($result)){
        $query='
        SELECT *
        FROM '.MPS_PROD_OPT_TABLE.' AS op
        JOIN '.MPS_OPTION_TABLE.' AS p ON p.id = op.opt_id
        WHERE product_id = '.$row['id'].'
        ;';
        $res = pwg_query($query);
        $opt = array();
        while($row1 = pwg_db_fetch_assoc($res)){
    $opt[] = $row1['name'];
        }
        $row['option'] = $opt ;
        $products[$row['id']]=$row;
  }

echo json_encode($products);