update file on mysql using PHP

ddtpmyra

Im having trouble on updating the file inside mysql database using the php. Should I use <form> or im wrong on how I called the variable from previous page?

FORM 1 - that accepts the file pointer to upload.

Expand|Select|Wrap|Line Numbers

 
# Get the ID

$id = $_GET['id'];

.....

echo "<p>Replace CMR Document: <input type=\"file\" name=\"uploaded_file\" size=\"43\">";

echo "<a href='replaceCMR.php?id=$id}'>Replace";

FORM2 - the php script that will update mysql.

Expand|Select|Wrap|Line Numbers

 <?php

# Check if a file has been uploaded

if(isset($_FILES['uploaded_file']))

{

    # Make sure the file was sent without errors

    if($_FILES['uploaded_file']['error'] == 0)

    {

        # Connect to the database

        .....
 
        # Gather all required data

        $name = mysql_real_escape_string($_FILES['uploaded_file']['name'], $dbLink);

        $mime = mysql_real_escape_string($_FILES['uploaded_file']['type'], $dbLink);

        $size = $_FILES['uploaded_file']['size'];

        $data = mysql_real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']), $dbLink);
 
        # INSERT SQL query

        $query = "

           UPDATE fileStorage  

            SET                     FileName= '{$name}',

                                    FileMime ='{$mime}',

                                    FileSize = {$size},

                                    FileData = '{$data}'

            WHERE                     FileID = {$id}";
 
        # Execute the INSERT QUERY

        $result = mysql_query($query, $dbLink);
 
        # Check if it was successfull

        if($result)

        {

            echo "<b>Success! ";

        }

        else

        {

            echo "Error! Failed to updatethe file";

            echo "<pre>". mysql_error($dbLink) ."</pre>";

        }

    }

    else

    {

        echo "Error!

                An error accured while the file was being uploaded.

                Error code: ". $_FILES['uploaded_file']['error'];

    }
 
}

else

{

    echo "Error! A file was not sent!";

}
 
?>

ddtpmyra

to make a little bit simple.

form

Expand|Select|Wrap|Line Numbers

 <html>

<body>
 
<form action="replaceCMR1.php" method="post"

enctype="multipart/form-data">

<label for="uploaded_file">Filename:</label>

<input type="file" name="file" id="file" /> 

<br />

<input type="submit" name="submit" value="Submit" />

</form>
 
</body>

</html>

uploader

Expand|Select|Wrap|Line Numbers

 <?php

# Check if a file has been uploaded

if(isset($_FILES['uploaded_file']))

{

    # Make sure the file was sent without errors

    if($_FILES['uploaded_file']['error'] == 0)

    {

        # Connect to the database

       .....
 
        # Gather all required data

        $name = mysql_real_escape_string($_FILES['uploaded_file']['name'], $dbLink);

        $mime = mysql_real_escape_string($_FILES['uploaded_file']['type'], $dbLink);

        $size = $_FILES['uploaded_file']['size'];

        $data = mysql_real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']), $dbLink);
 
  # INSERT SQL query

        $query = "

            UPDATE fileStorage  

            SET                     FileName= '{$name}',

                                    FileMime ='{$mime}',

                                    FileSize = {$size},

                                    FileData = '{$data}'

            WHERE                     FileID = {$id}";
 
        # Execute the INSERT QUERY

        $result = mysql_query($query, $dbLink);
 
        # Check if it was successfull

        if($result)

        {

            echo "<b>Success! Your file was successfully added!<br>";

            echo "Email alert was sent to reviewer's group</b>";
 
        }

        else

        {

            echo "Error! Failed to insert the file";

            echo "<pre>". mysql_error($dbLink) ."</pre>";

        }

    }

    else

    {

        echo "Error!

                An error accured while the file was being uploaded.

                Error code: ". $_FILES['uploaded_file']['error'];

    }
 
}

else

{

    echo "Error! A file was not sent!";

}
 
?>

ddtpmyra

Now i was able to update the records but it's blank it looks like
below code is not working. HELP!

Expand|Select|Wrap|Line Numbers

 # Gather all required data 

        $name = mysql_real_escape_string($_FILES['uploaded_file']['name'], $dbLink); 

        $mime = mysql_real_escape_string($_FILES['uploaded_file']['type'], $dbLink); 

        $size = $_FILES['uploaded_file']['size']; 

        $data = mysql_real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']), $dbLink);

ddtpmyra

I got it its the name on my first form should be name=uploaded_file

thanks!

roseple

Hi, why does this error occur:

Error:

Quote:

Error! Failed to insert the file

MySQL server has gone away

I don't know what to edit anymore..

Thanks..

update file on mysql using PHP

re: update file on mysql using PHP

re: update file on mysql using PHP

re: update file on mysql using PHP

re: update file on mysql using PHP

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/about