PHP - How To Display 3 Clickable Images In A Row From Database

I have this script from http://lampload.com/...,view.download/ (I am not using a database) I can upload images fine, I can view files, but I want to delete them. When I press the delete button, nothing happens   http://www.jayg.co.u...oad_gallery.php   <form> <?php $dir = dirname(__FILENAME__)."/images/gallery" ; $files1 = scandir($dir); foreach($files1 as $file){ if(strlen($file) >=3){ $foil = strstr($file, 'jpg'); // As of PHP 5.3.0 $foil = $file; $pos = strpos($file, 'css'); if ($foil==true){ echo '<input type="checkbox" name="filenames[]" value="'.$foil.'" />'; echo "<img width='130' height='38' src='images/gallery/$file' /><br/>"; // for live host //echo "<img width='130' height='38' src='/ABOOK/SORTING/gallery-dynamic/images/gallery/ $file' /><br/>"; } } }?> <input type="submit" name="mysubmit2" value="Delete"> </form>   any ideas please?   thanks

I'm creating a funeral home site and on the side of the page I would like to display the last 5 funeral obituaries that are in mySQL database (name and certain sized image (images are in "image" field) w/ a link to an "obituaries detail page for the individual deceased person"). I am able to do this successfully listing only the names....how can I list the image associated with the name? This is what I have so far:

Code: [Select]
<?php 

include("connect.php"); 

?>

Code: [Select]
<?php 

$query = "SELECT id, deceased_name, deceased_date, DATE_FORMAT(deceased_date, '%M %D, %Y') as datetext"; 
$query .= " FROM scales_obits ORDER BY deceased_date DESC LIMIT 5"; 

$listings = mysql_query($query); 
if (!listings) { 
        echo("<p>Error retrieving listings from lookup table<br>". 
                "Error: " . mysql_error()); 
        exit(); 
} 

echo("<table border=\"0\" width=\"100%\" class=\"obit\">"); 

while ($listing = mysql_fetch_array($listings)) { 

$deceased_name = $listing["deceased_name"]; 
$deceased_date = $listing["datetext"]; 
$id = $listing["id"]; 

echo("<tr><td width=\"100%\"><a href=\"obitdetail.php?id=".$id."\"><strong>".$deceased_name."</strong></a></td><td>&nbsp;</td>"); 


} 

echo("</table>"); 
?>

I read everywhere where it says not to stoe images in MYSQL but I have a code where I'm trying to display the images. They are all jpegs that are stored in the table. Here is the code Code: [Select]
<?php
include "dbaptsConfig.php";
include "searchaptsstyle.css";
// test id, you need to replace this with whatever id you want the result from
$id = "1";

// what you want to ask the db
$query = "SELECT * FROM `apartments` WHERE `id` = ".$id;

// actually asking the db
$res = mysql_query($query, $ms);

// recieving the answer from the db (you can only use this line if there is always only one result, otherwise will give error)
$result = mysql_fetch_assoc($res);

// if you uncomment the next line it prints out the whole result as an array (prints out the image as weird characters)
// print_r($result);

// print out specific information (not the whole array)
   echo "<br/>";
echo "<div id='title'>".$result['title']."<br/></div>";
echo "<br/>";
   echo "<div id='description'>".$result['description']."<br /></div>"; 
echo "<br/>";
echo "<div id='table'><tr>"; 
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Provider's Phone Number: ".$result['phone']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Provider: ".$result['service']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Borough: ".$result['county']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Town: ".$result['town']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Bedrooms: ".$result['rooms']."</td>";
echo "<td>&nbsp;&nbsp;&nbsp;</td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Bathrooms: ".$result['bath']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Square Footage: ".$result['square']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Rent: ".$result['rent']."<br /></td>";
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Listed On: ".$result['time']."<br /></td>";
echo "</tr></div>";
header("Content-type: image/jpeg");
echo "<td bgcolor='#FFFFFF' style='color: #000' align='center'> Listed On: ".$result['image1']."<br /></td>";
?>
Thanks

I want to display thumbnails for a picture gallery and when user clicks on image the larger image opens in a new window.  I can't find a straight answer on the php.net website.  Can someone help?

I am looking to display image paths in a row separated by commas. There are 6 images that goes to each user and I would like only the 6 images at be in each " " Like this:

