Jump to content

UPDATE command not working


Recommended Posts

Hi all!!!

 

Has ne1 got a script that allows them to upload images and UPDATE MYSQL db with the filename? I am stumped as to why this script won't UPDATE. Uploading the images is working.

 

My script:

 

<?php require_once('../Connections/conn_peninsula.php'); ?>
<?php
$colname_rs_uploadimage1 = "1";
if (isset($_GET['ID'])) {
$colname_rs_uploadimage1 = (get_magic_quotes_gpc()) ? $_GET['ID'] : addslashes($_GET['ID']);
}
mysql_select_db($database_conn_peninsula, $conn_peninsula);
$query_rs_uploadimage1 = sprintf("SELECT ID, Image1 FROM tbl_product WHERE ID = %s", $colname_rs_uploadimage1);
$rs_uploadimage1 = mysql_query($query_rs_uploadimage1, $conn_peninsula) or die(mysql_error());
$row_rs_uploadimage1 = mysql_fetch_assoc($rs_uploadimage1);
$totalRows_rs_uploadimage1 = mysql_num_rows($rs_uploadimage1);
?>
<form enctype="multipart/form-data" action="uploadimage1.php" method="POST" name="upload_file"> 
<input type="hidden" name="MAX_FILE_SIZE" value="5000000"> 
<input name="image1" type="file" id="image1" value="<?php echo $row_rs_uploadimage1['Image1']; ?>"> 
<input type="submit" value="upload" name="file_uploaded"> 
<input name="id" type="hidden" id="id" value="<?php echo $row_rs_uploadimage1['ID']; ?>">
<input type="hidden" name="MM_update" value="upload_file">
</form> 

upload.php:
<?php
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
$theValue = (!get_magic_quotes_gpc()) ? addslashes($theValue) : $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;
}

if (is_uploaded_file($_FILES['image1']['tmp_name'])) 
{ 
$file_realname = $_FILES['image1']['name']; 

copy($_FILES['image1']['tmp_name'], ".../images/$file_realname"); 
} else 
{ 
echo "<b><font color=red>No file uploaded.</font></b>"; } 
[COLOR=red]updateSQL = sprintf("UPDATE tbl_product SET Image1='$filename_realname' WHERE id=%s",
GetSQLValueString($_POST['ID'], "int"));
mysql_select_db($database_conn_peninsula, $conn_peninsula);
$Result1 = mysql_query($updateSQL, $conn_peninsula) or die(mysql_error());
mysql_free_result($rs_uploadimage1);[/COLOR]?>

If ne1 can shed some light, that would be excellent, as I hav searched the web for a script but have found none.

 

G :huh:

Link to comment
Share on other sites

Laying out your functions in some kind of order would help. Is this one script or 2? If one where is uploadimage1.php? Also why specify a MAX_FILESIZE if you dont use it in your script. Lay out your code in the order they are intended to work in balanced brackets and the code will work.

 

 <form enctype="multipart/form-data" action="uploadimage1.php" 

 

 

Also in the code below you are trying to update a table with infomation if a file is NOT uploaded.

 

if (is_uploaded_file($_FILES['image1']['tmp_name'])) 
{ 
$file_realname = $_FILES['image1']['name']; 

copy($_FILES['image1']['tmp_name'], ".../images/$file_realname"); 
} else 
{ 
echo "<b><font color=red>No file uploaded.</font></b>"; } 
[COLOR=red]updateSQL = sprintf("UPDATE tbl_product SET Image1='$filename_realname' WHERE id=%s",
GetSQLValueString($_POST['ID'], "int"));
mysql_select_db($database_conn_peninsula, $conn_peninsula);
$Result1 = mysql_query($updateSQL, $conn_peninsula) or die(mysql_error());

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.