Learn VBA & Macros in 1 Week!

PHP - Upload Multiple Images In Mysql Not Working

Full Excel VBA Course - Beginner to Expert

Upload Multiple Images In Mysql Not Working	View Content

I've looked around at a bunch of sample code and cannot seem to get this to work. I'm trying to create a table with the values provided in a form along with an uploaded image. Here is what I have.

Code: [Select]
<?php
//Set variables from form
$title = $_POST["title_textfield"];
$description = $_POST["description_textbox"];
$price = $_POST["price_textfield"];
$time = date("ymdHis");
$me = $myuserID

/Create Table
$con = mysql_connect("mydatabase.mysql.com","databaseAdmin","Adminpass");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

//check if table exists

// Create table
$time = date("ymdHis");
$tablename = "1_$me$time";
mysql_select_db("db_01", $con);
$sql = "CREATE TABLE $tablename
(
ID int NOT NULL AUTO_INCREMENT,
imageData LONGBLOB NOT NULL ,
PRIMARY KEY(comicID),
Owner varchar(15),
Status varchar(15),
AgeRestriction varchar(25),
Title varchar(25),
Description varchar(100),
Price varchar(15)
)";

// Execute query
mysql_query($sql,$con);
//input info into table
mysql_query("INSERT INTO $tablename (Owner, Status, Title, Description, Price)
VALUES ('$myid', 'Pending', '$title', '$description', '$price')");

//Image control!!!!
$maxFileSize = "2000000"; // 2 MB file size
//Initializing the image types.
$image_array = array("image/jpeg","image/jpg","image/gif","image/bmp","image/pjpeg","image/png"); // valid image type

//store the file type of the uploading file.
$fileType = $_FILES['userfile']['type'];
$nname= $_FILES['userfile']['name'];
echo "$nname";
//Initializing the  msg variable. Although , not necessary.
$msg = "";


// if Submit button is clicked
if(@$_POST['Submit'])
{
// check for the image type , before uploading
if (in_array($fileType, $image_array))
{

// check whether the file is uploaded
if(is_uploaded_file($_FILES['userfile']['tmp_name']))
{

// check whether the file size is below 2 mb
        if($_FILES['userfile']['size'] < $maxFileSize)
            {

// reading the image data
                  $imageData =addslashes (file_get_contents($_FILES['userfile']['tmp_name']));

// inserting into the database
        $sql = "INSERT INTO $tablename (imageData) VALUES ('$imageData')";


        mysql_query($sql) or die(mysql_error());
                $msg = " Data successfully uploaded";
         }
     else
         {

             $msg = " Error :  File size exceeds the maximum limit ";

             }
   }
}
else
{
$msg = "Error: Not a valid image ";
}

}
mysql_close($con);
?>
All the fields populate just fine except the imageData field which shows "[BLOB - 0 Bytes]" Any help would be GREATLY appreciated. Thank you for even taking the time to look.

Cordially,
TcS

Full Excel VBA Course - Beginner to Expert

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

Upload Multiple Images...from The Top

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 Images Upload Issue

Similar Tutorials

View Content

Hi I am developing a website for fun to play around with, like a little fun project and am trying to work out how to upload multiple images that stores the filename in the database and the actual file on the server I have managed to get it working if I upload just one image but can't work it out for multiple images Can anyone point me in the right direction or advise where I need to adjust for multiple images upload I know on the html form on the input tag needs to have multiple and then the name in the input tag be image[] but is as far as I get, it's the PHP I get stuck on The html for the form is below

<form action="private-add-insert.php" method="post" enctype="multipart/form-data">
Car Make: <input type="text" name="make">
Car Model: <input type="text" name="model">
Exterior Colour: <input type="text" name="exteriorcolour">
Engine Size: <input type="text" name="enginesize">
Fuel Type: <input type="text" name="fueltype">
Year Registered: <input type="text" name="yearregistered">
Transmission: <input type="text" name="transmission">
Mileage: <input type="text" name="mileage">
Number of Doors: <input type="text" name="nodoors">
Body Style: <input type="text" name="bodystyle">
Price: <input type="text" name="price">
<br>
<label>Upload Images</label>
<input type="file" name="image[]" multiple/>
<br />
<input type="hidden" name="MAX_FILE_SIZE" value="100000" />
<br />
<input type="submit" value="Submit Listing"> 
</form>

Below is the PHP coding that processes the html form

<?php
ini_set('display_startup_errors',1);
ini_set('display_errors',1);
error_reporting(-1);
?>

<?php
// Start a session for error reporting
session_start();

// Call our connection file
require("includes/conn.php");

// Check to see if the type of file uploaded is a valid image type
function is_valid_type($file)
{
	// This is an array that holds all the valid image MIME types
	$valid_types = array("image/jpg", "image/jpeg", "image/bmp", "image/gif", "image/png");

	if (in_array($file['type'], $valid_types))
		return 1;
	return 0;
}

// Just a short function that prints out the contents of an array in a manner that's easy to read
// I used this function during debugging but it serves no purpose at run time for this example
function showContents($array)
{
	echo "<pre>";
	print_r($array);
	echo "</pre>";
}

// Set some constants

// This variable is the path to the image folder where all the images are going to be stored
// Note that there is a trailing forward slash
$TARGET_PATH = "private-listing-images/";

// Get our POSTed variables
$make = $_POST['make'];
$model = $_POST['model'];
$exteriorcolour = $_POST['exteriorcolour'];
$enginesize = $_POST['enginesize'];
$fueltype = $_POST['fueltype'];
$yearregistered = $_POST['yearregistered'];
$transmission = $_POST['transmission'];
$mileage = $_POST['mileage'];
$nodoors = $_POST['nodoors'];
$bodystyle = $_POST['bodystyle'];
$price = $_POST['price'];
$image = $_FILES['image'];

// Sanitize our inputs
$make = mysql_real_escape_string($make);
$model = mysql_real_escape_string($model);
$exteriorcolour = mysql_real_escape_string($exteriorcolour);
$enginesize = mysql_real_escape_string($enginesize);
$fueltype = mysql_real_escape_string($fueltype);
$yearregistered = mysql_real_escape_string($yearregistered);
$transmission = mysql_real_escape_string($transmission);
$mileage = mysql_real_escape_string($mileage);
$nodoors = mysql_real_escape_string($nodoors);
$bodystyle = mysql_real_escape_string($bodystyle);
$price = mysql_real_escape_string($price);
$image['name'] = mysql_real_escape_string($image['name']);

// Build our target path full string.  This is where the file will be moved do
// i.e.  images/picture.jpg
$TARGET_PATH .= $image['name'];

// Check to make sure that our file is actually an image
// You check the file type instead of the extension because the extension can easily be faked
if (!is_valid_type($image))
{
	$_SESSION['error'] = "You must upload a jpeg, gif, bmp or png";
	header("Location: private-add-listing.php");
	exit;
}

// Lets attempt to move the file from its temporary directory to its new home
if (move_uploaded_file($image['tmp_name'], $TARGET_PATH))
{
	
	// NOTE: This is where a lot of people make mistakes.
	// We are *not* putting the image into the database; we are putting a reference to the file's location on the server
	$sql = "insert into privatelistings (make, model, exteriorcolour, enginesize, fueltype, yearregistered, transmission, mileage, nodoors, bodystyle, price, filename) values ('$make', '$model', '$exteriorcolour', '$enginesize', '$fueltype', '$yearregistered', '$transmission', '$mileage', '$nodoors', '$bodystyle', '$price', '" . $image['name'] . "')";
	$result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error());
	header("Location: private-add-listing-successfully.php?msg=Listing Added successfully");
	exit;
}
else
{
	// A common cause of file moving failures is because of bad permissions on the directory attempting to be written to
	// Make sure you chmod the directory to be writeable
	$_SESSION['error'] = "Could not upload file.  Check read/write persmissions on the directory";
	header("Location: private-add-listing.php");
	exit;
}
?>