"images/listings/listing_516013019A-only.jpg,images/listings/listing_848813453A-1.jpg,images/listings/listing_664613453A-2.jpg,images/listings/listing_520313453A-3.jpg,images/listings/listing_690513453A-4.jpg,images/listings/listing_125113453A-5.jpg,images/listings/listing_641013453A-6.jpg,"
"images/listings/listing_736913186A-1.jpg,images/listings/listing_822713186A-2.jpg,images/listings/listing_136513186A-3.jpg,images/listings/listing_700313186A-4.jpg,images/listings/listing_716013186A-5.jpg,images/listings/listing_213113186A-6.jpg,"
"images/listings/listing_292113254A..-1.jpg,images/listings/listing_854413254A..-2.jpg,images/listings/listing_446013254A..-3.jpg,images/listings/listing_676313254A..-4.jpg,images/listings/listing_563413254A..-5.jpg,images/listings/listing_341513254A..-6.jpg,"

Right now it is displaying them like this

"images/listings/listing_516013019A-only.jpg,"
"images/listings/listing_848813453A-1.jpg,"
"images/listings/listing_664613453A-2.jpg,"
"images/listings/listing_520313453A-3.jpg,"
"images/listings/listing_690513453A-4.jpg,"
"images/listings/listing_125113453A-5.jpg,"
"images/listings/listing_641013453A-6.jpg,"
"images/listings/listing_736913186A-1.jpg,"
"images/listings/listing_822713186A-2.jpg,"
"images/listings/listing_136513186A-3.jpg,"
"images/listings/listing_700313186A-4.jpg,"
"images/listings/listing_716013186A-5.jpg,"
"images/listings/listing_213113186A-6.jpg,"
"images/listings/listing_292113254A..-1.jpg,"
"images/listings/listing_854413254A..-2.jpg,"
"images/listings/listing_446013254A..-3.jpg,"
"images/listings/listing_676313254A..-4.jpg,"
"images/listings/listing_563413254A..-5.jpg,"
"images/listings/listing_341513254A..-6.jpg,"

Here is the code I have:

Code: [Select]
<?php

// Make a MySQL Connection
mysql_connect("localhost", "xxxxxxxx", "xxxxxxxx") or die(mysql_error());
mysql_select_db("xxxxxxxx") or die(mysql_error());

$result = mysql_query("SELECT * FROM listimages ORDER BY listimages.listingid DESC ")
or die(mysql_error());

while($row = mysql_fetch_array($result)) {

echo "\"";
        echo "$row[imagepath],";
echo "\"";
echo "<br>";

}

?>
My tables for the images is   "listimages" and the columns a
id (which are the auto_increments)
imagepath (which shows the path/image1.jpg)
mainimage (which just shows 0 or 1 depending on the picture that is the default for that listing, 1 being default)
listingid (shows numbers 1 2 3 etc corresponding to the Id in the listings table to show what images go with what listing) There are up to 6 images for each listing.

Any idea how to fix this?

Hi all, while I was coding a script for my website something struck me which ive not really got an idea how to code it, but anyway, in my Database ive got a table which holds image URL's but how could I echo them out in PHP which will show the image? Not just the writing.

Thanks for your help.

Hello everyone,

I need help figuring out why im not getting images displayed. I have tried everything I could think of and narrowed down the issue.

What Im doing id querying urls from DB for my images. Then using md5 to encrypting the url them before display on web page.

Here is the code:

Code: [Select]
$img = @ md5(mysql_result(mysql_query("SELECT `url` FROM `pictures` WHERE `mls`='{$row['mls']}'  ORDER BY `id` LIMIT 1",$avenu->link),0));
When html is displayed I get the hash.jpg. The image failed to be loaded.

How can i display all the images in a certain directory and echo the image names. So if a new image is uploaded, it will still display without edited the gallery.php file.

Cheers.

Hi all,

Newbie here, i am having a problem to get my images to show which are stored in mysql database as a mediumblob. I get id number to print in table ut am just getting empty square with red cross in where my image should be. Is my code incorrect or is it something else?
Appreciate your help with this.
I have included both of the pages codes i am using.

Thanks
Tony

image2.php

<?php
include("common.php");
error_reporting(E_ALL);
$link = mysql_connect(host,username,password) or die("Could not connect: " . mysql_error());
mysql_select_db(db) or die(mysql_error());
$sql = "SELECT id FROM photos";
$result = mysql_query("$sql") or die("Invalid query: " . mysql_error());
?>
<table border="1"><tr><td>id</td><td>image</td></tr>
<?php
while($row=mysql_fetch_assoc($result)){
print '<tr><td>'.$row['id'].'</td><td>';
print '<img src="image1.php?id='.$row['id'].'height="75" width="100"">';
}
echo '</td></tr></table>'
?>

