Brad--
I see what you're trying to do. Here's how this issue with a site I
did, perhaps this will help:
Eliminate the database of images all together. Create an image that
says "No Picture Available", and save it as "/images/no_photo.jpg".
When (if) a user uploads a file, have it rename the file as
/home/addicted/public_html/board/ranking/images/$user_id.jpg. Then,
place a call in your php page to:
<IMG SRC="image.php?$user_id">
And in the image.php file, have it check to see if the image actually
exists: (this is assuming $user_id is an integer)
<?php
header("Content-Type: image/jpeg");
if(is_file("/home/addicted/public_html/board/ranking/images/" .
(int)$HTTP_POST_VARS["QUERY_STRING"] . ".jpg"))
header("Location: /images/" .
(int)$HTTP_POST_VARS["QUERY_STRING"] . ".jpg");
else
header("Location: /images/no_photo.jpg");
?>
Good luck!
-----Original Message-----
From: Brad R. C. [mailto:[EMAIL PROTECTED]]
Sent: Friday, July 13, 2001 12:22 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Selecting userID
I have attached what I have so far. This version uses a table called
"picture_upload" and the field name is "picture_name".. also in my user
table I have the same field name, but that is from past trying to get it
to work... crap
I got it to upload to the table just fine and copy the file from a temp
source to the image directory I have chosen. So it works... but! it will
not insert into the right userid field, so I took it out and just made
it where they can copy and paste the url into the old way.. defeats the
purpose of uploading but atleast it gives them a place to put their
files if they don't have one :)
Can you take a look at my code below, and tell me how we can make it
Select a userid from the person who is logged in so that that the url
can be posted in the right field. I will try to play with it a little
more today, but I have sun poisoning and I am itching and burning all
over... what a pain.
This is for use with vb bulletin board software.. there is a user table
with userid for the id number of the user.. and I am sure I will have to
include the global.php file to find the bbuserinfo that is logged in.
---- start code ---
<TABLE cellSpacing=0 width="100%" align=center border=0
bordercolordark="#000000" cellpadding="0"> <TBODY><tr><TD
bgColor=#000000>
<TABLE align=center bgColor=#FFFFFF border=1 cellPadding=0
cellSpacing=0
width="100%" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF"
bordercolordark="#FFFFFF">
<TBODY>
<TR vAlign=top>
<TD vAlign=top align=middle>
<TABLE borderColor=#000000 cellSpacing=0
borderColorDark=#ffffff
cellPadding=5 width="100%" bgColor=#ffffff
borderColorLight=#000000
border=1 height="188">
</TABLE>
<table border="1" width="100%" cellspacing="0"
cellpadding="0" height="17" bordercolorlight="#000000"
bordercolor="#000000" bordercolordark="#3366CC" bgcolor="#3366CC">
<tr>
<TD bgcolor="#3366cc" bordercolor="#3366cc"
bordercolorlight="#3366CC" height="17"><b><font color="#FFFFFF"
face="Verdana" size="1"> Photo
Upload Information</font></b>
</TD>
</tr>
</table>
<TABLE borderColor=#000000 cellSpacing=0
borderColorDark=#ffffff
cellPadding=5 width="100%" bgColor=#ffffff
borderColorLight=#000000
border=1>
<tr>
<td>
<table class="reg" cellSpacing="0"
cellPadding="0" width="100%" border="0">
<tr vAlign="top">
<font face="Verdana, Arial, Helvetica,
sans-serif" size="2">
<td>
</font>
<font face="Verdana" size="1"><b>VERY,
VERY IMPORTANT - PLEASE READ!<br>
</b></font><font face="Verdana"
size="1">If you
have "Turned On" the picture
activation to show your photo, be
reminded that
it is shown to all members and guests
that come
to this site to look around and vote. If
there
is any information that you have given
upon your
part to this site that you don't want
others to
know about, please go into your user
control
panel and change it. If you have any
problems
with users and/or guests of this site
because of
your photo or your actions, please
notify one of
the Administrators or Moderators. Also
please
try to limit photos to no more than 500
pixels
in width, and 75kb in size. Reason being
is that
you will probably get a better rating if
it does
not take forever for your picture to
download,
and you also don't want your face to
take up the
whole screen.</font>
</td>
</tr>
</table>
</td>
</tr>
</TABLE><!------ NEXT -------><!------ NEXT ------->
<table border="1" width="100%" cellspacing="0"
cellpadding="0" height="18" bordercolorlight="#000000"
bordercolor="#000000" bgcolor="#3366CC" bordercolordark="#3366CC">
<tr>
<TD width=357 bgColor=#3366CC height="18"
bordercolor="#3366CC" bordercolorlight="#3366CC"
bordercolordark="#3366CC"><font face="Verdana"
size="1"> </font><b><font color="#FFFFFF" face="Verdana"
size="1">Upload
Form</font></b></TD>
</tr>
</table>
<TABLE borderColor=#000000 cellSpacing=0
borderColorDark=#ffffff
cellPadding=5 width="100%" bgColor=#ffffff
borderColorLight=#000000
border=1>
<tr>
<TD>
<form enctype="multipart/form-data" method="post"
action="<?php echo $PHP_SELF ?>">
Upload a Photo<br>
<input type="File" name="picture" size="25"><br>
<br>
<input type="submit" name="submit" value="Upload">
</form>
</TD>
</tr>
</TABLE>
</TD>
</TR>
</TBODY></TABLE>
</table>
<?php
define("SQL_SERVER", "localhost");
define("SQL_UID", "USERNAME");
define("SQL_PWD", "PASSWORD");
define("SQL_DB", "DATABASE NAME");
if ($submit) {
$connection = mysql_pconnect(SQL_SERVER, SQL_UID, SQL_PWD);
mysql_select_db(SQL_DB, $connection);
$sql = "INSERT INTO picture_upload (picture_name) ".
"VALUES ('$picture_name')";
mysql_query($sql);
exec("cp $picture
/home/addicted/public_html/board/ranking/images/$picture_name");
$beefy = "http://www.addictedusers.com/board/ranking/images";;
echo "temp file: $picture<br>\n";
echo "file name: $picture_name<br>\n";
echo "file size: $picture_size<br>\n";
echo "file type: $picture_type<br>\n";
echo "<br>\n";
echo "Copy and Paste this url : $beefy/$picture_name<br>\n";
echo "<br>\n";
echo "<img src=images/$picture_name><br>\n";
return 0;
}
?>
--- end code ---
Thanks
BradC
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
