1:
2:
3:
4:
5:
6:
7:

Warning: mysql_unbuffered_query() [function.mysql-unbuffered-query]: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/export/www/vhosts/funnetwork/hosting/wewillrockyourpg/wewillrockyoubandnight/uploadmysql/mysql-upload.php on line 9

Warning: mysql_unbuffered_query() [function.mysql-unbuffered-query]: A link to the server could not be established in /usr/export/www/vhosts/funnetwork/hosting/wewillrockyourpg/wewillrockyoubandnight/uploadmysql/mysql-upload.php on line 9

mysql-upload.php

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:

<?
if(isset($_POST['submit'])) 
{
        //MySQL Connect einfügen
 
        $pfad_zur_datei = $_FILES['img']['tmp_name'];
        $data = addslashes(fread(fopen($pfad_zur_datei, "r"), filesize($pfad_zur_datei)));
        mysql_unbuffered_query("INSERT INTO Bilder (id, bild, filetype)
                VALUES ('', '". $data ."', '".$_FILES['img']['type']."')");
}
?>
 
<form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
        <input type="hidden" name="daten_id" value="1" />
        <input type="file" name="img" />
        <input type="submit" name="submit" value="Datei Upload" />
</form>

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:

<?
if(isset($_GET['id'])) {
 
        // db verbindungen

 
        $result = mysql_query("SELECT bild,filetype FROM Bilder WHERE ID = '". $_GET['id']." '");
        $row = mysql_fetch_object($result);
 
        Header( "Content-type: $row->filetype");
        echo $row->bild;
}
?>

1:
2:
3:
4:
5:
6:
7:

$result = mysql_query("SELECT id FROM Bilder");
while($row = mysql_fetch_object($result))
{
        echo '<img src="mysql-bild.php?id='. $row->id .'" alt="" /><br />';
}

1:
2:
3:
4:
5:
6:
7:
8:

CREATE TABLE `Bilder` (
`id` INT( 5 ) NOT NULL ,
`bild` MEDIUMBLOB NOT NULL ,
`filetype` VARCHAR( 50 ) NOT NULL ,
PRIMARY KEY ( `id` )
)