image1.php

<?php
ob_start();
include("common.php");    
   mysql_connect(host,username,password) or die(mysql_error());
   mysql_select_db(db) or die(mysql_error()); 

$query = mysql_query("SELECT imgage FROM photos WHERE id={$_GET['image_id']}";
$row = mysql_fetch_array($query);
$content = $row['image']; 
header('Content-type: image/jpg');
     echo $content;
 }
 ob_end_flush();
?>

Hi everyone!! 

I have looked into how the upload script works and this is what i have:

Code: [Select]
<?php
 if ((($_FILES["file"]["type"] == "image/gif")
 || ($_FILES["file"]["type"] == "image/jpeg")
 || ($_FILES["file"]["type"] == "image/pjpeg"))
 && ($_FILES["file"]["size"] < 20000))
   {
   if ($_FILES["file"]["error"] > 0)
     {
     echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
     }
   else
     {
     echo "Upload: " . $_FILES["file"]["name"] . "<br />";
     echo "Type: " . $_FILES["file"]["type"] . "<br />";
     echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
     echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";
 
    if (file_exists("upload/" . $_FILES["file"]["name"]))
       {
       echo $_FILES["file"]["name"] . " already exists. ";
       }
     else
       {
       move_uploaded_file($_FILES["file"]["tmp_name"],
       "upload/" . $_FILES["file"]["name"]);
       echo "Stored in: " . "upload/" . $_FILES["file"]["name"];
       }
     }
   }
 else
   {
   echo "Invalid file";
   }
 ?>

Which is un-tested at the moment, but let's just say for talking sake it worked 100% what elements of this script would i be looking at to display the files uploaded on to another page, in my case my homepage?

ive found as to yet, that the uploads have to be stored on a file somewhere on my server, which i've set up. But i thought it would be just as easy to have a field in my table named upload and display it within the table next to the other results? instead i just get whatever the file name is named.jpg.

Any help in looking towards the answer? many thanks in advance guys!

I want to retrieve an image id from a db and show the images.
I cant get the syntax right for the image tag.Any help appreciated.
Code: [Select]
function display_covers()
{
    global $wpdb;
 $query = "select * from wp_cover";
   $result = mysql_query($query)or trigger_error("Query: $query\n<br />MySQL Error: " . mysql_error());
echo mysql_error();
  if (!$result)
  return false;
echo'<div class="wrap"><p>choose from one of the covers below</p></div>';

echo'<div id="main">';
echo'<table class="main" cellpadding="2">';
//echo"<caption>Please choose a book cover</caption>";
?>
<thead><tr><td colspan="5" ><h6 class="main">Book Covers</h6></td></tr>
</thead>
<?php
  $i=0;
  $size=3;
  echo "<tbody>";
  echo "<tr>";
  while ($row = mysql_fetch_array($result,MYSQL_ASSOC))
  {
    /* display picture  */
     ?>
    <td class="main">
    <?php
    
    
    echo"<img src="/Applications/MAMP/htdocs/wordpress_3/wp-content/plugins/Authors2/jackets/"{.$row['pix'].}""/>";

echo"</td>";
    $i++;

    if($i==$size)
{
  echo "</tr><tr>";

  $i=0;
}

 }
}

Hi I tried to write a script:
1) to locate all directories in a directory (1 level)
2) with the function GetImages() I try to display the image(s) in the subfolder

there are only images in the subfolder
I guess I'm doing something wrong in the GetImages() with the glob function, can anyone check this ?
Thanks in advance

function GetImages($map)
{
$files = glob('$map/*.jpg'); 
//$files = glob("$map/*.*"); 

for ($i=0; $i<count($files); $i++) 

{ $num = $files[$i]; 

       echo '<img height="50" width="50"  src="'.$num.'"  />'."  <br />"; } 
}



if ($handle = opendir('mystuff')) {
/* loop through directory. */
while (false !== ($dir = readdir($handle))) {

if($dir != ".." && $dir != "."){

echo '<option value='.$dir.'>'.$dir.'</option><br>';

GetImages($dir);

}
}
closedir($handle);
} 

I want users to be allowed to upload images to a table in a database but I cannot seem to find a suitable way to implementing using the code I already have, here is the code below;

