Save image path to MySQL and store file

Report · Oct 07, 2011

Hi there,

I have a form that saves data to a MySQL db. In this form there are four input type file to upload images.

Everything is made with the Dreamweaver wizard.

What I need to do is to store the file path into MySQL and the file into a folder of the website.

I assume that I need to change in GetSQLValueString($_POST['variable'], "text"), but I don't know how to do it.

Anyone can help???

Thank you VERY mcuh

Jaume

Report · Oct 10, 2011

Hi Jaume,

I can't claim credit for this - I got it from here

So want you want to do is upload an image, saving the image itself within your site and the image name in your database.

I haven't figured a way to do this in Dreamweaver wizards, without amending the code, but it's quite straightforward.

Assuming you have a form for people to upload an image, and a new folder within your 'images' folder named 'uploads'...

Using the Dreamweaver server behaviours will have added loads of hidden code to the top of your page, so you need to use the 'code' view to see this (or 'split' if you'd prefer to see both code and design views).

On your form page (mine's called add.php), within the code at the very top of your page which will begin with <?php

and end with

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

Add in the following code:

 $target = "../images/uploads/";  //This is the directory where images will be saved//
 $target = $target . basename( $_FILES['image']['name']);   //change the image and name to whatever your database fields are called//

Your Dreamweaver wizard will have created the $_POST details needed for each field. You need to change the one related to your image to a $_FILES rather than $_POST - look for the line that says something like this (depending on your fields):

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO database_name (name, Product_No, image) VALUES (%s, %s, %s)",
                       GetSQLValueString($_POST['Name'], "text"),
                       GetSQLValueString($_POST['Product_No'], "text"),
                       GetSQLValueString($_POST['image'], "text"));

And change the last line to this:

GetSQLValueString($_FILES['image']['name'], "text"));

That tells the form to insert the file to a specified location, and to insert the image's name - as text - into the database. Now you need to specifiy the location:


  //This code writes the photo to the server// 
 if(move_uploaded_file($_FILES['image']['tmp_name'], $target)) 
 { 
 //And confirms it has worked//
 echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 //Gives error if not correct// 
 echo "Sorry, there was a problem uploading your file."; 
 }

So your amended php will now look like this:

$target = "../images/uploads/";  //This is the directory where images will be saved//
 $target = $target . basename( $_FILES['image']['name']);   //change the image and name to whatever your database fields are called//
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form1")) {
  $insertSQL = sprintf("INSERT INTO database_name (name, Product_No, image) VALUES (%s, %s, %s)",
                       GetSQLValueString($_POST['Name'], "text"),
                       GetSQLValueString($_POST['Product_No'], "text"),
                         GetSQLValueString($_FILES['image']['name'], "text"));

  //This code writes the photo to the server// 
 if(move_uploaded_file($_FILES['image']['tmp_name'], $target)) 
 { 
 //And confirms it has worked//
 echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory"; 
 } 
 else { 
 //Gives error if not correct// 
 echo "Sorry, there was a problem uploading your file."; 
 }

Now in your HTML within the form, your code should look something like this:

	<label for="image">Image</label>
	<input name="image" type="file" id="image" value="<?php echo $row_add['image']; ?>" />
	</p>
	<p>
	<input type="Submit" name="Add" id="add" value="Add" />

	<input type="hidden" name="MM_insert" value="form1" />
	</form>

To display the uploaded images on your website, just put in the location and echo the image field, remembering your ALT tag:

<img src="images/uploads/<?php echo $row_get['image']; ?>" alt="<?php echo $row_get['name']; ?>" /></a>

Good luck!

Report · Oct 11, 2011

Becca, thank you very much!!!

I have some problems though, maybe you can help me 😉

I don't know where to place the

$target = "../images/uploads/";  //This is the directory where images will be saved// $target = $target . basename( $_FILES['image']['name']);   //change the image and name to whatever your database fields are called//

I think everything else I understand quite well.

I copy the code here so maybe you can have al look to it.

Thank you once again

Jaume.

<?php require_once('Connections/Conexion1.php'); ?>

<?php

