Learn VBA & Macros in 1 Week!

PHP - Upload And Replace Multiple Images

Full Excel VBA Course - Beginner to Expert

Upload And Replace Multiple Images	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');
}
}
}

?>

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

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?

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 In Mysql Not Working

Similar Tutorials

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

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

Pair Array Results To Replace Images

Similar Tutorials

View Content

hi, i am trying to visualize a table by replacing the fixed values with images.
For example, i have a visitor statistics table on mysql. Values on the config_os table are always in three letters. WI7 for Windows7, MAC for Macintosh. I hope I can tell this correctly.
I have a display page which retrieves the values from database and displays them website statistics.
But in order to make it more cool, i am telling to PHP that When you echo to divtable WI7, replace them with specified Windows7 icon image which has identical name as WI7.gif. Here is the code:

Code: [Select]
include("conn.php");
$sql="SELECT *, INET_NTOA(location_ip) AS location_ip FROM xx_log_visit AS location_ip ORDER BY idvisit DESC LIMIT 10";
// I am selecting all so you can't see config_os but it is there . I cropped unnecessary code for keeping it easy to read.

$result=mysql_query($sql);
$numofrows = @mysql_num_rows($result);

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

$system = $row['config_os'];
$SysName = array ("AND", "IPH", "LIN", "MAC", "UNK", "W2K", "W95", "W98", "WI7", "WME", "WNT", "WOS", "WS3", "WVI", "WXP");
$SysRename = array ("<img src='images/os/AND.gif'>","<img src='images/os/IPH.gif'>","<img src='images/os/LIN.gif'>","<img src='images/os/MAC.gif'>","<img src='images/os/UNK.gif'>","<img src='images/os/W2K.gif'>","<img src='images/os/W95.gif'>","<img src='images/os/W98.gif'>","<img src='images/os/wi7.gif'>","<img src='images/os/WME.gif'>","<img src='images/os/WNT.gif'>","<img src='images/os/WOS.gif'>","<img src='images/os/WS3.gif'>","<img src='images/os/WVI.gif'>","<img src='images/os/WXP.gif'>");
$showsystem= str_replace($SysName, $SysRename, $system);
What I do here is simply use strreplace function.

$showsystem = str_replace($SysName, $SysRename, $system);

and in the display table, continue from code:

Code: [Select]
echo ("
<div class='sub15'>$showsystem</div>
" );
}
So for example instead of writing WI7 as visitors os, it shows WI7.gif, cool hmm

How can i automate this instead of writing each of them separately?

Thanks for any help..

Replace Multiple Characters With Single Character.

Similar Tutorials

View Content

Hi, I believe this is my first post on here. First off let me say thank you for silently helping out in the past while I keep on learning PHP.

I have decided to build an image gallery, and I am having problems with the page numbering links and the breadcrumbs.

Reson I decided to build my own is that I wanted a challange to learn more.
I could not find anything that would intregrate with the site as I wanted it to (pulled as a function so offers some customising with options).

The problem that I am having is that the <a href= tag is starting to give multipul "/"s when I only need one, so that the url at the top is coming up as

http://localhost/mmv4/gallery/pics///Ax/Ax_Jo/

when I am wanting http://localhost/mmv4/gallery/pics/Ax/Ax_Jo/IMG_4244.JPG.

I have used str_replace to catch //s and more, but this then adds odd slashes on the end so the page numbeing is getting odd results. some dirs have the / on the end and some do not, so the links are sometimes "visited" and others not.

I beleve that the problem is generated in
Code: [Select]
<?php
if(isset($_GET['album'])) {
      //load the available dirs into an array so that the sneeky users cannot get further back.
      $files = scandir($gal);
      $dirs = array();
      foreach($files as $file){
         if($file != '.' && $file != '..' && $file != 'thumbs') {
            if(is_dir($gal."/".$file)) {
               $dirs[] = $file;
               //echo $file ."<br />\n";
            }
         }
      }

      //if(in_array($_GET['album'],$dirs)) {
         $album = "/".$_GET['album']."/";
         $album = str_replace("..", "", $album);
      //}
      //else {
      //   $output .= "<p>There is no album called \"$_GET[album]\", please select an album from below.</p>";
      //}
   }