Code: [Select]
<?php

error_reporting(E_ALL ^ E_NOTICE);
ini_set("display_errors", 1);

require_once ('./includes/config.inc.php');

require_once (MYSQL);

$add_cat_errors = array();

if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
if (!empty($_POST['product']))
{
$prod = mysqli_real_escape_string($dbc, strip_tags($_POST['product']));
}
else
{
$add_cat_errors['product'] = 'Please enter a Product Name!';
}

if (filter_var($_POST['prod_descr']))
{
$prod_descr = mysqli_real_escape_string($dbc, strip_tags($_POST['prod_descr']));
}
else
{
$add_cat_errors['prod_descr'] = 'Please enter a Product Description!';
}

// Check for a category:
if (filter_var($_POST['cat'], FILTER_VALIDATE_INT, array('min_range' => 1))) {
$catID = $_POST['cat'];
} else { // No category selected.
$add_page_errors['cat'] = 'Please select a category!';
}

if (filter_var($_POST['price']))
{
$price = mysqli_real_escape_string($dbc, strip_tags($_POST['price']));
}
else
{
$add_cat_errors['price'] = 'Please enter a Product Description!';
}

if (filter_var($_POST['stock']))
{
$stock = mysqli_real_escape_string($dbc, strip_tags($_POST['stock']));
}
else
{
$add_cat_errors['stock'] = 'Please enter a Product Description!';
}

if (empty($add_cat_errors))
{
$query = "INSERT INTO product (product, prod_descr, catID, price, image, stock) VALUES ('$prod', '$prod_descr', '$catID', '$price', '$image', '$stock')";
$r = mysqli_query ($dbc, $query);
if (mysqli_affected_rows($dbc) == 1)
{
echo '<p>Record Successfully Added!!!!!</p>';
$_POST = array();
}
else
{
trigger_error('OH NOOOOO!!!!');
}
}
}

require_once ('./includes/form_functions.inc.php');
?>

<form action="add_product.php" method="post">
Product Name: <?php create_form_input('product', 'text', $add_cat_errors);?>
Product Description: <?php create_form_input ('prod_descr', 'text', $add_cat_errors);?>
Category: <select name="cat"<?php if (array_key_exists('cat', $add_cat_errors))?>>
<option>Select a Category</option>
<?php $q = "SELECT catID, cat FROM category ORDER BY cat ASC";
$r = mysqli_query($dbc, $q); while ($row = mysqli_fetch_array($r, MYSQLI_NUM))
{
echo "<option value=\"$row[0]\"";
if (isset($_POST['cat']) && ($_POST['cat'] == $row[0]))
echo 'selected="selected"';
echo ">$row[1]</option>\n";
}
?>
Price: <?php create_form_input('price', 'text', $add_cat_errors);?>
Upload an Image: <?php if(array_key_exists('image', $add_cat_errors))
{
echo '<input type="file" name="image" />';
} ?>
Stock: <?php create_form_input('stock', 'text', $add_cat_errors);?>

<input type="submit" name="submit_button" value="ADD RECORD" />
</form>
Everything else writes perfectly but I have been trying ways to create a file upload and write successfully to the database. The 'image' field has a data type of 'varchar'.

I apologise immensely for the long winded explanation but if anyone could help me please that would be much appreciated.

I have this code which uoploads and resizes the images into a folder without a problem. My problem is I am unable to view the Thumb or Full image which has uploaded to the folder and the database with the other data.  How do i correct this problem code below. Thanks

upload form and script
Code: [Select]

<?php
//database properties
$dbhost = 'localhost';
$dbuser = 'user';
$dbpass = 'pass';
$dbname = 'DB';

// make a connection to mysql here
$conn = mysql_connect ($dbhost, $dbuser, $dbpass) or die ("I cannot connect to the database because: " . mysql_error());
mysql_select_db ($dbname) or die ("I cannot select the database '$dbname' because: " . mysql_error());

/******** start function ********/

function errors($error){
if (!empty($error))
{
$i = 0;
echo "<blockquote>\n";
while ($i < count($error)){
echo "<p><span class=\"warning\">".$error[$i]."</span></p>\n";
$i ++;}
echo "</blockquote>\n";
}// close if empty errors

} // close function


