Adding an Image Upload then showing it in an array =S!!!

colleyboy · September 16, 2010

Hiya all,

Firstly thanks for the previous help with the arrays and that... you guys (or girls) ROCK !

But now I am stuck... lol.

I am creating a simple motor dealer script for a friend with a garage and a few cars.

The idea is... they fill in the form... upload the image(s) and then it adds it in to the database and displays the info on the page with other cars.

So far I have got it to array all the info in the database how I want (thanks to you lot !).

Now I need to add another box on the add vehicle page to upload photos and then on the show vehicles page I need it to show the uploaded photos next to the vehicles info.

This is what I have so far:

showvehicles.php:

<HTML>

<HEAD>

<TITLE>Barry Ottley Motor Co - Quality Used Motors - Stanford-Le-Hope, Essex</TITLE>

</HEAD>



<BODY LINK="#000000" ALINK="#000000" VLINK="#000000">

<CENTER><IMG SRC="logo.jpg"></CENTER>



<CENTER>

<TABLE WIDTH="840" CELLPADDING="0" CELLSPACING="0" BORDER="0">

<TR>

<TD WIDTH="186" valign="top">
<BR>
<CENTER><A HREF="index.html"><IMG SRC="homepage.jpg" alt="Homepage" border="0"></A></CENTER>
<CENTER><A HREF="showroom.php"><IMG SRC="showroom.jpg" alt="Our Online Showroom" border="0"></A></CENTER>
<CENTER><A HREF="location.html"><IMG SRC="ourlocation.jpg" alt="Our location" border="0"></A></CENTER>
<CENTER><A HREF="aboutus.html"><IMG SRC="aboutus.jpg" alt="About Us" border="0"></A></CENTER>
<CENTER><A HREF="contactus.php"><IMG SRC="contactus.jpg" alt="Contact Us" border="0"></A></CENTER>




</TD>

<TD WIDTH="30" valign="top"> </TD>

<TD valign="top">

<FONT SIZE="2" FACE="ARIAL">

<CENTER><B>Current Showroom</B></CENTER>
<BR>

<!-- VIEWING BIT -->

<?php

include('dbconnect.php')

?>


<?php
// Make a MySQL Connection
$query = "SELECT * FROM cars"; 

$result = mysql_query($query) or die(mysql_error());


while($row = mysql_fetch_array($result)){
echo "<TABLE CELLPADDING=0 CELLSPACING=0 WIDTH=100% BORDER=0>";
echo "<TR />";
echo "<TD WIDTH=30% VALIGN=TOP />";
echo " <IMG SRC=immg.gif /> ";
echo "<br />";
echo "</TD>";
echo "<TD WIDTH=10 VALIGN=TOP />";
echo " ";
echo "</TD>";
echo "<TD />";

echo "<font size=3 face=arial /><B >";
echo $row['CarPrice'];
echo "</B><font size=2 face=arial />";
echo "<br />";
echo $row['CarTitle'];
echo "<br />";
echo "Vehicle Type: ";
echo $row['CarName'];
echo "<br />";
echo "Vehicle Mileage: ";
echo $row['CarMiles'];
echo "<br />";
echo "Description: ";
echo "<br />";
echo "<br />";
echo $row['CarDescription'];

echo "<br />";
echo "</TD>";


echo "</TR>";
echo "</TABLE>";
echo "<hr WIDTH=100% COLOR=BLACK />";
}
?>

<!-- END OF VIEWING BIT -->

</TD>


</TR>

</TABLE>


<BR><BR><BR><BR>

<CENTER><FONT FACE="VERDANA" SIZE="1">

This website was designed and is hosted by <A HREF="http://www.IRCDirect.co.uk">IRC Direct Website Design™</A> 2010

</CENTER>
<BR>
<CENTER><A HREF="admin.php">Employee Area</A>

</BODY>

</HTML>

AddVehicle.php

<HTML>

<HEAD>

<TITLE>Barry Ottley Motor Co - Quality Used Motors - Stanford-Le-Hope, Essex</TITLE>

</HEAD>



<BODY LINK="#000000" ALINK="#000000" VLINK="#000000">

<CENTER><IMG SRC="logo.jpg"></CENTER>



<CENTER>

<TABLE WIDTH="840" CELLPADDING="0" CELLSPACING="0" BORDER="0">

<TR>

<TD WIDTH="186" valign="top">
<BR>
<CENTER><A HREF="index.html"><IMG SRC="homepage.jpg" alt="Homepage" border="0"></A></CENTER>
<CENTER><A HREF="showroom.php"><IMG SRC="showroom.jpg" alt="Our Online Showroom" border="0"></A></CENTER>
<CENTER><A HREF="location.html"><IMG SRC="ourlocation.jpg" alt="Our location" border="0"></A></CENTER>
<CENTER><A HREF="aboutus.html"><IMG SRC="aboutus.jpg" alt="About Us" border="0"></A></CENTER>
<CENTER><A HREF="contactus.php"><IMG SRC="contactus.jpg" alt="Contact Us" border="0"></A></CENTER>




</TD>

<TD WIDTH="30" valign="top"> </TD>

<TD valign="top">

<FONT SIZE="2" FACE="ARIAL">

<CENTER><B>Add a Vehicle</B></CENTER>
<BR>

