PHP - Real Estate Listing With Multiple Images.

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?

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

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>
          &gt;
          <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 &quot;and&quot; <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>&nbsp;
              </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">&nbsp;</td>
            <td style="text-align: center">&nbsp;</td>
            <td style="text-align: center">&nbsp;</td>
            <td style="text-align: center">&nbsp;</td>
          </tr>
          <tr>
            <td colspan="2" style="text-align: center">&nbsp;</td>
            <td style="text-align: center">&nbsp;</td>
            <td style="text-align: center">&nbsp;</td>
            <td style="text-align: center">&nbsp;</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">&nbsp;</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">&nbsp;</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');
}
}
}
 
?>

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

Dear all,
I have a problem that I need to be helped with using one form and storing the images in database. I would like to upload multiple images with same title from "title" field.
Can somebody help me with this?

<?php
$db_host = 'localhost'; // don't forget to change 
$db_user = 'mysql-user'; 
$db_pwd = 'mysql-password';

$database = 'test';
$table = 'ae_gallery';
// use the same name as SQL table

$password = '123';
// simple upload restriction,
// to disallow uploading to everyone


if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

// This function makes usage of
// $_GET, $_POST, etc... variables
// completly safe in SQL queries
function sql_safe($s)
{
    if (get_magic_quotes_gpc())
        $s = stripslashes($s);

    return mysql_real_escape_string($s);
}

