Learn VBA & Macros in 1 Week!

PHP - How Do You Not Pass An Empty Value In A Multiple Upload Form

Full Excel VBA Course - Beginner to Expert

How Do You Not Pass An Empty Value In A Multiple Upload Form	View Content

Hello, this question was already answered on this form but the answer was deleted by admin a year or so ago. anyway, I have an edit items page with multiple images and I do not want to have to relocate all of the images manually but if I do not then an empty variable is passed to mysql, thus deleting my image. What do I need to know to write a code that will not pass an empty variable to my table? Do I use sprint?

Full Excel VBA Course - Beginner to Expert

Multiple Upload Form Help

Similar Tutorials

View Content

Hey guys.

I'm using this script to handle file (picture) uploads at the moment, and it works fine. Problem is though, I need to changeit to a multiple upload form (with 10 uploads per submit) and I dont know how to do it.

I think ...

I need to change this "<input type="file" name="image" >" to an array ... and put a "for each" loop or something somewhere ... but I really don't know what I am doing.

Can someone please help?

Thanks

Gem

<?php
include ("includes/dbconnect120-gem.php");
//define a maxim size for the uploaded images
define ("MAX_SIZE","500");
// define the width and height for the thumbnail
// note that theese dimmensions are considered the maximum dimmension and are not fixed,
// because we have to keep the image ratio intact or it will be deformed
define ("WIDTH","150");
define ("HEIGHT","100");

// this is the function that will create the thumbnail image from the uploaded image
// the resize will be done considering the width and height defined, but without deforming the image
function make_thumb($img_name,$filename,$new_w,$new_h)
{
//get image extension.
$ext=getExtension($img_name);
//creates the new image using the appropriate function from gd library
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
$src_img=imagecreatefromjpeg($img_name);

if(!strcmp("png",$ext))
$src_img=imagecreatefrompng($img_name);

//gets the dimmensions of the image
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);

// next we will calculate the new dimmensions for the thumbnail image
// the next steps will be taken:
// 1. calculate the ratio by dividing the old dimmensions with the new ones
// 2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable
// and the height will be calculated so the image ratio will not change
// 3. otherwise we will use the height ratio for the image
// as a result, only one of the dimmensions will be from the fixed ones
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1>$ratio2) {
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;
}
else {
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}

// we create a new image with the new dimmensions
$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);

// resize the big image to the new created one
imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y);

// output the created image to the file. Now we will have the thumbnail into the file named by $filename
if(!strcmp("png",$ext))
imagepng($dst_img,$filename);
else
imagejpeg($dst_img,$filename);

//destroys source and destination images.
imagedestroy($dst_img);
imagedestroy($src_img);
}

// This function reads the extension of the file.
// It is used to determine if the file is an image by checking the extension.
function getExtension($str) {
$i = strrpos($str,".");
if (!$i) { return ""; }
$l = strlen($str) - $i;
$ext = substr($str,$i+1,$l);
return $ext;
}

// This variable is used as a flag. The value is initialized with 0 (meaning no error found)
//and it will be changed to 1 if an errro occures. If the error occures the file will not be uploaded.
$errors=0;
if(isset($_POST['submit1']) && !$errors)
{
$sqlalbum="INSERT INTO album (album_name) VALUES ('$_POST[newalbumname]')";
mysql_query($sqlalbum) or die ('Error, album_query failed : ' . mysql_error());
}

