View Full Version: FILE UPLOAD

MPAM Rebooted Forums > Software support (freewares, PHP...) > FILE UPLOAD


Title: FILE UPLOAD
Description: combining scripts


257335 - January 1, 2007 11:56 PM (GMT)
ok i have 2 forms and i had 2 php scripts i have already combine the php scripts and im pretty sure that it will work im not sure how to go about combining the forms though.

here is the php script after i combined them
CODE

<html>
<head>
<title>Home</title>
<link rel="stylesheet" href="CSS.css" type="text/css" />
</head>

<body>
<div id="sidebar">
<img src="images/bigdoglogo.gif" width="215"height="75">
<div id="menu">
<a class="active" href="Home.html">Home</a>
<a href="Apartments.php">Apartments</a>
<a href="Industrial.php">Industrial</a>
<a href="Land.php">Land</a>
<a href="Retail.php">Retail</a>
<a href="OfficeSpace.php">Office Space</a>
<a href="AboutUs.html">About Us</a>
</div>
</div>

<div id="content"><h3>
<?php
$con = mysql_connect("localhost","root","52al73");
if (!$con)
 {
 die('Could not connect: ' . mysql_error());
 }

mysql_select_db("realestate", $con);

$sql="INSERT INTO estate & #40;accountnum,address,zipcode,price,baths,bedrooms,state,city,squarefeet,county,subdivision,yearbui
lt,description,buyorlease,typeofprop,imagename,acreage)
VALUES
('$_POST[accountnum]','$_POST[Address]','$_POST[zipcode]','$_POST[price]','$_POST[baths]','$_POST[bedrooms]','$_POST[state]','$_POST[city]','$_POST[squarefeet]','$_POST[county]','$_POST[subdivision]','$_POST[yearbuilt]','$_POST[description]','$_POST[buyorlease]','$_POST[type]','$_POST[imagepath]','$_POST[acreage]')";

if (!mysql_query($sql,$con))
 {
die('Error: ' . mysql_error());
}


//FILE UPLOAD
if (($_FILES["file"]["type"] == "image/gif")
|| ($_FILES["file"]["type"] == "image/jpeg")
&& ($_FILES["file"]["size"] < 20000))
 {
 if ($_FILES["file"]["error"] > 0)
   {
   echo "Return Code: " . $_FILES["file"]["error"] . "<br />";
   }
 else
   {
   echo "Upload: " . $_FILES["file"]["name"] . "<br />";
   echo "Type: " . $_FILES["file"]["type"] . "<br />";
   echo "Size: " . ($_FILES["file"]["size"] / 1024) . " Kb<br />";
   echo "Temp file: " . $_FILES["file"]["tmp_name"] . "<br />";

   if (file_exists("C:/Documents and Settings/Marquis Taliaferro/Desktop/web page/images/" . $_FILES["file"]["name"]))
     {
     echo $_FILES["file"]["name"] . " already exists. ";
     }
   else
     {
     move_uploaded_file($_FILES["file"]["tmp_name"],
     "upload/" . $_FILES["file"]["name"]);
     echo "Stored in: " . "C:/Documents and Settings/Marquis Taliaferro/Desktop/web page/images/" . $_FILES["file"]["name"];
     }
   }
 }
else
 {
 echo "Invalid file";
 }
//END OF UPLOAD


echo "1 record added";

mysql_close($con)
?>


here are the 2 forms im trying to combine
CODE

<?php
session_start();
?>
<html>
<head>
<title>CMS</title>
<link rel="stylesheet" href="CSS.css" type="text/css" />
</head>

<body>

