mysql - woocommerce - 从 mysql 获取类别图像

Question

我想从 woocommerce 中的 mysql 数据库返回我的类别图像。我不知道该怎么办以及如何从数据库返回图像。

到目前为止，我只返回类别名称和 Ides，

SELECT * from `wp_terms` where term_id in (SELECT term_id FROM `wp_term_taxonomy` WHERE `taxonomy` LIKE 'product_cat' AND `parent` = 0 and count>0)

我该怎么做？

Answer 1

Try below code:

    $catTerms = get_terms('product_cat', array('hide_empty' => 0, 'orderby' => 'ASC'));
    foreach($catTerms as $catTerm) :
    $thumbnail_id = get_woocommerce_term_meta( $catTerm->term_id, 'thumbnail_id', true ); 
    // get the image URL
    $image = wp_get_attachment_url( $thumbnail_id );
    <li>
        <img src="<?php echo $image; ?>" width="152" height="245"/>
        <span><?php echo $catTerm->name; ?></span>
    </li>
    endforeach;