<form action="inserts.php" method="post">
<CENTER>Vehicle Name:</CENTER> 
<CENTER><input type="text" name="CarName"></CENTER>
<br>
<CENTER>Vehicle Type:</CENTER>
<CENTER><input type="text" name="CarTitle"></CENTER>
<br>
<CENTER>Vehicle Price:</CENTER>
<CENTER><input type="text" name="CarPrice"></CENTER>
<br>
<CENTER>Vehicle Mileage:</CENTER>
<CENTER><input type="text" name="CarMiles"></CENTER>
<br>
<CENTER>Vehicle Description:</CENTER>
<CENTER><textarea name="CarDescription" rows="10" cols="30"></textarea></CENTER>
<br>
<CENTER><input type="Submit"></CENTER>
</form>

</TD>


</TR>

</TABLE>


<BR><BR><BR><BR>

<CENTER><FONT FACE="VERDANA" SIZE="1">

This website was designed and is hosted by <A HREF="http://www.IRCDirect.co.uk">IRC Direct Website Design™</A> 2010

</CENTER>
<BR>
<CENTER><A HREF="admin.php">Employee Area</A>

</BODY>

</HTML>

inserts.php (Actually handles adding info to the database thats been typed in form)

<HTML>

<HEAD>

<TITLE>Barry Ottley Motor Co - Quality Used Motors - Stanford-Le-Hope, Essex</TITLE>

</HEAD>



<BODY LINK="#000000" ALINK="#000000" VLINK="#000000">

<CENTER><IMG SRC="logo.jpg"></CENTER>



<CENTER>

<TABLE WIDTH="840" CELLPADDING="0" CELLSPACING="0" BORDER="0">

<TR>

<TD WIDTH="186" valign="top">
<BR>
<CENTER><A HREF="index.html"><IMG SRC="homepage.jpg" alt="Homepage" border="0"></A></CENTER>
<CENTER><A HREF="showroom.php"><IMG SRC="showroom.jpg" alt="Our Online Showroom" border="0"></A></CENTER>
<CENTER><A HREF="location.html"><IMG SRC="ourlocation.jpg" alt="Our location" border="0"></A></CENTER>
<CENTER><A HREF="aboutus.html"><IMG SRC="aboutus.jpg" alt="About Us" border="0"></A></CENTER>
<CENTER><A HREF="contactus.php"><IMG SRC="contactus.jpg" alt="Contact Us" border="0"></A></CENTER>




</TD>

<TD WIDTH="30" valign="top"> </TD>

<TD valign="top">

<FONT SIZE="2" FACE="ARIAL">

<CENTER><B>Vehicle Added</B></CENTER>
<BR>

<?php

mysql_connect("localhost", "wormste1_barry", "barry") or die(mysql_error());
mysql_select_db("wormste1_barry") or die(mysql_error());

$CarName = mysql_real_escape_string(trim($_POST['CarName']));
$CarTitle = mysql_real_escape_string(trim($_POST['CarTitle']));
$CarPrice = mysql_real_escape_string(trim($_POST['CarPrice']));
$CarMiles = mysql_real_escape_string(trim($_POST['CarMiles']));
$CarDescription = mysql_real_escape_string(trim($_POST['CarDescription']));


mysql_query("INSERT INTO cars 
(CarName, CarTitle, CarPrice, CarMiles, CarDescription) VALUES('$CarName', '$CarTitle', '$CarPrice', '$CarMiles', '$CarDescription' ) ") 
or die(mysql_error());  


echo "The vehicle data has been added!";

?>


</TD>


</TR>

</TABLE>


<BR><BR><BR><BR>

<CENTER><FONT FACE="VERDANA" SIZE="1">

This website was designed and is hosted by <A HREF="http://www.IRCDirect.co.uk">IRC Direct Website Design™</A> 2010

</CENTER>
<BR>
<CENTER><A HREF="admin.php">Employee Area</A>

</BODY>

</HTML>

If anyone can help me... much appreciated.

I googled it and it started quoting BLOBS and stuff... i was confused

schilly · September 16, 2010

Search PHP Upload Image for a good tutorial. You need to upload the image using the $_FILES global then put the filename into the database record. Then when you view the entry, pull the image name from the db and grab the image from where you uploaded it to and display it.

colleyboy · September 16, 2010

I can find loads of php standalone image uploaders fine.

Cant seem to find one with the details you mean. I understand you upload the image and it goes to a directory. But how does it get added to the DB and then pull it from there to show the path in a <IMG tag>

confused.com!!!

schilly · September 16, 2010

So in your addvehicle form you add a file upload field. when you post the form, save the uploaded file somewhere and get the name from the $_FILES info. Add the image name to the other info from the form that you are inserting into the db for that vehicle.

then in your showvehicle page when you are displaying info about each vehicle you have the image name in each record so you can create an img tag and show it.

Make sense?

kristijan.jurkovic · September 17, 2010

for that you will also have to specify form enctype to "multipart/form-data":

<form method="post" action="file.php" enctype="multipart/form-data">
<input type="file" name="image_file" />
<input type="submit" name="submit" value="Upload Image" />
</form>

//this is file.php
if(isset($_POST['submit'])){

        //directory in which your file will be uploaded
        $target_path = "images/";

        $target_path = $target_path . basename( $_FILES['image_file']['name']); 

        if(move_uploaded_file($_FILES['image_file']['tmp_name'], $target_path)) {
                 echo "The file ".  basename( $_FILES['image_file']['name']). " has been uploaded"; 
              //this is file name which you can store in database
              $file_name = $_FILES['image_file']['name'];
             /*
                Code for storing file name into db    
            */
      }else
    echo "Something went wrong =)";
}

Sign In

Adding an Image Upload then showing it in an array =S!!!

Recommended Posts

colleyboy

Link to comment

Share on other sites

schilly

Link to comment

Share on other sites

colleyboy

Link to comment

Share on other sites

schilly

Link to comment

Share on other sites

kristijan.jurkovic

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information