php - 如何显示来自wordpress数据库的产品图片

Question

我想显示来自 wordpress mysql 数据库的 woocommerce 产品图片。例如，如果产品的 ID 为 11，其图像、属性、价格等存储在数据库的 wp-postmeta 表中。图片存储在其他 id 中，id 值在产品 10 的图片中给出。现在如何从表中获取图片。

对于单个产品，

    $img = mysql_query("SELECT meta_value FROM wp_postmeta WHERE meta_key ='_thumbnail_id' AND post_id='11'",$con);
    $res= mysql_fetch_array($img);
    $img2 = mysql_query("SELECT meta_value FROM wp_postmeta WHERE meta_key ='_wp_attached_file' AND post_id='".$res['meta_value']."'",$con);
    $res2= mysql_fetch_array($img2);
    echo $res2['metavalue'];

展示的是单个商品的图片，如何从mysql数据库中取多个商品的数据？

Answer 1

我做了这样的东西来获取所有 woocommerce 产品的图像

$query = "SELECT * FROM wp_posts WHERE post_status = 'publish' AND post_type LIKE 'product%'";

if ($result = $mysqli->query($query)) {
    printf("<br>Select returned %d rows.\n", $result->num_rows);
    echo "<table>";
    echo "<thead>";
    echo "<tr>";
    echo "<td>ID</td><td>Termék neve</td><td>Termék linkje</td><td>Termék kép</td>";
    echo "</tr>"; 
    echo "<thead>";
    while ($row = $result->fetch_assoc()) {
        $post_id = $row["ID"];

        echo "<tr>";
        echo "<td>".$post_id."</td>";
        echo "<td>".$row["post_title"]."</td>";
        echo "<td>".$row["guid"]."</td>";
        $query_img = "SELECT meta_value FROM wp_postmeta WHERE meta_key ='_thumbnail_id' AND post_id = $post_id";
        $result_img = $mysqli->query($query_img);
        $img = $result_img -> fetch_assoc();
        $query_img_2 = "SELECT meta_value FROM wp_postmeta WHERE meta_key ='_wp_attached_file' AND post_id = ".$img['meta_value']."";
        $result_img_2 = $mysqli->query($query_img_2);
        $img_2 = $result_img_2 -> fetch_assoc();
        echo "<td>".$img_2["meta_value"]."</td>";
        echo "</tr>";
    }       
    echo "</table>";

    /* free result set */
    $result->close();
}