Styling images coming from another blog

12 Views

I had asked a question earlier, on getting post-thumbnails from another WP-site. There, the awesome Mike coded a SQL query whose results are then passes on to a PHP array. The piece of code from that answer that I want to modify is this. 

$post_urls = $wpdb->get_col($sql);
  if (is_array($post_urls))
    echo implode("n",$post_urls);

Now the array holds values in the form of <img src="/link/to/image.jpg"/>. Now how do I..

Read More
  1. Call the WP image_resize function on each image URL?
  2. Apply my own CSS class to each image?

UPDATE:

Thanks to Jan for the tips on optimizing the SQL query. Now the $post_urls array will hold only plain URLs to the images. Can someone show me how to loop through each URL in the array and add prefixes (like <img src=") and suffixes (like " class="awesome-image"/>) to each of them?

Post Views: 12

Related posts

Leave a Reply

3 comments

  1. Calling image_resize() would be difficult, since it would search for the image in your main blog’s upload directory. If it is a fixed image size I would just add it to the configuration of your photoblog, so it is created there when you upload new images (you can then rebuild your old image thumbnails).

    In Mike’s answer you see that he adds the <img src=" and "/> parts in the SQL query. That’s nice, but you don’t have to do that. If you leave that off you get just the URL of the image and you can add everything later in PHP. I wrote an alternative version that will provide you with more raw information to play with.

    $attachment_data_list = $wpdb->get_results( $sql );
if ( $attachment_data_list ) {
    foreach ( $attachment_data_list as $attachment_data ) {
        echo '<img src="/mysubblog/wp-content/uploads/';
        echo $attachment_data->upload_relative_path;
        echo '"/>';
    }
}

  2. I must admit that I do not really know if it is wise to use the power of WP image_resice on HTTP linked images. I would probably formulate an additional question to find out more about needs.Probably something like:

    How do I display a smaller version of an image I have linked in an HTML IMG tag?

    As for the rest of the magic with PHP, this probably is doing what you’re asking for. I found this ancient magic formula which should to the magic according to the book I’ve found it in:

    <?php
function doing_magic_on($my_very_specific_formatted_string, $my_own_css_class, $magic = 'bGlzdCgkc3RhcnQsICR1cmwsICRlbmQpID0gZXhwbG9kZSgnIicsICRteV92ZXJ5X3NwZWNpZmljX2Zvcm1hdHRlZF9zdHJpbmcpOw0KcmV0dXJuIHNwcmludGYoJyVzJXMiIGNsYXNzPSIlcyVzJywgJHN0YXJ0LCAkdXJsLCAkbXlfb3duX2Nzc19jbGFzcywgJGVuZCk7DQo=') {
    return eval(base64_decode($magic));
}

    May the force be with you and good luck improving your magic skills for the future!

  3. If you want to resize the image you need to download the image from the webserver and then write it to disk. The below function should do the trick. The image is then stored on the local hard drive. This is actually much more friendly then loading the thumbnails from another site.

    function http_image_writer($imgSrc, $filepath) {

  if(isset($imgSrc)) {

    //getting the image dimensions
    list($width, $height) = getimagesize($imgSrc);

    //saving the image into memory
    //the file has to be a jpg file or it will fail.
    //Use the other imagecreate functions for other formats.
    $myImage = imagecreatefromjpeg($imgSrc);

    // Creating the thumbnail
    $file = imagecreatetruecolor($width, $height);
    imagecopyresampled($file, $myImage, 0,0,0,0, $width, $height, $width, $height);

    //final output of the image file
    imagejpeg($file,$filepath);

    //cleanup of the images in memory
    imagedestroy($file);
    imagedestroy($myImage);
  }
}

    since this function uses GD u can simply add some resizing code to it there are plenty of examples for that.