need help displaying an image from sql or upload?

mikewooten

i am working on an administration section for an ecommerce site for a school project.
Question?
when the administrator goes to update and add items from the admin to the products pages, i want the administrator to be able enter information including uploading an image from the admin to the products page. when that image is uploaded, i want the image to display on the products page.
so far, what i have now is, the whole form works as far as adding information into the database and i can view what has been added on the products page. the only thing that doesn't work is when i upload the
image, the image is not being displayed on the products page, it is also not being entered into the database. it works as far as uploading a file to a folder on my server, but it does not display that
image.
here's the site or page that i'm working on at the moment:

Image Upload?

can anyone help me with that. does anyone know how do display an image that has been uploaded to a folder so that i can view that image on the products page?

if you want to see the code that i have so far, just let me know. thanks

travelbuff

Mike - we would definitely nned to see the code to be able to help, but here is the basic process:

upload the image to a temp dir via the form, such as the link you provided
generate a name for the image and rename it accordingliy
insert the name of the image into the db keyed to the product
copy the image to the directory that you want to call it from
call the image from the product page

IMHO, it is generally not a good idea to store the actual image in the DB - takes lots of overhead.

There is a pretty simple tutorial here that may help: http://www.phpfreaks.com/tutorials/36/0.php

mikewooten

here's the code that i have so far, can you help me to get this code to work and for this image to display. if there is anything that i need to change with the code, can you let me know, thanks

here's the code:
here's the HTML

<form action="<?

 $_SERVER['PHP_SELF'];

?>" method="post" ENCTYPE="multipart/form-data">

Choose a product category <br>
<select name="txtCatID" id="select">
<option alue="0" SELECTED>0</option>
<option value="1">1</option>
<option value="2">2</option>
<option value="3">3</option>
</select>
Choose product items to add to your product pages <br>
<input type="hidden" name="

<?echo '$txtCatID';?>

">
<select name="txtprodItems" id="select">
<option alue="Guitars" SELECTED>Guitars</option>
<option value="Drums">Drums</option>
<option value="Amps">Amps</option>
<option value="Books">Books</option>
</select>
item name<br>
<input type="text" name="txtItemName"><br>

item description<br>
<input type="text" name="txtItemDesc"><br>

item price<br>
<input type="text" name="txtItemPrice"><br>

upload image<br>
<INPUT TYPE="HIDDEN" NAME="MAX_FILE_SIZE" VALUE="800000">
<INPUT TYPE="HIDDEN" NAME="action" VALUE="1">
<input type="file" name="txtItemImage"><br>
<input type="submit" name="submit" value="submit"><input type="Reset">

HERE'S THE PHP

<?php
 $submit = $_POST['submit'];
      if(isset($submit)){
	include("db.php");
	$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);            

            $txtCatID = $_POST['txtCatID'];
            $txtprodItems = $_POST['txtprodItems'];
            $txtItemName = $_POST['txtItemName'];
            $txtItemDesc = $_POST['txtItemDesc'];
            $txtItemPrice = $_POST['txtItemPrice'];           

            $txtItemImage = $_POST['txtItemImage'];
   $theSQL = "insert into items (prodItems, catid, itemName, itemDesc, itemPrice, ItemImage)";
   $theSQL = $theSQL . " values ('$txtprodItems', '$txtCatID', '$txtItemName', '$txtItemDesc', '$txtItemPrice', '$txtItemImage')";
    $result = mysql_query($theSQL); 	
    echo "<br><br>";
    echo "Thanks, the items have been added to category<br><br>";
    echo " 
    The items that you have add to the category are: 
      <br>
     Product Items: $txtprodItems <br>
    Cat Id:  $txtCatID <br>
    Item Description: $txtItemDesc <br>
    Item Price: $ $txtItemPrice <br>
    Item Image: $txtItemImage 
    "; 
   }
else
{
echo "<br><br><br>You Have To Enter In All Information Before Results Can Show"; 
     }
 ?> 