I know the coding needs updating to mysqli and prevent sql injections but want to get it working first and then will do them parts Thank you in advance Kind regards Ian

Upload Multiple Images Stops At 20

Similar Tutorials

View Content

I created scripting to upload multiple images simultaneously.

The files sizes allowed for upload are 2 MB (or larger) and are then resized to approx 300kb each.

In testing, I have discovered that the uploading terminated after 20 images.

Is there a variable that needs to be re-defined in order to easily allow uploads of several hundred images?

PS: I've seen several conflicting examples for defining max_file_size. What is the correct math to define this parameter?

Upload And Replace Multiple Images

Similar Tutorials

View Content

I have a form that will be used to edit various fields including images. Everything works on this form except the images. When I choose the image i want to replace and upload the new image the location of the others get erased on the MySQL database and I'm just left with the one I replaced. How can I just change the image I pick to replace without erasing the location of the others? Is there a way just to tell the script to only replace the image that corresponds with the image selected? Thank You

The Form

Code: [Select]
<!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>FormListing </title>
</head>

<body>\<?php
session_start();
if(empty($_SESSION['myusername'])){

// send them back to login

header('location: index.php');

}
$_SESSION['id'];
$_SESSION['$myusername'];

$id = (int)$_GET['id'];
$id = substr($id, 0,5);

if($id < 1 || $id > 99999) exit;
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name
$tbl_name=""; // Table name

// Connect to server and select database.
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

// get value of id that sent from address bar
$id=$_GET['id'];

// Retrieve data from database
$sql="SELECT * FROM $tbl_name WHERE id='$id'";
$result=mysql_query($sql);

$rows=mysql_fetch_array($result);
?>
<form method="post" action="aptmodifyform.php" enctype="multipart/form-data"/>
<input type="hidden" name="id" id="id" value="<?php echo $id; ?>" />
<table width="914" height="1234" border="0">
<tr>
<td width="636" height="68"><div align="right"><span style="color: #F00">*</span>Title</div></td>
<td width="11"><div align="center">:</div></td>
<td colspan="3" style="text-align: left"><label for="title"></label>
<div align="left"><span id="sprytextfield1">
<input name="title" type="text" value="<? echo $rows['title']; ?>" id="title" size="50" maxlength="50"/>
</span></div></td>
</tr>
<tr>
<td><div align="right">County</div></td>
<td><div align="center">:</div></td>
<td colspan="3" style="text-align: left"><label for="county"></label>
<select name="county" id="county">
<option selected="selected" <?=($rows['county'] == 'Bronx') ? 'selected="selected"' : ''?>>Bronx</option>
<option <?=($rows['county'] == 'Brooklyn') ? 'selected="selected"' : ''?>>Brooklyn</option>
<option <?=($rows['county'] == 'Manhattan') ? 'selected="selected"' : ''?>>Manhattan</option>
<option <?=($rows['county'] == 'Queens') ? 'selected="selected"' : ''?>>Queens</option>
<option <?=($rows['county'] == 'Staten Island') ? 'selected="selected"' : ''?>>Staten Island</option>
<option>-----------------</option>
<option <?=($rows['county'] == 'Nassau') ? 'selected="selected"' : ''?>>Nassau</option>
<option <?=($rows['county'] == 'Suffolk') ? 'selected="selected"' : ''?>>Suffolk</option>
</select></td>
</tr>
<tr>
<td><div align="right">Town</div></td>
<td><div align="center">:</div></td>
<td colspan="3" style="text-align: left"><label for="town"></label>
<input name="town" type="text" value="<? echo $rows['town']; ?>" id="town" size="50" maxlength="30"/></td>
</tr>
<tr>
<td><div align="right">Description<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</div></td>
<td><div align="center">
<p>:<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
</p>
</div></td>
<td colspan="3" style="text-align: left"><label for="description"></label>
<textarea name="description" cols="70" rows="25" id="description"><?php echo $rows['description']; ?></textarea></td>
</tr>
<tr>
<td style="text-align: right; color: #000;">Service</td>
<td style="text-align: center">:</td>
<td colspan="3" style="text-align: left"><label for="service"></label>
<select name="service" size="1" id="service">
<option <?=($rows['service'] == 'Landlord') ? 'selected="selected"' : ''?>>Lanlord</option>
<option <?=($rows['service'] == 'Property Mangement') ? 'selected="selected"' : ''?>>Property Mangement</option>
<option <?=($rows['service'] == 'Realtor') ? 'selected="selected"' : ''?>>Realtor</option>
</select></td>
</tr>
<tr>
<td><div align="right">Service Fees</div></td>
<td>:</td>
<td colspan="3" style="text-align: left"><select name="feeornofee" id="feeornofee">
<option <?=($rows['feeornofee'] == 'Broker Fees + Other Fees') ? 'selected="selected"' : ''?>>Broker Fees + Other Fees</option>
<option <?=($rows['feeornofee'] == 'Broker Fees') ? 'selected="selected"' : ''?>>Broker Fees</option>
<option <?=($rows['feeornofee'] == 'Other Fees - No Broker Fee') ? 'selected="selected"' : ''?>>Other Fees - No Broker Fee</option>
<option <?=($rows['feeornofee'] == 'No Fees') ? 'selected="selected"' : ''?>>No Fees</option>
</select></td>
</tr>
<tr>
<td><div align="right">Lease Type</div></td>
<td>:</td>
<td colspan="3" style="text-align: left"><label for="lease"></label>
<select name="lease" id="lease">
<option <?=($rows['lease'] == 'Rent Stabilized ') ? 'selected="selected"' : ''?>>Rent Stabilized </option>
<option <?=($rows['lease'] == 'Prime, non-stabilized lease') ? 'selected="selected"' : ''?>>Prime, non-stabilized lease</option>
<option <?=($rows['lease'] == 'Coop (sub) Lease') ? 'selected="selected"' : ''?>>Coop (sub) Lease</option>
<option <?=($rows['lease'] == 'Condo Lease') ? 'selected="selected"' : ''?>>Condo Lease</option>
<option <?=($rows['lease'] == 'Commercial Lease') ? 'selected="selected"' : ''?>>Commercial Lease</option>
<option <?=($rows['lease'] == 'Other') ? 'selected="selected"' : ''?>>Other</option>
</select></td>
</tr>
>
<tr>
<td><div align="right">Contact's Name</div></td>
<td>:</td>
<td colspan="3" style="text-align: left"><label for="contact"></label>
<input name="contact" type="text" value="<? echo $rows['contact']; ?>" id="contact" size="40" maxlength="40" /></td>
</tr>
<tr>
<td><div align="right">Name of Office</div></td>
<td>:</td>
<td colspan="3" style="text-align: left"><label for="office"></label>
<input name="office" type="text" value="<? echo $rows['office']; ?>" id="office" size="40" maxlength="40" /></td>
</tr>
<tr>
<td><div align="right">Pets</div></td>
<td>:</td>
<td colspan="3" style="text-align: left"><label for="pets"></label>
<select name="pets" id="pets">
<option <?=($rows['pets'] == 'Pets Allowed') ? 'selected="selected"' : ''?>>Pets Allowed</option>
<option <?=($rows['pets'] == 'No Pets') ? 'selected="selected"' : ''?>>No Pets</option>
<option <?=($rows['pets'] == 'Pets Allowed - Small pets') ? 'selected="selected"' : ''?>>Pets Allowed - Small pets</option>
</select></td>
</tr>
<tr>
<td><div align="right">Phone<br />
</div>
<br /></td>
<td><div align="center">:<br />
<br />
</div></td>
<td colspan="3" style="text-align: left"><label for="phone"></label>
<span id="rental_phone">
<input type="text" name="phone" value="<? echo $rows['phone']; ?>"id="phone" />
<span class="textfieldMaxCharsMsg">Exceeded maximum number of characters.</span></span><br />
<span style="font-style: italic; font-size: 14px; font-weight: bold;">ex. (123) 456-7890 - Please keep this format.</span></td>
</tr>
<tr>
<td style="text-align: right"><p>Location<br />
</p>
<p><br />
<br />
<br />
</p></td>
<td style="text-align: center">:<br />
<br />
<br />
<br />
<br /></td>
<td colspan="3" style="text-align: left"><label for="cross_streets"></label>
<input name="cross_streets" type="text" value="<? echo $rows['cross_streets']; ?>" id="cross_streets" size="80" maxlength="100" />
<br />
<span style="color: #F00">Please insert here the intersecting streets. Make sure you add the word "and" <br />
between streets <br />
OR<br />
You can put the property's
full address. <br />
e.g. 193rd Street AND Jamaica Avenue, Jamaica, NY </span></td>
</tr>
<tr>
<td style="text-align: right">Zip Code</td>
<td style="text-align: center">:</td>
<td colspan="3" style="text-align: left"><input name="zipcode" type="text" id="zipcode" value="<? echo $rows['zipcode']; ?>" size="9"

