April 2013

If you’re looking for an example:
symfony2 file upload with related entities

The PHP way:

SQL

CREATE TABLE `file` (
  `id` int(10) unsigned NOT NULL,
  `full_path` varchar(255) NOT NULL,
  `filename` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `filename` (`filename`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `file` (

`id` int(10) unsigned NOT NULL,

`full_path` varchar(255) NOT NULL,

`filename` varchar(255) NOT NULL,

PRIMARY KEY (`id`),

KEY `filename` (`filename`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

HTML

<!doctype html>
<html>
<body>
<form method="post" enctype="multipart/form-data">
    <input type="file" name="file[]" multiple>
    <button type="submit">Upload</button>
</form>
</body>
</html>
<?php
$mysql = new mysqli('localhost','username','password','dbname');
$upload_dir = 'uploads';
$i = 0;
foreach ($_FILES as $file)
{
    if(is_uploaded_file($file['tmp_name']{$i}))
    {
        $destination = __DIR__ . DIRECTORY_SEPARATOR . 
                       $upload_dir . DIRECTORY_SEPARATOR . 
                       $file['name']{$i}; 
        move_uploaded_file($file['tmp_name']{$i}, $destination);
        $mysql->query("INSERT INTO file 
(id, full_path, filename) 
VALUES (NULL,'" . $destination. "','" . $file['name']{$i} ."')");
    }
    $i++;
}
?>

<!doctype html>

<html>

<body>

<button type="submit">Upload</button>

</form>

</body>

</html>

<?php

$mysql = new mysqli('localhost','username','password','dbname');

$upload_dir = 'uploads';

$i = 0;

foreach ($_FILES as $file)

{

if(is_uploaded_file($file['tmp_name']{$i}))

{

$destination = __DIR__ . DIRECTORY_SEPARATOR .

$upload_dir . DIRECTORY_SEPARATOR .

$file['name']{$i};

move_uploaded_file($file['tmp_name']{$i}, $destination);

$mysql->query("INSERT INTO file

(id, full_path, filename)

VALUES (NULL,'" . $destination. "','" . $file['name']{$i} ."')");

}

$i++;

}

15 minutes later. Success.

The symfony2 way:
How to handle File Uploads with Doctrine
Multiple File Uploads with Symfony2
Syntax Error. Head Explodes. 3 days later, time wasted.

And this is why Symfony2 sucks.

Can you reuse the PHP way? Sure you can. It works for single and multiple uploads. It does not use the uploadprogress but neither does the Symfony2 way.
Adding a mime type check? About 4 lines of code.

Imho the Symfony2 developers should focus on creating a scripting language since they’re so hot about reinventing the wheel.

If you want to waste resources and increase costs when developing a project use Symfony2. Go ahead, I won’t stop you.
If you want to keep it slim and easy learn PHP or some other scripting language.
Simplicity always wins.

Example: C64 vs Amstrad/Schneider CPC 464, the CPC was superior in every aspect but the C64 was simpler to use. The C64 won.
Amiga vs Atari, Amiga -> simpler. Facebook vs Myspace. Facebook simple. Facebook also sucks but yeah you get the point.
Windows vs Linux. Windows just works aka simple therefore Windows is used on most workstations. New Macintosh vs Windows. Mac is easy and just works, easier than Windows. Mac Userbase grows. IOS vs Android. Personally I find Android is better but the IPhone also just works and is simple.

Month: April 2013

Symfony2 File Upload with Related Entities

This is for a very old version of Symfony – 2.3

File Uploads in PHP and in Symfony2