// ----------------Create Smaller version of large image---------------------
function createthumbfull($src_filename, $dst_filename_full)
{
  // Get information about the image
        list($src_width, $src_height, $type, $attr) = getimagesize( $src_filename );

        // Load the image based on filetype
        switch( $type ) {
        case IMAGETYPE_JPEG:
                $starting_image = imagecreatefromjpeg( $src_filename );
                break;
        case IMAGETYPE_PNG:
                $starting_image = imagecreatefrompng( $src_filename );
                break;
        case IMAGETYPE_GIF:
                $starting_image = imagecreatefromgif( $src_filename );
                break;
        default:
                return false;
        }


// get the image to create thumbnail from
    $starting_image; 
// get image width
$width = imagesx($starting_image);
// get image height
    $height = imagesy($starting_image);
// size to create thumnail width
$thumb_width = 600;

    // divide iwidth by specified thumb size
    $constant = $width/$thumb_width;
// round height by constant and add t thumb_height
    $thumb_height = round($height/$constant, 0);


//create thumb with true colours
    $thumb_image = imagecreatetruecolor($thumb_width, $thumb_height);

//create thumbnail resampled to make image smooth
    imagecopyresampled($thumb_image, $starting_image, 0, 0, 0, 0, $thumb_width, $thumb_height, $width, $height);

$ran = rand () ;
$thumb1 = $ran.".jpg";

global $thumb_Add_full;
$thumb_Add_full = $dst_filename_full;
$thumb_Add_full .= $thumb1;

imagejpeg($thumb_image, "" .$dst_filename_full. "$thumb1");
} 



//-------------------- create thumbnail --------------------------------------------
//$src_filename = source of image
//$dst_filename_thumb = location to store final image
function createthumb($src_filename, $dst_filename_thumb)
{
    $size = getimagesize($src_filename); // get image size
   $stype = $size['mime']; //get image type : gif,png,jpg
   $w = $size[0]; // width of image
   $h = $size[1]; // height of image
   
   //do a switch statment to create image from right image type
   
   switch($stype) {
      //if image is gif create from gif
      case 'image/gif':
      $simg = imagecreatefromgif($src_filename);   
      break;
      //if image is jpeg create from jpeg
      case 'image/jpeg':
      $simg = imagecreatefromjpeg($src_filename);      
      break;
      //if image is png create from png
      case 'image/png':
      $simg = imagecreatefrompng($src_filename);      
      break;
      }

   
   $width = $w; // get image width   
    $height = $h; // get image height
   
   // size to create thumnail width
   $thumb_width = 150;
   $thumb_height = 150;
   
   //use true colour for image
   $dimg = imagecreatetruecolor($thumb_width, $thumb_height);
   $wm = $width/$thumb_width; //width divided by new width
   $hm = $height/$thumb_height; //height divided by new height
   $h_height = $thumb_height/2; //ass new height and chop in half
   $w_height = $thumb_width/2; //ass new height and chop in half
   
   //if original width is more then original height then modify by width
   if($w> $h) {
      $adjusted_width = $w / $hm; // add original width and divide it by modified height and add to var
      $half_width = $adjusted_width / 2; // chop width in half
      $int_width = $half_width - $w_height; // take away modified height from new width
      //make a copy of the image
      imagecopyresampled($dimg,$simg,-$int_width,0,0,0,$adjusted_width,$thumb_height,$w,$h);
      
      //else if original width is less or equal to original height then modify by height
      
   } elseif(($w <$h) || ($w == $h)) {
      $adjusted_height = $h / $wm; // diving original height by modified  width
      $half_height = $adjusted_height / 2; // chop height in half
      $int_height = $half_height - $h_height; // take away modified height from new width
      //make a copy of the image
      imagecopyresampled($dimg,$simg,0,-$int_height,0,0,$thumb_width,$adjusted_height,$w,$h);
   } else { // don't modify image and make a copy
      imagecopyresampled($dimg,$simg,0,0,0,0,$thumb_width,$thumb_height,$w,$h);
   }
      
   $ran = "thumb_".rand (); // generate random number and add to a string   
   $thumb2 = $ran.".jpg"; //add random string to a var and append .jpg on the end
   
   global $thumb_Add_thumb; //make this var available outside the function as it will be needed later.
   $thumb_Add_thumb = $dst_filename_thumb; // add destination
   $thumb_Add_thumb .= $thumb2; // append file name on the end
      
   //actually create the final image
    imagejpeg($dimg, "" .$dst_filename_thumb. "$thumb2");    
}

/********end functions ***********/