maxlength="5" /></td>
</tr>
<tr>
<td style="text-align: right"><span style="color: #000">Email </span><br />
<br /></td>
<td style="text-align: center">:<br />
<br /></td>
<td colspan="3" style="text-align: left"><label for="email"></label>
<input name="email" type="text" value="<? echo $rows['email']; ?>" id="email" size="60" maxlength="60" />
<br />
<span style="font-size: 12px; font-style: italic;">This field is optional. It will be viewable to users.</span></td>
</tr>
<tr>
<td><div align="right">Rooms</div></td>
<td><div align="center">:</div></td>
<td colspan="3" style="text-align: left"><label for="rooms"></label>
<select name="rooms" id="rooms">
<option <?=($rows['rooms'] == '0') ? 'selected="selected"' : ''?>>0</option>
<option <?=($rows['rooms'] == '1') ? 'selected="selected"' : ''?>>1</option>
<option <?=($rows['rooms'] == '1.5') ? 'selected="selected"' : ''?>>1.5</option>
<option <?=($rows['rooms'] == '2') ? 'selected="selected"' : ''?>>2</option>
<option <?=($rows['rooms'] == '2.5') ? 'selected="selected"' : ''?>>2.5</option>
<option <?=($rows['rooms'] == '3') ? 'selected="selected"' : ''?>>3</option>
<option <?=($rows['rooms'] == '3.5') ? 'selected="selected"' : ''?>>3.5</option>
<option <?=($rows['rooms'] == '4') ? 'selected="selected"' : ''?>>4</option>
<option <?=($rows['rooms'] == '4.5') ? 'selected="selected"' : ''?>>4.5</option>
<option <?=($rows['rooms'] == '5') ? 'selected="selected"' : ''?>>5</option>
<option <?=($rows['rooms'] == '5.5') ? 'selected="selected"' : ''?>>5.5</option>
<option <?=($rows['rooms'] == '6') ? 'selected="selected"' : ''?>>6</option>
</select>
0 = Studio, 1 = 1 Bedroom, etc.</td>
</tr>
<tr>
<td><div align="right">Bath</div></td>
<td><div align="center">:</div></td>
<td colspan="3" style="text-align: left"><label for="bath"></label>
<select name="bath" id="bath">
<option <?=($rows['bath'] == '0') ? 'selected="selected"' : ''?>>0</option>
<option <?=($rows['bath'] == '1') ? 'selected="selected"' : ''?>>1</option>
<option <?=($rows['bath'] == '1.5') ? 'selected="selected"' : ''?>>1.5</option>
<option <?=($rows['bath'] == '2') ? 'selected="selected"' : ''?>>2</option>
<option <?=($rows['bath'] == '2.5') ? 'selected="selected"' : ''?>>2.5</option>
<option <?=($rows['bath'] == '3') ? 'selected="selected"' : ''?>>3</option>
<option <?=($rows['bath'] == '3.5') ? 'selected="selected"' : ''?>>3.5</option>
<option <?=($rows['bath'] == '4') ? 'selected="selected"' : ''?>>4</option>
</select></td>
</tr>
<tr>
<td><div align="right">Square ft.</div></td>
<td><div align="center">:</div></td>
<td colspan="3" style="text-align: left"><label for="square"></label>
<input name="square" type="text" value="<? echo $rows['square']; ?>" id="square" size="6" maxlength="6" /></td>
</tr>
<tr>
<td><div align="right"><span style="color: #F00">*</span>Rent</div></td>
<td><div align="center">:</div></td>
<td colspan="3" style="text-align: left"><label for="rent">
$
<input name="rent" type="text" value="<? echo $rows['rent']; ?>" id="rent" size="10" maxlength="10" />
</label></td>
</tr>
<tr>
<td><div align="right"><span style="color: #F00">*</span>Fees
</div></td>
<td><div align="center">
<p>: </p>
</div></td>
<td colspan="3" style="text-align: left"><label for="fees"></label>
<span id="sprytextfield3">
<input name="fees" type="text" id="fees" value="<? echo $rows['fees']; ?>" size="90" />
</span></td>
</tr>
<tr>
<td colspan="5" style="text-align: center; font-weight: bold; font-size: 18px; color: #F00;"> Video Link</td>
</tr>
<tr>
<td><div align="right">URL</div></td>
<td><div align="center">:</div></td>
<td colspan="3"><p> 
</p>
<p>
<input name="url" type="text" id="url" value="<? echo $rows['url']; ?>"size="80" />
</td>
</tr>
<tr>
<td><div align="center" style="color: #F00">
<div align="right">Name Your
Video Link</div>
</div></td>
<td><div align="center">
<p>: </p>
</div></td>
<td colspan="3"><br />
<p>
<input name="videotitle" type="text" id="videotitle" value="<? echo $rows['videotitle']; ?>"size="80" />
<br />
<span style="color: #E62E00">If you posted a URL for your video you must give it a title to give it a link.</span></p></td>
</tr>
<tr>
<td colspan="2" style="text-align: center"> </td>
<td style="text-align: center"> </td>
<td style="text-align: center"> </td>
<td style="text-align: center"> </td>
</tr>
<tr>
<td colspan="2" style="text-align: center"> </td>
<td style="text-align: center"> </td>
<td style="text-align: center"> </td>
<td style="text-align: center"> </td>
</tr>
<tr>
<td colspan="2" style="text-align: center"><img src="<? echo $rows['imageurl1']; ?>" width="200" /><br /></td>
<td width="213" style="text-align: center"><img src="<? echo $rows['imageurl2']; ?>" width="200" /></td>
<td width="180" style="text-align: center"><img src="<? echo $rows['imageurl3']; ?>" width="200" /></td>
<td width="188" style="text-align: center"><img src="<? echo $rows['imageurl4']; ?>" width="200" /></td>
</tr>
<tr>
<td colspan="2" style="text-align: center"><div align="center">
<input id="image3" type="file" name="image1" />
</div></td>
<td style="text-align: center"><div align="center">
<input id="image3" type="file" name="image2" />
</div></td>
<td style="text-align: center"><div align="center">
<input id="image3" type="file" name="image3" />
</div></td>
<td style="text-align: center"><div align="center">
<input id="image4" type="file" name="image4" />
</div></td>
</tr>
<tr>
<td colspan="5" style="text-align: center"> </td>
</tr>
<tr>
<td colspan="2" style="text-align: center"><img src="<? echo $rows['imageurl5']; ?>" width="200" /></td>
<td style="text-align: center"><img src="<? echo $rows['imageurl6']; ?>" width="200" /></td>
<td style="text-align: center"><img src="<? echo $rows['imageurl7']; ?>" width="200" /></td>
<td style="text-align: center"><img src="<? echo $rows['imageurl8']; ?>" width="200" /></td>
</tr>
<tr>
<td colspan="2" style="text-align: center"><input id="image5" type="file" name="image5" /></td>
<td style="text-align: center"><input id="image6" type="file" name="image6" /></td>
<td style="text-align: center"><input id="image7" type="file" name="image7" /></td>
<td style="text-align: center"><input id="image8" type="file" name="image8" /></td>
</tr>
<tr>
<td colspan="2" style="text-align: center"><img src="<? echo $rows['imageurl9']; ?>" width="200" /></td>
<td style="text-align: center"><img src="<? echo $rows['imageurl10']; ?>" width="200" /></td>
<td style="text-align: center"><img src="<? echo $rows['imageurl11']; ?>" width="200" /></td>
<td style="text-align: center"><img src="<? echo $rows['imageurl12']; ?>" width="200" /></td>
</tr>
<tr>
<td colspan="2" style="text-align: center"><input id="image9" type="file" name="image9" /></td>
<td style="text-align: center"><input id="image10" type="file" name="image10" /></td>
<td style="text-align: center"><input id="image11" type="file" name="image11" /></td>
<td style="text-align: center"><input id="image12" type="file" name="image12" /></td>
</tr>
<tr>
<td colspan="5" style="text-align: center"> </td>
</tr>
<tr>
<td colspan="5" style="text-align: center"><span style="color: #F00">*</span> REQUIRED FIELDS </td>
</tr>
<tr>
<td colspan="5" style="text-align: center"> PRESS SUBMIT ONCE!!!</td>
</tr>
<tr>
<td colspan="5" style="text-align: center"><input type="submit" name="button" id="button" value="Submit Changes" />
<input type="reset" name="button" id="button" value="Reset" /></td>
</tr>
</table>
</form>
</body>
</html>

