Jump to content


Photo

UPDATE command not working


  • Please log in to reply
1 reply to this topic

#1 goldenbrown21

goldenbrown21
  • Members
  • Pip
  • Newbie
  • 9 posts

Posted 08 August 2004 - 07:35 AM

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:

#2 morpheus.100

morpheus.100
  • Members
  • PipPipPip
  • Advanced Member
  • 145 posts

Posted 08 August 2004 - 10:57 PM

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());





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users