// if form submitted then process form
if (isset($_POST['submit'])){

// check feilds are not empty
$imageTitle = trim($_POST['imageTitle']);
if (strlen($imageTitle) < 3 || strlen($imageTitle) > 255) {
$error[] = 'Title must be at between 3 and 255 charactors.';
}

// check feilds are not empty or check image file size
if (!isset($_FILES["uploaded"])) {
$error[] = 'You forgot to select an image.';
}

// check feilds are not empty
$imageDesc = trim($_POST['imageDesc']);
if (strlen($imageDesc) < 3) {
$error[] = 'Please enter a description for your image.';
}

// location where inital upload will be moved to
$target = "productimages/" . $_FILES['uploaded']['name'] ;


// find the type of image
switch ($_FILES["uploaded"]["type"]) {
case $_FILES["uploaded"]["type"] == "image/gif":
move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/jpeg":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/pjpeg":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/png":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;
case $_FILES["uploaded"]["type"] == "image/x-png":
    move_uploaded_file($_FILES["uploaded"]["tmp_name"],$target);
    break;

default:
    $error[] = 'Wrong image type selected. Only JPG, PNG or GIF accepted!.';
}

// if valadation is okay then carry on
if (!$error) {

// post form data 
   $imageTitle     = $_POST['imageTitle'];
   $imageDesc     = $_POST['imageDesc'];
   
   //strip any tags from input
   $imageTitle   = strip_tags($imageTitle);
   $imageDesc   = strip_tags($imageDesc);
   
   
   // add slashes if needed
   if(!get_magic_quotes_gpc())
{ 
$imageTitle   = addslashes($imageTitle);
$imageDesc   = addslashes($imageDesc);
 }
   
   // remove any harhful code and stop sql injection
   $imageTitle = mysql_real_escape_string($imageTitle); 
   $imageDesc = mysql_real_escape_string($imageDesc); 
   
  
//add target location to varible $src_filename 
$src_filename = $target;
// define file locations for full sized and thumbnail images
$dst_filename_full = 'productimages/';
$dst_filename_thumb = 'productthumb/';

// create the images
createthumbfull($src_filename, $dst_filename_full); //call function to create full sized image
createthumb($src_filename, $dst_filename_thumb); //call function to create thumbnail image
// delete original image as its not needed any more.
unlink ($src_filename);


// insert data into images table
$query = "INSERT INTO table (imageTitle, imageThumb, imageFull, imageDesc) VALUES
  ('$imageTitle', '$thumb_Add_thumb', '$thumb_Add_full', '$imageDesc')";
  $result  = mysql_query($query) or die ('Cannot add image because: '. mysql_error());
 
// show a message to confirm results
echo "<h3 align='center'> $imageTitle uploaded</h3>";
 
}
}


//dispaly any errors
errors($error);
?>

<form enctype="multipart/form-data" action="" method="post">
<fieldset>
<legend>Upload Picture</legend>
<p>Only JPEG, GIF, or PNG images accepted</p>
<p><label>Title<br /></label><input type="text" name="imageTitle" <?php if (isset($error)){ echo "value=\"$imageTitle\""; }?> /></p>

<p><label>Image<br /></label><input type="file" name="uploaded" /></p>

<p><label>Description<br /></label><textarea name="imageDesc" cols="50" rows="10"><?php if (isset($error)){ echo "$imageDesc"; }?></textarea></p>

<p><label>&nbsp;</label><input type="submit" name="submit" value="Add Image" /></p>

</fieldset>
</form>

view data
Code: [Select]

<?php 
 
 // Connects to your Database 
 mysql_connect("localhost", "user", "pass") or die(mysql_error()) ; 
 mysql_select_db("DB") or die(mysql_error()) ; 
 
 //Retrieves data from MySQL 
 $data = mysql_query("SELECT * FROM table") or die(mysql_error());  //Puts it into an array 
 while($info = mysql_fetch_array( $data )) 
 { 
 ?>
 
<?php echo "<img src=http://www.web.com/productimages/" .$info['imagefull'] ." > <br>"; ?>
<?php echo "<img src=http://www.web.com/productthumb/" .$info['imageThumb'] ." > <br>"; ?>


<?php echo "<b>imageTitle:</b> ".$info['imageTitle'] . "<br> "; ?>
<?php echo "<b>imageDesc:</b> ".$info['imageDesc'] . " <hr>"; ?>
 
<?php  }?>