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]