if (!function_exists("GetSQLValueString")) {

function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")

{

if (PHP_VERSION < 6) {

$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;

}

$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);

switch ($theType) {

case "text":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "long":

case "int":

$theValue = ($theValue != "") ? intval($theValue) : "NULL";

break;

case "double":

$theValue = ($theValue != "") ? doubleval($theValue) : "NULL";

break;

case "date":

$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";

break;

case "defined":

$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;

break;

}

return $theValue;

}

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "UpdateForm")) {

$updateSQL = sprintf("UPDATE detailsmachines SET Hours=%s, StateCons=%s, Accesory1=%s, Accesory2=%s, Accesory3=%s, Image1=%s, Image2=%s, Image3=%s, Image4=%s WHERE ID=%s",

GetSQLValueString($_POST['HoursEdit'], "int"),

GetSQLValueString($_POST['State'], "text"),

GetSQLValueString($_POST['Accesory1'], "text"),

GetSQLValueString($_POST['Accesory2'], "text"),

GetSQLValueString($_POST['Accesory3'], "text"),

GetSQLValueString($_POST['Image1'], "text"),

GetSQLValueString($_POST['Image2'], "text"),

GetSQLValueString($_POST['Image3'], "text"),

GetSQLValueString($_POST['Image4'], "text"),

GetSQLValueString($_POST['id'], "int"));

mysql_select_db($database_Conexion1, $Conexion1);

$Result1 = mysql_query($updateSQL, $Conexion1) or die(mysql_error());

$updateGoTo = "Message Pages/Thanks.html";

if (isset($_SERVER['QUERY_STRING'])) {

$updateGoTo .= (strpos($updateGoTo, '?')) ? "&" : "?";

$updateGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $updateGoTo));

}

$colname_DetailRS1 = "-1";

if (isset($_GET['recordID'])) {

$colname_DetailRS1 = $_GET['recordID'];

}

mysql_select_db($database_Conexion1, $Conexion1);

$query_DetailRS1 = sprintf("SELECT * FROM detailsmachines WHERE ID = %s", GetSQLValueString($colname_DetailRS1, "int"));

$DetailRS1 = mysql_query($query_DetailRS1, $Conexion1) or die(mysql_error());

$row_DetailRS1 = mysql_fetch_assoc($DetailRS1);

$totalRows_DetailRS1 = mysql_num_rows($DetailRS1);

?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

<title>Untitled Document</title>

</head>

<body>

<form action="<?php echo $editFormAction; ?>" method="POST" enctype="multipart/form-data" name="UpdateForm" id="UpdateForm">

<p>

</p>

<tr>

<td>Family</td>

</tr>

<tr>

<td>Chasis</td>

</tr>

<tr>

<td>Model</td>

</tr>

<tr>

<td>Price</td>

</tr>

<tr>

<td>Hours</td>

</tr>

<tr>

<td>Warehouse</td>

</tr>

<tr>

<td>StateCons</td>

</tr>

<tr>

<td>Accesory1</td>

</tr>

<tr>

<td>Accesory2</td>

</tr>

<tr>

<td>Accesory3</td>

</tr>

<tr>

<td>Accesory4</td>

</tr>

<tr>

<td>Image1</td>

<td><label for="Image1"></label><input name="Image1" type="file" id="Image1" value="<?php $row_DetailRS1['Image1']->file_src_pathname; ?>"/>

</td>

</tr>

<tr>

<td>Image2</td>

</tr>

<tr>

<td>Image3</td>

</tr>

<tr>

<td>Image4</td>

</tr>

</table>

</p>

</form>

</body>

</html><?php

mysql_free_result($DetailRS1);

?>

Report · Oct 11, 2011

Hi Jaume,

