newbie(making out for database)

[cezame1123]

hi, is anyone know how to make a database of picture?

[russell]

what db are u using? usually best to store images on file server, path to image in database

[cezame1123]

im using xampp for that,with mysql and phpadmin..how will i do that?where will i find that path?what do you mean file server?

[russell]

file server = web server in most cases. path to image is wherever u save it to for example: /var/www/mySite/images/imageName.jpg

[cezame1123]

so how should i do that?is it really working?can i make a database out of pictures?my webserver is apache..

[lightnb]

assuming your database is on a web server, and uses a domain like "www.yoursite.com":

1. Use your FTP program to create a new folder. for example "www.yoursite.com/pictures".
2. Use your FTP program to upload the pictures you want to the folder "www.yoursite.com/pictures"

If you go to "www.yoursite.com/pictures/picture1.jpg" you should see your 1st picture, if you go to "www.yoursite.com/pictures/picture2.jpg" you should see your second, and so on.

3. In mySQL, using phpMyAdmin, create your table and create a field for "image_url".
4. insert the url for your picture into a row, one row for each image / url.

Now when you query the database, you should be able to pull out the link to the image as a variable, for example '$image_url" (this varies by language).

Depending on what you want to do with it, you can incorperate the url variable into your HTML code like this:


<?
echo "<img src='" . $image_url . "'/>";
?>


what are you trying to acomplish with this?

[cezame1123]

its for our thesis..by the way thanks..gonna try this right away..