or the breadcrumbs bit
Code: [Select]
<?php
if($crumbs == 1) {
      //bread crums
       $path = $gal.$album;
       $path = explode("/", $path);


       $crumbs = array();
       foreach($path as $key => $value) {
          if($value != ""){
             $crumbs[] = $value;
          }
       }
       // create Breadcrumbs div

       $output .= "<div id=\"breadcrumbs\">";
       $number = count($crumbs);
       $real = "";
       foreach($crumbs as $num => $link) {
          if ($link == $gal) {
             $link = "Gallery Home";
          }
          if ($num == $number -1) {
             $output .= $link;
          }
          else{
             if ($num >= 1){
                $real ="";
                for($x=1; $x<=$num; $x++) {
                   $real .= "/".$crumbs[$x];
                }
                $output .= "<a href=\"?album=".str_replace("/", "",$real)."\">".$link."</a>"." <- ";
             }
             else{
                $output .= "<a href=\"?album=".str_replace("/", "",$real)."\">".$link."</a>"." <- ";
             }
          }
          $num +1;

       }

       //close breadcrumbs div
       $output .= "</div>";
   }

Can any one please help me shed some light on this one, I am confused.
I can send / attach the full source if needed.

MOD EDIT: tags fixed for syntax highlighting . . .

Multi File Upload. Go Back To Edit Mode & Replace A File.

Similar Tutorials

View Content

In this multi file upload form, choose three images, click submit and preview the images on the preview page. If the user wishes to delete or replace an image, click edit and the form will go back to the previous page. Select the replace radio button for example on one of the three images and select a new image from the file input prompt and click submit. The form will go to the preview page again to display the images. During this process the image names are being input into a table and the images are being moved to a directory.

The table is

`id` AUTO_INCREMENT,
`image0`
`image1`
`image2`
`status`

So input name='image[image0]' can be directed to table `image0` and so on.

The code for keep and delete work fine, but how do I replace an image?
I have two foreach blocks. The first one deletes the image file from the directory and deletes the image name from the table, but the second foreach dose not move the new image file into the directory.
Thanks.

<input type='radio' name='image[image0]' value='keep' checked='checked'/>
<input type='radio' name='image[image0]' value='delete' />
<input type='radio' name='image[image0]' value='replace' />
<input type="file" name="image[]" />

<input type='radio' name='image[image1]' value='keep' checked='checked'/>
<input type='radio' name='image[image1]' value='delete' />
<input type='radio' name='image[image1]' value='replace' />
<input type="file" name="image[]" />

<input type='radio' name='image[image2]' value='keep' checked='checked'/>
<input type='radio' name='image[image2]' value='delete' />
<input type='radio' name='image[image2]' value='replace' />
<input type="file" name="image[]" />

<?php
if (isset($_POST['status'])) {

$status = $_POST['status'];
$confirm_code = $status;

#--------------------------- replace --------------------------------------------

if (isset($_POST['submitted']) &&
($image = $_POST['image'])) {

foreach($image as $imageKey => $imageValue) {
if ($imageValue == 'replace') {
$query = "SELECT $imageKey FROM table WHERE status = '$status' ";
if($result = $db->query( $query )){
$row = $result->fetch_array();
}

unlink( UPLOAD_DIR.$row[0] );

$query = "UPDATE table SET $imageKey = '' WHERE status = '$status' ";
}
}

foreach($image as $imageKey => $imageValue) {
if ($imageValue == 'replace') {

$filenm = $_FILES['image']['name'];
$file = $_FILES['image']['tmp_name'];

move_uploaded_file($file, UPLOAD_DIR . $filenm);
$filename[] = $filenm;

$query = "INSERT INTO table VALUES ('','$filename[0]','$filename[1]','$filename[2]','$confirm_code')";
}
}
}
}
?>

Comment Upload On Forum - Replace ":blobby-tired" With An Img Tag But Getting An Error When Passing To

Similar Tutorials

View Content

So I wanted to create stickers on my forum where people type in say ":Blobby-Tired" and then instead of the comment showing ":Blobby-Tired" it shows an html image tag displaying a picture of Blobby in the comment box

So I created the following page CommentUpload.php

However my sql fails to insert it despite the fact when I "echo $new" it shows the image on the page correctly

And it can't be my sql insert code as if I change $new variable for "$BodyText" int he SQL query it it inserts ":Blobby-Tired" OK?

<?php
include 'dbconnect.php';
session_start();

if(isset($_POST["submit"]) && !empty($_POST["CommentText"])){
$id = intval($_SESSION['id']);
echo  $_SESSION['id'] . '<p> </p>'   ; 
$BodyText = $conn -> real_escape_string($_POST['CommentText']) ; 
$User = $_SESSION['username'];

//Replace flairs with <img> tags 
/*not working currently) */
$new = str_replace(":Blobby-Tired","<img src='flairs/Blobby-Tired.jpg'> </img>","'$BodyText'");
echo "$new";
/************************/ 

	 $sql = "INSERT INTO Posts (User, CommentText, IdOfThread)
     VALUES ('$User','$new','$id')";
     if (mysqli_query($conn, $sql)) {
        echo "New record has been added successfully !";
     } else {
        echo "Error: " . $sql . ":-" . mysqli_error($conn);
     }


     mysqli_close($conn);

}

