How To Upload File From Users Computer To Database

eleven Years Ago

For you requirements it sounds like you want a separate table for each user. Although I'm non sure if this is the virtually efficient option.

Perhaps you lot could add a field on your table to agree user_id which would reference your users table using foriegn/principal keys. And so you could utilize a SELECT where user_id='blah blah'.

Otherwise to practice it your manner, just create a 'files' table for each user upon registration. Call the table name $user_id.'files' (that variable tin come up from $_POST or your session variables. And so yous tin use $query = "SELECT * from ".$user_id."files;" in your lawmaking that recalls the information.

Edited eleven Years Agone by tr4ssj2 because: n/a

ryan311 -7 Posting Whiz in Grooming

11 Years Ago

create userid to your file table to make a unique file to the user.

too i suggest to yous, do not put your file in your dbase information technology will get bigger and hard to load someday/somehow, create a binder to upload all of your files there. delete this code and delete the information entity to your database

$data = $dbLink->real_escape_string(file_get_contents($_FILES ));

try this code.

              <?php // Cheque if a file has been uploaded if(isset($_FILES['uploaded_file'])) {     // Brand sure the file was sent without errors     if($_FILES['uploaded_file']['error'] == 0) {         // Connect to the database         $dbLink = new mysqli('xxxxx', 'xxxxx', 'xxxxx', 'xxxxx');         if(mysqli_connect_errno()) {             dice("MySQL connection failed: ". mysqli_connect_error());         }   $target = "images/";  $target = $target . basename( $_FILES['uploaded_file']['proper name']);          // Gather all required data         $userid = $_SESSION['id']; //login session         $proper noun = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);         $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);      // delete this line   $data = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));         $size = intval($_FILES['uploaded_file']['size']);           // Create the SQL query        //add userid to your database delete the data entity.         $query = "             INSERT INTO `file` (               `userid`,  `proper noun`, `mime`, `size`, `created`             )             VALUES ('{$userid}',                 '{$name}', '{$mime}', {$size}, NOW()             )";           // Execute the query         $result = $dbLink->query($query);           // Cheque if information technology was successfull         if($result) {             move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $target);             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 existence 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 folio echo '<p>Click <a href="index.php">here</a> to go back!</p>'; ?>

Edited 11 Years Ago by ryan311 because: due north/a

ryan311 -7 Posting Whiz in Preparation

11 Years Ago

i have ane question for yous.

can user download and share the file?

if yous say yeah

here is your code:

              <?php // Cheque 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('xxxxx', 'xxxxx', 'xxxxx', 'xxxxx');         if(mysqli_connect_errno()) {             die("MySQL connection failed: ". mysqli_connect_error());         }  $userid = $_SESSION['id']; //login session $target = "images/".$userid."_";  $target = $target . basename( $_FILES['uploaded_file']['name']);          // Gather all required data                  $proper noun = $dbLink->real_escape_string($_FILES['uploaded_file']['name']);         $mime = $dbLink->real_escape_string($_FILES['uploaded_file']['type']);      // delete this line   $information = $dbLink->real_escape_string(file_get_contents($_FILES  ['uploaded_file']['tmp_name']));         $size = intval($_FILES['uploaded_file']['size']);           // Create the SQL query        //add userid to your database delete the information entity.         $query = "             INSERT INTO `file` (               `userid`,  `name`, `mime`, `size`, `created`             )             VALUES ('{$userid}',                 '{$name}', '{$mime}', {$size}, At present()             )";           // Execute the query         $result = $dbLink->query($query);           // Check if it was successfull         if($outcome) {             move_uploaded_file($_FILES['uploaded_file']['tmp_name'], $target);             echo 'Success! Your file was successfully added!';         }         else {             repeat 'Error! Failed to insert the file'                . "<pre>{$dbLink->fault}</pre>";         }     }     else {         repeat 'An error accured while the file was existence uploaded. '            . 'Error code: '. intval($_FILES['uploaded_file']['error']);     }       // Close the mysql connexion     $dbLink->shut(); } else {     echo 'Error! A file was not sent!'; }   // Repeat a link back to the master page echo '<p>Click <a href="index.php">here</a> to go back!</p>'; ?>

if you say no only add userid to your file.

to view all of his file

              <table cellpadding="0" cellspacing="0" border="ane">        <tr>        <thursday bgcolor="black" width="150"><p><font color="white">File Proper name</font></p></th>        <thursday bgcolor="blackness" width="150"><p><font color="white">Date Uploaded</font></p></th>         </tr>         <?php             $id = $_SESSION['id']; // login session. 	   $sql = "Select * from file where userid='$id'"; 	    	   $result = mysql_query($sql); 	    	   while($row = mysql_fetch_assoc($issue)) { 	   ?>        <tr>                <td><p><font colour="#000099"><?php repeat $row['name']; ?></font></p></td>        <td><p><?php echo $row['created']; ?></p></td>        </tr>         <?php 	   } 	   ?>        </Tabular array>

ryan311 -7 Posting Whiz in Training

11 Years Ago

no, don't rename or delete the id in your file because that is the unique file you need that in downloading or sharing a file. just add userid entity into your file

so hither is the entity of your file table

-id /auto_increment
-userid /userid
-name / file name
-mime / file type
-size / file size
-created