Images and Mysql

Anon

Please help me ive tried everything!!
I need a script that will get a image file name from a mysql file name and have display out to a page. Nothing ive tried have worked. Ive read the article on phpbuilder and it doesnt work. Im creatingf a site on windows 2000 with php and mysql using a apache webserver.

Please help me!!

Anon

I'm assuming that you have already uploded the images and their names into the database (MySql). If so, try this, works fine with me:

<?php
$the_path="../../path/to/images";
$table="tablename";

// connecting to the database
if (!($link=mysql_pconnect($DB_SERVER,$DB_LOGIN,$DB_PASSWORD)))
{
DisplayErrMsg(sprintf("internal error %d:%s\n",mysql_errno(),mysql_error()));
exit();
}

//getting the data
if (!(@$result=mysql_db_query("$DB","select * from $table order by imgid")))
{
DisplayErrMsg(sprintf("internal error %d:%s\n",mysql_errno(),mysql_error()));

exit();
}

while(($row=mysql_fetch_array($result)))
{
$v=$row["imgid"];
$name= $row["imgname"];
$filename="$the_path/$name";

    //Displaying the image...
    echo "<img src=$filename><br>";

}

// End of script.
Of course, you can output the image in a neat way by using tables and other styles...

Hope this help.

Anon

Thanks but i get an error message that says

Fatal error: Call to undefined function: displayerrmsg() in C:\apache\htdocs\khs\image.php on line 15

Anon

I'm Very sorry...
I forgot to add it because it was passed to my program through another "require 'funtions.php'" file..
here is how the function() looks like:

//it just display the error..
function DisplayErrMsg($msg)
{
printf("<blockquote><blockquote><blockquote><h3><font color=\"#cc0000\">%s</font></blockquote>
</blockquote></blockquote>\n",$msg);
}

...
You should copy&paste it before where you are calling it..

<?php
paste it here...
.
.
.
the rest of the code..

Again, hope this help.

vikcious

Two weeks ago I tried to do the same thing and it only worked under Linux!
Unfortunately you are working under win2k and this is a F&&* mess. Why? Just try and see how hard it is to get a directory and all its possible subs traversed as to obtain the full path... Here is what I have done! Not 100% my ideea yet...!

<?php

$dir="/usr/local/apache/htdocs/storage/";
$a = find $dir -depth -type f -print;
$files = explode ("\n", $a);

for ($i=0; $i<count($files); $i++)
{
$cut = $files[$i];
$link = substr ($cut, 25);
$nojpg = substr ($link, -20);

$my_cust_id = substr ($nojpg,1,15);
$con = mysql_connect("localhost","root") or die ("Eroare");
$seldb = mysql_select_db("storage",$con);
$query = "insert ignore into docmaster (link, cust_id) values ('$link','$my_cust_id')";
$result=mysql_query($query) or die (mysql_error());
//echo "$final<br>\n";
}
?>

I have used "insert ignore" as I have set some fields in the table to be unique and the above scrript is actually run about 100 times per day to gather all the links to new images dropped by users in a certain folder (n.n /usr/local/apa....)

Good Luck!

Anon

How are u selecting the database?