0

I have added a column called post_thumbnail to my wp_posts table.

Is there any way I can make post_thumbnail to each post's featured image?

4
  • 1
    Why you had to add a custom column to the default posts table? Dec 18, 2013 at 18:47
  • Because I am running a script that turns an RSS feed into WP posts and I don't know how else to transfer the RSS thumbnail as a featured image.
    – Giveny
    Dec 18, 2013 at 18:54
  • Take a look at this plugin WP RSS Multi Importer Dec 18, 2013 at 19:01
  • There is more to my import script, that I need to keep. There should be a way to change where the featured image is found. Why is it basically impossible to find an answer to this anywhere?
    – Giveny
    Dec 18, 2013 at 19:39

1 Answer 1

1

How is the post_thumbnail information stored?

If you've already created an attachment with the image and are storing the attachment's postId in post_thumbnail, then you just need to go through your posts and update the meta using update_post_meta($postId, '_thubmnail_id', $attachmentPostId).

If post_thumbnail stores the path to an image file on your server, you need to create an attachment using wp_insert_attachment and pass in that file location. If the files are not already stored in the uploads directory, you can use the Add From Server plugin to import the files into wordpress as attachments. You can then use update_post_meta to set the attachment as your featured image.

If post_thumbnail stories the URI of the image, you need to save it to your server, then create the attachment, then update the post's meta.

3
  • Hey! Thanks for your answer. Does this mean that it is not possible to use images that are not stored in the wordpress blog? The post_thumbnail is just the url of an image on an external source. Also, I'd like it to be automated, so I don't have to import anything continuously.
    – Giveny
    Dec 18, 2013 at 22:52
  • If you're trying to use Wordpress' Featured Image feature, the image needs to be stored by your blog. If you just want to display the image whenever the post is viewed, you can do modify the loop of the template that displays the post (ie. index.php, single.php, single-posttype.php depending on how much you've modified Wordpress) and put the url of the image inside of an <img> tag.
    – pLiKT
    Dec 19, 2013 at 3:30
  • Thanks! How would I go about displaying the image to the relevant row? What code would I have to insert to post.php? I guess if I can do this there should be a plugin that transforms that image to the featured image?
    – Giveny
    Dec 20, 2013 at 22:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.