Editing an uploaded Image in MySQL DB

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
squire
Forum Newbie
Posts: 4
Joined: Wed Jan 26, 2005 7:22 pm
Location: Belfast, Ireland

Editing an uploaded Image in MySQL DB

Post by squire »

Hi guys,

I have been playing around with a Property Script script for a bit that allows you to add, edit and delete properites using PHP and MySQL. It also allows you to add 4 images with each property.

The problem is when editing the property I cannot edit the images or add new images related to the property. I have tried numerous methods and read numerous uploading examples but have been unable to get it to work. On the Property_Add.php page it seems that the images are put into an array, uploaded to the required directory and has a reference number attached to the beginning of the file name.

I cannot alter the Property_edit.php coding so that I can add new images or replace old images with new ones. When I try to do so it usually results in the


Can anyone provide a solution on how to edit the images in the database or show some examples or online tutorials? Any help would be greatly appreciated.

Property_Edit.php Code:

Code: Select all

<?php
 include "config.php";
if (isset($_COOKIE["ValidUserAdmin"]))
{
?><HTML> 
  <HEAD> 
	 <TITLE>Property Edit</TITLE> <LINK HREF="style.css" REL="stylesheet" TYPE="text/css"> 
  </HEAD> 
  <BODY><?PHP include "header.php"; ?>
	 <TABLE WIDTH="760" ALIGN="CENTER" CLASS="maincentre"> 
		<TR> 
		  <TD> 
			 <P><A HREF="main.php">MAIN</A> > <B>PROPERTY EDIT</B></P><BR>
			 <?php 

if (isset($_POST["op"]) && ($_POST["op"]=="editestablishment"))
{

mysql_connect($server, $DBusername, $DBpassword) or die ("$DatabaseError - 42");
mysql_select_db($database);
$result = mysql_query("SELECT * from $property_table where id = '".$_POST['id']."' LIMIT 1") or die ("$DatabaseError"); 

$row = mysql_fetch_array( $result );	
{
?>
<p><b>You have selected to edit the following property</b><br>
Please enter the new details for this property in the correct spaces below. To complete the property edit process, please 
click on the 'Update Proporty' button.</p>

<form method="post" enctype="multipart/form-data">
<input name="id" type="hidden" value="<?php print "$row[id]"; ?>">
<input name="op" type="hidden" value="UpdateProperty">


<br>

		      <TABLE WIDTH="95%" border="0" ALIGN="CENTER" CELLPADDING="5" CELLSPACING="1" BGCOLOR="#f3f3f3">
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Date:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P> <?php print "$row[DATEADDED]"; ?></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Property Ref Number:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<strong><?php print "$row[PROPERTYREF]"; ?></strong></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Select Property Type:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>

          <SELECT NAME="PROPERTYTYPE">
<OPTION VALUE="Commercial" <?php if($row['PROPERTYTYPE'] =="Commercial"){print " selected";} ?>>
   Commercial Property</OPTION> 
<OPTION VALUE="Detached" <?php if($row['PROPERTYTYPE'] =="Detached"){print " selected";} ?>>
   Detached House</OPTION>
<OPTION VALUE="Semi-detached" <?php if($row['PROPERTYTYPE'] =="Semi-detached"){print " selected";} ?>>
   Semi-detached House</OPTION>
<OPTION VALUE="Terraced" <?php if($row['PROPERTYTYPE'] =="Terraced"){print " selected";} ?>>
   Terraced House</OPTION>
<OPTION VALUE="Detached Bungalow" <?php if($row['PROPERTYTYPE'] =="Detached Bungalow"){print " selected";} ?>>
   Detached Bungalow</OPTION>
<OPTION VALUE="Semi-detached Bungalow" <?php if($row['PROPERTYTYPE'] =="Semi-detached Bungalow"){print " selected";} ?>>
   Semi-detached Bungalow</OPTION>
<OPTION VALUE="Apartment/Flat" <?php if($row['PROPERTYTYPE'] =="Apartment/Flat"){print " selected";} ?>>
   Apartment/Flat</OPTION>
<OPTION VALUE="Maisonette" <?php if($row['PROPERTYTYPE'] =="Maisonette"){print " selected";} ?>>
   Maisonette</OPTION>
<OPTION VALUE="Other" <?php if($row['PROPERTYTYPE'] =="Other"){print " selected";} ?>>
   Other</OPTION>
          </SELECT>
</P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Enter Property Price:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P> <?php print "$CurrencyUnit"; ?> 
<INPUT TYPE="TEXT" NAME="PROPERTYPRICE" SIZE="10" MAXLENGTH="20" VALUE="<?php print "$row[PROPERTYPRICE]"; ?>">
<i>(Enter Numbers Only. Do not use commas, spaces or punctuations)</i></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Number of Bedrooms:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>

          <SELECT NAME="PROPERTYBEDROOMS">
<OPTION VALUE="1" <?php if($row['PROPERTYBEDROOMS'] =="1"){print " selected";} ?>>One</OPTION>
<OPTION VALUE="2" <?php if($row['PROPERTYBEDROOMS'] =="2"){print " selected";} ?>>Two</OPTION>
<OPTION VALUE="3" <?php if($row['PROPERTYBEDROOMS'] =="3"){print " selected";} ?>>Three</OPTION>
<OPTION VALUE="4" <?php if($row['PROPERTYBEDROOMS'] =="4"){print " selected";} ?>>Four</OPTION>
<OPTION VALUE="5" <?php if($row['PROPERTYBEDROOMS'] =="5"){print " selected";} ?>>Five</OPTION>
<OPTION VALUE="6" <?php if($row['PROPERTYBEDROOMS'] =="6"){print " selected";} ?>>Six</OPTION>
<OPTION VALUE="7" <?php if($row['PROPERTYBEDROOMS'] =="7"){print " selected";} ?>>Seven</OPTION>
<OPTION VALUE="8" <?php if($row['PROPERTYBEDROOMS'] =="8"){print " selected";} ?>>Eight</OPTION>
<OPTION VALUE="9" <?php if($row['PROPERTYBEDROOMS'] =="9"){print " selected";} ?>>Nine</OPTION>
<OPTION VALUE="10" <?php if($row['PROPERTYBEDROOMS'] =="10"){print " selected";} ?>>Ten +</OPTION>
          </SELECT>
</P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Address of Property:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<INPUT TYPE="TEXT" NAME="PROPERTYADDRESS" SIZE="50"
				  MAXLENGTH="100" VALUE="<?php print "$row[PROPERTYADDRESS]"; ?>">
</P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Town/Location of Property:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<INPUT TYPE="TEXT" NAME="PROPERTYLOCATION" SIZE="35" MAXLENGTH="100" VALUE="<?php print "$row[PROPERTYLOCATION]"; ?>">
</P></TD>
</TR>
<TR>
<TD width="165" VALIGN="TOP" BGCOLOR="#e1ebfb">
<P><b>Short Property Description:</b><BR>
<I>(Maximum of 255 Characters)</I></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<TEXTAREA NAME="SHORTDESCRIPTION" ROWS="4" COLS="65"><?php print "$row[SHORTDESCRIPTION]"; ?></TEXTAREA>
</P></TD>
</TR>
<TR>
<TD width="165" VALIGN="TOP" BGCOLOR="#e1ebfb">
<P><b>Long Property Description:</b><BR>
<I>(HTML Permitted)</I></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<TEXTAREA NAME="LONGDESCRIPTION" ROWS="15" COLS="65"><?php print "$row[LONGDESCRIPTION]"; ?></TEXTAREA>
</P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Status:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<SELECT NAME="PROPERTYSTATUS">
<OPTION VALUE="" SELECTED="SELECTED">Please Select</OPTION>
<OPTION VALUE="1" <?php if($row['PROPERTYSTATUS'] =="1"){print " selected";} ?>>For Sale</OPTION>
<OPTION VALUE="2" <?php if($row['PROPERTYSTATUS'] =="2"){print " selected";} ?>>Sale Agreed</OPTION>
<OPTION VALUE="3" <?php if($row['PROPERTYSTATUS'] =="3"){print " selected";} ?>>Under Offer</OPTION>
<OPTION VALUE="4" <?php if($row['PROPERTYSTATUS'] =="4"){print " selected";} ?>>New Instructions</OPTION>
</SELECT>
<i>(The property will be marked as this on the search results)</i></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P><b>Listing Option:</b></P></TD>
<TD BGCOLOR="#f3f3f3">
<P>
<SELECT NAME="PROPERTYSHOW">
<OPTION VALUE="Yes" <?php if($row['PROPERTYSHOW'] =="Yes"){print " selected";} ?>>Yes</OPTION>
<OPTION VALUE="No" <?php if($row['PROPERTYSHOW'] =="No"){print " selected";} ?>>No</OPTION>
</SELECT>
<i>(Make the property listing available to view on website)</i></P></TD>
</TR>
<TR>
<TD width="165" BGCOLOR="#e1ebfb">
<P></P></TD>
<TD BGCOLOR="#f3f3f3">
<P> </P></TD>
</TR>
<TR>
<TD width="165" VALIGN="TOP" BGCOLOR="#e1ebfb">
<P><b>Upload Property Photos:</b><BR>
<I>(If no photo available leave blank for default image)</I></P></TD>
<TD BGCOLOR="#f3f3f3">
<P> Picture 1: 
	<input name="PROPERTYPHOTOONE[]" type="file" size="35" VALUE="<?php print "$row[PROPERTYPHOTOONE]"; ?>" />
<br>
	Picture 2:
	<input name="PROPERTYPHOTOTWO[]" type="file" size="35" VALUE="<?php print "$row[PROPERTYPHOTOTWO]"; ?>" />
<br>
	Picture 3:
	<input name="PROPERTYPHOTOTHREE[]" type="file" size="35" VALUE="<?php print "$row[PROPERTYPHOTOTHREE]"; ?>"/>
<br>
	Picture 4:
	<input name="PROPERTYPHOTOFOUR[]" type="file" size="35" VALUE="<?php print "$row[PROPERTYPHOTOFOUR]"; ?>"/>
<br/>

</TD>
</TR>
<TR><TD width="165" BGCOLOR="#e1ebfb"><b>Current Photos</b></TD>
	<TD>
	<?php
if (!$row['PROPERTYPHOTOONE']) {print "<image src=\"$ImageURL/nopropertyimage.jpg\" height=\"$ShowImageHeightEdit\" width=\"$ShowImageWidthEdit\">";}
else {print "<P ALIGN=\"CENTER\"><em>Click photographs for larger image</em></p><a href=\"$ImageURL/$row[PROPERTYPHOTOONE]\" target=\"_blank\"><image src=\"$ImageURL/$row[PROPERTYPHOTOONE]\" height=\"$ShowImageHeightEdit\" width=\"$ShowImageWidthEdit\" border=\"0\" alt=\"Click for larger image\"></a>&nbsp;";}		 
if ($row['PROPERTYPHOTOTWO']) {print "<a href=\"$ImageURL/$row[PROPERTYPHOTOTWO]\" target=\"_blank\"><img src=\"$ImageURL/$row[PROPERTYPHOTOTWO]\" width=\"$ShowImageWidthEdit\" height=\"$ShowImageHeightEdit\" border=\"0\" alt=\"Click for larger image\"></a>&nbsp;";}
if ($row['PROPERTYPHOTOTHREE']) {print "<a href=\"$ImageURL/$row[PROPERTYPHOTOTHREE]\" target=\"_blank\"><img src=\"$ImageURL/$row[PROPERTYPHOTOTHREE]\" width=\"$ShowImageWidthEdit\" height=\"$ShowImageHeightEdit\" border=\"0\" alt=\"Click for larger image\"></a>&nbsp;";}

if ($row['PROPERTYPHOTOFOUR']) {print "<a href=\"$ImageURL/$row[PROPERTYPHOTOFOUR]\" target=\"_blank\"><img src=\"$ImageURL/$row[PROPERTYPHOTOFOUR]\" width=\"$ShowImageWidthEdit\" height=\"$ShowImageHeightEdit\" border=\"0\" alt=\"Click for larger image\"></a>";}
?>
	</TD>
</TR>
</TABLE>
<br>
<p align="center">  <input value="Update Property" type="submit" class="submit" ONCLICK="return confirm('Are you sure you want to Update this Property?');"></p>
          </form>
<br>

<?php
}

}
#### Update the requested Establishment ####
if (isset($_POST["op"]) && ($_POST["op"]=="UpdateProperty"))
{

mysql_connect($server, $DBusername, $DBpassword) or die ("$DatabaseError - 42");
mysql_select_db($database);
mysql_query("UPDATE $property_table SET 
PROPERTYTYPE = '$_POST[PROPERTYTYPE]', 
PROPERTYPRICE = '$_POST[PROPERTYPRICE]', 
PROPERTYBEDROOMS = '$_POST[PROPERTYBEDROOMS]', 
PROPERTYADDRESS = '$_POST[PROPERTYADDRESS]', 
PROPERTYLOCATION = '$_POST[PROPERTYLOCATION]',
SHORTDESCRIPTION = '$_POST[SHORTDESCRIPTION]',
LONGDESCRIPTION = '$_POST[LONGDESCRIPTION]',
PROPERTYSTATUS = '$_POST[PROPERTYSTATUS]',
PROPERTYPHOTOONE = '$_POST[PROPERTYPHOTOONE]',
PROPERTYPHOTOTWO = '$_POST[PROPERTYPHOTOTWO]',
PROPERTYPHOTOTHREE = '$_POST[PROPERTYPHOTOTHREE]',
PROPERTYPHOTOFOUR = '$_POST[PROPERTYPHOTOFOUR]',
PROPERTYSHOW = '$_POST[PROPERTYSHOW]'
WHERE id = '$_POST[id]'");



print "<p align=\"center\"><font color=\"#CC0000\">Property details have been updated</font></p>";
print "<br><form method=\"post\">
<input name=\"op\" type=\"hidden\" value=\"editestablishment\">
<input name=\"id\" type=\"hidden\" value=\"".$_POST['id']."\">
<p align=\"center\"><input value=\"View New Details\" type=\"submit\" class=\"textinput\"></p>
</form>";

}
?>
			 </TD> 
		</TR> 
	 </TABLE><?PHP include "footer.php"; ?>
  </BODY>
</HTML>
<?php
}
   else
  {
	header("Location: login_error.php");
	exit;
  }
?>
Property_Add.php Code:

Code: Select all

<?php
 include "config.php";
if (isset($_COOKIE["ValidUserAdmin"]))
{
?>
<HTML> 
  <HEAD> 
	 <TITLE>Property Add</TITLE> <LINK HREF="style.css" REL="stylesheet" TYPE="text/css"> 
  </HEAD> 
  <BODY><?PHP include "header.php"; ?>
	 <TABLE WIDTH="760" ALIGN="CENTER" CLASS="maincentre"> 
		<TR> 
		  <TD> 
			 <P><A HREF="main.php">MAIN</A> > <B>ADD PROPERTY</B></P>
			<br> 
			<?php
if (isset($_POST["op"]) && ($_POST["op"]=="AddProperty"))
{
foreach ($_FILES["PROPERTYPHOTOONE"]["error"] as $key => $error) 
{
   if ($error == UPLOAD_ERR_OK) {
       $tmp_name = $_FILES["PROPERTYPHOTOONE"]["tmp_name"][$key];
       $name = $_FILES["PROPERTYPHOTOONE"]["name"][$key];
       move_uploaded_file($tmp_name, "$ImagePath/".$_POST['PROPERTYREF']."-$name");
$PROPERTYPHOTOONE = "".$_POST['PROPERTYREF']."-$name";
}
}

foreach ($_FILES["PROPERTYPHOTOTWO"]["error"] as $key => $error) 
{
   if ($error == UPLOAD_ERR_OK) {
       $tmp_name = $_FILES["PROPERTYPHOTOTWO"]["tmp_name"][$key];
       $name = $_FILES["PROPERTYPHOTOTWO"]["name"][$key];
       move_uploaded_file($tmp_name, "$ImagePath/".$_POST['PROPERTYREF']."-$name");
$PROPERTYPHOTOTWO = "".$_POST['PROPERTYREF']."-$name";
}
}
foreach ($_FILES["PROPERTYPHOTOTHREE"]["error"] as $key => $error) 
{
   if ($error == UPLOAD_ERR_OK) {
       $tmp_name = $_FILES["PROPERTYPHOTOTHREE"]["tmp_name"][$key];
       $name = $_FILES["PROPERTYPHOTOTHREE"]["name"][$key];
       move_uploaded_file($tmp_name, "$ImagePath/".$_POST['PROPERTYREF']."-$name");
$PROPERTYPHOTOTHREE = "".$_POST['PROPERTYREF']."-$name";
}
}
foreach ($_FILES["PROPERTYPHOTOFOUR"]["error"] as $key => $error) 
{
   if ($error == UPLOAD_ERR_OK) {
       $tmp_name = $_FILES["PROPERTYPHOTOFOUR"]["tmp_name"][$key];
       $name = $_FILES["PROPERTYPHOTOFOUR"]["name"][$key];
       move_uploaded_file($tmp_name, "$ImagePath/".$_POST['PROPERTYREF']."-$name");
$PROPERTYPHOTOFOUR = "".$_POST['PROPERTYREF']."-$name";
}
}

mysql_connect($server, $DBusername, $DBpassword) or die ("$DatabaseError");
mysql_select_db($database);  
mysql_query( "LOCK TABLES $property_table WRITE" );
mysql_query("INSERT INTO $property_table (
id,
PROPERTYREF,
PROPERTYTYPE,
PROPERTYPRICE,
PROPERTYBEDROOMS,
PROPERTYADDRESS,
PROPERTYLOCATION,
SHORTDESCRIPTION,
LONGDESCRIPTION,
PROPERTYSTATUS,
PROPERTYPHOTOONE,
PROPERTYPHOTOTWO,
PROPERTYPHOTOTHREE,
PROPERTYPHOTOFOUR,
PROPERTYVIEWS,
PROPERTYSHOW,
DATEADDED
)
VALUES (
'', 
'".$_POST['PROPERTYREF']."', 
'".$_POST['PROPERTYTYPE']."', 
'".$_POST['PROPERTYPRICE']."', 
'".$_POST['PROPERTYBEDROOMS']."', 
'".$_POST['PROPERTYADDRESS']."', 
'".$_POST['PROPERTYLOCATION']."', 
'".$_POST['SHORTDESCRIPTION']."',
'".$_POST['LONGDESCRIPTION']."',
'".$_POST['PROPERTYSTATUS']."',
'".$_POST['PROPERTYPHOTOONE']."',
'".$_POST['PROPERTYPHOTOTWO']."',
'".$_POST['PROPERTYPHOTOTHREE']."',
'".$_POST['PROPERTYPHOTOFOUR']."',
'0',
'".$_POST['PROPERTYSHOW']."',
'".$_POST['DATEADDED']."'
)")or die ("$DatabaseError 48");
 mysql_query( "UNLOCK TABLES" ); # Unlock the tables

 print "<br><br><br>";
print "<br><br><br><p align=\"center\"><b>The New Property (<b>".$_POST['PROPERTYREF']."</b>) has been added successfully.</b></p>";
print "<p align=\"center\"><a href=\"property_add.php\">Click here</a> if you would like to Add another Property</p>";
 print "<br>";

{
$result = mysql_query("SELECT * FROM $property_table WHERE PROPERTYREF = '".$_POST['PROPERTYREF']."' LIMIT 1") or die ("$DatabaseError"); 
$row = mysql_fetch_array( $result );	

if($row['PROPERTYPHOTOONE'] == "Array") {$PROPERTYPHOTOONE = "";} 
if($row['PROPERTYPHOTOTWO'] == "Array") {$PROPERTYPHOTOTWO = "";}
if($row['PROPERTYPHOTOTHREE'] == "Array") {$PROPERTYPHOTOTHREE = "";} 
if($row['PROPERTYPHOTOFOUR'] == "Array") {$PROPERTYPHOTOFOUR = "";}
}
{
mysql_query("UPDATE $property_table SET 
PROPERTYPHOTOONE ='$PROPERTYPHOTOONE',
PROPERTYPHOTOTWO ='$PROPERTYPHOTOTWO',
PROPERTYPHOTOTHREE ='$PROPERTYPHOTOTHREE',
PROPERTYPHOTOFOUR ='$PROPERTYPHOTOFOUR'
WHERE PROPERTYREF = '".$_POST['PROPERTYREF']."'") or die ("$DatabaseError - 51");
}
}
else
{
?>
<p>Fill in all the details below to add a new property to the database. As soon as the property has been added, it will be available on your website for your visitors to search.</p>			 
<br><form method="post" enctype="multipart/form-data">
<input name="op" type="hidden" value="AddProperty">
<input name="DATEADDED" type="hidden" value="<?php print "$dateadded"; ?>">
<br>

		      <TABLE WIDTH="95%" border="0" ALIGN="CENTER" CELLPADDING="5" CELLSPACING="1" BGCOLOR="#f3f3f3">
			            <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Date:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> <?php print "$dateadded"; ?></P></TD>
    </TR>
          <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Property 
          Ref Number:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <INPUT TYPE="TEXT" NAME="PROPERTYREF" SIZE="20" MAXLENGTH="50"> (<i>A unique number which identifies this property)</i></P></TD>
    </TR>
    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Select Property 
          Type:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <SELECT NAME="PROPERTYTYPE">
            <OPTION VALUE="">Select Property Type</OPTION>
												 <OPTION VALUE="Commercial">Commercial Property</OPTION> 
            <OPTION VALUE="Detached">Detached House</OPTION>
            <OPTION VALUE="Semi-detached">Semi-detached House</OPTION>
            <OPTION VALUE="Terraced">Terraced House</OPTION>
            <OPTION VALUE="Detached Bungalow">Detached Bungalow</OPTION>
            <OPTION VALUE="Semi-detached	Bungalow">Semi-detached Bungalow</OPTION>
            <OPTION VALUE="Apartment/Flat">Apartment/Flat</OPTION>
            <OPTION VALUE="Maisonette">Maisonette</OPTION>
            <OPTION VALUE="Other">Other</OPTION>
          </SELECT>
        </P></TD>
    </TR>
    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Enter Property 
          Price:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> <?php print "$CurrencyUnit"; ?> 
          <INPUT TYPE="TEXT" NAME="PROPERTYPRICE" SIZE="10"
				  MAXLENGTH="20" class="textinput">

          <i>(Enter Numbers Only. Do not use commas, spaces or punctuations)</i></P></TD>
    </TR>
    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Number of Bedrooms:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
     <SELECT NAME="PROPERTYBEDROOMS">
       <OPTION VALUE="" SELECTED="SELECTED">Please Select</OPTION>
       <OPTION VALUE="1">One</OPTION>
       <OPTION VALUE="2">Two</OPTION>
       <OPTION VALUE="3">Three</OPTION>
       <OPTION VALUE="4">Four</OPTION>
       <OPTION VALUE="5">Five</OPTION>
	<OPTION VALUE="6">Six</OPTION>
	<OPTION VALUE="7">Seven</OPTION>							<OPTION VALUE="8">Eight</OPTION>
	<OPTION VALUE="9">Nine</OPTION>
	<OPTION VALUE="10">Ten +</OPTION>
     </SELECT>
        </P></TD>
    </TR>
    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Address of Property:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <INPUT TYPE="TEXT" NAME="PROPERTYADDRESS" SIZE="50"
				  MAXLENGTH="100">
        </P></TD>
    </TR>
    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Town/Location of 
          Property:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <INPUT TYPE="TEXT" NAME="PROPERTYLOCATION" SIZE="35" MAXLENGTH="100">
        </P></TD>
    </TR>
    <TR> 
            <TD width="165" VALIGN="TOP" BGCOLOR="#e1ebfb"> 
              <P><b>Short Property Description:</b><BR>
          <I>(Maximum of 255 Characters)</I></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <TEXTAREA NAME="SHORTDESCRIPTION" ROWS="4" COLS="65"></TEXTAREA>
        </P></TD>
    </TR>
	    <TR> 
            <TD width="165" VALIGN="TOP" BGCOLOR="#e1ebfb"> 
              <P><b>Long Property Description:</b><BR>
          <I>(HTML Permitted)</I></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <TEXTAREA NAME="LONGDESCRIPTION" ROWS="15" COLS="65"></TEXTAREA>
        </P></TD>
    </TR>
    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Status:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <SELECT NAME="PROPERTYSTATUS">
            <OPTION VALUE="" SELECTED="SELECTED">Please Select</OPTION>
            <OPTION VALUE="1">For Sale</OPTION>
            <OPTION VALUE="2">Sale Agreed</OPTION>
            <OPTION VALUE="3">Under Offer</OPTION>
            <OPTION VALUE="4">New Instructions</OPTION>
          </SELECT>
         <i>(The property will be marked as this on the search results)</i></P></TD>
    </TR>
	    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P><b>Listing Option:</b></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
          <SELECT NAME="PROPERTYSHOW">
            <OPTION VALUE="Yes">Yes</OPTION>
            <OPTION VALUE="No">No</OPTION>

          </SELECT>
         <i>(Make the property listing available to view on website)</i></P></TD>
    </TR>
	    <TR> 
            <TD width="165" BGCOLOR="#e1ebfb"> 
              <P></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
</P></TD>
    </TR>
    <TR> 
            <TD width="165" VALIGN="TOP" BGCOLOR="#e1ebfb"> 
              <P><b>Upload 
          Property Photos:</b><BR>
          <I>(If no photo available leave blank for default image)</I></P></TD>
      <TD BGCOLOR="#f3f3f3"> 
        <P> 
Picture 1: <input name="PROPERTYPHOTOONE[]" type="file" size="35" />
<br>
Picture 2: <input name="PROPERTYPHOTOTWO[]" type="file" size="35" />
<br> 
Picture 3: <input name="PROPERTYPHOTOTHREE[]" type="file" size="35" />
<br>
Picture 4: <input name="PROPERTYPHOTOFOUR[]" type="file" size="35" />
<br> 


</TD>
    </TR>
  </TABLE>
  <br>
                        <p align="center">  <input value="Click Here to Add New Property" type="submit" class="submit" ONCLICK="return confirm('Are you sure you want to Add this New Property Listing?');"></p>
                        </form>
<?php 
}
?> 
			<br><br> 
			 </TD> 
		</TR> 
	 </TABLE><?PHP include "footer.php"; ?>
  </BODY>
</HTML>
<?php
}
   else
  {
	header("Location: login_error.php");
	exit;
  }
?>
Last edited by squire on Thu Jul 21, 2005 11:08 am, edited 1 time in total.
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

use php tags when posting php code.

You're not actually storing the image in the db (this is a good thing), rather you're creating references to the images and saving those references in the db.

what you could do is fetch the list of references for any given property then provide an option to delete the reference. You woudl probably want to delete the actual file using unlink() for any reference you select to delete as well.

that would remove the files...

to create new ones, you'll have to develop an HTML form where people can upload new images that are tied with the record ID of any property you want. If the file names have the ID attached to them, then just append the id to the file name when you move it to its proper location.
squire
Forum Newbie
Posts: 4
Joined: Wed Jan 26, 2005 7:22 pm
Location: Belfast, Ireland

Post by squire »

Hi Burrito and thaks for your repy.

So would you recommend in the Edit page, just having an option to delete the images and maybe having a popup form for adding new images that sends the property ID to a Property_Image_edit.php page where I can add new images into the relevant property?
User avatar
Burrito
Spockulator
Posts: 4715
Joined: Wed Feb 04, 2004 8:15 pm
Location: Eden, Utah

Post by Burrito »

or do it all on the same page. Just include a section for admins only that they can add new images.
Post Reply