<?php if ($HTTP_POST_VARS['action']) { ?> 
<br><FONT FACE="Arial, Helvetica, sans-serif"><FONT SIZE="+1">File Upload 
    Results</FONT>
<?php      

    $uploadpath = '/home/username/public_html/php_cart/p_imgs/';     

    $source = $HTTP_POST_FILES['txtItemImage']['tmp_name'];
    $source_name = $HTTP_POST_FILES['txtItemImage']['name'];
    $source_size = $HTTP_POST_FILES['txtItemImage']['size'];
    $source_type = $HTTP_POST_FILES['txtItemImage']['type'];
    $source_error = $HTTP_POST_FILES['txtItemImage']['error']; 
    $dest = ''; 
     echo "$upload_tmp_dir";
    if ( ($source != 'none') && ($source != '' )) { 
        $imagesize = getimagesize($source);   

        switch ( $imagesize[2] ) { 
            case 0: 
                echo '<BR> Image is unknown <BR>';
                break; 

        case 1: 
            echo '<BR> Image is a GIF <BR>'; 
            echo 'Image uploaded!!'; 
            $dest = $uploadpath.uniqid('img').'.gif'; 
            break; 

        case 2: 
            echo '<BR> Image is a JPG <BR>'; 
            echo 'Image uploaded!!'; 
            $dest = $uploadpath.uniqid('img').'.jpg'; 
            break; 

        case 3: 
            echo '<BR> Image is a PNG <BR>'; 
            echo 'Image uploaded!!';
            $dest = $uploadpath.uniqid('img').'.png'; 
            break;  
    } 
if ($source_type = 'text/plain')
  {
    echo '<br>The name of the uploaded files is:&nbsp;';
    echo "$source_name";
  }  

  $upfile = $uploadpath . $source_name;

  if (is_uploaded_file($source)) 
  {
     if (!move_uploaded_file($source, $upfile))
     {
        echo 'Problem: Could not move file to destination directory';
        exit;
     }
  } 
  else 
  {
    echo 'Problem: Possible file upload attack. Filename: '.$source_name;
    exit;
  }

    if ( $dest != '' ) { 
        if ( move_uploaded_file( $source, $dest ) ) {                  
            echo 'File successfully stored.<BR>'; 
        } else { 
            echo '.<BR>'; 
        } 
    }  
} else { 
    echo 'File not supplied, or file too big.<BR>'; 
} 
?> 
</BODY> 
</HTML> 
<?php } else { ?> 
<?php
 } 

$sql = "SELECT * FROM items";
$results = mysql_query($sql);
echo "<table border='1'>";
while($products = mysql_fetch_array($results)){
		echo "<tr>
					<td>
						<span>".$products[3]."</span><br />
<a href=\"add4_1.php?id=".$products[1]."\">
<img src='/home/username/public_html/php_cart/p_imgs/".$products[4]."'
alt='".$products[3]."' /></a>
					</td>
			</tr>
	</table>";
} 
?>

mikewooten

here's the code that i'm currently using, can anyone help me in getting these images to display. i appreciate it
thanks

HTML

Choose product items to add to your product pages <br>
<input type="hidden" name="<?echo '$txtCatID';?>">
<select name="txtprodItems" id="select">
<option alue="Guitars" SELECTED>Guitars</option>
<option value="Drums">Drums</option>
<option value="Amps">Amps</option>
<option value="Books">Books</option>
</select>
<br>

item name<br>
<input type="text" name="txtItemName"><br>

item description<br>
<input type="text" name="txtItemDesc"><br>

item price<br>
<input type="text" name="txtItemPrice"><br>

PHP