The $target bit on mine is inbetween the $editFormAction and the if ((isst... To be honest I don't know that it matters where it goes, but it works there on mine!

So that bit of code would look like this:

  $editFormAction = $_SERVER['PHP_SELF'];
 if (isset($_SERVER['QUERY_STRING'])) {
  $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
$target = "../images/uploads/";  //This is the directory where images will be saved//
 $target = $target . basename( $_FILES['image']['name']);  
if ((isset($_POST["MM_update"])) && ($_POST["MM_update"] == "UpdateForm")) {

If it has worked, you'll end up with just the image's name (eg image.jpg) in your database field and the image file itself within your Dreamweaver site's images folder.

Report · Oct 12, 2011

Just for something to think about, I've always been divided/uncertain if saving the path with the filename is the best way to go. If anything, I think I would at least store the filename in a separate column. The reason being that often, you don't always know where the page will be that will eventually link to the file and document relative links then may not work.

The path can be added to the image source string at any time - either as a static or dynamic value.

Report · Oct 12, 2011

I would never store the pathname like that. Just add it in the static HTML on the page.

Report · Oct 13, 2011

Thank you Lon and Murray for your comments.

I'd like to know, though, how would you do it.

My website is a "used machine info" site. I would like to show the machines we have for sale with 4 pics and a table with the specs of each one.

It is generated dynamically, so when I pick one it shows the details.

There is also an admin panel where the staff can upload the pics.

I thought it would be hard to store the pic in the MySQL so I decided to upload the file to ther server and save the path in the db.

What do you think???

Is there any other way to do it??

how about a flickr API?

Once again thankl you VERY much for all your help

Jaume

Report · Oct 13, 2011

I thought it would be hard to store the pic in the MySQL so I decided to upload the file to ther server and save the path in the db.
What do you think???

I think this is the right way to do it, except just save the image NAME - put the path in the static HTML, e.g.,

<img src="path_to_the_image_location/<?php echo $image_file_name; ?>"

That way if you ever change the image location, you only have to change that one line not every record in the database.

Report · Oct 13, 2011

And, to go fully not state the obvious, the image file name value will come from a recordset in most situations.

One way to do it if you're working with a detail page for example, is to create the recordset as you normally would for a detail page, using the unique recordID that's passed from the master page. Insert an image placeholder and for the source, click the lightning bolt icon for dynamic data and select the image file name column from the recordset. Then add the path in manually so it ends up like what Murray posted.

The image placeholder will also add height and width attributes that default to 32x32. So if all the images are the same size, change the attributes accordingly. If they're not the same size, and here's something I should know - will removing those attributes altogether just display the image in it's native dimensions?

Report · Oct 13, 2011

If they're not the same size, and here's something I should know - will removing those attributes altogether just display the image in it's native dimensions?

Yes. If the various images are going to have different dimensions, then you will either have to also store the dimensions in the database, or just remove them from the image tag altogether as you have suggested. You can also use PHP to get the image's dimensions, but that seems like a long walk around the park for this purpose.

Report · Oct 13, 2011

Then comes the issue of what the dimensions of the images actually are. Going back to the top of the thread, they are user uploaded images, so that means they can come in just about any size and resolution. So the uploading process should also include resizing to a maximum width and/or height.

Report · Oct 13, 2011

Certainly - always.

Report · Oct 14, 2011

Gentelmen, thanks a lot again!!

I haven't realized about what Lon says. And it is ABSOLUTELY true.

I will need to resize the big images to a certain size.

Can this be done with dreamweaver????

Any ideas?

Thanks

Jaume

Report · Oct 14, 2011

Can this be done with dreamweaver????

That is not the question. You should ask "Can this be done with PHP", and the answer is yes, sure. Google "PHP image resize" - you'll find lots....

Report · Oct 16, 2011

But why don't you go simple? http://www.felixone.it/extensions/prod/xuplen.asp

Report · Oct 17, 2011

VERY nice but expensive 😞

Thank you VERY much anyway!!!

Report · Oct 17, 2011

Yes if this is the only time you are going to do that I'm agreeing with you, it is very expensive. But for a regular webdesigner I don't think it is worth to spend days to find a solution on the internet expecially when you have to face situations like that many times and any time with different details, if it is true that "time is money" it would be much more expensive to spend weeks or months to find a solution that you could have at your finger tips. After all regular webdesigners don't love coding.

Of course I don't know your state so, in one way such a solution may be expensive on the other way it is not, but that was just a suggestion.

Thanks to you

Report · Oct 17, 2011

You are right plus the library is AWESOME!!!!!!!

Shame I do this just for once.

Thanks for the tip 😉

Jaume

Report · Feb 07, 2013

Hi, sorry for my english, my english is very bad

My code, as the code is exposed:

// Variables

# Definiendo la carpeta #
$target = "productos/";
# Definiendo la variable IMAGEN #
$mat_img = $_FILES['mat_img']['name'];
# Haciendo que funcione! #
$target = $target . basename( $_FILES['mat_img']['name']);

// Insert dreamweaver

// change $_FILES['mat_img']['name'], "text"),

GetSQLValueString($_FILES['mat_img']['name'], "text"),

// And finish

if(move_uploaded_file($_FILES['mat_img']['tmp_name'], $target))
{
mysql_select_db($database_adis, $adis);
# Ejectutar la consulta para insertar! #
$Result1 = mysql_query($insertSQL, $adis) or die(mysql_error());
$insertGoTo = "bien.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
# Si todo salio exito!, mostar mensaje! #
echo "The file ". basename( $_FILES['mat_img']['name']). " has been uploaded, and your information has been added to the directory";
}
else {
# Y si no, mostrar un mensaje! #
echo "Sorry, there was a problem uploading your file.";
}

// Code Complete

<?php
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
}
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
}
return $theValue;
}
}
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}
# Definiendo la carpeta #
$target = "productos/";
# Definiendo la variable IMAGEN #
$mat_img = $_FILES['mat_img']['name'];
# Haciendo que funcione! #
$target = $target . basename( $_FILES['mat_img']['name']);
if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form")) {
$insertSQL = sprintf("INSERT INTO material (mat_tipo, mat_fecha, mat_numero, mat_codigo, mat_deta1, mat_deta2, mat_img, idcolaborador, idciudad, idlocal, direccion, hora, costo, fechapanel, idestado) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($_POST['mat_tipo'], "int"),
                       GetSQLValueString($_POST['mat_fecha'], "text"),
                       GetSQLValueString($_POST['mat_numero'], "text"),
                       GetSQLValueString($_POST['mat_codigo'], "text"),
                       GetSQLValueString($_POST['mat_deta1'], "text"),
                       GetSQLValueString($_POST['mat_deta2'], "text"),
                       GetSQLValueString($_FILES['mat_img']['name'], "text"),
                       GetSQLValueString($_POST['idcolaborador'], "int"),
                       GetSQLValueString($_POST['idciudad'], "int"),
                       GetSQLValueString($_POST['idlocal'], "int"),
                       GetSQLValueString($_POST['direccion'], "text"),
                       GetSQLValueString($_POST['hora'], "text"),
                       GetSQLValueString($_POST['costo'], "text"),
                       GetSQLValueString($_POST['fechapanel'], "text"),
                       GetSQLValueString($_POST['idestado'], "int"));

