update file on mysql using PHP

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • ddtpmyra
    Contributor
    • Jun 2008
    • 333
    #1

    update file on mysql using PHP

    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.
    Code:
    # 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.

    Code:
    <?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!";
}


?>
    Tags: None
    • ddtpmyra
      Contributor
      • Jun 2008
      • 333
      #2
      to make a little bit simple.

      form
      Code:
      <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
      Code:
      <?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!";
}

?>

        Comment

        • ddtpmyra
          Contributor
          • Jun 2008
          • 333
          #3
          Now i was able to update the records but it's blank it looks like
          below code is not working. HELP!

          Code:
          # 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);

            Comment

            • ddtpmyra
              Contributor
              • Jun 2008
              • 333
              #4
              I got it its the name on my first form should be name=uploaded_f ile

              thanks!

                Comment

                • roseple
                  New Member
                  • Jun 2009
                  • 26
                  #5
                  Hi, why does this error occur:

                  Error:
                  Error! Failed to insert the file

                  MySQL server has gone away
                  I don't know what to edit anymore..

                  Thanks..

                    Comment

                    Previous template Next
                    Working...