从字符串php wordpress获取ID

Question

我有一个用“|”分隔的图像URL字符串，我希望使用一个php函数来读取该字符串，将图像分开，并用“，”分隔，以使用wordpress gallery组件

http://xxxxxxxx/xxxxxxx/wp-content/uploads/2018/02/large-IMG_5367.jpg|http://xxxxxxxx/xxxxxxx/wp-content/uploads/2018/02/large-IMG_5376.jpg|http://xxxxxxxx/xxxxxxx/wp-content/uploads/2018/02/large-IMG_6324.jpg

我试图创建一个名为GetID from string的php短代码

   /* ---------------------------------------------------------------------------
 * Shortcode | get_id_from_string
* --------------------------------------------------------------------------- */


add_shortcode('get_id_from_string', 'function_get_id_from_string');
function function_get_id_from_string($atts) {
  global $wpdb;
  $return_value = '';

  $url_array = explode('|', $atts['urls']);

  foreach ($url_array as &$url) {
    $return_value .= $wpdb->get_col($wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid='%s';", $url))[0] . ',';

  }

  return rtrim($return_value, ',');
}

但它不起作用，有人已经做过类似的事情吗？

提前谢谢

Answer 1

试试下面的cod，如果在数据库中找到URL，它将返回ID并添加$return_value变量。

add_shortcode('get_id_from_string', 'function_get_id_from_string');
function function_get_id_from_string($atts)
{
    global $wpdb;
    //$imagestr = "http://xxxxxxxx/xxxxxxx/wp-content/uploads/2018/02/large-IMG_5367.jpg|http://xxxxxxxx/xxxxxxx/wp-content/uploads/2018/02/large-IMG_5376.jpg|http://xxxxxxxx/xxxxxxx/wp-content/uploads/2018/02/large-IMG_6324.jpg";
    $imagestr = $atts['urls'];
    $url_array = explode("|", $imagestr);
    $return_value = [];
    foreach ($url_array as $url) {
        $query = $wpdb->prepare("SELECT ID FROM $wpdb->posts WHERE guid='%s'", $url);
        $result = $wpdb->get_col($wpdb->prepare($query, $url), ARRAY_A);
        if (!empty($result))
            $return_value[] = $result[0];
    }
    $images_ids = implode(",", $return_value);
    return ($images_ids);
}