EOF / Failed to load error when calling PHP file with AJAX

Question

Apparently my POST requests are being cancelled? http://puu.sh/d73LC/c6062c8c07.png

and also, mysqli_result object has all null values when i query the database with a select query:

object(mysqli_result)[2]
  public 'current_field' => null
  public 'field_count' => null
  public 'lengths' => null
  public 'num_rows' => null
  public 'type' => null

here is my php file:

<?php

$servername = "localhost";
$username = "root";
$password = "root";
$dbname = "uoitlol";
$name = "test1"; //this should be $_POST['name']; test1 is just to test if it works.
$err = false;

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_errno > 0) {
    echo 'connerr';
    die();
}
$sql = "INSERT INTO summoners (name) VALUES (?)";

$getname = "SELECT name FROM summoners";

$result = $conn->query($getname);
while ($row = $result->fetch_assoc()) {
    echo 'name : ' . $row['name'];
    if ($row['name'] === $name) {
        echo 'error, name exists';
        $err = true;
    }
}

$stmt = $conn->prepare($sql);
$stmt->bind_param('s', $name);

if ($err === false) {
    if (!$stmt->execute()) {
        echo 'sqlerr';
    } else {
        echo 'success';
    }
}

$stmt->close();
mysqli_close($conn);

here is my javascript file, which calls the php file with ajax whenever i click submit on my form (in a different html file)

$(document).ready(function () {
    $("#modalClose").click(function () {
        document.getElementById("signupInfo").className = "";
        document.getElementById("signupInfo").innerHTML = "";
    });
    $("#formSubmit").click(function () {
        var name = $("#name").val();
// Returns successful data submission message when the entered information is stored in database.
        var dataString = {'name' :name};
        if (name === '')
        {
            document.getElementById("signupInfo").className = "alert alert-danger";
            document.getElementById("signupInfo").innerHTML = "<b>Please enter a summoner name!</b>";
        }
        else
        {
// AJAX Code To Submit Form.
            $.ajax({
                type: "POST",
                url: "submitName.php",
                data: dataString,
                cache: false,
                success: function (msg) {
                    if (msg === 'error'){
                        document.getElementById("signupInfo").className = "alert alert-danger";
                        document.getElementById("signupInfo").innerHTML = "<b>That summoner name is already in the database!</b>";
                    } else if (msg === 'sqlerror'){
                        document.getElementById("signupInfo").className = "alert alert-danger";
                        document.getElementById("signupInfo").innerHTML = "<b>SQL error, contact the administrator.</b>";
                    } else if (msg === 'success'){
                        document.getElementById("signupInfo").className = "alert alert-success";
                        document.getElementById("signupInfo").innerHTML = "<b>Summoner successfully added!</b>";
                    }
                }
            });
        }
        return false;
    });
});

I'm getting these errors everytime I click my button that submits my form:

Failed to load resource: Unexpected end of file from server (19:41:35:538 | error, network) at public_html/submitName.php

Failed to load resource: Unexpected end of file from server (19:41:35:723 | error, network) at public_html/submitName.php

Failed to load resource: Unexpected end of file from server (19:41:36:062 | error, network) at public_html/submitName.php

I'm using Netbeans IDE, if that matters.

puu.sh/d6YXP/05b5f3dc06.png - screenshot of the IDE, with the output log errors.

I was using it, but it still got garbled, I managed to fix it, my bad! — user4298098
– user4298098, Commented Nov 27, 2014 at 1:04

EternalHour · Accepted Answer · 2014-11-27 03:42:42Z

1

Remove this from your submitName.php, unless there really is HTML in it.

<!DOCTYPE html>

If there is HTML in it, do this instead.

<?php
//your PHP code//
?>
<!DOCTYPE html>
//your HTML here//
</html>

Also, if submitName.php contains no HTML, make sure there is no blank line after ?> at the bottom.

EDIT: In regards to your query failing, try this code.

if (!empty($name) { //verify the form value was received before running query//
    $getname = "SELECT name FROM summoners WHERE name = $name";

    $result = $conn->query($getname);
    $count = $getname->num_rows; //verify a record was selected//
    if ($count != 0) {
        while ($row = $result->fetch_assoc()) {
            echo 'name : ' . $row['name'];
            if ($row['name'] === $name) {
                echo 'error, name exists';
                $err = true;
            }
        }
    } else {
        echo "no record found for name";
        exit;
    }
}

edited Nov 27, 2014 at 3:42

answered Nov 27, 2014 at 2:04

EternalHour

8,6776 gold badges40 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

user4298098 Over a year ago

Thank you, but this did not fix the issue.

EternalHour Over a year ago

I've gone through the files you've provided thoroughly and there is nothing wrong with them. Either you are missing a },; or there is space before/after your php tags. You may also want to try reloading netbeans.

user4298098 Over a year ago

I got this from my WAMP server log file: 27-Nov-2014 04:12:21 Europe/Paris] PHP Fatal error: Call to a member function fetch_assoc() on a non-object in C:\Program Files (x86)\wamp\www\WSFinal\public_html\submitName.php on line 27 [27-Nov-2014 04:12:21 Europe/Paris] PHP Stack trace: [27-Nov-2014 04:12:21 Europe/Paris] PHP 1. {main}() C:\Program Files (x86)\wamp\www\WSFinal\public_html\submitName.php:0

EternalHour Over a year ago

So $getname = "SELECT name FROM summoners"; is not returning anything.

user4298098 Over a year ago

I guess so... but the query is returning a mysqli_result object. However, every field in the object is NULL. I am quite confused.

Philll_t · Accepted Answer · 2014-11-27 01:46:31Z

0

Drop the ?> at the end of the php file and instead of using var dataString = 'name=' + name; use this instead:

var data = { "name" : name};

jQuery will automagically do the dirty stuff for you so that you don't have to special text-escape it and stuff.

That's as far as I can help without any log files and just a quick skim of your code.

answered Nov 27, 2014 at 1:46

Philll_t

4,4377 gold badges48 silver badges61 bronze badges

7 Comments

user4298098 Over a year ago

Thank you for the reply! I made the changes as suggested, and I am still getting errors. These are the errors I got from the Output Log: Failed to load resource: Software caused connection abort: recv failed (20:55:45:109 | error, network) at public_html/submitName.php Failed to load resource: Unexpected end of file from server (20:55:52:199 | error, network) at public_html/submitName.php

Philll_t Over a year ago

Okay cool. Can you go ahead and update your code please on the question. Thanks!

user4298098 Over a year ago

I am actually using ajax to execute the php file, so that the browser does not switch pages. I can load the page, but whenever I submit the form I get the unexpected eof error, or i get the Software cause connection abort, recv failed error.

Philll_t Over a year ago

Okay, that's cool. But you should still be able to load the page on its own to see the output. so load "submitName.php" on its own, then using the die(); method, step through the file until you find the error. Also, if you are not seeing errors add this to the beginning of your PHP code ini_set('display_errors',1); ini_set('display_startup_errors',1); error_reporting(-1);

user4298098 Over a year ago

Ok, I ran the PHP file and changed it a bit (updated version is edited in the post). It runs fine by itself, it updates the table and will not add a name if it already exists.

|

Collectives™ on Stack Overflow

EOF / Failed to load error when calling PHP file with AJAX

2 Answers 2

5 Comments

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related