CODEWITHSUNDEEP
phpmysql
sm21guy
sm21guy

Reputation: 626

php generate image?

How can i use php to get an image url from database (based on user id) and display it out as an image. http://mysite.com/img.php?id=338576

The code below shows a php script goes to a database , check whether the specific user(using the id in the link above) exist then get the image url out of that user's row.

 <?php
    //connect to database
    include ("connect.php");

    //Get the values
       $id = mysql_real_escape_string($_GET['id']);


    //get the image url
      $result = mysql_query("SELECT * FROM users WHERE id='$id'")
      or die(mysql_error()); 
      $row = mysql_fetch_array($result);
      if($row)
      {
        $img_url = row['imgurl'];
        mysql_close($connect);

      }
      else{
      }

    ?>

The $Img_url is an actual image link www.asite.com/image.jpg

The problem is how can i use php to make an image from the image link($img_url)? By which http://mysite.com/img.php?id=338576 will turn into an image.

I hope someone could guide me

Thanks!

Upvotes: 1

Views: 299

Answers (2)

Buttle Butkus
Buttle Butkus

Reputation: 9456

This is pretty basic stuff. Am I understanding you correctly? I would just do this:

<?php

$img_html = '<img src="' . $img_url . '" />';


echo $img_html;

?>

Or check this answer: How do I script a php file to display an image like <img src="/img.php?imageID=32" />?

Upvotes: -1

changx
changx

Reputation: 1957

The easiest way:

header('Location: url/to/image');

You could also proxy the request, which uses your bandwidth:

echo(file_get_contents('url/to/image'));

Upvotes: 3

Related Questions