After an image has been uploaded into database, the webpage does not load properly unless refreshed

Question

I recently altered some code of mine into a prepared statement to a form which essentially allows a user to simply upload an image and save in the database. Ever since I made some changes to the SQL query, after the upload button is pressed, only half of the webpage reloads again.

Webpage before an image is uploaded:

Then this is the webpage after an image is uploaded, the rest of the screen just dissapears:

I checked MAMPS apache error log and this is the last log that's on there [Mon Mar 11 20:35:04 2019] [error] [client ::1] File does not exist: /Applications/MAMP/htdocs/PhotoClub/style.css, referer: http://localhost:8888/PhotoClub/after-login.php?login=success

Which doesn't make any sense to me with it to do with the CSS file as the link to this is at the top of the page:

     
    
    Dashboard

The weird thing is that in the error log it doesn't seem to say the correct file path name even which is: /Applications/MAMP/htdocs/PhotoClub/CSS/style.css It's almost like it's missing out the CSS from the file path?

The html code for the form:


                    Upload photo entries here!
                    
                        Select Competition
                        
                    

                    Enter Member ID
                        
                        Enter Title

The php code:

Files uploaded
";
                }

                if(mysqli_connect_errno())
                {
                  printf("Connect failed: %s
", mysqli_connect_error());
                    exit();
                }

                if(!get_magic_quotes_gpc())
                {
                $fileName = addslashes($fileName);
                $filePath = addslashes($filePath);
                } 


                $stmt = $conn->prepare ("INSERT INTO tblImage (fldImageID, fldMemberID, fldCatID, fldFilePath, fldName) VALUES (NULL, ?, ?, ?, ?)");

                $stmt->bind_param("iiss", $memberID, $catID, $filePath, $imgTitle); 
                $stmt->execute();
                $result = mysqli_stmt_get_result($stmt) or die ("");

                //2. $query = "SELECT `fldImageID` FROM `tblImage` ORDER BY `fldImageID` DESC LIMIT 1";
                //3. Then I need a query to update the membEntComp or comp Table
                }

                  ?>

rickdenhaan · Accepted Answer

$stmt = $conn->prepare ("INSERT INTO tblImage (fldImageID, fldMemberID, fldCatID, fldFilePath, fldName) VALUES (NULL, ?, ?, ?, ?)");

$stmt->bind_param("iiss", $memberID, $catID, $filePath, $imgTitle); 
$stmt->execute();
$result = mysqli_stmt_get_result($stmt) or die ("");

You cannot use mysqli_stmt_get_result() on an INSERT query, as it only works for SELECT queries.

Since it returns false, your or die("") code is fired and your script stops executing there.

Instead, you can check the return value for $stmt->execute() to see if the query was executed successfully. To avoid confusion the next time, I'd add a more useful error message within the die(""):

$stmt = $conn->prepare ("INSERT INTO tblImage (fldImageID, fldMemberID, fldCatID, fldFilePath, fldName) VALUES (NULL, ?, ?, ?, ?)");

$stmt->bind_param("iiss", $memberID, $catID, $filePath, $imgTitle); 
$stmt->execute() or die("Failed to insert image into the database");

Or, more transparent (but essentially the same thing):

$result = $stmt->execute();

if (!$result) {
    die("Failed to insert image into the database");
}

After an image has been uploaded into database, the webpage does not load properly unless refreshed

Answers (1)

Related Questions