# Si todo salio OK, copiar la imagen a la carpeta definida #
if(move_uploaded_file($_FILES['mat_img']['tmp_name'], $target))
{

mysql_select_db($database_adis, $adis);
# Ejectutar la consulta para insertar! #
$Result1 = mysql_query($insertSQL, $adis) or die(mysql_error());
$insertGoTo = "bien.php";
if (isset($_SERVER['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
# Si todo salio exito!, mostar mensaje! #
echo "The file ". basename( $_FILES['mat_img']['name']). " has been uploaded, and your information has been added to the directory";
}
else {
# Y si no, mostrar un mensaje! #
echo "Sorry, there was a problem uploading your file.";
}
}
mysql_select_db($database_adis, $adis);
$query_disertante = "SELECT * FROM colaboradores";
$disertante = mysql_query($query_disertante, $adis) or die(mysql_error());
$row_disertante = mysql_fetch_assoc($disertante);
$totalRows_disertante = mysql_num_rows($disertante);
mysql_select_db($database_adis, $adis);
$query_ciudad = "SELECT * FROM ciudades";
$ciudad = mysql_query($query_ciudad, $adis) or die(mysql_error());
$row_ciudad = mysql_fetch_assoc($ciudad);
$totalRows_ciudad = mysql_num_rows($ciudad);
mysql_select_db($database_adis, $adis);
$query_locales = "SELECT * FROM locales";
$locales = mysql_query($query_locales, $adis) or die(mysql_error());
$row_locales = mysql_fetch_assoc($locales);
$totalRows_locales = mysql_num_rows($locales);
?>

Hope you are useful!

Report · Feb 09, 2014

Hello Goldbecca and ALL:

Please I need your assistance.

I followsed the procedues head to toll but my images are not uploading. Please could you go through and kindly advice. I have spent all night working on this but its not uploading to the upload folder inside the Image folder.

Here is the fiest part ofd the code on the same page

$editFormAction = $_SERVER['PHP_SELF'];

if (isset($_SERVER['QUERY_STRING'])) {

$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);

}

$target = "images/uploads/"; //This is the directory where images will be saved//

$target = $target . basename( $_FILES['Projimg1']['name']);

$target = $target . basename( $_FILES['Projimg2']['name']);

$target = $target . basename( $_FILES['Projimg3']['name']);

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "submitpage")) {

$insertSQL = sprintf("INSERT INTO tbl_projects (projcode, projname, projdesc, projdateentered, projcommunity, projlga, projstate, projcost, projtype, projbaselinedata, Projexpoutcome, adultmen, adultfem, totalchildren, totalben, projteamlead, projdepteamlead, projofficer, projliasonofficer, projmeeting1, projmeeting2, projmeeting3, projmousigndate, projstartdate, projenddate, Projdoc1, Projdoc2, Projdoc3, Projimg1, Projimg2, Projimg3) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",

GetSQLValueString($_POST['projcode'], "text"),

GetSQLValueString($_POST['projname'], "text"),

GetSQLValueString($_POST['projdesc'], "text"),

GetSQLValueString($_POST['projdateentered'], "date"),

GetSQLValueString($_POST['projcommunity'], "text"),

GetSQLValueString($_POST['projlga'], "text"),

GetSQLValueString($_POST['projstate'], "text"),

GetSQLValueString($_POST['projcost'], "double"),

GetSQLValueString($_POST['projtype'], "text"),

GetSQLValueString($_POST['projbaselinedata'], "text"),

GetSQLValueString($_POST['Projexpoutcome'], "text"),

GetSQLValueString($_POST['adultmen'], "int"),

GetSQLValueString($_POST['adultfem'], "int"),

GetSQLValueString($_POST['totalchildren'], "int"),

GetSQLValueString($_POST['totalben'], "int"),

GetSQLValueString($_POST['projteamlead'], "text"),

GetSQLValueString($_POST['projdepteamlead'], "text"),

GetSQLValueString($_POST['projofficer'], "text"),

GetSQLValueString($_POST['projliasonofficer'], "text"),

GetSQLValueString($_POST['projmeeting1'], "date"),

GetSQLValueString($_POST['projmeeting2'], "date"),

GetSQLValueString($_POST['projmeeting3'], "date"),

GetSQLValueString($_POST['projmousigndate'], "date"),

GetSQLValueString($_POST['projstartdate'], "date"),

GetSQLValueString($_POST['projenddate'], "date"),

GetSQLValueString($_POST['Projdoc1'], "text"),

GetSQLValueString($_POST['Projdoc2'], "text"),

GetSQLValueString($_POST['Projdoc3'], "text"),

GetSQLValueString($_FILES['Projimg1']['name'], "text"),

GetSQLValueString($_FILES['Projimg2']['name'], "text"),

GetSQLValueString($_FILES['Projimg3']['name'], "text"));

mysql_select_db($database_ProjMonEva, $ProjMonEva);

$Result1 = mysql_query($insertSQL, $ProjMonEva) or die(mysql_error());

$insertGoTo = "projects.php";

if (isset($_SERVER['QUERY_STRING'])) {

$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";

$insertGoTo .= $_SERVER['QUERY_STRING'];

}

header(sprintf("Location: %s", $insertGoTo));

}