// checks if the form has been submitted
if(isset($_POST['Submit']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
// if it is not empty
if ($image)
{
// get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);

// get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
// if it is not a known extension, we will suppose it is an error, print an error message
//and will not upload the file, otherwise we continue
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png"))
{
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
else
{
// get the size of the image in bytes
// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which the uploaded file was stored on the server
$size=getimagesize($_FILES['image']['tmp_name']);
$sizekb=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($sizekb > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="uploads/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
//we verify if the image has been uploaded, and print error instead
if (!$copied)
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
// the new thumbnail image will be placed in images/thumbs/ folder
$thumb_name='uploads/thumbs/thumb_'.$image_name;
// call the function that will create the thumbnail. The function will get as parameters
//the image name, the thumbnail name and the width and height desired for the thumbnail
$thumb=make_thumb($newname,$thumb_name,WIDTH,HEIGHT);
}} }}

//If no errors registred, print the success message and show the thumbnail image created
if(isset($_POST['Submit']) && !$errors)
{
$album = $_POST['album'];
$query = "INSERT INTO upload (name, path, album_id, thumbpath ) ".
"VALUES ('$image_name', '$newname' , '$album', '$thumb_name')";

mysql_query($query) or die('Error, query failed : ' . mysql_error());

echo "<h1>Thumbnail created Successfully!</h1>";
echo '<img src="'.$thumb_name.'">';
}

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
</head>

<body>
<form name="newalbum" method="post" action="">
<input name="newalbumname" type="text" size="30" maxlength="30" value="<?php echo $newalbumname; ?>" />
<input type="submit" name="submit1" value="Create Album" />
</form>
<br />
<form name="newad" method="post" enctype="multipart/form-data" action="">
<table>
<tr><td><select name="album">
    <option value="select" selected="selected" >-Albums-</option>
  <?php
$asql="select * from album order by album_id DESC";
$aresult=mysql_query($asql) or die(mysql_error());;
while($arow=mysql_fetch_array($aresult)) {
$album_id=$arow['album_id'];
$album_name=$arow['album_name'];
?>
  <option value="<?php echo $album_id; ?>"><?php echo $album_name; ?></option>
  <?php } ?>
</select>
<tr><td><input type="file" name="image" ></td></tr>
<tr><td><input name="Submit" type="submit" value="Upload image"></td></tr>
</table>
</form>
</body>
</html>

Multiple Upload Form Not Uploading!

Similar Tutorials

View Content

Hi,

I have been trying to create a site where you can list multiple items with a picture for each but I can't get the upload form working. Here's what I've got:

<?php include "/home/a9653716/public_html/header.inc"; ?>
<body>
<table border="0" width="100%"><tr>
<td valign="top" width="800">

<?php
echo "<div id='content'>";
echo "<h2 div id='title'>";
echo "Create a listing";
echo "</h2>";

//////content//////////////////////////

if($_SESSION['uid']){


$id = mss($_POST['id']);
$no_w =($_POST['want']);
$no_o =($_POST['offer']);
$wantbtn = ($_POST['addwantbtn']);
$offerbtn = ($_POST['addofferbtn']);

if ($wantbtn)
echo "Want <br />";

$no_want = ($_POST['no_want']);
$no_offer = ($_POST['no_offer']);

if (!$no_w){
if ($no_want){
$no_w = $no_want;
}else
$no_w = 3;
}

if (!$no_o){
if ($no_offer){
$no_o = $no_offer;
}else
$no_o = 3;
}

if ($no_o > 20){
$no_o = 20;
}

if ($no_w > 20){
$no_w = 20;
}

$offerid = 1;
$wantid = 1;

$addofferlimit = 20 - $no_o + 1;
$addwantlimit = 20 - $no_w + 1;

$addoffer = 1;
$addwant = 1;

$addmorewants = ($_POST['addmorewants']);
$addmoreoffers = ($_POST['addmoreoffers']);

if ($wantbtn){
$no_w = $addmorewants;
}

if ($offerbtn){
$no_o = $addmoreoffers;
}

if ($id) {
    $sql = "SELECT * FROM `item_sub_cats` WHERE `id`='" . $id . "'";
    $res = mysql_query($sql) or die(mysql_error());
    if (mysql_num_rows($res) == 0) {
        echo "The category you are trying to create a listing on, does not exist!\n";
    } else {
        $row1 = mysql_fetch_assoc($res);

            if (!$_POST['submit']) {
                echo "<table border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
                echo "<form method=\"post\" action=\"./create_listing.php\">\n";
                echo "<tr><td>Sub Category</td><td><select name=\"cat\">\n";
                $sql2 = "SELECT * FROM `item_cats`";
                $res2 = mysql_query($sql2);
                while ($row = mysql_fetch_assoc($res2)) {
                    $sql3 = "SELECT * FROM `item_sub_cats` WHERE `cid`='" . $row['id'] . "'";
                    $res3 = mysql_query($sql3) or die(mysql_error());

                    echo "<option value=\"0\">" . $row['name'] . "</option>\n";
                    while ($row2 = mysql_fetch_assoc($res3)) {
                        $selected = ($row2['id'] == $id) ? " SELECTED" : "";
                        echo "<option value=\"" . $row2['id'] . "\"" . $selected .
                            ">     " . $row2['name'] . "</option>\n";
                    }
                }
                echo "</select></td></tr>\n";
echo "<tr><td>Listing Title</td><td><input type=\"text\" name=\"title\" size=\"53\"></td></tr>\n";
?>
                <script>edToolbar('message'); </script>
<?php
echo "<tr><th colspan='2'><b>What you have to offer!</b><br /><br />Change to <select name='addmoreoffers'>";
echo "<option>1</option>";
echo "<option>2</option>";
echo "<option>3</option>";
echo "<option>4</option>";
echo "<option>5</option>";
echo "<option>6</option>";
echo "<option>7</option>";
echo "<option>8</option>";
echo "<option>9</option>";
echo "<option>10</option>";
echo "<option>11</option>";
echo "<option>12</option>";
echo "<option>13</option>";
echo "<option>14</option>";
echo "<option>15</option>";
echo "<option>16</option>";
echo "<option>17</option>";
echo "<option>18</option>";
echo "<option>19</option>";
echo "<option>20</option>";
echo "</select> item(s) <input type='submit' value='Go' name='addofferbtn'><br /></th></tr>";

//offer while loop//
while ($offerid <= $no_o){

echo "<tr><td>Item $offerid</td><td><input type='textbox' value='title' size='40' name='offer$offerid'> <input type='textbox' value='pts' size='7' name='offer" . $offerid . "pts'></td></tr>";
echo "<tr><td></td><th colspan='2'><textarea cols='37' rows='5' name='offer" . $offerid . "desc'></textarea></th></tr>";
echo "<tr><td></td><td><input type='file' size='27' name='offer" . $offerid . "img'></td></tr>";

$offerid ++;
}
//end offer while loop//

//want while loop//
echo "<tr><th colspan='2'><b>What you want!</b><br /><br />Change to <select>";

echo "<option>1</option>";
echo "<option>2</option>";
echo "<option>3</option>";
echo "<option>4</option>";
echo "<option>5</option>";
echo "<option>6</option>";
echo "<option>7</option>";
echo "<option>8</option>";
echo "<option>9</option>";
echo "<option>10</option>";
echo "<option>11</option>";
echo "<option>12</option>";
echo "<option>13</option>";
echo "<option>14</option>";
echo "<option>15</option>";
echo "<option>16</option>";
echo "<option>17</option>";
echo "<option>18</option>";
echo "<option>19</option>";
echo "<option>20</option>";

echo "</select> item(s) <input type='submit' value='Go' name='addwantbtn'><br /></th></tr>";

while ($wantid <= $no_w){

echo "<tr><td>Item $wantid</td><td><input type='textbox' size='40' value='title' name='want" . $wantid . "title'> <input type='textbox' value='pts' size='7' name='want" . $wantid . "pts'></td></tr>";
echo "<tr><td></td><th colspan='2'><textarea cols='37' rows='5' name='want" . $wantid . "desc'></textarea></th></tr>";
echo "<tr><td></td><td><input type='file' size='27' name='want" . $wantid . "img'></td></tr>";

$wantid ++;
}
//end want while loop//

echo "<tr><td>Other Details</td><th colspan='2'><textarea cols='50' rows='10' id=\"message\" name=\"message\"></textarea></th></tr>\n";
echo "<tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Create Listing\"></td></tr>\n";
                echo "</form></table>\n";
            } else {
                $cat = mss($_POST['cat']);
                $title = mss($_POST['title']);
                $details = mss($_POST['message']);

                if ($cat && $title && $details) {
                    $sql = "SELECT * FROM `item_sub_cats` WHERE `id`='" . $cat . "'";
                    $res = mysql_query($sql) or die(mysql_error());
                    if (mysql_num_rows($res) == 0) {
                        echo "This sub category does not exist!\n";
                    } else {
                        $row = mysql_fetch_assoc($res);

                            if (strlen($title) < 3 || strlen($title) > 32) {
                                echo "The title must be between 3 and 32 characters!\n";
                            } else {
                                if (strlen($details) < 3 || strlen($details) > 10000) {
                                    echo "The message must be between 3 and 10,000 characters!\n";
} else {
                                    $date = date("m-d-y") . " at " . date("h:i:s");
                                    $time = time();
                                    $sql2 = "INSERT INTO `listing_topics` (`cid`,`title`,`uid`,`date`,`time`,`message`,) VALUES('" .
                                        $cat . "','" . $title . "','" . $_SESSION['uid'] . "','" . $date . "','" . $time .
                                        "','" . $details . "')";
                                    $res2 = mysql_query($sql2) or die(mysql_error());
                                    $tid = mysql_insert_id();
                                    topic_go($tid);
}
                            }
                    }
                } else {
            }
        }
}
} else {
    if (!$_POST['submit']) {
        echo "<table border=\"0\" cellspacing=\"3\" cellpadding=\"3\">\n";
        echo "<form method=\"post\" action=\"./create_listing.php\">\n";
        echo "<tr><td>Sub Category</td><td><select name=\"cat\">\n";
        $sql2 = "SELECT * FROM `item_cats`";
        $res2 = mysql_query($sql2) or die(mysql_error());
        while ($row = mysql_fetch_assoc($res2)) {
            $sql3 = "SELECT * FROM `item_sub_cats` WHERE `cid`='" . $row['id'] . "'";
            $res3 = mysql_query($sql3) or die(mysql_error());

            echo "<option value=\"0\">" . $row['name'] . "</option>\n";
            while ($row2 = mysql_fetch_assoc($res3)) {
                $selected = ($row2['id'] == $id) ? " SELECTED" : "";
                echo "<option value=\"" . $row2['id'] . "\"" . $selected .
                    ">     " . $row2['name'] . "</option>\n";
            }
        }
echo "</select></td></tr>\n";
echo "<tr><td>Listing Title</td><td><input type=\"text\" name=\"title\" size=\"53\"></td></tr>\n";
?>
                <script>edToolbar('message'); </script>
<?php
echo "<tr><th colspan='2'><b>What you have to offer!</b><br /><br />Change to <select name='addmoreoffers'>";
echo "<option>1</option>";
echo "<option>2</option>";
echo "<option>3</option>";
echo "<option>4</option>";
echo "<option>5</option>";
echo "<option>6</option>";
echo "<option>7</option>";
echo "<option>8</option>";
echo "<option>9</option>";
echo "<option>10</option>";
echo "<option>11</option>";
echo "<option>12</option>";
echo "<option>13</option>";
echo "<option>14</option>";
echo "<option>15</option>";
echo "<option>16</option>";
echo "<option>17</option>";
echo "<option>18</option>";
echo "<option>19</option>";
echo "<option>20</option>";
echo "</select> item(s) <input type='submit' value='Go' name='addofferbtn'><br /></th></tr>";

//offer while loop//

while ($offerid <= $no_o){

$offername = "offer" . "$offerid";

echo "<tr><td>Item $offerid</td><td><input type='textbox' value='title' size='40' name='$offername'> <input type='textbox' value='pts' size='7' name='offer" . $offerid . "pts'></td></tr>";
echo $offername;
echo "<tr><td></td><th colspan='2'><textarea cols='37' rows='5' name='offer" . $offerid . "desc'></textarea></th></tr>";
echo "<tr><td></td><td><input type='file' size='27' name='offer" . $offerid . "img'></td></tr>";
$offerid ++;
}
//end offer while loop//

//want while loop//
echo "<tr><th colspan='2'><b>What you want!</b><br /><br />Change to <select name='addmorewants'>";
echo "<option>1</option>";
echo "<option>2</option>";
echo "<option>3</option>";
echo "<option>4</option>";
echo "<option>5</option>";
echo "<option>6</option>";
echo "<option>7</option>";
echo "<option>8</option>";
echo "<option>9</option>";
echo "<option>10</option>";
echo "<option>11</option>";
echo "<option>12</option>";
echo "<option>13</option>";
echo "<option>14</option>";
echo "<option>15</option>";
echo "<option>16</option>";
echo "<option>17</option>";
echo "<option>18</option>";
echo "<option>19</option>";
echo "<option>20</option>";
echo "</select> item(s) <input type='submit' value='Go' name='addwantbtn'><br /></th></tr>";

while ($wantid <= $no_w){

$wantname = "want" . "$wantid";

echo "<tr><td>Item $wantid</td><td><input type='textbox' size='40' value='title' name='$wantname'> <input type='textbox' value='pts' size='7' name='want" . $wantid . "pts'></td></tr>";
echo "<tr><td></td><th colspan='2'><textarea cols='37' rows='5' name='want" . $wantid . "desc'></textarea></th></tr>";
echo "<tr><td></td><td><input type='file' size='27' name='want" . $wantid . "img'></td></tr>";

$wantid ++;
}
//end want while loop//
echo "<tr><td>Other Details</td><th colspan='2'><textarea cols='50' rows='10' id=\"message\" name=\"message\"></textarea></th></tr>\n";
echo "<tr><td colspan=\"2\" align=\"right\"><input type=\"submit\" name=\"submit\" value=\"Create Listing\"></td></tr>\n";

echo "<input type='hidden' name='no_offer' value='$no_o'>";
echo "<input type='hidden' name='no_want' value='$no_w'>";

echo "</form></table>\n";
    } else {
$cat = mss($_POST['cat']);
        $title = mss($_POST['title']);
        $details = mss($_POST['message']);
$o_title_count = 1;
$filled_o = 1;
$offer_no_values=1;
$w_title_count = 1;
$filled_w = 1;
$want_no_values=1;

while ($filled_o && $filled_o != "title"){
$o_title_count = "offer" . "$offer_no_values";

$filled_o = ($_POST["$o_title_count"]);
$offer_no_values++;
}
$offer_no_values=$offer_no_values-2;
echo "Number of offer titles:" . $offer_no_values . "<br />";

while ($filled_w && $filled_w != "title"){
$w_title_count = "want" . "$want_no_values";

$filled_w = ($_POST["$w_title_count"]);
$want_no_values++;
}
$want_no_values=$want_no_values-2;
echo "number of want titles:" . $want_no_values . "<br />";

echo "cat: " . $cat . "<br />";
echo "title: " . $title . "<br />";
echo "message: " . $details . "<br />";
echo "want_no_values: " . $want_no_values . "<br />";
echo "offer_no_values: " . $offer_no_values . "<br />";

if ($cat && $title && ($want_no_values >= 1) && ($offer_no_values >= 1)) {

//////////////////////////////////////////////////////
////////////////////want construct////////////////////
//////////////////////////////////////////////////////

$x=1;

while ($x <= $want_no_values){

$w_points = "want" . $x . "pts";
$w_desc = "want" . $x . "desc";
$w_image = "want" . $x . "img";

if ($w_image){

$w_img_name = $_FILES['want1img']['name'];
$w_img_type = $_FILES['$w_image']['type'];
$w_img_size = $_FILES['$w_image']['size'];
$w_img_tmpname = $_FILES['$w_image']['tmp_name'];
$w_img_ext = substr($w_img_name, strpos($w_img_name, '.'));

echo "w name:" . $w_img_name . "<br />";

print_r ($_FILES['want1img']);
}

if ($w_img_name){
move_uploaded_file($w_img_tmpname, "images/listings/$username" . "-" . "$w_img_name" . "-" . "$w_img_size" . "$ext") or die(mysql_error());
$w_image = "$username" . "-" . "$w_img_name" . "-" . "$w_img_size" . "$ext";
}

echo $w_points;

$w_item_name = ($_POST["want$x"]);
$w_item_pts = ($_POST["$w_points"]);
$w_item_desc = ($_POST["$w_desc"]);

$want_item  = "<tr><td width='25'></td><th colspan='3'><b>" . $w_item_name . "</b> - " . $w_item_pts . "pts</th></tr>
<tr><td width='25'></td><td width='25'></td><th colspan='2'>" .
$w_item_desc . $w_image .
"</th></tr>";

$want_items = $want_items . $want_item;

$x++;
}

$want_desc = "<table>
<tr><th colspan='3'><h3>What I want!</h3></th></tr>"
. $want_items .
"</table>";

//////////////////////////////////////////////////////
////////////////////offer construct///////////////////
//////////////////////////////////////////////////////

$x=1;

while ($x <= $offer_no_values){

$o_points = "offer" . $x . "pts";
$o_desc = "offer" . $x . "desc";

echo $w_points;

$o_item_name = ($_POST["offer$x"]);
$o_item_pts = ($_POST["$o_points"]);
$o_item_desc = ($_POST["$o_desc"]);

$offer_item  = "<tr><td width='25'></td><th colspan='3'><b>" . $o_item_name . "</b> - " . $o_item_pts . "pts</th></tr>
<tr><td width='25'></td><td width='25'></td><th colspan='2'>" .
$o_item_desc .
"</th></tr>";

$offer_items = $offer_items . $offer_item;

$x++;
}

$offer_desc = "<table>
<tr><th colspan='3'><h3>What I offer!</h3></th></tr>"
. $offer_items .
"</table>";

$desc=$want_desc . $offer_desc;
echo $desc;

} else {
echo "Please supply all the fields!\n";
}
}
}
}
else
echo "You must be logged in to see this page!";
?>
</td><td width="250">

<?php include("sidebar.inc"); ?>

</td>
</table>
  </body>

</html>

<?php include("footer.inc"); ?>

I know it's very messy, I'll probably end up rewriting it but this is what I get after supplying the right fields and uploading an image for the want section:

Code: [Select]
Number of offer titles:1
number of want titles:1
cat: 1
title: This is the title
message: None still testing it!
want_no_values: 1
offer_no_values: 1
w img name:
want1ptswant1pts
The only bit that is of any use is the name section:

Code: [Select]
w img name:
Nothing is recieved and the file is not uploaded!! I probably have missed something out but I am very new to php so please help!!

Thanks
Cameron

Multiple Image Upload And Resize Form

Similar Tutorials

View Content

I am VERY new to PHP, but I am trying to adapt code from http://www.4wordsystems.com/php_image_resize.php to work with multiple images. Can any please help?

I know I need to place it in a loop of some kind, but I don't know how to write the code for that. Here is the code:

HTML FORM CODE:
Code: [Select]
<form action="upload.php" method="post" enctype="multipart/form-data" >
<input type="file" name="uploadfile"/>
<input type="submit"/>
</form>
upload.php CODE:
Code: [Select]
<?php

// This is the temporary file created by PHP
$uploadedfile = $_FILES['uploadfile']['tmp_name'];

// Create an Image from it so we can do the resize
$src = imagecreatefromjpeg($uploadedfile);

// Capture the original size of the uploaded image
list($width,$height)=getimagesize($uploadedfile);

// For our purposes, I have resized the image to be
// 600 pixels wide, and maintain the original aspect
// ratio. This prevents the image from being "stretched"
// or "squashed". If you prefer some max width other than
// 600, simply change the $newwidth variable
$newwidth=600;
$newheight=($height/$width)*600;
$tmp=imagecreatetruecolor($newwidth,$newheight);

// this line actually does the image resizing, copying from the original
// image into the $tmp image
imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);

// now write the resized image to disk. I have assumed that you want the
// resized, uploaded image file to reside in the ./images subdirectory.
$filename = "images/". $_FILES['uploadfile']['name'];
imagejpeg($tmp,$filename,100);

// For our purposes, I have resized the image to be
// 150 pixels high, and maintain the original aspect
// ratio. This prevents the image from being "stretched"
// or "squashed". If you prefer some max height other than
// 150, simply change the $newheight variable
$newheight=150;
$newwidth=($width/$height)*150;
$tmp=imagecreatetruecolor($newwidth,$newheight);

// this line actually does the image resizing, copying from the original
// image into the $tmp image
imagecopyresampled($tmp,$src,0,0,0,0,$newwidth,$newheight,$width,$height);

// now write the resized image to disk. I have assumed that you want the
// resized, uploaded image file to reside in the ./images subdirectory.
$filename = "images/thumb_". $_FILES['uploadfile']['name'];
imagejpeg($tmp,$filename,100);

imagedestroy($src);
imagedestroy($tmp); // NOTE: PHP will clean up the temp file it created when the request
// has completed.

echo "Successfully Uploaded: <img src='".$filename."'>";

?>

Php Dropzone Image Upload With Multiple Form Inputs

Similar Tutorials

View Content

Hello,

I'm developing one website for a real-estate agency. I have a html form that is used to submit property details, There is multiple form inputs and also I need to upload multiple property images using Dropzone JS multiple image upload.

Here I'm validating form inputs using jQuery Validation library. Validation works perfect and data Is being to posted to php file called submit_property_data.php. But when I implement the Dropzone JS image upload its not working.

JS File (property-submit.js)

$('document').ready(function() {
  $("#notification-property").hide();

  /* handling form validation */
  $("#property-form").validate({
    rules: {
      prop_title: "required",
      prop_price: {
        required: true,
        digits: true
        },
      prop_area: {
        required: true,
        digits: true
      },
      prop_address: "required",
      prop_message: {
        required: true,
        minlength: 10,
        maxlength: 2000
      },
      prop_owner_name: "required",
      prop_owner_email: {
        required: true,
        email: true
      },
      prop_owner_phone: {
        required: true,
        digits: true
      },
    },
    messages: {
      'prop_title': {
        required: "Please enter title for your property"
      },
      prop_price: {
        required: "Please enter price of your property",
        digits: "Please enter price in digits (AED)"
      },
      prop_area: "Please enter Sqft of your property",
      prop_address: "Please enter address of your property",
      prop_message: {
        required: "Please enter detailed Information",
        minlength: "Please enter something about your property in 50 - 20000 characters",
        maxlength: "Please enter something about your property in 50 - 20000 characters"
      },

			prop_owner_name: "Please enter your name",
			prop_owner_email: {
				required: "Please enter your email address",
				email: "Please enter valid email address"

			},
			prop_owner_phone: {
				required: "Please enter your phone number",
				digits: "Please enter valid phone number"

			},
    },
    submitHandler: submitPropertyForm
  });

  /* Handling login functionality */
  function submitPropertyForm() {
    var data = $("#property-form").serialize();
    $.ajax({
      type: 'POST',
      url: 'submit_property_data.php',
      data: data,
      beforeSend: function() {
        $("#submit-button").html('<span class="glyphicon glyphicon-transfer"></span> &nbsp; Submiting ...');
      },
      success: function(response) {
        if (response == "ok") {
          console.log(1);
          document.getElementById("property-form").reset();
          $("#notification-property").html('<b> ' + response + ' !</b>').show();
          //setTimeout(' window.location.href = "dashboard.php"; ',4000);
        } else {
          $("#notification-property").fadeIn(1000, function() {
            $("#notification-property").html('<b>' + response + ' !</b>').fadeOut();
            $("#submit-button").html('&nbsp; Send');
          });
        }
      },
			complete:function(){
											 $('body, html').animate({scrollTop:$('form').offset().top}, 'slow');
									 }
    });
    return false;
  }

    $("#submit-button").bind('click', function() {
	  if ( $("#property-form").valid() ) {
		  submitPropertyForm();
	  } else {
		  console.log('form invalid');
	  }
  })


		Dropzone.autoDiscover = false;
		$(function () {
				$("div#myDropzone").dropzone({

						url: 'submit_property_data.php',
						addRemoveLinks: true,
						maxFiles:11,
						uploadMultiple: true,
						autoProcessQueue: false,
						parallelUploads: 10,

						init: function () {

								var myDropzone = this;

								// Update selector to match your button
								$("#submit-button").click(function (e) {
										e.preventDefault();
										myDropzone.processQueue();
								});


								this.on('sending', function(file, xhr, formData) {
										// Append all form inputs to the formData Dropzone will POST
										var data = $('#property-form').serializeArray();
										$.each(data, function(key, el) {
												formData.append(el.name, el.value);
										});
								});

									this.on("success", function(file, responseText) {
											alert(responseText);
									});

							},


				});
		});


});

HTML File (submit-property.php)

<html>
<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.6.1/jquery.min.js"></script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.validate/1.11.1/jquery.validate.min.js"></script>

!-- Submit Property start -->
<div class="content-area-7 submit-property">
    <div class="container">
        <div class="row">
            <div class="col-md-12">

          <!--      <div id="error_message" class="notification-box"></div> -->





            </div>
            <div id="notification-property" class="notification-box">sd</div>

            <div class="col-md-12">
                <div class="submit-address">
                    <form name = "property-form" method="post" id="property-form">
                        <div class="main-title-2">
                            <h1><span>Tell Me</span> Something About Your Property</h1>
                        </div>
                        <div class="search-contents-sidebar mb-30">
                            <div class="form-group">
                                <label>Property Title</label>

                                <input class="input-text" name="prop_title" id="prop_title" placeholder="Property Title">

                            </div>

                            <div class="row">
                                <div class="col-md-6 col-sm-6">
                                    <div class="form-group">
                                        <label>Status</label>
                                        <select class="selectpicker search-fields" id="prop_status" name="prop_status">
                                            <option value="Sale">For Sale</option>
                                            <option value="Rent">For Rent</option>
                                        </select>
                                    </div>
                                </div>
                                <div class="col-md-6 col-sm-6">
                                    <div class="form-group">
                                        <label>Type</label>
                                        <select class="selectpicker search-fields" id="prop_title" name="prop_type">
                                            <option value="Modern">Modern</option>
                                            <option value="Traditional">Traditional</option>
                                            <option value="Arabic">Arabic</option>

                                        </select>

                                    </div>
                                </div>
                            </div>
                            <div class="row">
                                <div class="col-md-3 col-sm-6">
                                    <div class="form-group">
                                        <label>Price (Dirham)</label>
                                        <input class="input-text" name="prop_price" id="prop_price" placeholder="AED">

                                    </div>
                                </div>
                                <div class="col-md-3 col-sm-6">
                                    <div class="form-group">
                                        <label>Sqft</label>
                                        <input class="input-text" name="prop_area" id="prop_area" placeholder="SqFt">

                                    </div>
                                </div>
                                <div class="col-md-3 col-sm-6">
                                    <div class="form-group">
                                        <label>Bed Rooms</label>
                                        <select class="selectpicker search-fields" name="prop_rooms" id="prop_rooms">

                                            <option value="3">3</option>
                                            <option value="4">4</option>
                                            <option value="5">5</option>

                                        </select>

                                    </div>
                                </div>
                                <!-- <div class="col-md-3 col-sm-6">
                                    <div class="form-group">
                                        <label>Bathroom</label>
                                        <select class="selectpicker search-fields" name="1">
                                            <option>1</option>
                                            <option>2</option>
                                            <option>3</option>
                                            <option>4</option>
                                            <option>5</option>
                                            <option>6</option>
                                        </select>
                                    </div>
                                </div> -->
                            </div>
                        </div>


                        <div class="main-title-2">
                            <h1><span>Location</span></h1>
                        </div>
                        <div class="row mb-30 ">
                            <div class="col-md-6 col-sm-6">
                                <div class="form-group">
                                    <label>Address</label>
                                    <input class="input-text" id="prop_address" name="prop_address"  placeholder="Address">
                                </div>

                            </div>



                        </div>

                        <div class="main-title-2">
                        <h1><span>Upload</span> Photos Of Villa </h1>
                        </div>

                        <div id="myDropzone" class="dropzone dropzone-design mb-10">
                          <div class="dz-default dz-message" data=""><span>Drop files here to upload</span></div>
                                                </div>

                        <div class="main-title-2">
                            <h1><span>Detailed</span> Information</h1>
                        </div>



                        <div class="row mb-30">
                            <div class="col-md-12">
                                <div class="form-group">
                                    <textarea class="input-text" id="prop_message" name="prop_message" placeholder="Detailed Information"></textarea>
                                </div>
                            </div>
                        </div>
                        <!--<div class="row mb-30">
                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label>Building Age <span>(optional)</span></label>
                                    <select class="selectpicker search-fields" name="years">
                                        <option>0-1 Years</option>
                                        <option>0-5 Years</option>
                                        <option>0-10 Years</option>
                                        <option>0-20 Years</option>
                                        <option>0-40 Years</option>
                                        <option>40+Years</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label>Bedrooms (optional)</label>
                                    <select class="selectpicker search-fields" name="1">
                                        <option>1</option>
                                        <option>2</option>
                                        <option>3</option>
                                        <option>4</option>
                                        <option>5</option>
                                        <option>6</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label>Bathrooms (optional)</label>
                                    <select class="selectpicker search-fields" name="1">
                                        <option>1</option>
                                        <option>2</option>
                                        <option>3</option>
                                        <option>4</option>
                                        <option>5</option>
                                        <option>6</option>
                                    </select>
                                </div>
                            </div>

                            <div class="col-lg-12">
                                <label class="margin-t-10">Features (optional)</label>
                                <div class="row">
                                    <div class="col-lg-4 col-sm-4 col-xs-12">
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="opt_parking" name="opt_parking" value="1" type="checkbox">
                                            <label for="checkbox1">
                                                Free Parking
                                            </label>
                                        </div>
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="opt_air_condition" name="opt_air_condition" value="1" type="checkbox">
                                            <label for="checkbox2">
                                                Air Condition
                                            </label>
                                        </div>
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="opt_seat" name="opt_seat" value="1" type="checkbox">
                                            <label for="checkbox3">
                                                Places to seat
                                            </label>
                                        </div>
                                    </div>
                                    <div class="col-lg-4 col-sm-4 col-xs-12">
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="opt_swimming" name="opt_swimming" value="1" type="checkbox">
                                            <label for="checkbox4">
                                                Swimming Pool
                                            </label>
                                        </div>
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="opt_laundary" name="opt_laundary" value="1" type="checkbox">
                                            <label for="checkbox5">
                                                Laundry Room
                                            </label>
                                        </div>
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="opt_window_covering" name="opt_window_covering" value="1" type="checkbox">
                                            <label for="checkbox6">
                                                Window Covering
                                            </label>
                                        </div>
                                    </div>
                                    <div class="col-lg-4 col-sm-4 col-xs-12">
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="opt_parking" name="opt_parking" value="1" type="checkbox">
                                            <label for="checkbox7">
                                                Central Heating
                                            </label>
                                        </div>
                                        <div class="checkbox checkbox-theme checkbox-circle">
                                            <input id="checkbox8" type="checkbox">
                                            <label for="checkbox8">
                                                Alarm
                                            </label>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>-->
                        <div class="main-title-2">
                            <h1><span>Contact</span> Details</h1>
                        </div>
                        <div class="row">
                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label>Name</label>
                                    <input class="input-text" name="prop_owner_name" id="prop_owner_name" placeholder="Name">
                                </div>
                            </div>
                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label>Email</label>
                                    <input class="input-text" name="prop_owner_email" id="prop_owner_email" placeholder="Email">
                                </div>
                            </div>

                            <div class="col-md-4 col-sm-4">
                                <div class="form-group">
                                    <label>Contact No</label>
                                    <input class="input-text" name="prop_owner_phone" id="prop_owner_phone" placeholder="Phone">
                                </div>
                            </div>



                            </div>
                            <div class="col-md-12">
                                <button type="button" name="submit-button" id="submit-button">Submit</button>
                            </div>
                        </div>
                    </form>
                </div>
            </div>
        </div>
    </div>
</div>
<script src="property-submit.js"></script>
<script src="js/dropzone.js"></script>

</html>

PHP File (submit_property_data.php)

<?php
echo "ok";
require_once("functions.php");


$ds          = DIRECTORY_SEPARATOR;  //1
$storeFolder = 'villas-images';
$encpt_data = rand(1000,5000);

if (!empty($_FILES)) {

   $tempFile = $_FILES['file']['tmp_name'];          //3

   $targetPath = dirname( __FILE__ ) . $ds. $storeFolder . $ds;  //4

   $targetFile =  $targetPath.$_FILES['file']['name'];  //5

   if(move_uploaded_file($tempFile,$targetFile))
   {

     echo '<b>Success</b>';


   }
}
?>

What I actually need ?

I need to validate the form inputs first & upload the images once the form is valid also I need to post all the inputs to my php file called submit_property_data.php

Also I need the image inputs to store into my database.

Multiple Files Upload Form Records Duplicating

Similar Tutorials

View Content

I have a hopefully small issue on a form submitting data to the mysql database table and email. The email side works fine as does the adding the data to the database table but if I upload two files, it stores the support ticket twice in the database table where as I want to store just once and the files be stored as a array in the database table. I got the code from the link https://www.codexworld.com/upload-multiple-images-store-in-database-php-mysql/

The code I have is below

<?php

require_once "registerconfig.php";

if (isset($_POST['submit'])) {
		
		// File upload configuration 
    $targetDir = "support-ticket-images/"; 
    $allowTypes = array('pdf','doc','docx','jpg','png','jpeg','gif');
	
	$statusMsg = $errorMsg = $insertValuesSQL = $errorUpload = $errorUploadType = '';
	
	// Escape user inputs for security
$ticket_subject = htmlentities($_POST['ticket_subject'], ENT_QUOTES);
$ticket_message = strip_tags($_POST['ticket_message'], ENT_QUOTES);
$ticket_status ='PENDING SUPPORT'; 
$username = htmlentities($_SESSION["user_name"], ENT_QUOTES);
$user_id = htmlentities($_SESSION["user_id"], ENT_QUOTES);
	
	$fileNames = array_filter($_FILES['files']['name']);
	if(!empty($fileNames)){ 
        foreach($_FILES['files']['name'] as $key=>$val){ 
            // File upload path 
            $fileName = basename($_FILES['files']['name'][$key]); 
            $targetFilePath = $targetDir . $fileName; 
             
            // Check whether file type is valid 
            $fileType = pathinfo($targetFilePath, PATHINFO_EXTENSION); 
            if(in_array($fileType, $allowTypes)){ 
                // Upload file to server 
                if(move_uploaded_file($_FILES["files"]["tmp_name"][$key], $targetFilePath)){ 
                    // Image db insert sql 
                    $insertValuesSQL .= "('".$ticket_subject."','".$ticket_message."','".$fileName."','".$ticket_status."','".$username."', '".$user_id."'),";
                }else{ 
                    $errorUpload .= $_FILES['files']['name'][$key].' | '; 
                } 
            }else{ 
                $errorUploadType .= $_FILES['files']['name'][$key].' | '; 
            } 
        }

if(!empty($insertValuesSQL)){ 
            $insertValuesSQL = trim($insertValuesSQL, ','); 
            // Insert image file name into database 
            $insert = $link->query("INSERT INTO DB TABLE NAME (ticket_subject, ticket_message, file_name, ticket_status, user_name, user_id) VALUES $insertValuesSQL");
			
            if($insert){
				
				$to = "emailaddress";

    $subject = "A new support ticket has been submitted";
    $message = " <strong>$username</strong> has just created a support ticket, below is the support ticket
    <br /><br />
    <u>Support Ticket Details</u>
    <br /><br>
    <strong>Support Ticket Subject</strong>: $ticket_subject
    <br/><br><strong>Support Ticket Message</strong>: $ticket_message
    <p><strong><u>Support Ticket Files</u></strong>
    <br>
    <img src='$fileName'>
    ";
    // Always set content-type when sending HTML email
    $headers = "MIME-Version: 1.0" . "\r\n";
    $headers .= "Content-type:text/html;charset=iso-8859-1" . "\r\n";
    // More headers
    $headers .= 'From: <noreply@emailaddress>' . "\r\n";
    $mail=mail($to,$subject,$message,$headers);
				
                $errorUpload = !empty($errorUpload)?'Upload Error: '.trim($errorUpload, ' | '):''; 
                $errorUploadType = !empty($errorUploadType)?'File Type Error: '.trim($errorUploadType, ' | '):''; 
                $errorMsg = !empty($errorUpload)?'<br/>'.$errorUpload.'<br/>'.$errorUploadType:'<br/>'.$errorUploadType;
header("location: support-ticket-confirmation?user=$username");
            }else{ 
                $statusMsg = "Sorry, there was an error uploading your file."; 
            } 
        } 
    }else{ 
        $statusMsg = 'Please select files to upload.';
    } 
     
    // Display status message 
    echo $statusMsg; 
}
?>

The structure of the db table column is file_name, VARCHAR(255), latin1_swedish_ci, NOT NULL

How Pass Empty Or Nothing To A Default Parameter For A Function?

Similar Tutorials

View Content

If I have a parameter that has a default value, how do I pass nothing such that it uses the default value? Passing NULL does not work.

Code: [Select]
function test($to = "test@test.com", $from)
{
echo $to . "<BR>" . $from;
}

//This will NOT show "test@test.com" but instead an empty line
test( NULL, "fake@fake.com" );

Why Does __call Pass Arguments And Also An Empty Array? Php5.3

Similar Tutorials

View Content

In my view file, I instantiate User class and call two methods that have not been declared or initialized in the class:

$user = new Models\User();
$user->setFirstName('John');
$user->setLastName('Merlino');

echo $user->getFirstName() . " " . $user->getLastName();

However, I have two private members only available to instances:
   protected $first_name;
   protected $last_name;

Because I don't want to manually create privileged getters and setters for each of my private members, I use the call method:

   public function __call($name,$args){

      echo $name . "<br />";
      echo $args . "<br />";

   }

Because my methods were not initialized, the interpreter calls the __call method as a last option resort, and passes the name of the method in local variable $name and if exists the arguments passed into the method in local variable $args. Ok so that makes sense. However, when I echo the values of the two variables, I see a blank array created:

setFirstName
Array
setLastName
Array
getFirstName
Array
getLastName
Array

See everytime I call it, there's an array being created. I don't see the purpose of this.

Also how often do you use __call() in your php applications, specifically when using MVC?

Thanks for response.

Allowing Users To Upload Multiple Images, And Resize On Upload

Similar Tutorials

View Content

I have code written for image uploading, but it doesn't allow multiple images on a single upload, and doesn't re-size.

Anyone willing to share a good upload script that will do the following?:
-Allow multiple image uploads (10+ per submission),
-Re-size images on upload, and
-Rename images.

Thanks
Brett

Problems Adding Multiple Upload Fields To Upload Script

Similar Tutorials

View Content

Hi everyone,

I have a page that i use to upload images to my website, i got a bit fed up of uploading one at a time so i decided to add multiple file fields to the form to upload multiple images at the same time.

Im having a few problems, iv read up he http://www.php.net/manual/en/features.file-upload.multiple.php and it seems all i have to do is add [] to the form names to turn them into arrays. However when i come to upload the images, i keep getting the "$error[] = "Incorrect format!...." error from the code below. I cant seem to figure out what the problem is.

Could anybody please point me in the right direction?

<?php
session_start();

$id = $_SESSION['id'];

$connect = mysql_connect("localhost","leemp5_admin","p7031521");
mysql_select_db("leemp5_database");

$query = mysql_query("SELECT * FROM users WHERE id='$id'");
$row = mysql_fetch_assoc($query);

$username = $row['username'];

$submit = $_POST['submit'];

$type = $_FILES['image']['type'];
$size = $_FILES['image']['size'];
$max_size = "1000";
$width = "100";
$height = "100";

$error = array();

function make_thumb($image_name,$filename,$new_width,$new_height)
{

$ext=getExtension($image_name);

if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))

