Dear Friends,

Im trying below code to update my user table but it doesn't work,

PHP Code:

$username = $this->qls->make_safe($username);
  $result = $this->qls->SQL->select('*',
  'users',
  array('username' =>
   array(
    '=',
    $username
   )
  )
 );
 $row = $this->qls->SQL->fetch_array($result);
 $this->qls->SQL->update('users',
   array(
    'profile_photo' => $newfilename
   ),
   array('username' =>
    array(
     '=',
     $username
    )
   )
  ); 


Your valuble suggestion is required.

Iggy

You have given too little information for us to do anything but guess. Just saying "it doesn't work" and showing some short code snippet isn't going to get you anywhere.

What is it that doesn't work? What should happen and what happens instead? Are there any error messages? What does the code mean, i.e. what does the different functions do and what do they look like (like the select() function)?

Dear Lizciz,

Sorry, Actually Im using this coding for upload of profile Image. Where Im trying to update my user table with the uploaded file name. File name not getting updated.

PHP Code:

function uploaded_file() {
 $temporary_file_location = $_FILES['upload']['tmp_name'];
 $filename = $_FILES['file']['name']; 
 $file_ext = strtolower(substr($_FILES['upload']['name'], -4));
 if (($file_ext == '.jpg') || ($file_ext == '.png') || ($file_ext == '.gif')){}
 $newfilename = rand() . $file_ext; 
 $new_file_location = $this->qls->main_directory . '/profile_photo/' . $newfilename;          
                 if ($this->validate_existance()){
                 if ($this->validate_size()){
                        if ($this->validate_extensions()) {                  
   // Is it an uploaded file? If so move it to the proper directory
   if (is_uploaded_file($temporary_file_location)) {
   if (move_uploaded_file($temporary_file_location, $new_file_location)) { 
        $username = $this->qls->make_safe($username);
  $result = $this->qls->SQL->select('*',
  'users',
  array('username' =>
   array(
    '=',
    $username
   )
  )
 );
 $row = $this->qls->SQL->fetch_array($result);
 $this->qls->SQL->update('users',
   array(
    'profile_photo' => $newfilename
   ),
   array('username' =>
    array(
     '=',
     $username
    )
   )
  );  
                                         
    return true;
    }    
    else {
    $this->qls->User->add_page_error = FILE_NOT_MOVED;
    return false;
    }
   }
   else {
  $this->qls->User->add_page_error = FILE_NOT_UPLOADED;
  return false;
  }   
  }
  else {
  $this->qls->User->add_page_error = FILE_EXTENSION_ERROR;
  return false;
  }
 }
 else {
   $this->qls->User->add_page_error = FILE_TOO_BIG;
   return false;
   }
}
  
else {
 $this->qls->User->add_page_error = FILE_EXISTS;
 return false;
 }
} 


Please tell me any further information required.

BR,
Iggy

You're calling various methods to do the db queries - we need to see those.

I can't see why you're messing around with unusual string arrays in the code you have given or where you're getting $username from. Read up on associative arrays anyway but you don't need them here - just pass the filename/username as args to the called methods.

Dear PaulW,

Sorry to tell you Im not really from programming line. Im from Telecom.
Jus trying to bring up my own site.

You're calling various methods to do the db queries - we need to see those.

I can't see why you're messing around with unusual string arrays in the code you have given or where you're getting $username from. Read up on associative arrays anyway but you don't need them here - just pass the filename/username as args to the called methods.

really not able to understand what you mean to say??? Even I tried simple update query still it don't work at all. If you don't mind can you please clear it again. soory for the inconvenience.

BR,
Iggy

*Sorry*

Hi,

Even tried,

PHP Code:

$Query = mysql_query("UPDATE qls3_users SET 
                        `profile_photo`='$newfilename'
                         WHERE `id`='$id'") or die(mysql_error()); 


still it is not updating......

Iggy

When you did this last try, did you get any errors from mysql_error() or did it just not update the value? Have you actually checked the value before and after to see that it did not change?

Have you checked that the $newfilename and $id variables have the values you'd expect? Try i.e. to dump them with

PHP Code:

var_dump($newfilename, $id) 


You should try to narrow down where the error occurs. Add some debug echos here and there to verify that all variables have the expected values and that functions returns what they should.

As an example:

PHP Code:

// ...
$a = get_a_number();
$b = 6;
var_dump($a, $b); // check what values they have

$c = add_numbers($a, $b);
var_dump($c);

// ... 


Lets say $a is 3 and $b is 6, then $c should be 9. But $c is 13, then that would tell you that the error lies somewhere in the function add_numbers().

PHP Code:

// ...
$a = get_mood();
if ($a == "happy") {
    do_something();
    echo "1"; // some simple debug
} else {
    do_something_else();
    echo "2";
}
// ... 


Lets say $a should be "happy", but the script echoes "2", that tells you that there's probably something wrong with the function get_mood().

After you've narrowed down the error, you might spot the problem yourself, or else you will at least have more information to give here on the forum and someone might be able to help you further.

Hi Iggy, I was trying to say "there's more php somewhere, can we see it" The form that's being processed would also be useful - you're mentioning a username and an id in your posts and I'm wondering where they come from.

Dear Paul/Lizciz,

Im totally confused with my coding itself. Now Im planning to change the coding completely for upload. Let me check whether it works or not? If it doesn't, I will come back for help. Sorry for now & thanks for your support.

Iggy

Dear Paul/Lizciz,

I fixed the problem. You people are really gr8.
Mistake I did was I haven't gave username info in my form.
I was simply fetching the user info in air...lol.

Thanks for you valuable support.
I got a long way to go. I will get back to you again & again now...

BR,
Ignatius