<div id="sidebar">
<img src="images/bigdoglogo.gif" width="215"height="75">
<div id="menu">
<a href="Home.html">Home</a>
<a href="Apartments.php">Apartments</a>
<a href="Industrial.php">Industrial</a>
<a href="Land.php">Land</a>
<a href="Retail.php">Retail</a>
<a href="OfficeSpace.php">Office Space</a>
<a href="AboutUs.html">About Us</a>
<a class="active" href="CMS.php">Realtor login</a>
</div>
</div>
<div id="content">
<?php
include ("login.php");   // **** This is where you include the log in form
?>
<?php
if (isset($_SESSION["uname"]))
{
?>
<h3>Enter New Data Here </h3>

<br>
<br>

<form name="input" action="fromCMS.php" method="post">
Account number:<input type="text" name="accountnum"size="30"><br><br>

Address: <input type="text"name="Address"size="30"><br><br>

Zipcode: <input type="text" name="zipcode" size="30"><br><br>

Price: <input type="text" name="price" size="30"><br><br>

Baths: <input type="text" name="baths" size="30"><br><br>

Bedrooms: <input type="text" name="bedrooms" size="30"><br><br>

City: <input type="text" name="city" size="30"><br><br>

State: <select name="state">
<option selected>--Pick a State--</option>
<option value="Alabama">Alabama</option>
<option value="volvo">Alaska</option>
<option value="Alaska">Arizona</option>
<option value="Arkansas">Arkansas</option>
<option value="California">California</option>
<option value="Colorado">Colorado</option>
<option value="Connecticut">Connecticut</option>
<option value="Delaware">Delaware</option>
<option value="Florida">Florida</option>
<option value="Georgia">Georgia</option>
<option value="Hawaii">Hawaii</option>
<option value="Idaho">Idaho</option>
<option value="Illinois">Illinois</option>
<option value="Indiana">Indiana</option>
<option value="Iowa">Iowa</option>
<option value="Kansas">Kansas</option>
<option value="Kentucky">Kentucky</option>
<option value="Louisiana">Louisiana</option>
<option value="Maine">Maine</option>
<option value="Maryland">Maryland</option>
<option value="Massachusetts">Massachusetts</option>
<option value="Michigan">Michigan</option>
<option value="Minnesota">Minnesota</option>
<option value="Mississippi">Mississippi</option>
<option value="Missori">Missori</option>
<option value="Montana">Montana</option>
<option value="Nebraska">Nebraska</option>
<option value="Nevada">Nevada</option>
<option value="New Hampshire">New Hampshire</option>
<option value="New Jersey">New Jersey</option>
<option value="New Mexico">New Mexico</option>
<option value="New York">New York</option>
<option value="North Carolina">North Carolina</option>
<option value="North Dakota">North Dakota</option>
<option value="Ohio">Ohio</option>
<option value="Oklahoma">Oklahoma</option>
<option value="Oregon">Oregon</option>
<option value="Pennsylvannia">Pennsylvannia</option>
<option value="Rhode Island">Rhode Island</option>
<option value="South Carolina">South Carolina</option>
<option value="South Dakota">South Dakota</option>
<option value="Tennessee">Tennessee</option>
<option value="Texas">Texas</option>
<option value="Utah">Utah</option>
<option value="Vermont">Vermont</option>
<option value="Virgina">Virgina</option>
<option value="Washington">Washington</option>
<option value="West Virginia">West Virginia</option>
<option value="Wisconsin">Wisconsin</option>
<option value="Wyoming">Wyoming</option>
</select><br><br>

Square feet: <input type="text" name="squarefeet" size="30"><br><br>

County: <input type="text" name="county" size="30"><br><br>

Subdivsion: <input type="text" name="subdivsion" size="30"><br><br>

Year built: <input type="text" name="yearbuilt" size="30"><br><br>

Description: <input type="text" name="description" size="30"><br><br>

Buy of Lease: <select name="buyorlease">
<option selected>--Pick one--</option>
<option value="buy">Buy</option>
<option value="lease">Lease</option>
</select><br><br>

Image name and type: <input type="text"name="imagepath"size="30"> <br><br>

Type of property: <select name="type">
<option selected>--Pick one--</option>
<option value="apartments">Apartments</option>
<option value="industrial">Industrial</option>
<option value="land">Land</option>
<option value="retail">Retail</option>
<option value="officespace">Office Space</option>
</select><br><br>

Acreage (if applies): <input type="text" name="acreage" size="30">
<br><br>
<input type="submit" value="Submit">
</form>

<?php
}
?>


</body>
</html>

and
CODE

<html>
<body>

<form action="fromCMS.php" method="post"
enctype="multipart/form-data">
<label for="file">Filename:</label>
<input type="file" name="file" id="file" />
<br />
<input type="submit" name="submit" value="Submit" />
</form>

</body>
</html>


257335 - January 2, 2007 05:55 AM (GMT)
ok we got that to work now im trying to output the jpeg file i uploaded
heres my code

CODE

while($row =  mysql_fetch_array($result))
 {
 echo "<img src="images/". $row['imagename'] . " width="400"height="400">";
 echo "<br>";
 echo "<br>";


the error is this
QUOTE


Parse error: parse error, unexpected T_STRING, expecting ',' or ';' in C:\Documents and Settings\Marquis Taliaferro\Desktop\web page\Retail.php on line 43

patheticcockroach - January 2, 2007 04:03 PM (GMT)
You have to escape the " in your echos (replace " with \"), or (my preferred method) :
CODE
while($row =  mysql_fetch_array($result))
{
echo '<img src="images/'. $row['imagename'] .'" width="400"height="400">';
echo '<br>';
echo '<br>';




Hosted for free by InvisionFree