RE: [PHP-DB] Selecting userID

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:bradc@addictedusers.com] Sent: Friday, July 13, 2001 12:22 PM To: php-db@lists.php.net 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">&nbsp;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 &quot;Turned On&quot; 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">&nbsp;</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: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net