<?php

 $submit = $_POST['submit'];
      if(isset($submit)){
	include("db2.php");

// Get a connection to the database
$cxn = @ConnectToDb($dbServer, $dbUser, $dbPass, $dbName);

        $txtCatID = $_POST['txtCatID'];
        $txtprodItems = $_POST['txtprodItems'];
        $txtItemName = $_POST['txtItemName'];
        $txtItemDesc = $_POST['txtItemDesc'];
        $txtItemPrice = $_POST['txtItemPrice'];           
        $txtItemImage = $_POST['txtItemImage'];
/*       
   $theSQL = "insert into items (prodItems, catid, itemName, itemDesc, itemPrice, ItemImage)";
   $theSQL = $theSQL . " values ('$txtprodItems', '$txtCatID', '$txtItemName', '$txtItemDesc', '$txtItemPrice', '$txtItemImage')";
*/

$theSQL = "insert into items (prodItems, catid, itemName, itemDesc, itemPrice, ItemImage)";
   $theSQL = $theSQL . " values ('$txtprodItems', '$txtCatID', '$txtItemName', '$txtItemDesc', '$txtItemPrice', '{$_FILES['upload']['name']}')";

$result = mysql_query($theSQL); 

if ($result) 
{ 
   $extension = explode ('.', $_FILES['upload']['name']); 
   $uid = mysql_insert_id(); 
   $filename = $uid . '.' . $extension[1]; 


  if (move_uploaded_file($_FILES['upload']['tmp_name'], "php_cart/p_imgs/$filename")) 
   { 
      //$query = "SELECT banner_id, username, password FROM bannerex WHERE username='$u'"; 
	  $query = "SELECT * FROM items";
      $result = @mysql_query ($query);                

      $row = mysql_fetch_array ($result, MYSQL_NUM); 
   } 
} 



$query = "SELECT * FROM items";       

$result = @mysql_query ($query); 
$row = mysql_fetch_array ($result, MYSQL_NUM); 
if ($row) 
{ 

  echo '<a href="'.$row[4].'" target="_blank"><img src="php_cart/p_imgs/'.$row[0].'.gif" border=0></a>'; 
$update ="UPDATE items WHERE itemId = $row[0]"; 
$result = @mysql_query ($update); 
} 
mysql_close(); 

$i=0; 
$dir = "/home/username/public_html/php_cart/p_imgs/"; // thumbs (duh) 
$bigdir = "/php_cart/"; // originalsized, using same names as thumbs 
echo '<table>'; 
if ($handle = opendir($dir)) { 
    while (false !== ($file = readdir($handle))) { 
        if ($file != "." && $file != "..") { 
         $i++; 
         // opens row and column is remainder is odd else open column 
             if ($i%2=='1'){ echo '<tr><td>'; }else{ echo '<td>'; } 
            echo "<p align='center'><a href=\"$bigdir/$file\"><img src=\"$dir/$file\" border=\"1\"></a></p>"; 
          // closes row and column is remainder is odd else close column 
             if ($i%2=='1'){ echo '</td>'; }else{ echo '</td></tr>'; } 
       } 
    } 
    echo '</table>'; 
    closedir($handle); 
} 

$dbname = "database"; 
$tblname = "items"; 
$linkid = mysql_connect("localhost", "username", "password")  

or die("Couldn't connect."); 
$db = mysql_select_db($dbname, $linkid) or die("Couldn't select database."); 
mysql_query ("SELECT * FROM $tblname");  

echo "$select<br>";					
	$host    ="localhost";
	$dbuser="username";
	$dbpass="password";
	$database="database";					
mysql_connect($host,$dbuser,$dbpass);
mysql_select_db($database) or die ("Unable to select database"); 
$query2="SELECT * FROM $tblname";  

$result3=mysql_query($query2);
$num=mysql_numrows($result3);  

$result3 = mysql_query($query2, $linkid);  

$result3 = mysql_query($query2);

$sql2 = "$query2"; 
$results2 = mysql_query($sql2) or die(mysql_error()); 
echo "<table border='1'>"; 
while($products = mysql_fetch_array($results2)){ 
      echo "<tr> 
               <td> 
                  <span>".$products[3]."</span><br /> 
<a href=\"add3_1.php?id=".$products[1]."\"> 
<img src='php_cart/p_imgs/".$products[4]."' 
alt='".$products[3]."' /></a> 
               </td> 
         </tr> 
   </table>"; 
} 


echo "<br><br>";
echo "Thanks, the items have been added to category<br><br>";
echo " 
The items that you have add to the category are: 
  <br>
 Product Items: $txtprodItems <br>
Cat Id:  $txtCatID <br>
Item Description: $txtItemDesc <br>
Item Price: $ $txtItemPrice <br>


Item Image: $txtItemImage 
"; 

   }