?>

Edited April 28 by Fishcakes

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";
  }
?>

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.

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.

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 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 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

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>

Multiple Image Upload Help

Similar Tutorials

View Content

I am trying to write a script to handle multiple image uploads however i cant get it to work i am a total novice in php so please be kind in your replys :-)

[php]
<?php

$allowed_filetypes = array('.jpg','.gif','.bmp','.png','.JPG','.PNG','.BMP','.GIF'); //These will be the types of file that will pass the validation.
$upload_path = '../pic_upload/'; // The place the files will be uploaded to.

foreach ($_FILES["pictures"]["error"] as $key => $error)
{
$filename = $_FILES['pictures']['name'][$key];
$ext = substr($filename, strpos($filename,'.'), strlen($filename)-1);

if(!empty($filename)) //is it empty
{
if ($_FILES["pictures"]["size"][$key] >= 9000000)
die ('Sorry the picture is too Big!');
}

if(!empty($filename)) //Is it empty
{
if(!in_array($ext,$allowed_filetypes)) //Is the file Allowed
die('The file you attempted to upload is not allowed! Pictures only!.');
}

if ($error == UPLOAD_ERR_OK) {
$tmp_name = $_FILES["pictures"]["tmp_name"][$key];
$name = $_FILES["pictures"]["name"][$key];
move_uploaded_file($tmp_name, "$upload_path/$ran$name");

if (!$i++) print "<!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>
<div align=\"center\"><img src=\".../image/8-1.gif\" width=\"100\" height=\"100\" /></div>
<form id=\"form1\" name=\"form1\" method=\"get\" action=\"reg.php\">
<div align=\"center\">
<input type=\"submit\" name=\"button\" id=\"button\" value=\"Submit\" />
<input type=\"hidden\" name=\"reg\" value=\"6\">
<p>\n";

print "<input type=\"hidden\" name=\"pic$key\" value=\"$ran$name\">\n";

if (!$i++) print "</p>
<p>
<label>
</div>
</label>
</p>
</form>
<p> </p>
</body>
</html>\n";

} }
?>
[php]

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.

Point Images To Upload To Different Directory

Similar Tutorials

View Content

I currently have a file upload form that uploads images to a folder on my server called "attachments". This is the directory path: www.mysite.com/docs/attachments/
However, I want the images to upload to www.mysite.com/data/attachments/ instead. I have included the relevant part of the PHP below. I have tried changing this: $cur_dir = $cur_dir."/".$dir; to this: $cur_dir = $cur_dir."www.mysite.com/data/attachments/".$dir;
and changing this: $dirs = explode("/","attachments//"); to this: $dirs = explode("www.mysite.com/data/","attachments//");
and also changing this: $_values[$file[0]."_real-name"] = "attachments/".date("YmdHis")."_".$_FILES[$file[0]]["name"]."_secure"; to this: $_values[$file[0]."_real-name"] = "www.mysite.com/data/attachments/".date("YmdHis")."_".$_FILES[$file[0]]["name"]."_secure"; But nothing has worked so far. Any suggestions would be appreciated.

foreach($files[$form] as $file){
         $str = $file[1];
         if (eval("if($str){return true;}")) {
            $_values[$file[0]] = $_FILES[$file[0]]["name"];
            $dirs = explode("/","attachments//");
            $cur_dir =".";
            foreach($dirs as $dir){
            $cur_dir = $cur_dir."/".$dir;
            if (!@opendir($cur_dir)) { mkdir($cur_dir, 0777);}}
            $_values[$file[0]."_real-name"] = "attachments/".date("YmdHis")."_".$_FILES[$file[0]]["name"]."_secure";
            copy($_FILES[$file[0]]["tmp_name"],$_values[$file[0]."_real-name"]);
            @unlink($_FILES[$file[0]]["tmp_name"]);
         }else{
          $flag=true;
          if ($_isdisplay) {
              //$ExtFltr = $file[2];
              //$FileSize = $file[4];
            if (!eval("if($file[2]){return true;}")){echo $file[3];}
            if (!eval("if($file[4]){return true;}")){echo $file[5];}
              $_ErrorList[] = $file[0];
          }
         }
      }