[SOLVED] Uploading

[simonb]

How would i get it so a user could use the form to upload a image to dir: images. Using the same for to add it to the DB

<form method="post" name="form2" action="<?php echo $editFormAction; ?>">
<table align="center">
<tr valign="baseline">
<td nowrap align="right">Name:</td>
<td><input type="text" name="Name" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">Dis:</td>
<td><input type="text" name="Dis" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">By:</td>
<td><input type="text" name="By" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">ImageURL:</td>
<td><input type="text" name="ImageURL" value="" size="32"></td>
</tr>
<tr valign="baseline">
<td nowrap align="right">&nbsp;</td>
<td><input type="submit" value="Insert record"></td>
</tr>
</table>
<input type="hidden" name="MM_insert" value="form2">
</form>

PHP: Select all

<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  $theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $theValue;

  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}

$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
  $insertSQL = sprintf("INSERT INTO images (Name, Dis, `By`, ImageURL) VALUES (%s, %s, %s, %s)",
                       GetSQLValueString($_POST['Name'], "text"),
                       GetSQLValueString($_POST['Dis'], "text"),
                       GetSQLValueString($_POST['By'], "text"),
                       GetSQLValueString($_POST['ImageURL'], "text"));

  mysql_select_db($database_localhost, $localhost);
  $Result1 = mysql_query($insertSQL, $localhost) or die(mysql_error());

  $insertGoTo = "/admin/image.php";
  if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_localhost, $localhost);
$query_Recordset1 = "SELECT ImageID, ImageURL, `By` FROM images";
$Recordset1 = mysql_query($query_Recordset1, $localhost) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
?>

[c010depunkk]

Here's the code for a simple upload script:

Code: Select all

<form name="upload_form" action="<?php echo($link_prefix); ?>fileshare/upload/" method="post" enctype="multipart/form-data">
     <input type="hidden" name="MAX_FILE_SIZE" value="100000000" />
     <p><input type="file" name="uploadfile" /></p>
     <p><input type="submit" action="submit" value="upload" /></p>
</form>

PHP: Select all

if(isset($_FILES['uploadfile'])) { // check for submitted file
            $message='';
            switch($_FILES['uploadfile']['error']) {
                case UPLOAD_ERR_OK:
                    if(move_uploaded_file($_FILES['uploadfile']['tmp_name'],$real_path.$_FILES['uploadfile']['name'])) {
                        $message.='Upload successful.';
                    } else {
                        $message.='Upload failed.';
                    }
                    break;
                case UPLOAD_ERR_INI_SIZE:
                case UPLOAD_ERR_FORM_SIZE:
                    // file too large
                    $message.='File is too large.';
                    break;
                default:
                    // file upload failed
                    $message.='Upload failed.';
                    break;
            }
        } 

[simonb]

I don't think i explain it well. My site users will upload images ( cartoons). I would like the php to upload to the image dir. AND add to the DB the record set is in the first post.

[c010depunkk]

Yeah, you'll have to combine the two scripts and that should be exactly what you want!

[simonb]

Ok right thanks.

How do you do that. lol.

[simonb]

Originally Posted by saltedm8

<?php include 'yourfile.php';?>

how does that help me.

[AdRock]

How do you reference to the image that has been uploaded in the database......do you insert the filename in the database and reference to that filename.

I have a script where I upload a file and I insert the filename in the database

[simonb]

insert the filename in the database and reference to that filename.


Yeah thats what i am looking for.
If i could have a copy.

[AdRock]

This is how I upload an image but this script resizes it to a thumbnail but you don't have to do that or you can just change the image dimensions in $twidth and $theight

Where I have <select name="gallery"> this is where I choose which gallery I want to upload to (even though it all uploads to same directory) so you can have different types/users.

If you need anymore help just let me know

PHP: Select all