else
{
echo "<br><br><br>You Have To Enter In All Information Before Results Can Show"; 
     }

 ?>

<?php if ($HTTP_POST_VARS['action']) { ?> 

<br><FONT FACE="Arial, Helvetica, sans-serif"><FONT SIZE="+1">File Upload 
    Results</FONT>
<?php 


$uploadpath = 'php_cart/p_imgs/'; 
$source = $HTTP_POST_FILES['txtItemImage']['tmp_name'];
$source_name = $HTTP_POST_FILES['txtItemImage']['name'];
$source_size = $HTTP_POST_FILES['txtItemImage']['size'];
$source_type = $HTTP_POST_FILES['txtItemImage']['type'];
$source_error = $HTTP_POST_FILES['txtItemImage']['error']; 
$dest = ''; 
 echo "$upload_tmp_dir";
if ( ($source != 'none') && ($source != '' )) { 

    $imagesize = getimagesize($source); 


    switch ( $imagesize[2] ) { 

        case 0: 

            echo '<BR> Image is unknown <BR>';
            //echo "<BR><A HREF='upload.php'>Back</A><br> "; 
            break; 

        case 1: 
            echo '<BR> Image is a GIF <BR>'; 
            echo 'Image uploaded!!'; 
            //echo "<BR><A HREF='upload.php'>Back</A><br> ";
            $dest = $uploadpath.uniqid('img').'.gif'; 
            break; 

        case 2: 
            echo '<BR> Image is a JPG <BR>'; 
            echo 'Image uploaded!!'; 
            //echo "<BR><A HREF='upload.php'>Back</A><br> ";
            $dest = $uploadpath.uniqid('img').'.jpg'; 
            break; 

        case 3: 
            echo '<BR> Image is a PNG <BR>'; 
            echo 'Image uploaded!!';
            //echo "<BR><A HREF='upload.php'>Back</A><br> ";
            $dest = $uploadpath.uniqid('img').'.png'; 
            break;  
    } 


if ($source_type = 'text/plain')
  {
    echo '<br>The name of the uploaded files is:&nbsp;';
    echo "$source_name";
  }

// put the file where we'd like it
  $upfile = $uploadpath . $source_name;

// is_uploaded_file and move_uploaded_file added at version 4.0.3
  if (is_uploaded_file($source)) 
  {
     if (!move_uploaded_file($source, $upfile))
     {
        echo 'Problem: Could not move file to destination directory';
        exit;
     }
  } 
  else 
  {
    echo 'Problem: Possible file upload attack. Filename: '.$source_name;
    exit;
  }

    if ( $dest != '' ) { 

        if ( move_uploaded_file( $source, $dest ) ) { 

            echo 'File successfully stored.<BR>'; 

        } else { 

            echo '.<BR>'; 

        } 

    }  

} else { 

    echo 'File not supplied, or file too big.<BR>'; 

} 

?> 

</BODY> 
</HTML> 
<?php } else { ?> 

<?php

 } 

?>  

</body>
</html>

mikewooten

Frederick

Its accually an easier process then you think. I will make fake names for examples.

$file - from browse field
$title - from text field

table rows:
fileName and title

if (file_exists("/path/to/directory/$file_name")) {
header("Location: returnPath.php");

} else {

copy($file, "/path/to/directory/$file_name") or die
(header("Location: returnPath.php"));

$sql = mysql_query("INSERT INTO tablename (title,fileName) VALUES ('$title','$file_name')");

header("Location: successPath.php");
}

mikewooten

is that code, all i need for the upload page, or do i need to add it in with the rest of the code that i have?
thanks

Frederick

It is a fully functioning script. You will need to make your form to point to it.