//This code writes the photo to the server//

if(move_uploaded_file($_FILES['Projimg1']['tmp_name'], $target))

{

//And confirms it has worked//

echo "The file ". basename( $_FILES['Projimg1']['name']). " has been uploaded, and your information has been added to the directory";

}

else {

//Gives error if not correct//

echo "Sorry, there was a problem uploading your file.";

}

//This code writes the photo to the server//

if(move_uploaded_file($_FILES['Projimg2']['tmp_name'], $target))

{

//And confirms it has worked//

echo "The file ". basename( $_FILES['Projimg2']['name']). " has been uploaded, and your information has been added to the directory";

}

else {

//Gives error if not correct//

echo "Sorry, there was a problem uploading your file.";

}

//This code writes the photo to the server//

if(move_uploaded_file($_FILES['Projimg3']['tmp_name'], $target))

{

//And confirms it has worked//

echo "The file ". basename( $_FILES['Projimg3']['name']). " has been uploaded, and your information has been added to the directory";

}

else {

//Gives error if not correct//

echo "Sorry, there was a problem uploading your file.";

}

and the second part on the same page

<legend>Review & Submit</legend>

<tr>

<td colspan="2"><strong>Core Project Details</strong></td>

</tr>

<td width="235"><p>Project Code:

</p></td>

Project Name:

</p></td>

</tr>

<td colspan="2"><p>Project Description:<span id="description"></span></p> <p>

</p></td>

</tr>

<td><p>Project Year:

</p></td>

<td><p>Project LGA:

</p></td>

</tr>

<td><p>Project Community:

</p></td>

<td><p>Project State:

</p></td>

</tr>

<td colspan="2"><p>Project Baseline Data:</p> <p>

</p></td>

</tr>

<td colspan="2"><p>Expected Outcome Of Project:</p> <p>

</p></td>

</tr>

<td><p>Project Cost:

</p></td>

<td><p>

Project Type:

</p></td>

</tr>

<tr>

<td colspan="2"><strong>Beneficiaries</strong></td>

</tr>

<td><p>Adult Men Beneficiaries:

</p></td>

<td><p>Adult Female Beneficiaries:

</p></td>

</tr>

