Upload Image Probelm

[rahia307]

Hi
I am using this code for upload image.

<table>
<form action="process.php method="POST" enctype="multipart/form-data">
<tr>
<td align="right">Image1 :</td>
<td><input type="file" name="photo1" class="box"> </td>
</tr>
<tr>
<td colspan="2" align=”center”>
<input name="add" type="Submit" id="add" value=" Submit " class="box">
<input type="reset" value="Refresh" class="box">
</td>
</tr>
</form>
</table>

And process.php file have this code

<?php

$epoch = date(“U”);

$uploadDir="../images-album/";
if (isset($_FILES['photo1']['name'])) {
$mode = '0777';
$photo1 = $epoch.$_FILES['photo1']['name'];
$image1 = $uploadDir.$photo1;
move_uploaded_file($_FILES['photo1']['tmp_name'],$image1);
chmod ($image1, octdec($mode));
}

$sql = “INSERT INTO tablename (photo1) VALUES (‘$photo1’)”;
$result = mysql_query($sql);

?>
I use above code for upload image.
Problem is that when the form is submitted without a file attached the epoch still gets inserted into the DB.
If any body has idea about it helps me.

[Markus]

Hi
I am using this code for upload image.

<table>
<form action="process.php method="POST" enctype="multipart/form-data">
<tr>
<td align="right">Image1 :</td>
<td><input type="file" name="photo1" class="box"> </td>
</tr>
<tr>
<td colspan="2" align=”center”>
<input name="add" type="Submit" id="add" value=" Submit " class="box">
<input type="reset" value="Refresh" class="box">
</td>
</tr>
</form>
</table>

And process.php file have this code

<?php

$epoch = date(“U”);

$uploadDir="../images-album/";
if (isset($_FILES['photo1']['name'])) {
$mode = '0777';
$photo1 = $epoch.$_FILES['photo1']['name'];
$image1 = $uploadDir.$photo1;
move_uploaded_file($_FILES['photo1']['tmp_name'],$image1);
chmod ($image1, octdec($mode));
}

$sql = “INSERT INTO tablename (photo1) VALUES (‘$photo1’)”;
$result = mysql_query($sql);

?>
I use above code for upload image.
Problem is that when the form is submitted without a file attached the epoch still gets inserted into the DB.
If any body has idea about it helps me.

Move the mysql queuries inside the IF statement.
Also, read this tutorial for a better image upload.

[sandeepsandeep]

Hi
I am using this code for upload image.

<table>
<form action="process.php method="POST" enctype="multipart/form-data">
<tr>
<td align="right">Image1 :</td>
<td><input type="file" name="photo1" class="box"> </td>
</tr>
<tr>
<td colspan="2" align=”center”>
<input name="add" type="Submit" id="add" value=" Submit " class="box">
<input type="reset" value="Refresh" class="box">
</td>
</tr>
</form>
</table>

And process.php file have this code

<?php

$epoch = date(“U”);

$uploadDir="../images-album/";
if (isset($_FILES['photo1']['name'])) {
$mode = '0777';
$photo1 = $epoch.$_FILES['photo1']['name'];
$image1 = $uploadDir.$photo1;
move_uploaded_file($_FILES['photo1']['tmp_name'],$image1);
chmod ($image1, octdec($mode));
}

$sql = “INSERT INTO tablename (photo1) VALUES (‘$photo1’)”;
$result = mysql_query($sql);

?>
I use above code for upload image.
Problem is that when the form is submitted without a file attached the epoch still gets inserted into the DB.
If any body has idea about it helps me.

isset() will return FALSE if testing a variable that has been set to NULL so when u used the isset then return the true so insert in DB only opec.submission the form check the vaue is not NULL as vell as empty.

so now u can check
is(!empty($_FILES['photo1']['name']))

Thanks,
Sandeep Agarwal

[arunj82]

I hope this code might help u. pls check it

<?php
$con=mysql_connect("localhost", "root", "simply123") or die("Could not connect: " . mysql_error());
mysql_select_db("minedb");
 
echo "Epoch is ".$epoch = date(U);
$uploadDir="uploads/";
 
if($_REQUEST['add'])
{
                    if (isset($_FILES['photo1']['name']))
                    {
                            $mode = '0777';
                            if(!empty($_FILES['photo1']['name']))
                            {
                                    $photo1 = $epoch.$_FILES['photo1']['name'];
                            }
                            $image1 = $uploadDir.$photo1;
                            move_uploaded_file($_FILES['photo1']['tmp_name'],$image1);
                            chmod ($image1, octdec($mode));
 
                    }
 
                    if(!empty($_FILES['photo1']['name']))
                    {
                            $sql="insert into photo(photoname) values('".$photo1."')";
                             mysql_query($sql) or die(mysql_error());
                            echo "Uploaded";
                    }
}
?>
<body>
<form action="upload12.php" method="POST" enctype="multipart/form-data">
<table>
<tr>
<td align="right">Image1 :</td>
<td><input type="file" name="photo1" class="box"> </td>
</tr>
<tr>
<td colspan="2" align=”center”>
<input name="add" type="Submit" id="add" value=" Submit " class="box">
<input type="reset" value="Refresh" class="box">
</td>
</tr>
</form>
</table>
</body>
</html>

by
arunj82

[Markus]

I hope this code might help u. pls check it

<?php
$con=mysql_connect("localhost", "root", "simply123") or die("Could not connect: " . mysql_error());
mysql_select_db("minedb");
 
echo "Epoch is ".$epoch = date(U);
$uploadDir="uploads/";
 
if($_REQUEST['add'])
{
                    if (isset($_FILES['photo1']['name']))
                    {
                            $mode = '0777';
                            if(!empty($_FILES['photo1']['name']))
                            {
                                    $photo1 = $epoch.$_FILES['photo1']['name'];
                            }
                            $image1 = $uploadDir.$photo1;
                            move_uploaded_file($_FILES['photo1']['tmp_name'],$image1);
                            chmod ($image1, octdec($mode));
 
                    }
 
                    if(!empty($_FILES['photo1']['name']))
                    {
                            $sql="insert into photo(photoname) values('".$photo1."')";
                             mysql_query($sql) or die(mysql_error());
                            echo "Uploaded";
                    }
}
?>
<body>
<form action="upload12.php" method="POST" enctype="multipart/form-data">
<table>
<tr>
<td align="right">Image1 :</td>
<td><input type="file" name="photo1" class="box"> </td>
</tr>
<tr>
<td colspan="2" align=”center”>
<input name="add" type="Submit" id="add" value=" Submit " class="box">
<input type="reset" value="Refresh" class="box">
</td>
</tr>
</form>
</table>
</body>
</html>

by
arunj82

Don't post full code.
Especially if you're not going to explain it.

[Markus]

isset() will return FALSE if testing a variable that has been set to NULL so when u used the isset then return the true so insert in DB only opec.submission the form check the vaue is not NULL as vell as empty.

so now u can check
is(!empty($_FILES['photo1']['name']))

Thanks,
Sandeep Agarwal

Yes...

His IF statement will work fine.