The Script

Code: [Select]
<?php
session_start();
include('SimpleImage.php');
$image = new SimpleImage();
//error_reporting(E_ALL);

// image upload folder
    $image_folder = 'images/classified/';
// fieldnames in form
$all_file_fields = array('image1', 'image2' ,'image3', 'image4', 'image5', 'image6', 'image7', 'image8', 'image9', 'image10', 'image11', 'image12');
// allowed filetypes
$file_types = array('jpg','gif','png');
// max filesize 5mb
$max_size = 5000000;
//echo'<pre>';print_r($_FILES);exit;

$time = time();
$count = 1;

foreach($all_file_fields as $fieldname){
if($_FILES[$fieldname]['name'] != ''){

$type = substr($_FILES[$fieldname]['name'], -3, 3);

// check filetype
if(in_array(strtolower($type), $file_types)){

//check filesize
if($_FILES[$fieldname]['size']>$max_size){
$error = "File too big. Max filesize is ".$max_size." MB";

}else{

// new filename
$filename = str_replace(' ','',$myusername).'_'.$time.'_'.$count.'.'.$type;

// move/upload file
$image->load($_FILES[$fieldname]['tmp_name']);
if($image->getWidth() > 150) { //if the image is larger that 150.
$image->resizeToWidth(500); //resize to 500.
}
$target_path = $image_folder.basename($filename); //image path.

$image->save($target_path); //save image to a directory.

//save array with filenames
$images[$count] = $image_folder.$filename;
$count = $count+1;

}//end if

}else{ $error = "Please use jpg, gif, png files";

}//end if
}//end if
}//end foreach

if($error != ''){ echo $error;
}else{
//error_reporting(E_ALL);
//ini_set('display_errors','On');

$id = $_POST['id'];
$id = substr($id, 0,5);
if($id < 1 || $id > 99999) exit;

  $servername = "localhost";
  $username = "";
  $password = "";

if(!$_POST["title"] || !$_POST["rent"] || !$_POST["fees"]){
header('location: fields.php');

}else if (!(preg_match('#^\d+(\.(\d{2}))?$#',($_POST["rent"])))){
header('location: rent.php');

}else{
$conn =  mysql_connect($servername,$username,$password)or die(mysql_error());
mysql_select_db("genesis_apts",$conn);

// validate id belongs to user
$sql_check = "SELECT * FROM apartments WHERE id = '".$id."' AND username = '".$myusername."'";
$res = mysql_query($sql_check,$conn) or die(mysql_error());
$count = mysql_num_rows($res);

if ($count > 0){

  $sql = "UPDATE apartments SET title = '".mysql_real_escape_string($_POST['title'])."', description = '".mysql_real_escape_string($_POST['description'])."', cross_streets = '".mysql_real_escape_string($_POST['cross_streets'])."', county = '".mysql_real_escape_string($_POST['county'])."', town = '".mysql_real_escape_string($_POST['town'])."', service = '".mysql_real_escape_string($_POST['service'])."', phone = '".mysql_real_escape_string($_POST['phone'])."', contact = '".mysql_real_escape_string($_POST['contact'])."', office = '".mysql_real_escape_string($_POST['office'])."', pets = '".mysql_real_escape_string($_POST['pets'])."', email = '".mysql_real_escape_string($_POST['email'])."', rooms = '".mysql_real_escape_string($_POST['rooms'])."', bath = '".mysql_real_escape_string($_POST['bath'])."', square = '".mysql_real_escape_string($_POST['square'])."', rent = '".mysql_real_escape_string($_POST['rent'])."', fees = '".mysql_real_escape_string($_POST['fees'])."', service = '".mysql_real_escape_string($_POST['service'])."', feeornofee = '".mysql_real_escape_string($_POST['feeornofee'])."', lease = '".mysql_real_escape_string($_POST['lease'])."', url = '".mysql_real_escape_string($_POST['url'])."', zipcode = '".mysql_real_escape_string($_POST['zipcode'])."', videotitle = '".mysql_real_escape_string($_POST['videotitle'])."', imageurl1 = '".mysql_real_escape_string($images[1])."', imageurl2 = '".mysql_real_escape_string($images[2])."', imageurl3 = '".mysql_real_escape_string($images[3])."', imageurl4 ='".mysql_real_escape_string($images[4])."', imageurl5 = '".mysql_real_escape_string($images[5])."', imageurl6 = '".mysql_real_escape_string($images[6])."', imageurl7 = '".mysql_real_escape_string($images[7])."', imageurl8 = '".mysql_real_escape_string($images[8])."', imageurl9 = '".mysql_real_escape_string($images[9])."', imageurl10 = '".mysql_real_escape_string($images[10])."', imageurl11 = '".mysql_real_escape_string($images[11])."', imageurl12 = '".mysql_real_escape_string($images[12])."' WHERE id = '".$id."'";


      //replace info with the table name above
      $result = mysql_query($sql,$conn) or die(mysql_error());
        header('location: apartments.php');

}else{
        header('location: wrong.php');
}
}
}

?>

Multiple Upload Script Not Working

Similar Tutorials

View Content

Hello Everyone,
I have been working on this add product script but cannot seem to get it to work when two files are uploaded.
All the data is uploaded to a database, including the two images filenames and then the two files are added to the server to different locations.

Here is the form:
<form action="addnewproduct.php" method="post" name="addproduct" id="addproduct" enctype="multipart/form-data">
    <input type="hidden" name="MAX_FILE_SIZE" value="10000000">