<td><p>Adult Children Beneficiaries:

</p></td>

<td><p>Total Beneficiaries:

<input name="totalben" type="text" id="totalben" value="<?php echo $_POST['totalben']; ?>" readonly="readonly" />

</p></td>

</tr>

<tr>

<td colspan="2"><strong>Project Team</strong></td>

</tr>

<td><p>Project Team Leader:

</p></td>

<td><p>Deputy Team Leader:

</p></td>

</tr>

<td><p>Project Officer:

</p></td>

<td><p>Liason Officer:

</p></td>

</tr>

<tr>

<td colspan="2"><strong>Meeting Dates</strong></td>

</tr>

<td><p>First Project Meeting Date:

</p></td>

<td><p>Third Project Meeting Date:

</p></td>

</tr>

<td><p>Second Project Meeting

Date:

</p></td>

</tr>

<tr>

<td colspan="2"><strong>Other Dates</strong></td>

</tr>

<td><p>Project Start Date:

</p></td>

<td><p>MoU Signing Date:

</p></td>

</tr>

<td><p>Project End Date:

</p></td>

</tr>

<tr>

</tr>

<td colspan="2" id="moredetails"><strong>Upload Initial Project Documents/Pictures</strong></td>

</tr>

<tr>

<td id="formcells"><p>Document/Picture One:

</p></td>

<td id="formcells"><p>Document/Picture Four:

</p></td>

</tr>

<tr>

<td id="formcells"><p>Document/Picture Two:

</p></td>

<td id="formcells"><p>Document/Picture Five:

</p></td>

</tr>

<tr>

<td id="formcells"><p>Document/Picture Three:

</p></td>

<td id="formcells"><p>Document/Picture Six:

</p></td>

</tr>

<tr>

</tr>

</table>

<p>

</p>

</div>

</form>

</fieldset>

Report · Feb 09, 2014

In the future, you should probably not reply to a 3 year old post and expect to get many replies - especially when that post was marked as 'Resolved'.

The first thing I noticed is that you have not set the correct enctype for file uploads.

You need to have the enctype="multipart/form-data" in your form tag. I haven't really looked further, there may be other problems.

Report · Feb 10, 2014

1. Agreed. Amend the line:

to:

2. Also, is this file in the same directory as your images folder? If not, this line won't work:

$target = "images/uploads/"; //This is the directory where images will be saved//

It needs to be relative to the path, or make it absolute (http://www.yoursite.com/images/uploads/)

3. I also think, and this was written so long ago that I can't really remember, the three lines relating to confirmation eg:

//And confirms it has worked//

echo "The file ". basename( $_FILES['Projimg1']['name']). " has been uploaded, and your information has been added to the directory";

Should say:

//Tells you if its all ok

echo "The file ". basename( $_FILES['uploadedfile']['name']). " has been uploaded, and your information has been added to the directory";

Ie, I don't think you need the image field here, just the word 'uploadedfile'. Though I can't find where this would relate to so I could be wrong

Report · Feb 10, 2014

Hi Goldbecca,

Thank you for your response.

I followed your corrections but the upload still did not go through. Just to be sure I did all things well, on this line

$target = "images/uploads/"; //This is the directory where images will be saved//

It needs to be relative to the path, or make it absolute (http://www.yoursite.com/images/uploads/)

am I supposed to put the image path is double quote like this "http://localhost/projmoneva/images/uploads/" or should I just live it like this http://localhost/projmoneva/images/uploads/?

Thank you

Mik

Report · Feb 10, 2014

I really don't know much about php, but I'd be surprised if a file based function like move_uploaded_file() works with an absolute url. Really, I think you are much better off referencing the document root:

target_path = $_SERVER['DOCUMENT_ROOT'] . "/uploads/" . basename( $_FILES['Projimg1']['name']).

>am I supposed to put the image path is double quote

Of course - you are populating a variable with a string.

What error message if any are you getting? Do you have error reporting enabled?

Report · Feb 10, 2014

I am also having errors on lines

$target = $target . basename( $_FILES['Projimg1']['name']);

$target = $target . basename( $_FILES['Projimg2']['name']);

$target = $target . basename( $_FILES['Projimg3']['name']);

and this ones aswell

if(move_uploaded_file($_FILES['Projimg1']['tmp_name'], $target))

if(move_uploaded_file($_FILES['Projimg2']['tmp_name'], $target))

if(move_uploaded_file($_FILES['Projimg3']['tmp_name'], $target))

See image below

Save image path to MySQL and store file

1 Correct answer