How to upload two images in a same row and save it to database

ghianita · May 19, 2014

One image is displaying but when i choose image 2 it overlaps image 1..gallery.php

IanA · May 19, 2014

Try giving the file inputs unique names as they currently are using the same name.

ghianita · May 19, 2014

i gave different folder for two image box. which started as gfilename1 and second picture will save as g2filename2..

ghianita · May 20, 2014

How to upload two images in same row of table

I got problem on while browsing file when i browse first image and insert imagename it works but when i browse second (picture 2) it overlaps first image but Image name will shown correctly.. Please help me out..

Here is the Code:

<?php

require_once("../database/connection.php");

$conn = new dbconnect();

$c = $conn->connect();

?>

<!--

.style1 {

color: #FFFFFF;

font-weight: bold;

}

.style2 {color: #FFFFFF}

.style4 {

color: #FFFFFF;

font-size: 18px;

font-weight: bold;

}

a{

color:#FFFFFF;

}

-->

</style>

<head>

<title>Puspa Lal Foundation Admin</title>

</head>

function readURL(input)

{

if (input.files && input.files[0])

{

var reader = new FileReader();

reader.onload = function (e)

{

$('#blah')

.attr('src', e.target.result)

.width(150)

.height(200);

};

reader.readAsDataURL(input.files[0]);

}

</script>

<?php

$viewTag = "N";

if(isset($_REQUEST['eimageName1']))

{

$id = $_REQUEST['eimageName1'];

$query = "SELECT gId, imageName1, imageName2, fileName1, fileName2, postedOn FROM gallery

where gId = '$id'";

$rec = $conn->selectData($c, $query);

if(isset($rec))

{

foreach($rec as $row)

{

$gId = $row['gId'];

$imageName1 = $row['imageName1'];

$imageName2 = $row['imageName2'];

$fileName1 = $row['fileName1'];

$fileName2 = $row['fileName2'];

$postedOn = $row['postedOn'];

}

if(isset($_POST['save']))

{

$imageName1 = $_POST['imageName1'];

$imageName2 = $_POST['imageName2'];

$postedOn = $_POST['postedOn'];

$fileName1 = "g".$_FILES["file"]["name"];

move_uploaded_file($_FILES["file"]["tmp_name"],

"../admin/Images/PhotoGallery/g" . $_FILES["file"]["name"]);

$fileName2 = "g2".$_FILES["file"]["name"];

move_uploaded_file($_FILES["file"]["tmp_name"],

"../admin/Images/g2" . $_FILES["file"]["name"]);

if($gId == null)

{

$query = "insert into gallery (imageName1, imageName2, fileName1, fileName2, postedOn) values

('$imageName1', '$imageName2', '$fileName1', '$fileName2', curdate())";

$conn->InEdDeData($c, $query);

}

else

{

$query = "update gallery set

imageName1 = '$imageName1', imageName2 = '$imageName2',

fileName1 = '$fileName1' , fileName2 = '$fileName2',

postedOn = sysdate

where gId = '$gId'";

$conn->InEdDeData($c, $query);

}

else if(isset($_POST['delete']))

{

$query = "delete from gallery where gId = '$gId'";

$conn->InEdDeData($c, $query);

$gId = null;

$imageName1 = null;

$imageName2 = null;

$fileName1 = null;

$fileName2 = null;

$postedOn = null;

$id = null;

$_REQUEST['eimageName1'] = null;

}

else if(isset($_POST['clear']))

{

$gId = null;

$imageName1 = null;

$imageName2 = null;

$fileName1 = null;

$fileName2 = null;

$postedOn = null;

$id = null;

$_REQUEST['eimageName1'] = null;

}

if(isset($_POST['view']))

$viewTag = "Y";

else if(isset($_POST['hide']))

$viewTag = "N";

?>

<tr>

</span></div>

</td>

</tr>

</table>

<tr>

<span class="style4">Photo Gallery</span></td></tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Picture 1</strong></div></td>

<td>

<?php

if($fileName1 == "")

echo '<label><img id="blah" src="#" alt="your image" height="80%" width="100%"/></label>';

else

echo '<label><img id="blah" src="../admin/Images/PhotoGallery/'.$fileName1.'" alt="your image" height="80%" width="100%"/></label>';

?>

</tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Image Name 1</strong></div>

</td>

<label>

</label></span></td>

</tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Picture 2</strong></div></td>

<td>

<?php

if($fileName2 == "")

echo '<label><img id="blah" src="#" alt="your image" height="80%" width="100%"/></label>';

else

echo '<label><img id="blah" src="../admin/Images/'.$fileName2.'" alt="your image" height="80%" width="100%"/></label>';

?>

</tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Image Name 2 </strong></div>

</td>

<label>

</label></span></td>

</tr>

<tr>

<?php

if($viewTag == "N")

echo '<input name="view" type="submit" id="view" value="View All"/>';

else

echo '<input name="hide" type="submit" id="hide" value="Hide All"/>';

?>

</table>

</form>

<?php

/* start of the list part */

if($viewTag == "Y")

{

$query = "SELECT gId, imageName1, imageName2, fileName1, fileName2, postedOn FROM gallery order by fileName1";

$rec = $conn->selectData($c, $query);

$rw = 0;

if(isset($rec))

{

foreach($rec as $row)

{

$g[$rw][0] = $row['gId'];

$g[$rw][1] = $row['imageName1'];

$g[$rw][2] = $row['imageName2'];

$g[$rw][3] = $row['fileName1'];

$g[$rw][4] = $row['fileName2'];

$g[$rw][5] = $row['postedOn'];

$rw++;

}

?>

<div align="center" class="style2"><strong>Photo Gallery</strong></div>

</td></tr>

<th>Image</th>

<th>Image Name</th>

<th>Image</th>

<th>Image Name</th>

<th>Posted On</th>

<th>Action</th>

<tr>

<?php

$cnt = count($g);

if($cnt > 0)

{

for($a = 0; $a < $cnt; $a++)

{

?>

<?php

echo '<td><img id="blah" src="../admin/Images/PhotoGallery/'.$g[$a][3].'" alt="your image" height="25%" width="30%"/>';

?>

<?php

echo '<td><img id="blah" src="../admin/Images/'.$g[$a][4].'" alt="your image" height="25%" width="30%"/>';

?>

</tr>

<?php

}

?>

<?php

}

?>

</table>

</td></tr>

</table>

IanA · May 20, 2014

What I am referring to are your inputs:

You have two of these with the same names and therefore they can't be distinguished between the two and this is why, I believe, the second file is overriding the file in the first input.

You will, of course, need to change some logic in your PHP code so that it will retrieve the correct variables following the change in names.

Edited May 20, 2014 by IanA

IanA · May 20, 2014

Have you simply re-posted the original issue? Have you tried my suggestion?

Edited May 20, 2014 by IanA

ghianita · May 21, 2014

ya bt it didn't work so can u please teach me how to work on this...

Barand · May 21, 2014

http://www.php.net/manual/en/features.file-upload.multiple.php

ghianita · May 21, 2014

Still not worked...

IanA · May 21, 2014

It would appear that the main reason the image is being 'overwritten' is because either:

1) You haven't properly implemented the examples seen in Barand's link

2) If the file input is now correct, that your PHP is not referencing the uploaded file array correctly.

Please attach the php file following your changes so we can see whether they've been implemented correctly.

ghianita · May 21, 2014

<?php

require_once("../database/connection.php");

$conn = new dbconnect();

$c = $conn->connect();

?>

<!--

.style1 {

color: #FFFFFF;

font-weight: bold;

}

.style2 {color: #FFFFFF}

.style4 {

color: #FFFFFF;

font-size: 18px;

font-weight: bold;

}

a{

color:#FFFFFF;

}

-->

</style>

<head>

<title>Puspa Lal Foundation Admin</title>

</head>

function readURL(input)

{

if (input.files && input.files[0])

{

var reader = new FileReader();

reader.onload = function (e)

{

$('#blah')

.attr('src', e.target.result)

.width(150)

.height(200);

};

reader.readAsDataURL(input.files[0]);

}

</script>

<?php

$viewTag = "N";

if(isset($_REQUEST['eimageName1']))

{

$id = $_REQUEST['eimageName1'];

$query = "SELECT gId, imageName1, imageName2, fileName1, fileName2, postedOn FROM gallery

where gId = '$id'";

$rec = $conn->selectData($c, $query);

if(isset($rec))

{

foreach($rec as $row)

{

$gId = $row['gId'];

$imageName1 = $row['imageName1'];

$imageName2 = $row['imageName2'];

$fileName1 = $row['fileName1'];

$fileName2 = $row['fileName2'];

$postedOn = $row['postedOn'];

}

if(isset($_POST['save']))

{

$imageName1 = $_POST['imageName1'];

$imageName2 = $_POST['imageName2'];

$postedOn = $_POST['postedOn'];

$fileName1 = "g".$_FILES["file"]["name"];

move_uploaded_file($_FILES["file"]["tmp_name"],

"../admin/Images/PhotoGallery/g" . $_FILES["file"]["name"]);

$fileName2 = "g2".$_FILES["file"]["name"];

move_uploaded_file($_FILES["file"]["tmp_name"],

"../admin/Images/PhotoGallery/g2" . $_FILES["file"]["name"]);

if($gId == null)

{

$query = "insert into gallery (imageName1, imageName2, fileName1, fileName2, postedOn) values

('$imageName1', '$imageName2', '$fileName1', '$fileName2', curdate())";

$conn->InEdDeData($c, $query);

}

else

{

$query = "update gallery set

imageName1 = '$imageName1', imageName2 = '$imageName2',

fileName1 = '$fileName1' , fileName2 = '$fileName2',

postedOn = sysdate

where gId = '$gId'";

$conn->InEdDeData($c, $query);

}

else if(isset($_POST['delete']))

{

$query = "delete from gallery where gId = '$gId'";

$conn->InEdDeData($c, $query);

$gId = null;

$imageName1 = null;

$imageName2 = null;

$fileName1 = null;

$fileName2 = null;

$postedOn = null;

$id = null;

$_REQUEST['eimageName1'] = null;

}

else if(isset($_POST['clear']))

{

$gId = null;

$imageName1 = null;

$imageName2 = null;

$fileName1 = null;

$fileName2 = null;

$postedOn = null;

$id = null;

$_REQUEST['eimageName1'] = null;

}

if(isset($_POST['view']))

$viewTag = "Y";

else if(isset($_POST['hide']))

$viewTag = "N";

?>

<tr>

</span></div>

</td>

</tr>

</table>

<tr>

<span class="style4">Photo Gallery</span></td></tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Picture 1</strong></div></td>

<td>

<?php

if($fileName1 == "")

echo '<label><img id="blah" src="#" alt="your image" height="80%" width="100%"/></label>';

else

echo '<label><img id="blah" src="../admin/Images/PhotoGallery/'.$fileName1.'" alt="your image" height="80%" width="100%"/></label>';

?>

</tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Image Name 1</strong></div>

</td>

<label>

</label></span></td>

</tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Picture 2</strong></div></td>

<td>

<?php

if($fileName2 == "")

echo '<label><img id="blah" src="#" alt="your image" height="80%" width="100%"/></label>';

else

echo '<label><img id="blah" src="../admin/PhotoGallery/'.$fileName2.'" alt="your image" height="80%" width="100%"/></label>';

?>

</tr>

<tr>

<td bgcolor="#98AFC7"><div align="right" class="style2"><strong>Image Name 2 </strong></div>

</td>

<label>

</label></span></td>

</tr>

<tr>

<?php

if($viewTag == "N")

echo '<input name="view" type="submit" id="view" value="View All"/>';

else

echo '<input name="hide" type="submit" id="hide" value="Hide All"/>';

?>

</table>

</form>

<?php

/* start of the list part */

if($viewTag == "Y")

{

$query = "SELECT gId, imageName1, imageName2, fileName1, fileName2, postedOn FROM gallery order by fileName1";

$rec = $conn->selectData($c, $query);

$rw = 0;

if(isset($rec))

{

foreach($rec as $row)

{

$g[$rw][0] = $row['gId'];

$g[$rw][1] = $row['imageName1'];

$g[$rw][2] = $row['imageName2'];

$g[$rw][3] = $row['fileName1'];

$g[$rw][4] = $row['fileName2'];

$g[$rw][5] = $row['postedOn'];

$rw++;

}

?>

<div align="center" class="style2"><strong>Photo Gallery</strong></div>

</td></tr>

<th>Image</th>

<th>Image Name</th>

<th>Image</th>

<th>Image Name</th>

<th>Posted On</th>

<th>Action</th>

<tr>

<?php

$cnt = count($g);

if($cnt > 0)

{

for($a = 0; $a < $cnt; $a++)

{

?>

<?php

echo '<td><img id="blah" src="../admin/Images/PhotoGallery/'.$g[$a][3].'" alt="your image" height="25%" width="30%"/>';

?>

<?php

echo '<td><img id="blah" src="../admin/Images/'.$g[$a][4].'" alt="your image" height="25%" width="30%"/>';

?>

</tr>

<?php

}

?>

<?php

}

?>

</table>

</td></tr>

</table>

IanA · May 21, 2014

Please make use of the code tag (seen in the toolbar) as this is quite difficult to read. You have highlighted some code in red...are you telling us that this is what you've changed, because if so, it would appear you haven't made changes to to reflect the link Barand gave you.

Change your file inputs to the following:

Edited May 21, 2014 by IanA

Sign In

How to upload two images in a same row and save it to database

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information