<table width="98%" border="0" cellspacing="0" cellpadding="5">
  <tr>
    <td width="28%" valign="middle" class="style1 style2"><div align="right" class="style5">Product Title </div></td>
    <td width="72%" class="style5"><input class="form" type="text" name="title" accesskey="1" tabindex="1" /></td>
    </tr>
  <tr>
    <td valign="middle" class="style1 style2"><div align="right" class="style5">Category</div></td>
    <td class="style5">
    <select class="form" name="cat" accesskey="2" tabindex="2">

      <option value="Boards">Boards</option>
      <option value="Accessories">Accessories</option>
      <option value="Clothing">Clothing</option>
      </select>
      </td>
  </tr>
  <tr>
    <td valign="top" class="style5"><div align="right">Description</div></td>
    <td class="style5"><textarea class="form" name="description" cols="50" rows="5" accesskey="3" tabindex="3"></textarea></td>
    </tr>
  <tr>
    <td valign="top" class="style5"><div align="right">Price<br />
        <span class="d">Including </span></div></td>
    <td class="style5"><input class="form" type="text" name="price" accesskey="4" tabindex="4" /></td>
    </tr>
  <tr>
    <td valign="top" class="style5"><div align="right">Paypal Link<br />
    <span class="d">Including</span></div></td>
    <td class="style5"><input class="form" type="text" name="paypal" accesskey="5" tabindex="5" /></td>
    </tr>
  <tr>
    <td valign="top" class="style5"><div align="right">Thumbnail<br />
      <span class="d">Image should be 100 x 100 </span></div></td>
    <td class="style5">
  <input style="padding:2px; border:1px #999 solid; color:blue;" name="userfile[]" type="file" id="userfile[]"> </td>
  </tr>
  <tr>
    <td valign="top" class="style5"><div align="right">Image<br />
      <span class="d">Image should be 300 x 450 </span></div></td>
    <td class="style5"><input style="padding:2px; border:1px #999 solid; color:blue;" name="userfile[]" type="file" id="userfile[]" /></td>
  </tr>
  <tr>
    <td valign="top" class="style5"><div align="right"></div></td>
    <td class="style5"><input class="form" type="submit" name="upload" value="upload" accesskey="6" tabindex="6" /></td>
  </tr>
</table>
</form>

And here is the script:

<?php
$uploadDir = 'upload/';
$uploadDir2= "upload/big".$HTTP_POST_FILES['userfile']['name'][1];

copy($HTTP_POST_FILES['userfile']['tmp_name'][1], $uploadDir2);

if(isset($_POST['upload']))
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];
$largeimage = $_FILES['userfile']['name'][1];
$filePath = $uploadDir . $fileName;

$result = move_uploaded_file($tmpName, $filePath);
if (!$result) {
echo "Error uploading file";
exit;
}

include 'config.php';
include 'opendb.php';

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
$largeimage = addslashes($largeimage);
}

$query = "INSERT INTO Products (title, description, price, paypal, cat, image, large) ".
"VALUES ('$_POST[title]','$_POST[description]','$_POST[price]','$_POST[paypal]','$_POST[cat]','$fileName','$largeimage')";

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

include 'closedb.php';

echo 'Product Uploaded';
?>

Upload Several Images And Save In Mysql Table

Similar Tutorials

View Content

I receive files/images and loop through an array as follows:

$files=rearrfiles( $_FILES['image']);
    foreach($files as $key=>$item)
    {
	  if(is_array($item) && !empty($item['name']) && !empty($item['tmp_name'])){
		  //$_POST['imageFile']=$item['name'];
		 //echo $item['name'];
		  if($error!=true && !uploadImageB(array('image'=>'image'), DB_EXTENTION."mod_projects_images", $naming, $search = $editId,  $dir, 'photo'))
		  {			
		   $error=true;
		   $action='Edit';
		   $message.='<br>Images were unable to be uploaded.';
		  } 

	  }
	}

The function uploadImageB() is as follows:

function uploadImageB($info, $table, $naming, $search, $path, $add='uploaded', $maxw=1280, $maxh=1280, $dynamic=true, $id='Id', $thumbMaxWidth = 120)
{
 global $connection;
 if(!$_POST){ global $HTTP_POST_VARS; @$_POST=$HTTP_POST_VARS;}
 if(!$_FILES){ global $HTTP_POST_FILES; @$_FILES=$HTTP_POST_FILES;}
 if(is_array($info) && !empty($info) && $table!='' && !empty($path))
 {

	$error=false;
    $d=$naming;
	foreach($info as $key=>$val)
	{		

	 $names[$val]=$dynamic==true?$add.'_'.$result[$id].'_'.$d.'_.'.strtolower(mygetext($_FILES[$val]['name'])):$add.strtolower(mygetext($_FILES[$val]['name']));
	
		 if(is_array(@$_FILES[$val]) && !empty($_FILES[$val]['name']) && !empty($names[$val]))
		 {
				if(!singMove($path, $names[$val], $_FILES[$val], array(), array('gif', 'jpeg', 'jpg', 'png', 'bmp', 'svg')))
				{
					$error=true; break;
				}
			else{
					$valid[$val]=$names[$val];
					resizeImage($path.$names[$val], $maxw, $maxh);
					make_thumb($path.$names[$val],$names[$val], $path, $thumbMaxWidth);
				}
		 }

	}
	
	
	if($error==true) return false;
	elseif(!empty($valid))
	{
  
	 $connection->info=$info; $connection->input=$valid; $connection->id=array('field'=>$id, 'val'=>addslashes($result[$id]));
	 $connection->makenew($table); $connection->return_db($connection->query);
	}
 }
 return true;
}

I get the error: Images were unable to be uploaded. Any help?

Multiple Image Upload On Mysql Table

Similar Tutorials

View Content

what's wrong with this ? i can't upload

Trying To Get Multiple Image Paths To Upload To A Mysql Database

Similar Tutorials

View Content

I am in the process of writing a CMS for a friend that is looking to add a classified section to his site. He will be the only one that will ever use it.

I got the code to work with one image when he asked me if I could do it so he could post 6 images for each item. I am unable to figure out how to do this. I was told to do this with a while loop.

This is the code that I have written so far.

<?php

//Check to make sure title is filled in. If not redirects to show_add.php
if (!$_POST[title]) {
header("Location: show_add.php");
exit;
} else {
//check and see if a session has started
session_start();
}
//if session has not been properly started redirects back to the administration menu
if ($_SESSION[valid] != "yes") {
header("Location: admin_menu.php");
exit;
}

include('includes/connection.php');

//check and see if the type of uploaded file is an image
function is_valid_type($file) {
$valid_types = array("image/jpg", "image/jpeg", "image/gif", "image/bmp");

if (in_array($file['type'], $valid_types))
return 1;
return 0;
}

//Set Constants
$TARGET_PATH = "/home/content/m/i/k/mikedmartiny/html/db_images/";

$title = $_POST['title'];
$year = $_POST['year'];
$make = $_POST['make'];
$model = $_POST['model'];
$descript = $_POST['descript'];
$image = $_FILES['image'];

//Sanitize the inputs
$title = mysql_real_escape_string($title);
$year = mysql_real_escape_string($year);
$make = mysql_real_escape_string($make);
$model = mysql_real_escape_string($model);
$descript = mysql_real_escape_string($descript);
$image['name'] = mysql_real_escape_string($image['name']);

//$target_path full string
$TARGET_PATH .= $image['name'];

//make sure that all fields from form are filled in
if ( $title == "" || $year == "" || $make =="" || $model == "" || $descript == "" || $image['name'] == "") {
$_SESSION['error'] = "ALL FIELDS ARE REQUIRED!";
header ("Location: show_add.php");
exit;
}

//check to make sure it has the right file type
if (!is_valid_type($image)){
$_SESSION['error'] = "You must upload a jpeg, gif, or bmp";
header ("Location: show_add.php");
exit;
}

//check to see if a file with that name exsists
if (file_exists($TARGET_PATH)){
$_SESSION['error'] = "A FILE WITH THAT NAME ALL READY EXIST!";
header ("Location: show_add.php");
exit;
}

//move the image - write path to database
while($image <=2) {
move_uploaded_file($image['tmp_name'], $TARGET_PATH)
} else {
// Make sure you chmod the directory to be writeable
$_SESSION['error'] = "COULD NOT UPLOAD FILE. CHECK WRITE/REWRITE PERMISSIONS ON THE FILE DIRECTORY!";
header ("Location: show_add.php");
exit;
}