$source_image=imagecreatefromjpeg($image_name);

if(!strcmp("png",$ext))

$source_image=imagecreatefrompng($image_name);

if(!strcmp("gif",$ext))

$source_image=imagecreatefromgif($image_name);

$old_x=imageSX($source_image);

$old_y=imageSY($source_image);

$ratio1=$old_x/$new_width;

$ratio2=$old_y/$new_height;

if($ratio1>$ratio2)

{

$thumb_width=$new_width;

$thumb_height=$old_y/$ratio1;

}

else

{

$thumb_height=$new_height;

$thumb_width=$old_x/$ratio2;

}

$destination_image=ImageCreateTrueColor($thumb_width,$thumb_height);

imagecopyresampled($destination_image,$source_image,0,0,0,0,$thumb_width,$thumb_height,$old_x,$old_y);

if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))

{

imagejpeg($destination_image,$filename);

}

if(!strcmp("png",$ext))

{

imagepng($destination_image,$filename);

}

if(!strcmp("gif",$ext))

{

imagegif($destination_image,$filename);

}

imagedestroy($destination_image);

imagedestroy($source_image);
}

function getExtension($str)
{

$i = strrpos($str,".");

if (!$i) { return ""; }

$l = strlen($str) - $i;

$ext = substr($str,$i+1,$l);

return $ext;
}

