[SOLVED] Code working on local host but not on server

[hane]

Hi I need some help please I got an image upload code that loads the image to the folder and stores the filename in a mysql database. Now it works 100% when I run the code locally with XAMPP but it doesnt update the record in mysql when I do it on my webserver.

 

Here is my action code:

 

<?php
$uploadDir = '../excaload/foto/';
$id=$_POST["id"];
if(isset($_POST['upload']))
{
$fileName = $_FILES['userfile']['name'];
$tmpName = $_FILES['userfile']['tmp_name'];
$fileSize = $_FILES['userfile']['size'];
$fileType = $_FILES['userfile']['type'];

$filePath = $uploadDir . $fileName;

$result = move_uploaded_file($tmpName, $filePath);
if (!$result) {
echo "Error uploading file";
exit;
}

$con = mysql_connect("xxxxxxx","xxxxxxx","xxxxxx");
if (!$con)
  {
  die('Error connecting to database');
  }

mysql_select_db("xxxxx", $con);

if(!get_magic_quotes_gpc())
{
$fileName = addslashes($fileName);
$filePath = addslashes($filePath);
}

mysql_query("UPDATE c_listing SET image ='" . "$fileName" . "' WHERE c_listing_id ='" . "$id" . "' ");

mysql_close($con);

echo "<img src='../excaload/foto/" . "$fileName" . "' alt='' width='300'/>";

}
?>

 

I just need someone else to look at the code because I've been going through it over and over and I'm missing it. All the rest of my insert and update statements on the website work. Thanks for having a look

[dennismonsewicz]

it could be possible that you don't have 777 permissions on that folder you are moving the files into

[dennismonsewicz]

if that is the case take a look here:

http://us2.php.net/manual/en/function.chmod.php

[hane]

the file gets loaded, the name just isn't being written to the database

[dennismonsewicz]

change

mysql_query("UPDATE c_listing SET image ='" . "$fileName" . "' WHERE c_listing_id ='" . "$id" . "' ");

 

to

mysql_query("UPDATE c_listing SET image ='$fileName' WHERE c_listing_id ='$id' ");

[hane]

Nope not working

[dennismonsewicz]

print_r($fileName) and make sure there is something there.

[hane]

the file name must be there because after the upload it must show me the image by using the $filename and it does. And also it works on my local host

[dennismonsewicz]

change ur mysql statement to:

 

mysql_query("UPDATE c_listing SET image ='" . "$fileName" . "' WHERE c_listing_id ='" . "$id" . "' ")or trigger_error(mysql_error());

[hane]

It doenst upload the filename to the database and it doesnt give me an error

[hane]

I got it, thanks for your help.

 

The $id wat empty as I wasnt posting it from my form.

 

Thanks again