<?php 
$idir = "../images/gallery/full/";   // Path To Images Directory 
$tdir = "../images/gallery/thumbs/";   // Path To Thumbnails Directory 
$twidth = "100";   // Maximum Width For Thumbnail Images 
$theight = "75";   // Maximum Height For Thumbnail Images 
$pic=($_FILES['imagefile']['name']);
$gallery = $_POST['gallery'];
if (!isset($_POST['gallery'])) {
?> 
<fieldset>
    <legend><b>Image Gallery Upload</b></legend>
 <form enctype="multipart/form-data" action="<? $_SERVER['PHP_SELF']; ?>" method="post">  
     <p style="margin-left:10px;">Gallery to upload to:<br />
     <select name="gallery" size="1">
      <option value="jack">Jack</option> 
      <option value="honeylands">Honeylands</option> 
      <option value="events">Events</option> 
      <option value="art">Art Auction</option> 
     </select>
         <p style="margin-left:10px;">Image to upload:<br />
         <input type="file" name="imagefile" style="width:450px" /><br /> 
         <P><input type="submit" name="submit" value="Upload Image" class="submit-button" style="margin-left:10px;" /></p>
     </form>
</fieldset><br /> 
<?}
else {   // Uploading/Resizing Script 
    $url = $_FILES['imagefile']['name'];   // Set $url To Equal The Filename For Later Use 
    if ($_FILES['imagefile']['type'] == "image/jpg" || $_FILES['imagefile']['type'] == "image/jpeg" || $_FILES['imagefile']['type'] == "image/pjpeg") { 
        $file_ext = strrchr($_FILES['imagefile']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
        $copy = copy($_FILES['imagefile']['tmp_name'], "$idir" . $_FILES['imagefile']['name']);   // Move Image From Temporary Location To Permanent Location 
            if ($copy) {   // If The Script Was Able To Copy The Image To It's Permanent Location 
         print 'Image uploaded successfully.<br />';   // Was Able To Successfully Upload Image 
     
    //insert the image names into the database
    include_once "../includes/connection.php";
    $query = "INSERT INTO image VALUES ('','$pic','$pic','$gallery')";
    mysql_query($query);
    mysql_close();
    $simg = imagecreatefromjpeg("$idir" . $url);   // Make A New Temporary Image To Create The Thumbanil From 
    $currwidth = imagesx($simg);   // Current Image Width 
    $currheight = imagesy($simg);   // Current Image Height 
    if ($currheight > $currwidth) {   // If Height Is Greater Than Width 
        $zoom = $twidth / $currheight;   // Length Ratio For Width 
        $newheight = $theight;   // Height Is Equal To Max Height 
        $newwidth = $currwidth * $zoom;   // Creates The New Width 
    } else {    // Otherwise, Assume Width Is Greater Than Height (Will Produce Same Result If Width Is Equal To Height) 
        $zoom = $twidth / $currwidth;   // Length Ratio For Height 
        $newwidth = $twidth;   // Width Is Equal To Max Width 
        $newheight = $currheight * $zoom;   // Creates The New Height 
    } 
    $dimg = imagecreate($newwidth, $newheight);   // Make New Image For Thumbnail 
    imagetruecolortopalette($simg, false, 256);   // Create New Color Pallete 
    $palsize = ImageColorsTotal($simg); 
    for ($i = 0; $i < $palsize; $i++) {   // Counting Colors In The Image 
        $colors = ImageColorsForIndex($simg, $i);   // Number Of Colors Used 
        ImageColorAllocate($dimg, $colors['red'], $colors['green'], $colors['blue']);   // Tell The Server What Colors This Image Will Use 
    } 
    imagecopyresized($dimg, $simg, 0, 0, 0, 0, $newwidth, $newheight, $currwidth, $currheight);   // Copy Resized Image To The New Image (So We Can Save It) 
    imagejpeg($dimg, "$tdir" . $url);   // Saving The Image 
    imagedestroy($simg);   // Destroying The Temporary Image 
    imagedestroy($dimg);   // Destroying The Other Temporary Image 
    print 'Image thumbnail created successfully.';   // Resize successful 
    } else { 
        print '<font color="#FF0000">ERROR: Unable to upload image.</font>';   // Error Message If Upload Failed 
    } 
} 
?>

[simonb]

Parse error: syntax error, unexpected $end in D:\Program Files\wamp\www\admin\test.php on line 68

[AdRock]

Missing a curly brace. Count each oif the curly braces and see which one is missing.

I had to cut down the script by a chunk beucase I have the script creating a thumbnail and another size image

[simonb]

Were do i add one

[AdRock]

Try this and see if it does the same

PHP: Select all

<?php 
$idir = "../images/gallery/full/";   // Path To Images Directory 
$tdir = "../images/gallery/thumbs/";   // Path To Thumbnails Directory 
$twidth = "100";   // Maximum Width For Thumbnail Images 
$theight = "75";   // Maximum Height For Thumbnail Images 
$pic=($_FILES['imagefile']['name']);
$gallery = $_POST['gallery'];
if (!isset($_POST['gallery'])) {
?> 
<fieldset>
    <legend><b>Image Gallery Upload</b></legend>
 <form enctype="multipart/form-data" action="<? $_SERVER['PHP_SELF']; ?>" method="post">  
     <p style="margin-left:10px;">Gallery to upload to:<br />
     <select name="gallery" size="1">
      <option value="jack">Jack</option> 
      <option value="honeylands">Honeylands</option> 
      <option value="events">Events</option> 
      <option value="art">Art Auction</option> 
     </select>
         <p style="margin-left:10px;">Image to upload:<br />
         <input type="file" name="imagefile" style="width:450px" /><br /> 
         <P><input type="submit" name="submit" value="Upload Image" class="submit-button" style="margin-left:10px;" /></p>
     </form>
</fieldset><br /> 
<?}
else {   // Uploading/Resizing Script 
    $url = $_FILES['imagefile']['name'];   // Set $url To Equal The Filename For Later Use 
    if ($_FILES['imagefile']['type'] == "image/jpg" || $_FILES['imagefile']['type'] == "image/jpeg" || $_FILES['imagefile']['type'] == "image/pjpeg") { 
        $file_ext = strrchr($_FILES['imagefile']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
        $copy = copy($_FILES['imagefile']['tmp_name'], "$idir" . $_FILES['imagefile']['name']);   // Move Image From Temporary Location To Permanent Location 
            if ($copy) {   // If The Script Was Able To Copy The Image To It's Permanent Location 
         print 'Image uploaded successfully.<br />';   // Was Able To Successfully Upload Image 
     
    //insert the image names into the database
    include_once "../includes/connection.php";
    $query = "INSERT INTO image VALUES ('','$pic','$pic','$gallery')";
    mysql_query($query);
    mysql_close();
    
    $simg = imagecreatefromjpeg("$idir" . $url);   // Make A New Temporary Image To Create The Thumbanil From 
    $currwidth = imagesx($simg);   // Current Image Width 
    $currheight = imagesy($simg);   // Current Image Height 
    if ($currheight > $currwidth) {