if($submit)
{

$image=$_FILES['image']['name'];

if ($image)

{

$filename = stripslashes($_FILES['image']['name']);

$extension = getExtension($filename);

$extension = strtolower($extension);

if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))

{

$error[] = "Incorrect format! Please make sure your image is a .jpg, .jpeg, .png or .gif file.";

}

else

{

$size=getimagesize($_FILES['image']['tmp_name']);

$sizekb=filesize($_FILES['image']['tmp_name']);

if ($sizekb > $max_size*1024)

{

$error[] = "Your image is too big! The maximum upload size is 1MB.";

}

else

{

$image_name=time().'.'.$extension;

$newname="uploads/" . $username . "/images/".$image_name; $copied = copy($_FILES['image']['tmp_name'], $newname);

if (!$copied)

{

$error[] = "There was an error uploading your image. Please try again!";

}

else

{

$thumb_name='uploads/' . $username . '/images/thumbs/thumb_'.$image_name;

$thumb=make_thumb($newname,$thumb_name,$width,$height);

}

else

{

$error[] = "Please select an image to upload!";

}

if(empty($error))

{

echo "Upload Successfully!<br />";

echo '<img src="'.$thumb_name.'">';

mysql_query("INSERT INTO images VALUES ('','$username','$image_name','','','','','uploads/$username/images/$image_name','uploads/$username/images/thumbs/thumb_$image_name','$type','$size')");

}

else

Similar Tutorials

View Content

Hi All

Been desperate to crack this nut for a few years now, but seem to be failing epically!

I have been building a property/real estate web site for a long time, but I have no training and have been learning as I go. I have a script written that allows me to upload data and store it in my database, what I was looking to do was add a section that allows me to upload multiple images at the same time, and store the location to another table in the same database.

So what I was looking to do was remove all the...lets say rubbish to be nice...and see where it takes us.

I apologize in advance for the lack of santized code...I am coding locally only, in an admin area, and will rectify before launching the site...just trying to get the bones of the script in place.

Ok, first we have my form as shown here, warts and all.
<?php
/**
* Create Listing
*/

?>

<div id="admin" class="intern">
    <div class="banner">
      <div class="logbanner">CREATE LISTING</div>
    </div>

<tr>

<td align="right"><label class="text">Property Title: </label></td>

</tr>

<tr>

<td align="right"><label class="text">Selling Agent: </label></td>

<td><input type="text" name="agent" maxlength="30" value="<?php echo $session->username; ?>"></td>

</tr>

<tr>

<td align="right"><label class="text">Style: </label></td>

<td>

<option value="Not Selected" selected>Not Selected</option>

<option value="Detached">Detached</option>

<option value="Semi-Deatched">Semi-Detached</option>

<option value="End Terrace">End Terrace</option>

<option value="Mid Terrace">Mid Terrace</option>

<option value="Ground Floor Flat">Ground Floor Flat</option>

<option value="4 in a Block">4 in a Block</option>

<option value="Bungalow">Bungalow</option>

<option value="Apartment">Apartment</option>

<option value="Studio">Studio</option>

<option value="Maisonette">Maisonette</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Address: </label></td>

</tr>

<tr>

<td align="right"><label class="text">Address: </label></td>

</tr>

<tr>

</tr>

<tr>

<td align="right"><label class="text">County: </label></td>

<td>

</select>

</td>

</tr>

<tr>

</tr>

<tr>

<td align="right"><label class="text">Price: </label></td>

<td>

<option value="Not Selected" selected>Not Selected</option>

<option value="Offers Over">Offers Over</option>

<option value="Fixed Price">Fixed Price</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Property Status: </label></td>

<td>

<option value="Not Selected" selected>Not Selected</option>

<option value="Fixed Price">Sold Subject to Signed Missives</option>

<option value="Fixed Price">Sold Subject to Survey</option>

<option value="Fixed Price">Price Reduced</option>

<option value="Fixed Price">Re-Listed</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Description Header: </label></td>

</tr>

<tr>

<td align="right"><label class="text">Description: </label></td>

</tr>

<tr>

<td align="right"><label class="text">Reception Rooms: </label></td>

<td>

<option value="0" selected>Not Selected</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Bedrooms: </label></td>

<td>

<option value="0" selected>Not Selected</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Bathrooms: </label></td>

<td>

<option value="0" selected>Not Selected</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Garden: </label></td>

<td>

<option value="Not Selected" selected>Not Selected</option>

<option value="Shared">Shared</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Garage: </label></td>

<td>

<option value="Not Selected" selected>Not Selected</option>

<option value="Shared">Shared</option>

</select>

</td>

</tr>

<tr>

<td align="right"><label class="text">Additional Info: <br />** Not seen by site users **</label></td>

</tr>

<tr>

<td>

</td>

</tr>

</table>

</form>
<?php echo $form->error("creListing"); ?>
</div>
</div>

next I have my process page which has the following function included...
  function procCreateListing(){

      global $session, $database, $form;
         $q = "INSERT INTO ".TBL_PROP."(prop_id, prop_agent, prop_type, prop_add_1, prop_add_2, prop_town, prop_county, prop_pc, prop_price, prop_price_cond, prop_rec_rooms, prop_bedrooms, prop_bathrooms, prop_status, prop_garden, prop_garage, prop_description_header, prop_description, prop_add_info, prop_add_date) VALUES ('".$_POST['property_title']."', '".$_POST['agent']."', '".$_POST['property_type']."', '".$_POST['address_one']."', '".$_POST['address_two']."', '".$_POST['town']."', '".$_POST['county']."', '".$_POST['postcode']."', '".$_POST['price']."', '".$_POST['price_cond']."', '".$_POST['recrooms']."', '".$_POST['bedrooms']."', '".$_POST['bathrooms']."', '".$_POST['status']."', '".$_POST['garden']."', '".$_POST['garage']."', '".$_POST['deschead']."', '".$_POST['desc']."', '".$_POST['addinfo']."', '".$_POST['date']."')";
         $database->query($q);

   }

and I have 2 tables in mysql

prop_listing and imagebin
Code: [Select]
CREATE TABLE `kea_userclass`.`prop_listing` (
`prop_id` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`prop_agent` VARCHAR( 40 ) NOT NULL ,
`prop_type` VARCHAR( 20 ) NOT NULL ,
`prop_add_1` VARCHAR( 50 ) NOT NULL ,
`prop_add_2` VARCHAR( 50 ) NOT NULL ,
`prop_town` VARCHAR( 30 ) NOT NULL ,
`prop_county` VARCHAR( 25 ) NOT NULL ,
`prop_pc` VARCHAR( 8 ) NOT NULL ,
`prop_price` INT( 10 ) NOT NULL ,
`prop_price_cond` VARCHAR( 20 ) NOT NULL ,
`prop_rec_rooms` INT( 2 ) NOT NULL ,
`prop_bedrooms` INT( 3 ) NOT NULL ,
`prop_bathrooms` INT( 2 ) NOT NULL ,
`prop_status` VARCHAR( 20 ) NOT NULL ,
`prop_garage` INT( 1 ) NOT NULL ,
`prop_garden` INT( 1 ) NOT NULL ,
`prop_description_header` VARCHAR( 50 ) NOT NULL ,
`prop_description` VARCHAR( 2000 ) NOT NULL ,
`prop_add_info` VARCHAR( 2000 ) NOT NULL ,
`prop_add_date` DATE NOT NULL ,
PRIMARY KEY ( `prop_id` )
) ENGINE = MYISAM ;

CREATE TABLE `imagebin` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`item_id` int( 11 ) NOT NULL ,
`image` varchar( 255 ) NOT NULL ,
PRIMARY KEY ( `id` ) ) ENGINE = MYISAM DEFAULT CHARSET = latin1;

first of all thanks for getting this far, I know it is a lot of reading, and a lot to ask for, but now I am stuck...
I need a section on my form that would allow me to upload 8 images, and store them in a directory folder I need the location saved into my imagebin table thats it just now
Many thanks for reading, and I hope someone can take me under their wing and help me passed this hurdle

Multiple Image Upload

Similar Tutorials

View Content

<form id="test" action="<?php $_POST['SERVER_SELF'] ?>" method="POST" enctype="multipart/form-data" >
  <div class="wrap">
<p>upload image here for Contact Page</p>

         <input type="file" name="image">    <br>
    <input name="about1" type="submit" value="Upload image"> <br>

</div>

</form>

<?php
//define a maxim size for the uploaded images in Kb
define ("MAX_SIZE","100000");

//This function reads the extension of the file. It is used to determine if the file  is an image by checking the extension.
function getExtension($str) {
         $i = strrpos($str,".");
         if (!$i) { return ""; }
         $l = strlen($str) - $i;
         $ext = substr($str,$i+1,$l);
         return $ext;
}

//This variable is used as a flag. The value is initialized with 0 (meaning no error  found)
//and it will be changed to 1 if an errro occures.
//If the error occures the file will not be uploaded.
$errors=0;
//checks if the form has been submitted

if(isset($_POST['about']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
//if it is not empty
if ($image)
{
//get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);
//get the extension of the file in a lower case format
   $extension = getExtension($filename);
$extension = strtolower($extension);
//if it is not a known extension, we will suppose it is an error and will not  upload the file,
//otherwise we will do more tests
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))
{
//print error message
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
else
{
//get the size of the image in bytes
//$_FILES['image']['tmp_name'] is the temporary filename of the file
//in which the uploaded file was stored on the server
$size=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($size > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=contactbg.'.'.jpg;
//the new name will be containing the full path where will be stored (images folder)
$newname="C:/xampp/htdocs/Dirk-taat/wp-content/themes/dirktaat/images/".$image_name;
//we verify if the image has been uploaded, and print error instead
$copied = copy($_FILES['image']['tmp_name'], $newname);
if (!$copied)
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}}}}

//If no errors registred, print the success message
if(isset($_POST['about']) && !$errors)
{
echo "<h1>File Uploaded Successfully! Try again!</h1>";
}



//This function reads the extension of the file. It is used to determine if the file  is an image by checking the extension.

//This variable is used as a flag. The value is initialized with 0 (meaning no error  found)
//and it will be changed to 1 if an errro occures.
//If the error occures the file will not be uploaded.
$errors=0;
//checks if the form has been submitted
if(isset($_POST['about1']))
{
//reads the name of the file the user submitted for uploading
$image=$_FILES['image']['name'];
//if it is not empty
if ($image)
{
//get the original name of the file from the clients machine
$filename = stripslashes($_FILES['image']['name']);
//get the extension of the file in a lower case format
   $extension = getExtension($filename);
$extension = strtolower($extension);
//if it is not a known extension, we will suppose it is an error and will not  upload the file,
//otherwise we will do more tests
if (($extension != "jpg") && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))
{
//print error message
echo '<h1>Unknown extension!</h1>';
$errors=1;
}
else
{
//get the size of the image in bytes
//$_FILES['image']['tmp_name'] is the temporary filename of the file
//in which the uploaded file was stored on the server
$size=filesize($_FILES['image']['tmp_name']);

//compare the size with the maxim size we defined and print error if bigger
if ($size > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=aboutme_bg.'.'.png;
//the new name will be containing the full path where will be stored (images folder)
$newname="C:/../.../../.../../.../images/".$image_name;
//we verify if the image has been uploaded, and print error instead
$copied = copy($_FILES['image']['tmp_name'], $newname);
if (!$copied)
{
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}}}}

//If no errors registred, print the success message
if(isset($_POST['about1']) && !$errors)
{
echo "<h1>File Uploaded Successfully! Try again!</h1>";
}

}
?>

the above code works only for 1 upload box if more than one upload box it does not upload the file.

Thanks