reterive images...

Alidad

hi, I have trouble to retreive the images file path name from mysql database.

I have created database and create insert file path name into the database, and images file in one of folder name images.

My question is that how do i can write that code to show images by retreive images from folder using files path name from database!

PradeepKr

You said you have inserted path name in DB.

Execute "Select path from table where id=id-of-image-you-want"
Get the path from above into a variable eg $img_src.

$sql = "SELECT path FROM table WHERE  id = $id_of_image_you_want";

$result = mysql_query($sql);

if (!$result) {
    echo "Could not successfully run query from DB: " . mysql_error();
    exit;
}

if (mysql_num_rows($result) == 0) {
    echo "No rows found, nothing to print so am exiting";
}

while ($row = mysql_fetch_assoc($result)) {
    echo $row["path"];
}

mysql_free_result($result);

?>

Create the img tag and put into the HTML

echp '<img src="'.$img_src.'" alt="" title="">;

Krik

<img src="<?php echo $row['file_path']; ?>" />

Alidad

I have not test this code i just read code myself to make sure i undersand, is this code "<img src="<?php echo $row['file_path']; ?>" /> " also be able to veiw images!

if not how can i write code to view images! I'm trying to underand how to write code to view images!

Krik

I'm trying to underand how to write code to view images!

Have you ever displayed an image in HTML? If not may want to learn that first. After that you will need to know how to pull data from your database (refer to PradeepKr's post). And then you just have to get the files path and name, from your database, and put it in the <img> tag.

The <img> tag for HTML and the background property in CSS are the only ways you can display images in the browser. There is no other way to view images in the browser. Now technically you could use something like a java applet or flash, but I suspect, if that was what you were using, you wouldn't be asking the question.