Uploading data and files to MySQL database through a single PHP form

Question

I am having some input types in a HTML form and a file uploader. But I am unable to upload both data and file at the same time in the MySQL database. Every time blank entries are filled up into the database...

HTML Form

<form method="post" action="upload.php" enctype="multipart/form-data">
    <p>
        <label>Name:</label>
        <input type="text" name="name" size="40">
    </p>
    <p>
        <label>Email:</label>
        <input type="email" name="email">
    </p>
    <p>
        <input type="radio" name="gen" value="Male">Male
        <input type="radio" name="gen" value="Female">Female</p>
    <input type="hidden" name="MAX_FILE_SIZE" value="1000000">
    <br>File to upload:
    <br>
    <input type="file" name="File" size="40">
    <p>
        <input type="submit" name="submit" value="submit">
</form>

PHP Code

if(isset($_POST['name']) && isset($_POST['email']) &&
        isset($_POST['gen']) && $_FILES['File']['size'] > 0) {
    $name=get_POST('name');
    $email=get_POST('email');
    $gender=get_POST('gen');
    $filename = $_FILES['File']['name'];
    $tmpname  = $_FILES['File']['tmp_name'];
    $filesize = $_FILES['File']['size'];
    $filetype = $_FILES['File']['type'];
    $fp = fopen($tmpname, 'r');
    $file = fread($fp, filesize($tmpname));
    $file = addslashes($file);
    fclose($fp);

    if(!get_magic_quotes_gpc()) {
        $filename = addslashes($filename);
    }
    $query = "
        INSERT INTO uploadform
        (Name, Email, Gender, Filename, Filetype, Filesize, File) VALUES
        ('$name', '$email', '$gender', '$filename', '$filetype', '$filesize', '$file');";

    mysql_query($query) or die('Error, query failed');
}

In the database the datatype of the file is MEDIUMBLOB

possible duplicate of [Insert Blobs in MySql databases with php](http://stackoverflow.com/questions/7052655/insert-blobs-in-mysql-databases-with-php) — RiggsFolly, Jul 09 '14 at 00:18
I overlooked the link but its not what I am looking for; the thing is that I am unable to upload my text data and file to the database from the php form...But if I only try with files then its successful...can I send data and image in to the same row form two different forms...? — , Jul 09 '14 at 08:23

score 0 · Accepted Answer · 2014-07-10T16:54:08.170

Ok I found the Answers...! Just check with the variables...I have used other database and example (common sense)...

<?php 
//This is the directory where images will be saved 
$target = "images/"; 
    if(!is_dir($target)) mkdir($target);
$target = $target . basename( $_FILES['photo']['name']); 

//This gets all the other information from the form 
$name=$_POST['username']; 
$email=$_POST['email']; 
$phone=$_POST['phone']; 
$fname=($_FILES['photo']['name']); 
$tmpName  = $_FILES['photo']['tmp_name'];
$fileSize = $_FILES['photo']['size'];
$fileType = $_FILES['photo']['type'];



//process the file
$fp      = fopen($tmpName, 'r');
$content = fread($fp, filesize($tmpName));
$content = addslashes($content);
fclose($fp);

if(!get_magic_quotes_gpc()){
$fname = addslashes($fname);}

// Connects to your Database 
require_once 'login.php';
$db_server=mysql_connect($db_hostname,$db_username,$db_password);

if(!$db_server) die("Unable to connect to MySQL" .mysql_error());

mysql_select_db($db_database,$db_server)
or die("Unable to connect to database" .mysql_error()); 

//Writes the information to the database 
mysql_query("INSERT INTO `employees` VALUES ('$name', '$email', '$phone', '$fname','$fileType','$fileSize','$content')") ; 

 //Writes the photo to the server 
 if(move_uploaded_file($_FILES['photo']['tmp_name'], $target)) { 

 //Tells you if its all ok 
echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the directory"; 
       } 
  else { 

         //Gives and error if its not 
 echo "Sorry, there was a problem uploading your file."; 
    } 
     ?> 
      <form enctype="multipart/form-data" action="up.php" method="POST"> 
      Name: <input type="text" name="username"><br> 
      E-mail: <input type="text" name = "email"><br> 
      Phone: <input type="text" name = "phone"><br> 
      <input type="hidden" name="MAX_FILE_SIZE" value="2000000">
      Photo: <input type="file" name="photo"><br> 
      <input type="submit" value="Add"> 
      </form>

Uploading data and files to MySQL database through a single PHP form

1 Answers1