Image Database Upload/Display Guidelines Needed

phence

I am not sure how to approach this... I'm not sure how to go about creating and uploading an image database....

I have read a few tutorials how to upload images... but i'm still confused on a few things. If anyone could drop some hints or guidelines, i'd greatly appreciate it!

Right now, this is what i have. A database with user data called 'information'. this database holds information about the user, I need to include a spot for an Image. So when user information is requested it will display an image as well as the users information.
I placed aside, a field in the database for the location of the image on the server. So for each user there is a URL or Path to his/her image.

The number of users and images is expected to grow pretty extensive. Do i have to worry about uploading all images to one directory? or should i write a script that will organize the images to specific directories such as by last name? which is more effiecient?

Also, after the user has submitted their information to the database, i would like to allow them to preview thier page that includes the picture and other information they submitted. I was thinking that i would only need the location of the image on the users computer to display the image on the preview page. The preveiw page does not pull anything from the database but rather uses the session varables created after the user submits thier information..

Sorry this was kinda lenthly in explaining what i am trying to do. i'd just like it to be clear.

I want to be able to accept at least .gif and .jpg files types. and i'd also like to place a limit on the file size. How can i do that?

the users input is validated and inserted into the database on the page following the preview page. and the actual picture upload is not going to be uploaded until after the user previews the data and has verified it. So i assume i am going to have to store the images location on the users computer in a session until i need to upload it to the server...
So, how can i upload the image to the image database?
Also is the Image database simply a directory on the server? linked to the MySQL database by the stored PATH location?

I would greatly appreciate if anyone could help in any way. Thank-you!

rupertbj

form - galleryadmin.php

<?php include("header.inc"); ?>
<p><br>
</p>
<table width="100%" border="0" cellpadding="3" cellspacing="5">
  <tr> 
    <td width="100%" valign="top" class="link"><div align="center">Gallery Administration - Add a painting</div></td>
  </tr>
  <tr> 
    <td width="100%" valign="top" class="link"><form action="addgallery.php" method="post" name="form1" enctype="multipart/form-data">
        <table align="center">
          <tr> 
            <td width="150" class="smalltext">Title:</td>
            <td><input type="text" size=40 name="name"></td>
          </tr>
          <tr> 
            <td class="smalltext">Materials:</td>
            <td><input type="text" size=40 name="materials"></td>
          </tr>
          <tr> 
            <td class="smalltext" valign=top>Size:</td>
            <td><input name="size" type="text" size="40"></td>
          </tr>
          <tr> 
            <td class="smalltext" valign="top">Tour:</td>
            <td>
				<SELECT name="tour"> 
				<?php 
					$db = "gallery";
					$link = mysql_connect( "user", "pass" );
					if ( !$link ) die( "Couldn't connect to MySQL".mysql_error() );
					mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
					$query = "SELECT DISTINCT (tour) FROM galleryTable ORDER BY tour"; 
					$result = mysql_query( $query, $link ) or die( "Couldn't execute query".mysql_error() ); 
					while ($row = mysql_fetch_array( $result )) { 
						$tour = $row["tour"]; 
						print "<OPTION value=\"$tour\" size=\"20\">$tour</OPTION>"; 
						}
					mysql_close( $link );
				?> 
				</SELECT>
			</td> 
          </tr>
          <tr> 
            <td class="smalltext" valign="top">Status:</td>
            <td><select name="status">
				<?php 
					$db = "gallery";
					$link = mysql_connect( "user", "pass" );
					if ( !$link ) die( "Couldn't connect to MySQL".mysql_error() );
					mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
					$query = "SELECT DISTINCT (status) FROM galleryTable ORDER BY status DESC"; 
					$result = mysql_query( $query, $link ) or die( "Couldn't execute query".mysql_error() ); 
					while ($row = mysql_fetch_array( $result )) { 
						$status = $row["status"]; 
						print "<OPTION value=\"$status\" size=\"20\">$status</OPTION>"; 
						}
					mysql_close( $link );
				?> 			
              </select></td>
          </tr>
          <tr> 
            <td class="smalltext" valign="top">Upload file:</td>
            <td><input type="file" name="fupload"> <input type="hidden" name="MAX_FILE_SIZE" value="51200"></td>
          </tr>
          <tr> 
            <td class="smalltext" valign="top">Upload thumb:</td>
            <td><input type="file" name="tupload"> <input type="hidden" name="MAX_FILE_SIZEtn" value="51200"></td>
          </tr>
          <tr> 
            <td align="center" colspan="2"><input class="button" type="submit" value="Submit"></td>
          </tr>
        </table>
      </form></td>
  </tr>
</table>
<?php include("footer.inc"); ?>

addgallery.php

<?php
	$file_dir = "/users/georgel/domains/octavianart.com/html/images/archive"; 
	$file_url = "http://www.octavianart.com/images/archive"; 
