开发者

MySQL Update Statement + File Upload

开发者 https://www.devze.com 2022-12-09 17:49 出处:网络
Been staring at this all day and can\'t seem to figure out why 开发者_Go百科my update statement fails to update the field \'image_filename\':

Been staring at this all day and can't seem to figure out why 开发者_Go百科my update statement fails to update the field 'image_filename':

 $fileName = $_FILES['image_filename'];

 if($fileName["name"] <> ""){
      $imageFile = $fileName['name']; 
      $destination = "../../../../assets/resources/images/".$fileName['name'];
      move_uploaded_file($fileName['name'], $destination);
 } 

 $updateSQL = sprintf("UPDATE content SET image_filename='$imageFile' WHERE id=%s",
 GetSQLValueString($_POST['resource_id'], "int"));

 mysql_select_db($database_conn_talent, $conn_talent);
 $Result1 = mysql_query($updateSQL, $conn_talent) or die(mysql_error());

Can a SQL pro tell me what I"m missing? Much thanks in advance for your feedback!


You appear to be building a query, but never executing it. Also, Drupal'll handle all the sprintfing for you, if you let it.

$query = "UPDATE content SET image_filename='$imageFile' WHERE id=%i";
db_query($query, $_POST['resource_id']);
0

精彩评论

暂无评论...
验证码 换一张
取 消