$sql = "INSERT INTO $table (id, title, year, make, model, descript, image, image_two) VALUES ('', '$_POST[title]', '$_POST[year]', '$_POST[make]', '$_POST[model]', '$_POST[descript]', '" . $image['name'] . "', '" . $image['name'] . "')";

$result = mysql_query($sql) or die ("Could not insert data into DB: " . mysql_error());

?>

I only have it set up to work with 2 images right now. I thought it would be easier to get it to work properly. Then I could just add in the rest of the info later.

Any help would be greatly appreciated.

Mysql Multiple Like Not Working

Similar Tutorials

View Content

How do I get LIKE to check multiple values? It works if you type in a single word, but not multiple, which I want it to in order to get an accurate search result. Here is what I am trying to do:

$target = "siemens 6s" ;

$multis = explode(" ", $target) ;

$query = "SELECT parts_table.*, manufacturers.* FROM parts_table, manufacturers WHERE parts_table.ManufacturerID = manufacturers.ManufacturerID AND parts_table.PartNumber LIKE" ;

foreach($multis as $current) {

$queryext .= " '%$current%' OR" ;

} $queryext = substr($queryext, 0, -3) ; // Remove the last 4 charecters i.e. " AND".

$query .= $queryext ;

echo $query .= " OR manufacturers.ManufacturerID = parts_table.ManufacturerID AND manufacturers.ManufacturerName LIKE" . $queryext ;

include("dbconnect.php") ;

$result = mysql_query($query) ;

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

echo $row['ManufacturerName'] ;
echo $row['PartNumber'] ;

}

Query Multiple Mysql Tables Is Not Working.

Similar Tutorials

View Content

Hi guys, I'm trying to query two tables for different data and echo the results that match both tables. Here are the tables I have and the query I'm trying to run.
(Table)
qc_reports

(Fields)
id
report_date
report_lot_number
report_po
report_supplier
report_buyer
report_inspectedby
report_pulptemprange
report_carrierconditions
report_supplierclaim
report_carrierclaim
report_temprecorder
report_temprange_N
report_temprange_M
report_temprange_B
report_suppliercontact
report_contactedby
report_time
report_comments

(Table)
qc_lots

(Fields)
id
report_id
lot_temprange
lot_commodity
lot_rpcs
lot_brand
lot_terms
lot_cases
lot_orgn
lot_estnum
lot_avgnum

This is the query that I'm trying to do.

Code: [Select]
<?php
$sql = "SELECT * FROM qc_reports, qc_lots WHERE  ";
if (!empty($start_date) and !empty($end_date)) $sql .= " qc_reports.report_date BETWEEN '$start_date' and '$end_date' AND ";
if (!empty($search_fronteralot)) $sql .= " qc_reports.report_lot_number = '$search_fronteralot' AND ";
if (!empty($search_buyer)) $sql .= " qc_reports.report_buyer = '$search_buyer' AND ";
if (!empty($search_supplier)) $sql .= " qc_reports.report_supplier = '$search_supplier' AND ";
if (!empty($search_po)) $sql .= " qc_reports.report_po = '$search_po' AND ";
if (!empty($search_carrierconditions) and $search_carrierconditions != 'all') $sql .= " qc_reports.report_carrierconditions = '$search_carrierconditions' AND ";
if (!empty($search_commodity) and $search_commodity != 'all') $sql .= " qc_lots.lot_commodity = '$search_commodity' AND ";
if (!empty($search_inspectedby)) $sql .= " qc_reports.report_inspectedby = '$search_inspectedby' AND ";

$sql = substr($sql, 0, -4);

$query = mysql_query($sql);

$numrows = mysql_num_rows($query);
?>
RESULTS - <?php echo $numrows; ?>
<hr>
<table width='500'><tr><td><b>Date</b></td><td><b>Lot Number</b></td><td><b>PO</b></td><td> </td></tr>
<tr>
<td> </td>
</tr>
<?php
while ($row = mysql_fetch_assoc($query))
{
$id = stripslashes($row['id']);
$report_lot_number = stripslashes($row['report_lot_number']);
$report_po = stripslashes($row['report_po']);
$report_date = stripslashes($row['report_date']);

echo "<tr>
<td>" . $report_date . "</td></td><td>" . $report_lot_number . "</td><td>" . $report_po . "</td><td><a href='view_report.php?id=" . $id . "'>View</a></td>
</tr>";
}
echo '</table><br><br><br><hr><br><br>';

}

?>
All the variables are passed from a HTML form with $_POST. I need the search to work like this: If there is a value in a form field then the query gets appended with that value but when it gets to the $search_commodity it needs to search the second table (qc_lots) and check for the results. Any results that match have to be matched to the results from the first table (qc_reports) and display (echo) only qc_reports that match to both tables. The only common field is the report_id on the qc_lots table and the id on the qc_reports table.

I'm stuck and need some guidance. Can someone help please?

Working Out A Grand Total From Multiple Mysql Tables

Similar Tutorials

View Content

Basically I want to add up multiple tables and display a grand total on my page when the radio button is pressed. The radio button has values that connect to my database and the values link to and ID with a price. How can I use this code in order to work out a grand total? Many thanks. I have searched everywhere but found nothing.

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

{

echo implode($error);

}
}
?>
<form method="post" enctype="multipart/form-data" action="upload_images.php">
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="file" name="image[]" /><br />
<input type="submit" name="submit" value="Upload">
</form>

Thanks

Need Help - Upload Images

Similar Tutorials

View Content

Hi there, I need a little help... I have simple form/code for upload image and insert it into db, and its working.

<form name="unos" action="" method="post" enctype="multipart/form-data">

<select name="kategorija">
<option value="1">Album</option>
</select>

<input type="file" name="uploaded_file[]" id="file" >

</form>

<?PHP
include "config.php";

$uploads_dir = 'slike';
foreach ($_FILES["uploaded_file"]["error"] as $key => $error) {
    if ($error == UPLOAD_ERR_OK) {
        $tmp_name = $_FILES["uploaded_file"]["tmp_name"][$key];
        $name = $_FILES["uploaded_file"]["name"][$key];
        move_uploaded_file($tmp_name, "$uploads_dir/$name");
    }
}

$sql="INSERT INTO galerija_slike (kategorija_id, url_slike) 
VALUES ('".$_POST['kategorija']."', '".$_FILES['uploaded_file']['name'][$key]."')";

if (mysql_query($sql))
{
	echo "success";
} else {
	echo "error" . mysql_error();
}
?>

How can I store more image url's from input fields? When I add more input fields..... move_uploaded_file(): uploads all images, but I don't know how to also add them in db? I need something like this:

<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >
<input type="file" name="uploaded_file[]" id="file" >

Thanks
Edited by Hrvoje, 02 February 2015 - 12:17 AM.

Need Help - Upload Few Images?

Similar Tutorials

View Content

Hello...

I have some simple code but no ideas for upload another image??
PHP stores image name in database but there is no second picture uploaded in the images/ folder.

Pls help.
Thanks