//		print "path: $fupload<br>\n";
//		print "name: $fupload_name<br>\n";
//		print "size: $fupload_size bytes<br>\n";
//		print "type: $fupload_type<p>\n\n";
		if ( ( $fupload_type == "image/pjpeg" && $tupload_type == "image/pjpeg" ) && $MAX_FILE_SIZE <= "51200" )
			{
			$db = "gallery";
			$link = mysql_connect( "user", "pass" );
			if ( !$link ) die( "Couldn't connect to MySQL".mysql_error() );
			mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
			$sql = "INSERT INTO galleryTable VALUES ( '', '$status', '$tour', '$name', '$materials', '$size', '$fupload_name', '$tupload_name' )";
			mysql_query( $sql, $link );
			mysql_close( $link );
			copy ( $fupload, "$file_dir/$fupload_name" ) or die ("Couldn't copy");
			copy ( $tupload, "$file_dir/$tupload_name" ) or die ("Couldn't copy");			
			}
		else
			{
			if ( $MAX_FILE_SIZE > "32000" ){
			print "File size beyond maximum size of 51,200 bytes - ($fupload_size bytes)";
			exit;
				}
			elseif ( $MAX_FILE_SIZEtn > "16000" ){
			print "File size beyond maximum size of 16,000 bytes - ($tupload_size bytes)";
			exit;
				}
			elseif ( $fupload_type != "image/pjpeg" ){
			print "Invalid file type $fupload_type. Please submit only pjepg images (with extensions .jpg / .jpeg)";
			exit;
				}
			elseif ( $tupload_type != "image/pjpeg" ){
			print "Invalid file type $tupload_type. Please submit only pjepg images (with extensions .jpg / .jpeg)";
			exit;
				}
			else
				{
			print "Failed - reason unknown.";
			exit;
				}
			}
?>

and view gallery

        <?php
		$db = "gallery";
		$link = mysql_connect( "user", "pass" );
		if ( !$link ) die( "Couldn't connect to MySQL".mysql_error() );
		mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
		$sql = "SELECT * FROM galleryTable WHERE tour = '$page' ORDER BY id DESC";
		$result = mysql_query( $sql, $link );
		while ( $newArray = mysql_fetch_array($result) )
			{
			$id = $newArray['id'];
			$status = $newArray['status'];
			$name = $newArray['name'];
			$materials = $newArray['materials'];
			$size = $newArray['size'];
			$size = htmlspecialchars($size); 
			$fupload = $newArray['fupload'];
			$tupload = $newArray['tupload'];
			print "
				<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
					<tr>
						<td valign=top width=\"40%\">
							<a href=\"display.php?fupload=$fupload&name=$name&materials=$materials&status=$status&size=$size\"><img src=\"/images/archive/$tupload\"></a>
						</td>
						<td valign=bottom width=\"60%\"><p class=smalltext>$name<br>$materials<br>$size<br>$status</p></td>
					</tr>
				</table><hr noshade color=#000000>
			";
			}
		mysql_close( $link );
		?>

phence

hey thanks alot! Looks like that code answered alot of my questions!

So i guess my logic on setting up the image database is efficient?

thanks again!

Truti

What is the SQL query, to get this script working?

rupertbj

The MySQL query for what? uploading pictures? or viewing them?

It's all in the code. Tweak it as you like to suit your purposes. Remember though that the MySQL database will have to have fields corresponding to those in the code.

onion2k

<tr>
            <td class="smalltext" valign="top">Tour:</td>
            <td>
                <SELECT name="tour">
                <?php 
                    $db = "gallery";
                    $link = mysql_connect( "user", "pass" );
                    if ( !$link ) die( "Couldn't connect to MySQL".mysql_error() );
                    mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
                    $query = "SELECT DISTINCT (tour) FROM galleryTable ORDER BY tour"; 
                    $result = mysql_query( $query, $link ) or die( "Couldn't execute query".mysql_error() ); 
                    while ($row = mysql_fetch_array( $result )) { 
                        $tour = $row["tour"]; 
                        print "<OPTION value=\"$tour\" size=\"20\">$tour</OPTION>"; 
                        }
                    mysql_close( $link );
                ?> 
                </SELECT>
            </td>
          </tr>
          <tr>
            <td class="smalltext" valign="top">Status:</td>
            <td><select name="status">
                <?php 
                    $db = "gallery";
                    $link = mysql_connect( "user", "pass" );
                    if ( !$link ) die( "Couldn't connect to MySQL".mysql_error() );
                    mysql_select_db( $db, $link ) or die( "Couldn't open $db: ".mysql_error() );
                    $query = "SELECT DISTINCT (status) FROM galleryTable ORDER BY status DESC"; 
                    $result = mysql_query( $query, $link ) or die( "Couldn't execute query".mysql_error() ); 
                    while ($row = mysql_fetch_array( $result )) { 
                        $status = $row["status"]; 
                        print "<OPTION value=\"$status\" size=\"20\">$status</OPTION>"; 
                        }
                    mysql_close( $link );
                ?>             

              </select></td>
          </tr>

Sometimes the code posted here amazes me. Not in a good way.

rupertbj

If you're going to make comments, at least make them helpful - like show us a better way - We're all trying to learn. The code works for me, but if you can improve on it, I want to know about it so I can improve!

Thanks