Error reading result set's header in C:\wamp\www\storeinfo.php on line 15 and MySQL server has gone away in C:\wamp\www\storeinfo.php on line 15

Question

I am getting the following errors while uploading an image on phpmysql through wamp server.

1. MySQL server has gone away in C:\wamp\www\storeinfo.php on line 15

2. Error reading result set's header in C:\wamp\www\storeinfo.php on line 15

The code is given below:

<?php
ini_set('display_errors',1);
error_reporting(E_ALL);
$conn = mysql_connect("localhost","root","");
$db = mysql_select_db("imagestore",$conn);
if(!$db)
{
    echo mysql_error();
}
$rollNo = $_POST['rollNo'];
$image = addslashes (file_get_contents($_FILES['image']['tmp_name']));
$image_s=getimagesize($_FILES['image']['tmp_name']);
$imgtype = $image_s['mime'];
$q = "INSERT INTO students VALUES('','$rollNo','$image','$imgtype')";
$r=mysql_query($q, $conn);
if($r)
{
    echo "Information stored successfully";
}
else
{
    echo mysql_error();
}

?>

How to remove these errors?

I created it on phpmyadmin. So I have not used any statements to create table. — Tasneem, Feb 27 '17 at 07:11
http://stackoverflow.com/questions/11583352/php-mysql-server-has-gone-away — Suraj Rao, Feb 27 '17 at 11:10
http://stackoverflow.com/questions/1644432/mysql-server-has-gone-away-in-exactly-60-seconds — Suraj Rao, Feb 27 '17 at 11:10

score 0 · Answer 1 · edited Sep 18 '18 at 21:43

0

Please check the data type of the image field in the database. It must be longblob not blob. May be that is the reason it is not able to accept large files.

edited Sep 18 '18 at 21:43

Nimitt Shah

4,477
2
10
21

answered Sep 18 '18 at 21:14

Moses Arepelli

69
1
3

score 0 · Answer 2 · answered Sep 18 '18 at 21:23

Q 1.MySQL server has gone away in C:\wamp\www\storeinfo.php on line 15

This means you mysql server is not working properly, first you need to check if you mylsq server is working fine (try to use mysqlWorkBench or something like that)

Q 2: Error reading result set's header in C:\wamp\www\storeinfo.php on line 15

This means your file is printing something before the headers are sending, usually this happens when you try to print some image and you have some echo before

Also I would suggest to use mysqli or PDO instead of mysql_connect, since it is already deprecated https://phpdelusions.net/pdo

Error reading result set's header in C:\wamp\www\storeinfo.php on line 15 and MySQL server has gone away in C:\wamp\www\storeinfo.php on line 15

2 Answers2