<?php mysql_connect('************','***************','***********');
mysql_select_db('************');
error_reporting(-1);
ini_set('display_errors',1); ?>
<html><body>
<h1>Uploading Images to MySQL</h1><p>
<?php
if ( !isset($_FILES['userFile']['type']) )
{
die('<p>No image submitted</p></body></html>');
}
?>
You submitted this file:<br /><br />
Temporary name: <?php echo $_FILES['userFile']['tmp_name'] ?><br />
Original name: <?php echo $_FILES['userFile']['name'] ?><br />
Size: <?php echo $_FILES['userFile']['size'] ?> bytes<br />
Type: <?php echo $_FILES['userFile']['type'] ?></p>
<?php
if (isset($_POST['picup'])) {
if ( !preg_match( '/gif|png|x-png|jpeg/', $_FILES['userFile']['type']) ) {
die('<p>Не тот формат</p></body></html>'); }
else if ( strlen($_POST['altText']) < 9 ) {
die('<p>Текст надобно подлиннее</p></body></html>'); }
else if ( $_FILES['userFile']['size'] > 160384 ) {
die('<p>Файл надобно помельче</p></body></html>'); }
// Copy image file into a variable
else if ( !($handle = fopen ($_FILES['userFile']['tmp_name'], "r")) ) {
die('<p>Error opening temp file</p></body></html>'); }
else if ( !($image = fread ($handle, filesize($_FILES['userFile']['tmp_name']))) ) {
die('<p>Error reading temp file</p></body></html>'); }
else {
fclose ($handle);
// Commit image to the database
$image = mysql_real_escape_string($image);
$alt = htmlentities($_POST['altText']);
$query = ("
INSERT INTO `image` SET
`type` = '".($_FILES['userFile']['type'])."',
`name` = '".($_FILES['userFile']['name'])."',
`alt` = '".($alt)."',
`img` = '".($image)."',
");
if ( !mysql_query($query)) {
die('<p>Error writing image to database</p></body></html>');
} else {
die('<p>Image successfully copied to database</p></body></html>');
}
}
}
?>
</body></html>