php - mysql- bit of help needed

gat

ok,

Im simply creating a thumbnail gallery, with the thumbnails and parent images in a db called 'kriminalyouth'

i have created the db with two tables so far.....images...&....Thumbnails.

each table has 3 fields pic_id, pic_area, pic_path.

now i can retrieve the data from mysql np.
but how do i make the path actually go to the image.

i have an images folder and a thums folder, in 'htdocs' folder.
is that right?

if i can pull the path from the db, surely its just a function or something to go find the pic...

thanks

anthill

do you have the full image path in the database including the name of the image, coz then its just a simple case of pulling it from the database, e.g.


<img src="<? echo $query['pic_path']; ?>" alt="">

Or do you have the path to the directory and need to read the images files in the directory?

Ant

gat

thanks for replying.

yes i do have the full path.
at the moment im still running files from the 'htdocs' folder, so i have two folders in there containing the images.

BUT.

i do not want to simply display the image.
I want the image to be a link to the bigger version. (thumbnail).

Ideally, i would also like all the images clicked on to be shown in one sort of universal page??

but im a novice, and i dont have an idea really.

thanks for your help though..........if you have any more....great

anthill

ok, so do you have the full path to the thumbnail and the larger image or is there some common way of interpretting which is a thumbnail and which is the full image, like image01.jpg and image01_thumb.jpg.

lets assume you have the full link to the thumbnail and the larger image...you could do something like


$query = mysql_query("SELECT * FROM images");

while ($result = mysql_fetch_array($query))
   {
    echo "<a href=\"".$result['image_path']."\"><img src=\"".$result['thumb_path']."\"></a><br>";
   }

Let me know how you get on.

Ant

gat

ah ha......it diddnt work, but its definatly getting someware.

the image showed as a cross.
when clicked on, brought up the path to the image, but did not show it.

so its working, but maybe needs a bit of fiddeling.
ill pase the code in, let you have a look.

<?php
$conn= @mysql_connect("localhost","gworsnup","bracknell")
or die("Err:Conn");

$rs= @mysql_select_db("kriminalyouth", $conn)
or die("Err😃b");

$query = mysql_query("SELECT * FROM images");

while ($result = mysql_fetch_array($query))
{
echo "<a href=\"".$result['pic_path']."\"><img src=\"".$result['thumb_path']."\"></a><br>";
}
?>

for your info.

the thums are all saved as whateverthum.jpg thats how i distinguish them

e.g, currently vase.jpg is in images
vasethum.jpg is in thums

Also, is is going to create a lot of extra code to make a page that displays the image, rather than simply opening an explorer window with the image in.

your help is much apreciated.

anthill

little confused now... so do you have the path to the image and the path to the thumbnail in the database or just for the full image?

And, when you test the page and get a little cross, what is the source code for the link and image?

gat

basically the table is layed out like this, and this is also what it contains.

name of table = images

(there are 4 table fields)

pic_id = 001

Pic_area = Bracknell

Pic_path = C:\Program Files\Apache Group\Apache\htdocs\images\vase.jpg

Thum_path = C:\Program Files\Apache Group\Apache\htdocs\thums\vasethum.jpg

hope that makes sense.

Currently,

i get this error message
"Notice: Undefined index: thumb_path in c:\program files\apache group\apache\htdocs\mysql\displaythum.php on line 18"

line 18 = echo "<a href=\"".$result['pic_path']."\"><img src=\"".$result['thumb_path']."\"></a><br>";

and the path of the crossed image is just 'http://localhost/mysql/'
when it should be

C:\Program Files\Apache Group\Apache\htdocs\thums\vasethum.jpg

hope this clears things up for you a bit.

anthill

i'm guessing that you need to have the path to the images as if it were running off the server, so rather than c:\path\to\images\ you need to have
http://localhost/path/to/images/

e.g

name of table = images

(there are 4 table fields)

pic_id = 001

Pic_area = Bracknell

Pic_path = http://localhost/images/vase.jpg

Thum_path = http://localhost/thums/vasethum.jpg

hope that helps

gat

Of course!

Now the path is working and when you click on the thum, you do get the big image.

BUT, the thum its self still does not show.

i still get

Undefined index: thumb_path in c:\program files\apache group\apache\htdocs\mysql\displaythum.php on line 18

could this be because i diddnt allocate an index to the thum_path in the database?

well i added an index, to thum_path and nothing happened.
I promise ill stop asking you questions as soon as i can see the thumnail image......lol

thanks though.

gat

here is the code, as it is.

html>
<head>
<title>get_data</title>
</head>

<body>
<?php
$conn= @mysql_connect("localhost","gworsnup","bracknell")
or die("Err:Conn");

$rs= @mysql_select_db("kriminalyouth", $conn)
or die("Err😃b");

$query = mysql_query("SELECT * FROM images");

while ($result = mysql_fetch_array($query))
{
echo "<a href=\"".$result['pic_path']."\">
<img src=\"".$result['thumb_path']."\"></a><br>";
}
?>

</body>

</html>

anthill

as far as i know you don't need to allocate an index to the thum_path, and your code looks spot on.

You're almost there, it's probably something really simple, maybe a spelling mistake...not sure. If the link to the larger image is working great it must be the thumbnail link (obviously).

is it coz you have thumb_path when it might be Thumb_path..i dunno, stumped me on that one too, i'm sure it has to be a spelling mistake somewhere.

Ant

gat

thing is its path (when you right click > properties) is looking in

http://localhost/mysql/

whe it should be

http://localhost/thums/vasethum.jpg

when you roll over it, you can see the link its going to and that works.

but it looks like its looking in the wrong place.
like you said when you have problems like this, it is usually something small......i guess ill have to keep trying things.

anthill

weird, so the image it is looking in:

http://localhost/images/vase.jpg

but the thumb its looking in:

http://localhost/mysql/vasethum.jpg ???

then it can only be the path you have added to the database, as it works fine for the full image.

Wish I could be of more help but thats the only thing i can see ;(

Hope you get it sorted, let me know if you need more help.

Good luck

Ant

Tim_Brown

In a previous post you gave Thum_path as the name for the field holding the path for the thumbnail images. But you are using $result['thumb_path'] to call up the data from that field. Try changing to $result['Thum_path'].

gat

how very very stupid of me....

it was the 'b' on the end on thumb.

heheheheheh

Its always something like that.

Now everything works....

thanks guys.