if ((($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
|| ($_FILES["file"]["type"] == "image/png")
|| ($_FILES["file"]["type"] == "image/pjpeg"))
&& ($_FILES["file"]["size"] < 2000000))
  {
  if ($_FILES["file"]["error"] > 0)
    {
    echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
    }
  else
    {
    echo "<strong>Slika:</strong> " . $_FILES["file"]["name"] . "<br />";
    echo "<strong>Format slike:</strong> " . $_FILES["file"]["type"] . "<br />";
    echo "<strong>Velicina:</strong> " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
    echo "<strong>Temp file:</strong> " . $_FILES["file"]["tmp_name"] . "<br />";

//  here is mistake???

      move_uploaded_file($_FILES["file"]["tmp_name"],
      "images/" . $_FILES["file"]["name"]);

//


$sql="INSERT INTO test (name, something, slika, slika2)
VALUES ('".$_POST['name']."', '".$_POST['something']."', '".$_FILES['file']['name']."', '".$_FILES['slika1']['name']."')";

if (mysql_query($sql))

{

    echo "Sucess";

} else {

    echo "Error" . mysql_error();

}
}
}
  else
  {
  echo "Invalid file";
  }
?>

Loop To Insert Multiple Rows (multiple Mysql Connections??) Help Please!

Similar Tutorials

View Content

Ok I'm trying to insert multiple rows by using a while loop but having problems. At the same time, need to open a new mysql connection while running the insert query, close it then open the previous mysql connection.

I managed to insert multiple queries before using a loop, but for this time, the loop does not work?
I think it is because I am opening another connection... yh that would make sense actually?

Here is the code:

$users = safe_query("SELECT * FROM ".PREFIX."user");
       while($dp=mysql_fetch_array($users)) {

$username = $dp['username'];
$nickname = $dp['nickname'];
$pwd1 = $dp['password'];
$mail = $dp['email'];
$ip_add = $dp['ip'];
$wsID = $dp['userID'];
$registerdate = $dp['registerdate'];
$birthday = $dp['birthday'];
$avatar = $dp['avatar'];
$icq = $dp['icq'];
$hp = $dp['homepage'];

echo $username." = 1 username only? :(";


// ----- Forum Bridge user insert -----

$result = safe_query("SELECT * FROM `".PREFIX."forum`");
$ds=mysql_fetch_array($result);
$forum_prefix = $ds['prefix'];
define(PREFIX_FORUM, $forum_prefix);
define(FORUMREG_DEBUG, 0);

$con = mysql_connect($ds['host'], $ds['user'], $ds['password']) or system_error('ERROR: Can not connect to MySQL-Server');
$condb = mysql_select_db($ds['db'], $con) or system_error('ERROR: Can not connect to database "'.$ds['db'].'"');

include('../_phpbb_func.php');
$phpbbpass = phpbb_hash($pwd1);
$phpbbmailhash = phpbb_email_hash($mail);
$phpbbsalt = unique_id();

safe_query("INSERT INTO `".PREFIX_FORUM."users` (`username`, `username_clean`, `user_password`, `user_pass_convert`, `user_email`, `user_email_hash`, `group_id`, `user_type`, `user_regdate`, `user_passchg`, `user_lastvisit`, `user_lastmark`, `user_new`, `user_options`, `user_form_salt`, `user_ip`, `wsID`, `user_birthday`, `user_avatar`, `user_icq`, `user_website`) VALUES ('$username', '$username', '$phpbbpass', '0', '$mail', '$phpbbmailhash', '2', '0', '$registerdate', '$registerdate', '$registerdate', '$registerdate', '1', '230271', '$phpbbsalt', '$ip_add', '$wsID', '$birthday', '$avatar', '$icq', '$hp')");
if (FORUMREG_DEBUG == '1') {
echo "<p><b>-- DEBUG -- : User added: ".mysql_affected_rows($con)."<br />";
       echo "<br />-- DEBUG -- : Query used: ".end($_mysql_querys)."</b></p><br />";

       $result = safe_query("SELECT user_id from ".PREFIX_FORUM."users WHERE username = '$username'");
       $phpbbid = mysql_fetch_row($result);
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('2', '$phpbbid[0]', '0', '0')");
safe_query("INSERT INTO `".PREFIX_FORUM."user_group` (`group_id`, `user_id`, `group_leader`, `user_pending`) VALUES ('7', '$phpbbid[0]', '0', '0')");
mysql_close($con);
}

         include('../_mysql.php');
         mysql_connect($host, $user, $pwd) or system_error('ERROR: Can not connect to MySQL-Server');
mysql_select_db($db) or system_error('ERROR: Can not connect to database "'.$db.'"');

       }

So I need to be able to insert these rows using the while loop.. how can I do this?

I really appreciate any help.

Images Not Resizing On Upload

Similar Tutorials

View Content

Hi

I am trying to resize images as they are uploaded. The problem I have is that the image is uploading and adding to the database, but is not resizing.

The code I am using is below

Code: [Select]
<?php
include("config.inc.php");
    include('../includes/connect_inc.php');

// initialization
$result_final = "";
$counter = 0;

// List of our known photo types
$known_photo_types = array(
'image/pjpeg' => 'jpg',
'image/jpeg' => 'jpg',
'image/gif' => 'gif',
'image/bmp' => 'bmp',
'image/x-png' => 'png'
);

// GD Function List
$gd_function_suffix = array(
'image/pjpeg' => 'JPEG',
'image/jpeg' => 'JPEG',
'image/gif' => 'GIF',
'image/bmp' => 'WBMP',
'image/x-png' => 'PNG'
);

// Fetch the photo array sent by add-photos.php
$photos_uploaded = $_FILES['photo_filename'];

// Fetch the photo caption array
$photo_caption = $_POST['photo_caption'];

while( $counter <= count($photos_uploaded) )
{
if($photos_uploaded['size'][$counter] > 0)
{
if(!array_key_exists($photos_uploaded['type'][$counter], $known_photo_types))
{
$result_final .= "File ".($counter+1)." is not a photo<br />";
}
else
{
mysql_query( "INSERT INTO gallery_photos(`photo_filename`, `photo_caption`, `photo_category`) VALUES('0', '".addslashes($photo_caption[$counter])."', '".addslashes($_POST['category'])."')" );
$new_id = mysql_insert_id();
$filetype = $photos_uploaded['type'][$counter];
$extention = $known_photo_types[$filetype];
$filename = $new_id.".".$extention;

mysql_query( "UPDATE gallery_photos SET photo_filename='".addslashes($filename)."' WHERE photo_id='".addslashes($new_id)."'" );
                //resize photos to maximum height or width
                //define parameters - maximum height & width for new images
                $image_max_width=599;
                $image_max_height=599;
                $max_dimension=800;
                // Grab the width and height of the image.
                list($width,$height) = getimagesize($_FILES['photo_filename']);
                // If the max width input is greater than max height we base the new image off of that, otherwise we
                // use the max height input.
                // We get the other dimension by multiplying the quotient of the new width or height divided by
                // the old width or height.
                if($image_max_width > $image_max_height){
                if($image_max_width > $max_dimension){
                $newwidth = $max_dimension;
                } else {
                $newwidth = $image_max_width;
                }
                $newheight = ($newwidth / $width) * $height;
                } else {
                if($image_max_height > $max_dimension){
                $newheight = $max_dimension;
                } else {
                $newheight = $image_max_height;
                }
                $newwidth = ($newheight / $height) * $width;
                }
                // Create temporary image file.
                $tmp = imagecreatetruecolor($newwidth,$newheight);
                // Copy the image to one with the new width and height.
                imagecopyresampled($tmp,$image,0,0,0,0,$newwidth,$newheight,$width,$height);
                //end of resizing
// Store the orignal file
copy($photos_uploaded['tmp_name'][$counter], $images_dir."/".$filename);

// Let's get the Thumbnail size
$size = GetImageSize( $images_dir."/".$filename );
if($size[0] > $size[1])
{
$thumbnail_width = 100;
$thumbnail_height = (int)(100 * $size[1] / $size[0]);
}
else
{
$thumbnail_width = (int)(100 * $size[0] / $size[1]);
$thumbnail_height = 100;
}

// Build Thumbnail with GD 1.x.x, you can use the other described methods too
$function_suffix = $gd_function_suffix[$filetype];
$function_to_read = "ImageCreateFrom".$function_suffix;
$function_to_write = "Image".$function_suffix;

// Read the source file
$source_handle = $function_to_read ( $images_dir."/".$filename );

if($source_handle)
{
// Let's create an blank image for the thumbnail
      $destination_handle = ImageCreate ( $thumbnail_width, $thumbnail_height );

// Now we resize it
       ImageCopyResized( $destination_handle, $source_handle, 0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1] );
}

// Let's save the thumbnail
$function_to_write( $destination_handle, $images_dir."/tb_".$filename );
ImageDestroy($destination_handle );
//

$result_final .= "<img src='".$images_dir. "/tb_".$filename."' /> File ".($counter+1)." Added<br />";
}
}
$counter++;
}
    header('Location: add-photos.php');
