0

please if anyone could tell me, how it would be possible,


i want to save the content of a uploaded word document in database field with php, no problem with encrypted file like ( ´V z2Ö<Ö<ôÿÿÿÿÿÿ·üü?????ÿÿÿÿSSS8‹DÏLS¥9à1) as it shows if you open a word document in a browser. just want to save content of whole document in field.

thanks for help in advance. i read it somewhere open file with fopen save it in variable n then save it in database, is it possible in that way ?

2
Contributors
5
Replies
10
Views
6 Years
Discussion Span
Last Post by diafol
0

> i read it somewhere open file with fopen save it in variable n then save it in database, is it possible in that way ?

Have you tried it? It would only take a handful of lines of code.

0

> i read it somewhere open file with fopen save it in variable n then save it in database, is it possible in that way ?

Have you tried it? It would only take a handful of lines of code.

only fopen() didn't work so with lots of tries found the solution for refrence of other people am shearing it here.

<?php // to upload files
include("includes/connection.php");?>
<!DOCTYPE html>
<head>
    <title>MySQL file upload example</title>
    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
    <form action="add_file.php" method="post" enctype="multipart/form-data">
        <input type="file" name="uploaded_file"><br>
        <input type="submit" value="Upload file">
    </form>
    <p>
        <a href="list_files.php">See all files</a>
    </p>
</body>
</html>
<?php //to open and save it in database
// 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
        $dbLink = new mysqli('localhost', 'user', 'password', 'db_name');
        if(mysqli_connect_errno()) {
            die("MySQL connection failed: ". mysqli_connect_error());
        }
 
        // Gather all required data
        $name = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);
        $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);
        $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));
        $size = intval($_FILES['uploaded_file']['size']);
 
        // Create the SQL query
       $query = "UPDATE file SET
							
							name='{$name}',
							mime='{$mime}',
							size='{$size}',
							data='{$data}',
							created= NOW()
							
												  

WHERE name='XYZ'"; 
 // can also use insert query here according to your need
        // Execute the query
        $result = $dbLink->query($query);
 
        // Check if it was successfull
        if($result) {
            echo 'Success! Your file was successfully added!';
        }
        else {
            echo 'Error! Failed to insert the file'
               . "<pre>{$dbLink->error}</pre>";
        }
    }
    else {
        echo 'An error accured while the file was being uploaded. '
           . 'Error code: '. intval($_FILES['uploaded_file']['error']);
    }
 
    // Close the mysql connection
    $dbLink->close();
}
else {
    echo 'Error! A file was not sent!';
}
 
// Echo a link back to the main page
?>
0

Great. DIY is so much sweeter. However, is there an advantage of doing this, since you've already uploaded the file. Why not just save the location in the DB? Seems like a lot of work.

0

Great. DIY is so much sweeter. However, is there an advantage of doing this, since you've already uploaded the file. Why not just save the location in the DB? Seems like a lot of work.

earlier i was using this thing, saving only file name in database, now as i am working on a search query where i required data from uploaded docs (around 100,000 docs), so for that had to make it save in database. well with that docs get save in an encrypted language, but you can get required data by using LIKE in query

0

Does Word save overwritten work as well? I know in earlier forms, versioning was an option. If this is still the case, you could end up getting a positive search result for a file, only to find the search term is no longer in the actual document. Just a thought.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.