Hi all ,
Since a week i decide to learn HTML ,PHPand MYSQL ...
So I'm REALLY new to this .
My first work has been making a guestbook , I managed to make it works , but then
I tried to upload and then display images with the messages , and I failed ... Since 2 days I'm trying to find out how to do it , but without any success .
(Probably I messed up something very easy ...:P )
If some can help me , I'd really appreciate it .
So those are my files :
The form :
-------------------------------------------------------------------------------------
<form enctype="multipart/form-data" action="write2db.php" method="post">
<fieldset>
<legend> Write here </legend><br>

Nome : <input type="text" name="name" rows="10" columns="6" ><br>
Soggetto: <input type="text" name="subject" rows="10" columns="5" ><br>
<input type="hidden" name="MAX_FILE_SIZE" value="320000">
Image :<input name="photo" type="file"><br>
<p>Messaggio :</p>
<TEXTAREA name="message" rows="10" cols="22" > </textarea>
<input type="submit" value="Submit">
<input type="reset" name="resetbutton" value="Cancel">
</fieldset>
</form>
---------------------------------------------------------------------------

The script to upload :
---------------------------------------------------------------------------------
<?
$photo = $_FILES['photo'];
$date= Date("j/d/Y H:i" );
$name = $_POST['name'] ;
$subject = $_POST['subject'] ;
$message = $_POST['message'] ;
$esc_name = mysql_escape_string($name);
$esc_subject = mysql_escape_string($subject);
$esc_msg = mysql_escape_string($message);

mysql_connect("localhost", "admin", "password") or die(mysql_error());
mysql_select_db("guestbook") or die(mysql_error());
mysql_query("INSERT INTO guestbook
(name,date,subject,photo,message)VALUES('$esc_name ', '$date','$esc_subject','$photo','$esc_msg') ")
or die (mysql_error()) ;

header("location:http://caffeina/prove/index.php?p=msgdb");
?>
-------------------------------------------------------------------------------------

and then to display :
------------------------------------------------------------------------------------
<?
echo "<h2>" ;
echo "Guestbook" ;
echo "</h2>" ;
mysql_connect("localhost", "admin", "password") or die(mysql_error());
mysql_select_db("guestbook") or die(mysql_error());
$result = mysql_query("SELECT * FROM guestbook ORDER BY id DESC")
or die(mysql_error());

while($row = mysql_fetch_array( $result )) {
$id = $row['id'];

echo "<div id=\"msg_header\">";
echo "Msg. nº :",$row['id'];
echo " on date ",$row['date'];
echo "<br>";
echo "<br>";
echo "..:",$row['name'];
echo ":..";
echo "<br>";
echo "<br>";
echo $row['subject'];
echo "<br>" ;
echo "<br>" ;
echo "</div>";
echo "<div id=\"msg_body\">";
echo "<br>" ;
echo "<br>" ;
#echo $row['photo'] ;
echo $row['message'];
echo "<img src=\"image.php?file=$id\" =\"170\" height=\"127\" border=\"1\" >";
#echo $row['photo'];
echo "<br>" ;
echo "<br>" ;
echo "</div>";}
?>

and

<?

mysql_connect("localhost", "admin", "password") or die(mysql_error());
mysql_select_db("guestbook") or die(mysql_error());
$result = mysql_query("SELECT photo FROM guestbook WHERE id = '.$_GET[id].' ")
or die(mysql_error());
header("Content-Type: image/jpeg");
$r=mysql_query($result);
$row=mysql_fetch_row($r);
echo $row['photo'];

?>
-------------------------------------------------------------------------------------
From th db :
-------------------------------------------------------------------------------------
mysql> select * from guestbook ;
+----+-----------+------------------+---------+-------+---------+
id | name | date | subject | photo |message
+----+-----------+------------------+---------+-------+----------+
| 1 | David | 13/13/2005 05:16 | TEST1| | aa |
| 2 | SDL | 13/13/2005 05:18 | TEST2| Array | test |


THX

David

What is the error you are getting? Was this ever working with the images? (Is that how you output and create images from a database in php?? Never tried it) Does the image.php page work if you navigate directly to it? Also, please post your table structure.

Hi ,

This is the output

<h2>Guestbook</h2><div id="msg_header">Msg. nº :8 on date 13/13/2005 06:49<br><br>..DL:..<br><br>Secondo post di prova un po piú lungo del primo p<br><br></div><div id="msg_body"><br><br> sdasd<img src="image.php?file=Array" ="170" height="127" border="1" ><br><br></div>


Well , the form and the upload script should upload image to the db ... same way as the data .
( maybe I'm wrong :P ).Image.php doesn't work .
Already posted table content ...

thx

So everything is being inserted correctly, right? It's just retrieving the images that is the problem?

Hmmm...I'm not sure why this is happening since the $id variable is working in the rest of the script? "file" should equal the guestbook entry id, right?


Sinc you are passing the id as the variable file in the query string (image.php?file=...) change that php line to:

Hopefully those changes will get us closer.

Many thx jfulton ...
Finally I got it working !
Seems the problem was just here :

$photo_name = $_FILES['photo']['name'];
$temp_photo = $_FILES['photo']['tmpname'];
$photo_size = $_FILES['photo']['size'];
$photo_type = $_FILES['photo']['type'] ;

and not just $photo = $FILES['photo'];
'cause this is just an Array
This for upload correctly the data , and :

echo "<img src=\"".$row['photo_name']."\" border=\"1\" >";

For showing them in the web . That's all ... No need of image.php
( I know i messed up something ... but u know ... first week of this stuff ...)

So I got it working on my machine , but when i moved all the stuff to the server seems that can't find the images ...

Dunno why ... Could be because in the server this stuff it's in UserDir directory and not in the main Apache one ?

I'm investigating it now ...

David