// Print Result
echo <<<__HTML_END

<html>
<head>
<title>Photos uploaded</title>
</head>
<body>
$result_final
</body>
</html>

__HTML_END;
?>

Any help would be appreciated.

Upload To Multiple Directories

Similar Tutorials

View Content

I have one input upload and need it to go to two directories here is my upload code that handles the move_upload_file portion.
Code: [Select]
move_uploaded_file($_FILES['fillPDF']['tmp_name'], $strNewsPath . $strFilename);
Thanks in advance.

Multiple Image Upload

Similar Tutorials

View Content

i have done a coding for image multiple upload , the coding is working perfectly when i store image in the image folder but when trying to insert the image name in database its not working.
important thing is while we store the value of images it should store in single column seperated with comma or special character. like this

id image
1 car.jpg,bike.jpg,sun.jpg

pls help to me, thanks in advance.

Here is the code.
img.php
<?php
$max_no_img=5; // Maximum number of images value to be set here
echo "<form method=post action=addimgck.php enctype='multipart/form-data'>";
echo "<table border='0' width='400' cellspacing='0' cellpadding='0' align=center>";
for($i=1; $i<=$max_no_img; $i++){
echo "<tr><td>Images $i</td><td>
<input type=file name='images[]' class='bginput'></td></tr>";
}
echo "<tr><td colspan=2 align=center><input type=hidden name='userid' value='68'></td></tr>";

echo "<tr><td colspan=2 align=center><input type=submit value='Add Image'></td></tr>";

echo "</form> </table>";

?>

addimgck.php

<?php
ini_set('display_errors', 1);
ini_set('error_reporting', E_ALL);
function findexts ($filename) { $filename = strtolower('$filename') ;
$exts = preg_split("[/\\.]", $filename) ;
$n = count($exts)-1;
$exts = $exts[$n];
return $exts;
}

$ext = findexts ($_FILES['images']['name']) ;
$ran = rand ();
$ran2 = $ran.".";

while(list($key,$value) = each($_FILES['images']['name']))
{
if(!empty($value))
{
$filename = $ran.$value;
$filename=str_replace(" "," _ ",$filename);// Add _ inplace of blank space in file name, you can remove this line

$add = "images/$filename";
$insert_query = 'insert into image (

photo

)
values
(

"'.$filename.'"
)';
//echo $_FILES['images']['type'][$key];
// echo "<br>";
copy($_FILES['images']['tmp_name'][$key], $add);
chmod("$add",0777);

mysql_query($insert_query);

}

}

?>

Multiple Photo Upload

Similar Tutorials

View Content

Hey guys,

I am a newb but trying to figure out how I can upload multiple associated photo files. My code is working for one photo, however I would like to have multiple photos that are associated uploaded at the same time. I would like the photos save in a format such as: photo_filename1 = 100, photo_filename2 = 100_a

I am using the following code with no luck, not sure how I can work this.

Any help is much appreciated!!! Thanks in advance.

<code>
<?php
   include("config.inc.php");

   // initialization
   $result_final = "";
   $counter = 0;

   // List of our known photo types
   $known_photo_types = array(
                  'image/pjpeg' => 'jpg',
                  'image/jpeg' => 'jpg',
                  'image/gif' => 'gif',
                  'image/bmp' => 'bmp',
                  'image/x-png' => 'png'
               );

   // GD Function List
   $gd_function_suffix = array(
                  'image/pjpeg' => 'JPEG',
                  'image/jpeg' => 'JPEG',
                  'image/gif' => 'GIF',
                  'image/bmp' => 'WBMP',
                  'image/x-png' => 'PNG'
               );

   // Fetch the photo array sent by preupload.php
   $photos_uploaded1 = $_FILES['photo_filename1'];
   $photos_uploaded2 = $_FILES['photo_filename2'];

   // Fetch the photo caption array
   $photo_caption = $_POST['photo_caption'];

   while( $counter <= count($photos_uploaded1) )
   {
      if($photos_uploaded1['size'][$counter] > 0)
      {
         if(!array_key_exists($photos_uploaded1['type'][$counter], $known_photo_types))
         {
            $result_final .= "File ".($counter+1)." is not a photo<br />";
         }
         else
         {
            mysql_query( "INSERT INTO gallery_photos(`photo_filename1`, `photo_caption`, `photo_category`) VALUES('0', '".addslashes($photo_caption[$counter])."', '".addslashes($_POST['category'])."')" );
            $new_id = mysql_insert_id();
            $filetype = $photos_uploaded1['type'][$counter];
            $extention = $known_photo_types[$filetype];
            $filename = $new_id.".".$extention;

            mysql_query( "UPDATE gallery_photos SET photo_filename1='".addslashes($filename)."' WHERE photo_id='".addslashes($new_id)."'" );

            // Store the orignal file
            copy($photos_uploaded1['tmp_name'][$counter], $images_dir."/".$filename);

            // Let's get the Thumbnail size
            $size = GetImageSize( $images_dir."/".$filename );
            if($size[0] > $size[1])
            {
               $thumbnail_width = 100;
               $thumbnail_height = (int)(100 * $size[1] / $size[0]);
            }
            else
            {
               $thumbnail_width = (int)(100 * $size[0] / $size[1]);
               $thumbnail_height = 100;
            }

            // Build Thumbnail with GD 1.x.x, you can use the other described methods too
            $function_suffix = $gd_function_suffix[$filetype];
            $function_to_read = "ImageCreateFrom".$function_suffix;
            $function_to_write = "Image".$function_suffix;

            // Read the source file
            $source_handle = $function_to_read ( $images_dir."/".$filename );

            if($source_handle)
            {
               // Let's create an blank image for the thumbnail
                  $destination_handle = ImageCreate ( $thumbnail_width, $thumbnail_height );

               // Now we resize it
              ImageCopyResized( $destination_handle, $source_handle, 0, 0, 0, 0, $thumbnail_width, $thumbnail_height, $size[0], $size[1] );
            }

            // Let's save the thumbnail
            $function_to_write( $destination_handle, $images_dir."/tb_".$filename );
            ImageDestroy($destination_handle );
            //

            $result_final .= "<img src='".$images_dir. "/tb_".$filename."' /> File ".($counter+1)." Added<br />";
         }
      }
   $counter++;
   }

//file2
while( $counter <= count($photos_uploaded2) )
   {
      if($photos_uploaded2['size'][$counter] > 0)
      {
         if(!array_key_exists($photos_uploaded2['type'][$counter], $known_photo_types))
         {
            $result_final2 .= "File ".($counter+1)." is not a photo<br />";
         }
         else
         {
            mysql_query( "INSERT INTO gallery_photos(`photo_filename2`) VALUES('0')" );
            $new_id = mysql_insert_id();
            $filetype = $photos_uploaded2['type'][$counter];
            $extention = $known_photo_types[$filetype];
            $filename = $new_id."_1.".$extention;

            mysql_query( "UPDATE gallery_photos SET photo_filename2='".addslashes($filename)."' WHERE photo_id='".addslashes($new_id)."'" );

            // Store the orignal file
            copy($photos_uploaded2['tmp_name'][$counter], $images_dir."/".$filename);


            $result_final2 .= "<img src='".$images_dir. "/tb_".$filename."' /> File ".($counter+1)." Added<br />";
         }
      }
   $counter++;
   }

   // Print Result
echo <<<__HTML_END

<html>
<head>
   <title>Photos uploaded</title>
</head>
<body>
   $result_final $result_final2
</body>
</html>

__HTML_END;
?>

</code>