Linking Image Paths in My SQl to PHP

[Maleko]

OK, im new to PHP, and stuck...

At the moment im trying to upload an image to my webserver, then insert the path to the image into the database.

What I want to do is now, using that path in the db, is enable it so when it uploads an image, it will add the image to a web page.

Also, if its possible, to add some html with the image so that I can place it where I want on the web page, for example, If i uploaded the image and wanted to align it to the lieft, I would wanna add, <div align="left></div>....get it?

Thanks in advance, Im sure I'll be popping here a few time 😉

[bastien]

its pretty simple, just echo out the result variable from the query to show the image

//your query

$result=mysql_query($sql);

while ($rows=mysql_fetch_array($result)){

//assign var name to image field
$path=$rows['image_path'];

//echo the image

   echo "<img src=\"$path\">";

}

You can add any number of other image taf attributes like height or width as well as any other div tag stuff in the echo

hth

[help_needed]

<?
session_start();
require("inc/auth.php");
require("inc/conf.php");
$username = $_SESSION[username];

if ($action == "upload")
{


	if (isset($upload)) 
	{ 
	$path = "images/"; 

	$tempname = $_FILES['photo']['tmp_name']; 
	$filetype = $_FILES['photo']['type']; 
	$filename = $username."_".$_FILES['photo']['name'];

		if(!empty($filename))
		{
		copy($tempname, $path.$filename) or die("Couldn't copy the file!");
		$imgpath = "$path"."$filename";

		$q = "INSERT INTO album (username, imgpath, date) VALUES ('$username', '$imgpath', '$date')";
		$r = mysql_query($q) or die (mysql_error());

		print "<meta http-equiv=\"refresh\" content=\"0; url=details.php?a=gallery&action=view\">";
		}

		else
		{
		echo "You must have something to upload!"; 
		}
	}

	else
	{
	include ("template/galleryupload.php");
	}
}

else
{
$q = "SELECT * FROM album WHERE username = '$username'";
$r = mysql_query($q) or die (mysql_error());

	if (mysql_num_rows($r) < 1)
	{
	print "No Pictures!";
	}

	else
	{
		while ($album = mysql_fetch_array($r))
		{
		print "<img src=\"$album[imgpath]\" border=\"0\">";
		}
	}

}
?>

[Maleko]

Excellent, cheers guys, will let you know how I get on! 🙂