上传大尺寸图像时出错


Error while uploading large size image

我在尝试上传大图像时出错。我是 php 的新手,请指导我或为我提供更好的编码方法。

我收到了这些错误消息

Warning: mysql_query(): MySQL server has gone away in C:'xampp'htdocs'testing'test.php on line 63
Warning: mysql_query(): Error reading result set's header in C:'xampp'htdocs'testing'test.php on line 63

向上显示图像时出现问题。请检查您的数据库

这是我的代码

<?php
//connect to the database//
$con = mysql_connect("localhost","root", "root");
if(!$con)
{
 die('Could not connect to the database:' . mysql_error());
 echo "ERROR IN CONNECTION";
}
$sel = mysql_select_db("forms1");
if(!$sel)
{
die('Could not connect to the database:' . mysql_error());
echo "ERROR IN CONNECTION";
}
//file properties//
$file = $_FILES['image']['tmp_name']; 
$upload=0;
*/for($count = 0; $count < count($_FILES['image']); $count++)
{
if(!empty($_FILES['image']['name'][$count])){
   $image_desc[$count] = addslashes($_POST['imageDescription'][$count]);
   $image_name[$count] = addslashes($_FILES['image']['name'][$count]); echo '<br '>';
   $image_size[$count] = @getimagesize($_FILES['image']['tmp_name'][$count]);
   $error[$count] = $_FILES['image']['error'][$count];
   if($image_size[$count] === FALSE  || ($image_size[$count]) == 0)
       echo "That's not an image";
   $upload++;
   echo $upload;
// Temporary file name stored on the server
    $tmpName[$count]  = $_FILES['image']['tmp_name'][$count];
// Read the file
   $fp[$count]   = fopen($tmpName[$count], 'r');
   $data[$count] = fread($fp[$count], filesize($tmpName[$count]));
   $data[$count] = addslashes($data[$count]);
   fclose($fp[$count]);

// Create the query and insert into database.
$results = mysql_query("INSERT INTO files( name, image) VALUES('$image_desc[$count]','$data[$count]')", $con);
    if(!$results)
    echo "Problem uploding the image. Please check your database";  
}
?>

如果你在本地服务器上工作,你必须改变你的php.ini文件

以下是以下步骤:http://alex-lanos.blogspot.com/2012/09/xampp-apache-php-how-to-increase-upload.html

在 public_html 下创建一个文件并将其命名为 php.ini(如果您还没有的话。把以下内容放进去:upload_max_filesize = 5Mpost_max_size = 5M将 5 替换为 20 或更少。如果您允许其他人上传,尺寸上限可保护您的存储空间免遭滥用/过度使用。然后,您需要将此行添加到 .htaccess 文件中:(请将"您的用户名"替换为您的 cpanel 用户名,并在 comand 行的末尾将文件夹添加到 php.ini 文件的位置 - 路径和/home 之间也有一个空格)suPHP_ConfigPath/首页/您的用户名/public_html现在您的 PHP 上传限制应该增加。