+ REP - PHP Help

[adamFTW]

I have the following code, but the info submitted doesn't submit to the database.

Any help?

    <?php
    // The database
    include 'config.php';
    
// The variables
$name = ($_POST["name"]);
$grade = ($_POST["grade"]);
$comment = ($_POST["comment"]);
$ip = $_SERVER[REMOTE_ADDR];

//Those horrible IF's - Form data
if ($_GET["action"] == "submit")
{
if ($name == "")
    {
        echo "Whoops! You didn't enter your name.";
        exit;
    }
    
    
if ($comment== "")
    {
        echo "Whoops! You didn't enter a comment.";
        exit;
    }
        $name = addslashes(htmlspecialchars($name));  
        $grade = addslashes(htmlspecialchars($grade));
        $comment = addslashes(htmlspecialchars($comment));
         $addpetition = mysql_query("INSERT INTO `petition` (`name`, `grade`, `comment`, `ip`) VALUES ('$name','$grade','$comment', '$ip')"); 
        
    // The form details are fine, display text & details
    echo "XX: <br />
Name: $name<br />
Grade: $grade<br />
Your comment: $comment<br />
<br />
To view all the signatures, click <a href=\"petition.php?view=entries\">here.</a> To go back to the home page, click <a href=\"index.php\">here.</a>";
exit;
}

else
// Display the form
{
    echo "
<div align\"center\">XX</div><br />
<br />
<form action=\"?action=submit\" method=\"post\">
    <div id=\"title\">Name:</div>
    <input type=\"text\" name=\"name\"><br /><br />
    <div id=\"title\">XX:</div>
    <select name=\"XX\">
    <option id=\"5\">XX</option>
    <option id=\"5\">XX</option>
    <option id=\"6\">XX</option>
    <option id=\"7\">XX</option>
    <option id=\"8\">XX</option>
    </select><br /><br />
    <div id=\"title\">Comment:</div>
    <style=\"width=\"169\"; height=\"116\"><textarea rows=\"7\" input type=\"text\" name=\"comment\" cols=\"28\"></textarea><br />
    <input type=\"submit\" name=\"submit\" value=\"Sign the petition!\">
    </form>";
    exit;
    }
    
?>

[Dentafrice,]

  <?php
// The database
include 'config.php';

// The variables
$name = ($_POST["name"]);
$grade = ($_POST["grade"]);
$comment = ($_POST["comment"]);
$ip = $_SERVER[REMOTE_ADDR];

//Those horrible IF's - Form data
if ($_GET["action"] == "submit") {
    if ($name == "") {
        echo "Whoops! You didn't enter your name.";
        exit;
    }


    if ($comment == "") {
        echo "Whoops! You didn't enter a comment.";
        exit;
    }
    $name = addslashes(htmlspecialchars($name));
    $grade = addslashes(htmlspecialchars($grade));
    $comment = addslashes(htmlspecialchars($comment));
    $addpetition = mysql_query("INSERT INTO `petition` (`name`, `grade`, `comment`, `ip`) VALUES ('$name','$grade','$comment', '$ip')") or die(mysql_error());

    // The form details are fine, display text & details
    echo "XX: <br />
Name: $name<br />
Grade: $grade<br />
Your comment: $comment<br />
<br />
To view all the signatures, click <a href=\"petition.php?view=entries\">here.</a> To go back to the home page, click <a href=\"index.php\">here.</a>";
    exit;
} else // Display the form
{
    echo "
<div align\"center\">XX</div><br />
<br />
<form action=\"?action=submit\" method=\"post\">
    <div id=\"title\">Name:</div>
    <input type=\"text\" name=\"name\"><br /><br />
    <div id=\"title\">XX:</div>
    <select name=\"XX\">
    <option id=\"5\">XX</option>
    <option id=\"5\">XX</option>
    <option id=\"6\">XX</option>
    <option id=\"7\">XX</option>
    <option id=\"8\">XX</option>
    </select><br /><br />
    <div id=\"title\">Comment:</div>
    <style=\"width=\"169\"; height=\"116\"><textarea rows=\"7\" input type=\"text\" name=\"comment\" cols=\"28\"></textarea><br />
    <input type=\"submit\" name=\"submit\" value=\"Sign the petition!\">
    </form>";
    exit;
}
?>

Should output a MySQL error.

[adamFTW]

Did you edit the code?

And don't bother - I fixed it.

I have one more question, what is wrong with this code, it's suppose to display the data from a mysql database but it doesn't.

<?php

include "config.php";

$sql = "SELECT * FROM petition";
$check = mysql_query($connect, $sql)
// The above variables will be used to check our connection to MySQL.

if ($check) { // If we're able to connect, we continue in displaying.

while ($display = mysql_fetch_array($check, MYSQL_ASSOC)) {

$name = $display['name'];
$grade = $display['grade'];
$comment = $display['comment'];

// Above are variables defined for our Name, XX and Comment.

echo "
Name: $name 
<br> 
<br>
XX: $XX
<br>
<br>
Comment: <br><br> $comment
<br>
___________________
";

} else {

echo("Sorry. We could not retrieve the information requested. Please try again later");
}

[Dentafrice,]

<?php

include "config.php";

$sql = "SELECT * FROM petition";
$check = mysql_query("SELECT name, grade, comment FROM petition") or die("Cannot get it.");
// The above variables will be used to check our connection to MySQL.

while ($display = mysql_fetch_array($check)) {

    $name = $display['name'];
    $grade = $display['grade'];
    $comment = $display['comment'];

    // Above are variables defined for our Name, XX and Comment.

    echo "
Name: $name 
<br> 
<br>
XX: $XX
<br>
<br>
Comment: <br><br> $comment
<br>
___________________
";

}
?>

[Beau]

I think your PHP configuration for MySQL is preventing it from generating errors...

[Dentafrice,]

The PHP configuration is probably preventing the whole script from generating errors, place this at the top of your file, see what it gives you on load.

ini_set("display_errors", "1");
error_reporting(E_ALL); 

before anything.

[adamFTW]

The code you posted earlier works fine.

When I add that display_errors code to the top of my code, I get: Notice: Use of undefined constant xx_who - assumed 'xx_who' in /home/voonu/public_html/miss/config.php on line 3

[Dentafrice,]

Yeah, remove it now. That just displays everything. If you just want to display errors use E_ERROR

[adamFTW]

Okay, thank you.