CODEWITHSUNDEEP
phpsql
user3266957
user3266957

Reputation: 284

how to get picture filename from database?

I want to get the database picture path so that i can used it and store the same file-name path in the image folder so both can be matched up. Actually i am using a unique-id so that pictures have unique names but don't know how to use it rightly. Any help would be appreciated. 

$insert = "UPDATE USER_LOGIN SET PICTURE = '".uniqid().$_FILES['file']['name']."' WHERE USERNAME = '".$_COOKIE['username']."'";

$result = oci_parse($con, $insert);


// Executes a statement.

$check = oci_execute($result);


$UploadDirectory = '/wamp/www/img/Users/Users/'.$row['PICTURE'];

Upvotes: 1

Views: 311

Answers (1)

user3266957
user3266957

Reputation: 284

Working Solution:

              if($row)
              {

                    $Filename = uniqid().$_FILES['file']['name'];
                    $DirectoryPath = '/wamp/www/img/Users/Users/'.$Filename;
                    if(move_uploaded_file($_FILES['file']['tmp_name'], $DirectoryPath))
                    {

                        $insert = "UPDATE USER_LOGIN SET PICTURE = '".$Filename."' WHERE USERNAME = '".$_COOKIE['username']."'";
                        $result = oci_parse($con, $insert);

                        // Executes a statement.
                        $check = oci_execute($result);

                        if($check)
                        {
                            echo "Saved";

                            // Commit the changes to the table.
                            oci_commit($con);
                        }

                        else
                        {
                            // Rollback changes to table.
                            oci_rollback($con);
                        }
                    }

                    else
                    {
                        //die('error uploading File!');
                    }
              }

Upvotes: 2

Related Questions