• Catch one value with xpdo [SOLVED]#

  • 37475
    25

    Bingo Reply #1, 4 months, 2 weeks ago

    Reply
    I am completely new to xpdo so I'm sorry if it's a stupid question.

    I try to capture only one value in my database. I have solved it using the code below, but realizes that it must be possible to solve without foreach. But how?
    The value in alias is always unique and I just want the id back.

    $output = '';

$query = $modx->newQuery('Product');
$query->select($modx->getSelectColumns('Product','Product','',array('id')));
$query->where(array(
   'alias' => 'PRODUCT-NAME',
));
$products = $modx->getCollection('Product',$query);

foreach ($products as $product) {
  
  $output = $product->get('id');
  
}

return $output;
    Edited 4 months, 2 weeks ago by bingojoviken


  • 22303
    9,770
    - MODX Chief Architect

    Jason Coward | MODX Chief Architect

    jasoncoward.com | @drumshaman

    opengeek Reply #2, 4 months, 2 weeks ago

    Reply
    Here is one way, using the new getValue() method...

    <?php
$output = '';
 
$query = $modx->newQuery('Product');
$query->select($modx->getSelectColumns('Product','Product','',array('id')));
$query->where(array(
   'alias' => 'PRODUCT-NAME',
));

$output = $modx->getValue($query->prepare());

return $output;


  • 37475
    25

    Bingo Reply #3, 4 months, 2 weeks ago

    Reply
    Fungerar perfekt. Tack.


  • 22303
    9,770
    - MODX Chief Architect

    Jason Coward | MODX Chief Architect

    jasoncoward.com | @drumshaman

    opengeek Reply #4, 4 months, 2 weeks ago

    Reply
    Du är hjärtligt välkommen!


  • 37475
    25

    Bingo Reply #5, 4 months, 2 weeks ago

    Reply
    Oops, sorry about the Swedish. Was probably too tired.

    How do I change it if I want both id and title?

    First:

    $query->select($modx->getSelectColumns('Product','Product','',array('id', 'title')));


    Then?


  • 22303
    9,770
    - MODX Chief Architect

    Jason Coward | MODX Chief Architect

    jasoncoward.com | @drumshaman

    opengeek Reply #6, 4 months, 2 weeks ago

    Reply
    Easy way:
    <?php
$product = $modx->getObject('Product', array('alias' => 'PRODUCT-NAME'));
return $product ? implode('-', $product->get(array('id', 'pagetitle'))) : 'Nothing was retrieved!';


    Uses less memory (doesn't load the object):
    <?php
$output = '';
  
$query = $modx->newQuery('Product');
$query->select($modx->getSelectColumns('Product','Product','',array('id', 'pagetitle')));
$query->where(array(
   'alias' => 'PRODUCT-NAME',
));
if ($query->prepare() && $query->stmt->execute()) {
    $row = $query->stmt->fetch(PDO::FETCH_ASSOC);
    $output = "{$row['id']}, {$row['pagetitle']}";
    $query->stmt->closeCursor();
}
 
return $output;


  • 37475
    25

    Bingo Reply #7, 4 months, 2 weeks ago

    Reply
    Thank you again.