Premature end of script headers: newArticle.php

[lars55]

I got to tutorial 3 and have tried to implement it to that point. When I try to post a new article, I get the dreaded Internal Server Error 500 "Premature end of script headers: newArticle.php". I have checked and rechecked my coding and can't find where the problem might be.

I checked my permissions on the php scripts, all are set to 755. The message tells me the problem is somewhere in or around the newArticle.php file. Here is the code for said file below.

<?php
// Get the PHP file containing the DbConnector class
require_once('../includes/DbConnector.php');

// Check whether a form has been submitted. If so, carry on
if ($HTTP_POST_VARS){

// Create an instance of DbConnector
$connector = new DbConnector();

// IMPORTANT!! ADD FORM VALIDATION CODE HERE - SEE THE NEXT ARTICLE

// Create an SQL query (MySQL version)
$insertQuery = "INSERT INTO articles (title,tagline,section,article) VALUES (".
"'".$HTTP_POST_VARS['title']."', ".
"'".$HTTP_POST_VARS['tagline']."', ".
$HTTP_POST_VARS['section'].", ".
"'".$HTTP_POST_VARS['article']."')";

// Save the form data into the database
if ($result = $connector->query($insertQuery)){

// It worked, give confirmation
echo '<center><b>Article added to the database</b></center><br>';

}else{

// It hasn't worked so stop. Better error handling code would be good here!
exit('<center>Sorry, there was an error saving to the database</center>');

}

}
?>

If anyone sees a problem or has a suggestion, please advise.

thanks,
lars.

[marzar00]

G'day lars,

Try completing all of the articles and see if that helps. I noticed that in a few of the early code example, Peter has missed a few bits. It very well could have happened to his newArticle.php code that you have above. Rest assured that it DOES work...eventually!

Hope that helps,

Marzar

[Chip]

Hi Lars,
I can't remember if I had a problem with this or not but it looks like some of your quotations around the $insert function might be wrong?
It could just be the way it looks due to the forum/browser, but try this:

N.B. I will put extra spaces in just to be extra clear on which quotes to use, in practice you can remove them:
Instaed of this:
// Create an SQL query (MySQL version)
$insertQuery = "INSERT INTO articles (title,tagline,section,article) VALUES (".
"'".$HTTP_POST_VARS['title']."', ".
"'".$HTTP_POST_VARS['tagline']."', ".
$HTTP_POST_VARS['section'].", ".
"'".$HTTP_POST_VARS['article']."')";
try:
// Create an SQL query (MySQL version)
$insertQuery = "INSERT INTO articles (title,tagline,section,article) VALUES (' " .
$HTTP_POST_VARS['title']." ' , ' ".
$HTTP_POST_VARS['tagline']." ', ' ".
$HTTP_POST_VARS['section']." ', ' ".
$HTTP_POST_VARS['article']." ' )";

I appreciate that these differences are subtle and might not be easy to see, but look closely between the " and ' and hopefully you'll see a difference.
If you copy and paste that second version it might work?

Good luck

Chip