// If user pressed submit in one of the forms
if ($_SERVER['REQUEST_METHOD'] == 'POST')
{
    // cleaning title field
    $title = trim(sql_safe($_POST['title']));

    if ($title == '') // if title is not set
        $title = '(empty title)';// use (empty title) string

    if ($_POST['password'] != $password)  // cheking passwors
        $msg = 'Error: wrong upload password';
    else
    {
        if (isset($_FILES['photo']))
        {
            @list(, , $imtype, ) = getimagesize($_FILES['photo']['tmp_name']);
            // Get image type.
            // We use @ to omit errors

            if ($imtype == 3) // cheking image type
                $ext="png";   // to use it later in HTTP headers
            elseif ($imtype == 2)
                $ext="jpeg";
            elseif ($imtype == 1)
                $ext="gif";
            else
                $msg = 'Error: unknown file format';

            if (!isset($msg)) // If there was no error
            {
                $data = file_get_contents($_FILES['photo']['tmp_name']);
                $data = mysql_real_escape_string($data);
                // Preparing data to be used in MySQL query

                mysql_query("INSERT INTO {$table}
                                SET ext='$ext', title='$title',
                                    data='$data'");

                $msg = 'Success: image uploaded';
            }
        }
        elseif (isset($_GET['title']))      // isset(..title) needed
            $msg = 'Error: file not loaded';// to make sure we've using
                                            // upload form, not form
                                            // for deletion


        if (isset($_POST['del'])) // If used selected some photo to delete
        {                         // in 'uploaded images form';
            $id = intval($_POST['del']);
            mysql_query("DELETE FROM {$table} WHERE id=$id");
            $msg = 'Photo deleted';
        }
    }
}
elseif (isset($_GET['show']))
{
    $id = intval($_GET['show']);

    $result = mysql_query("SELECT ext, UNIX_TIMESTAMP(image_time), data
                             FROM {$table}
                            WHERE id=$id LIMIT 1");

    if (mysql_num_rows($result) == 0)
        die('no image');

    list($ext, $image_time, $data) = mysql_fetch_row($result);

    $send_304 = false;
    if (php_sapi_name() == 'apache') {
        // if our web server is apache
        // we get check HTTP
        // If-Modified-Since header
        // and do not send image
        // if there is a cached version

        $ar = apache_request_headers();
        if (isset($ar['If-Modified-Since']) && // If-Modified-Since should exists
            ($ar['If-Modified-Since'] != '') && // not empty
            (strtotime($ar['If-Modified-Since']) >= $image_time)) // and grater than
            $send_304 = true;                                     // image_time
    }


    if ($send_304)
    {
        // Sending 304 response to browser
        // "Browser, your cached version of image is OK
        // we're not sending anything new to you"
        header('Last-Modified: '.gmdate('D, d M Y H:i:s', $ts).' GMT', true, 304);

        exit(); // bye-bye
    }

    // outputing Last-Modified header
    header('Last-Modified: '.gmdate('D, d M Y H:i:s', $image_time).' GMT',
            true, 200);

    // Set expiration time +1 year
    // We do not have any photo re-uploading
    // so, browser may cache this photo for quite a long time
    header('Expires: '.gmdate('D, d M Y H:i:s',  $image_time + 86400*365).' GMT',
            true, 200);

    // outputing HTTP headers
    header('Content-Length: '.strlen($data));
    header("Content-type: image/{$ext}");

    // outputing image
    echo $data;
    exit();
}
?>
<html><head>
<title>MySQL Blob Image Gallery Example</title>
</head>
<body>
<?php
if (isset($msg)) // this is special section for
                 // outputing message
{
?>
<p style="font-weight: bold;"><?=$msg?>
<br>
<a href="<?=$PHP_SELF?>">reload page</a>
<!-- I've added reloading link, because
     refreshing POST queries is not good idea -->
</p>
<?php
}
?>
<h1>Blob image gallery</h1>
<h2>Uploaded images:</h2>
<form action="<?=$PHP_SELF?>" method="post">
<!-- This form is used for image deletion -->

<?php
$result = mysql_query("SELECT id, image_time, title FROM {$table} ORDER BY id DESC");
if (mysql_num_rows($result) == 0) // table is empty
    echo '<ul><li>No images loaded</li></ul>';
else
{
    echo '<ul>';
    while(list($id, $image_time, $title) = mysql_fetch_row($result))
    {
        // outputing list
        echo "<li><input type='radio' name='del' value='{$id}'>";
        echo "<a href='{$PHP_SELF}?show={$id}'>{$title}</a> &ndash; ";
        echo "<small>{$image_time}</small></li>";
    }

    echo '</ul>';

    echo '<label for="password">Password:</label><br>';
    echo '<input type="password" name="password" id="password"><br><br>';

    echo '<input type="submit" value="Delete selected">';
}
?>

</form>
<h2>Upload new image:</h2>
<form action="<?=$PHP_SELF?>" method="POST" enctype="multipart/form-data">
<label for="title">Title:</label><br>
<input type="text" name="title" id="title" size="64"><br><br>

<label for="photo">Photo:</label><br>
<input type="file" name="photo" id="photo"><br><br>

<label for="password">Password:</label><br>
<input type="password" name="password" id="password"><br><br>

<input type="submit" value="upload">
</form>
</body>
</html>

Hi I'm using an IP database to correctly (+/-) serve related ads based on country. This seems to work fine BUT when tested on a USA proxy (I'm in the UK) I am getting TWO ads served, one for USA (correctly) and one for the UK (proxy error?). When surfing via proxy from the Netherlands I get no image at all.

Looking for somebody to see what I've done wrong he


$server   = 'localhost'; // MySQL hostname
$username = '***'; // MySQL username
$password = '***'; // MySQL password
$dbname   = '***'; // MySQL db name


$db = mysql_connect($server, $username, $password) or die(mysql_error());
      mysql_select_db($dbname) or die(mysql_error());

$sql = 'SELECT
            country
        FROM
            ip2nation
        WHERE
            ip < INET_ATON("'.$_SERVER['REMOTE_ADDR'].'")
        ORDER BY
            ip DESC
        LIMIT 0,1';

list($country) = mysql_fetch_row(mysql_query($sql));

switch ($country) {
case 'us':
// Image or USA
echo '<img src="impact/samsungN210PLUS_usa.jpg">';

case 'uk':
// Image for UK
echo '<img src="impact/samsungN210PLUS_uk.jpg">';

default:
// Image for everybody else (europe)
echo '<img src="impact/samsungN210PLUS_europe.jpg">';
end;
}


echo '<div width="420" class="loc"><span  class="loc" align="center">Not from ';


$sql = 'SELECT
            c.country
        FROM
            ip2nationCountries c,
            ip2nation i
        WHERE
            i.ip < INET_ATON("'.$_SERVER['REMOTE_ADDR'].'")
            AND
            c.code = i.country
        ORDER BY
            i.ip DESC
        LIMIT 0,1';

list($countryName) = mysql_fetch_row(mysql_query($sql));

// Output full country name
echo $countryName;
$domain = str_replace("www.","", $_SERVER['HTTP_HOST']);
 echo '? Choose your flag: <a href="http://uk.' .$domain. '"><img src="images/flags/ukflag.gif"></a>&nbsp;<a href="http://usa.' .$domain. '"><img src="images/flags/usaflag.gif"></a>&nbsp;<a href="http://europe.' .$domain. '"><img  src="images/flags/euflag.gif"></a></span></div>';





All help appreciated and thanks in advance.

PS. The script is working he http://darrenbassett.com/trial if somebody in the USA wishes to check and let me kow if it is a proxy surfing error (seeing BOTH IP's). Not a real website just a 'play' page to get the bones of the script working.

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

Hey guys I have found this peice of code and messed around with it. I got it to work with Thickbox and I would like to know how to seperate my images aka files to every 4th column. Heres the code I found and tweaked. The images would look great if it was every 4th column they break. Also where would I place he echo command if I want it to display information about that image. Heres the code...
Code: [Select]
<?

/**
 * Change the path to your folder.
 *
 * This must be the full path from the root of your
 * web space. If you're not sure what it is, ask your host.
 *
 * Name this file index.php and place in the directory.
 */

    // Define the full path to your folder from root
    $path = "images/default/";

    // Open the folder
    $dir_handle = @opendir($path) or die("Unable to open $path");

    // Loop through the files
    while ($file = readdir($dir_handle)) {

    if($file == "." || $file == ".." || $file == "default.php" )

        continue;
        echo "<a href=\"images/default/$file\" class=\"thickbox\"><img src=\"images/default/$file\" height=\"150\" width=\"150\" border=\"0\"></a>";

    }

    // Close
    closedir($dir_handle);

?> 

Getting an unexpected end error on this and unsure as to why.

Code: [Select]
<?php if($players['is_banned'] == 1) { ?>
<a href="profile.php?id=<?php echo $players['id'] ?>"><?php echo $players['name']  ?> (BANNED)
<? }else{ ?>
<a href="profile.php?id=<?php echo $players['id'] ?>"><?php echo $players['name']  ?>
<? } ?>

Ok so I don't even know where to start with this idea so I thought I would poke around here for some inspiration. On my server I have a Directory. In that directory I have roughly 300 folders with 5,000 files + 1 index.php (so 5,001 files but I want to ignore the index.php in the listings) per directory. Anyway what I am trying to do is list all the files and load them into a database. What my ideal goal would be is device a script that I would put in the root directory with the 300 or so subdirectories and let it run through the directories automatically one by one, listing all the files in them and then storing them in the database. I'd break it down more but that part I can figure out on my own cause I do want to do more than just store the file names and corresponding directory its in in the DB. My issue is I can find anything or figure anything out that will cycle through all directories, thats what I need to figure out first.

I have a mysql database set up with 4 fields - id, month, day, event. The database will be filled with something like: month=Jan, day=4 and event=Meeting. All are text fields. The display will be Jan. 4: Meeting

I can set up the PHP to display the database in a unordered list. The code for this is:

<?php

$result = @mysql_query("SELECT id, month, day, event FROM homecalendar");

if (!$result) {
      exit('<p>Error performing query: ' . mysql_error() . '</p>');
      }
while ($row = mysql_fetch_array($result)) {

echo '<li>' . $row['month'] . $row['day'] .': ' . $row['event'] . '</li>'  ; 

}

?>

How can I limit the code to display items for only the current month and the next month?

Hi everyone,

If I have a line like this:
$nfn = $brand . $model;

then when the variable is echoed ($nfn) will come out like nikeair, how can I save it with a space so when echoed it will display nike air?

Cheers

Hello guys,

I have been searching on the internet for articles that shows me how to get the real IP address when they are behind a proxy. But after some reading it seems that this is not completely possible. Correct me if I'm wrong.

So what is the best thing to do? Because I have seen different methodes and I'm not sure which one is the best.

http://www.laughing-buddha.net/php/lib/remoteip

I am trying to have an event with each performance listed for the event underneath. I have worked with the MySQL Forum and have gotten to the point where my coding for MySQL is complete, but it still will not work. I was told from the MySQL Forum group that I need to now post these in this forum...

Here's how I tried the coding:
Code: [Select]
<p class="categoryHeader">Theatre</p><?php
$last_eventtitle = NULL; // remember the last EventTitle
while ($Row = mysqli_fetch_assoc($TheatreResult)){
$eventtitle = $Row['EventTitle'];
if($last_eventtitle != $eventtitle){ // a new or the first EventTitle was found
echo '<p>';
if($Row['Ranking']<10){
echo '<img src="http://www.myalaskacenter.com/images/logos/acpa/weblogo-small_nowords.jpg" alt="Alaska Center for the Performing Arts" width="80" height="80" border="0" align="right">';
}
if ($Row['FreeEvents']==TRUE){
echo '<img src="http://www.myalaskacenter.com/images/free.gif" alt="Free Event" width="67" height="64" align="right" border="0">';
}
echo '<a href="' . $Row['ShoWareEventLink'] . '"><img src="https://alaskapac.centertix.net/UPLImage/' . $Row['thumb'] . '" alt="' . $Row['EventTitle'] . '" title="' . $Row['EventTitle'] . '" align="left" border="0" style="padding-right:5px"><span class="Heading3_blue"><br />' . $Row['EventTitle'] . '</span>';
echo '<br />Presented by <a href="' . $Row['website'] .'" target="_blank">' . $Row['Presenter']  . '</a><br />';
if($last_eventtitle != NULL){ // not the first EventTitle, close out the previous section
echo '<br />'.date("l, F j, Y", strtotime($Row['startDateTime']). ' at ' . date("g:i a", strtotime($Row['startDateTime']))).' - <a href="'.$Row['VenueSite'].'" target="_blank">'.$Row['VenueName'].'</a>';
}
$last_eventtitle = $eventtitle; // save the new EventTitle
// output the heading/start a new section
echo '<br />'.date("l, F j, Y", strtotime($Row['startDateTime']). ' at ' . date("g:i a", strtotime($Row['startDateTime']))).' - <a href="'.$Row['VenueSite'].'" target="_blank">'.$Row['VenueName'].'</a>';
echo '<br /><br /></p><hr>';
}
}
?>
Now it lists the first performances correctly; although it does NOT list the correct number of performances and the first performance is sometimes listed twice -- so almost there. See webpage http://www.myalaskacenter.com/centermail/_upcomingevents.php. For example, Anchorage Youth Symphony only has one performance, but it lists 2; while It's a Wonderful Life has 17 performances, but it lists only 2. What am I doing wrong still?