0

Recently I change from <input type="button"> to <button> in my forms however the form being processed by PHP wouldn't then submit to the database. Am I missing something in my code?

Basically all I have done is changed this:

<input type="submit" name="submitAdd" value="Ask Question! " />

To this:

<button type="submit" class="btn" name="submitAdd"><span><span>Ask Question!</span></span></button>

Here is the basic PHP processing Code:

//Extract question from submission
$question = (isset($_POST["question"]))?$_POST["question"]:"";
$question_date = (isset($_POST["question_date"]))?$_POST["question_date"]:"";
$submitAdd = (isset($_POST["submitAdd"]))?$_POST["submitAdd"]:"";

//Open connect to database 
include("include/session.php");

//Prepare data for submission
$db_question = addslashes($question);
$db_question_date = addslashes($question_date);

//If form has been submitted, insert question into database
if ($submitAdd) {
    $sql ="INSERT INTO questions
    (question,question_date)
    VALUES ('$db_question', '$db_question_date')";
    $result = mysql_query($sql);
    if (!$result) {
        $message = "Failed to add question. MySQL said " . mysql_error();
    } else {
        header("Location:http://localhost/grill/register.php"); 
    }
}
2
  • Um, just curious... why the two nested spans? Commented Nov 25, 2009 at 23:42
  • You want mysql_real_escape_string. addslashes isn't secure in all circumstances. Commented Nov 26, 2009 at 0:45

5 Answers 5

3

It doesn't work because the button version has no value. Your code says:

$submitAdd = (isset($_POST["submitAdd"]))?$_POST["submitAdd"]:"";

but you have:

<button type="submit" class="btn" name="submitAdd"><span><span>Ask Question!</span></span></button>

Compare this to:

<input type="submit" name="submitAdd" value="Ask Question! " />

which has a value attribute. This value is passed to the PHP script and is what you're testing. Your <button> doesn't have one.

With no value $submitAdd, even when clicked, will have a value of ''. An empty string evaluates to false when you do this:

if ($submitAdd) {

So, a couple of changes I would recommend. Firstly, change this:

$submitAdd = (isset($_POST["submitAdd"]))?$_POST["submitAdd"]:"";

to

$submitAdd = isset($_POST['submitAdd']);

since you don't really care about the value.

Secondly, unrelated to this but still worth mentioning, I would do this:

$db_question = mysql_real_escape_string($question);
$db_question_date = mysql_real_escape_string($question_date);
$sql = <<<END
INSERT INTO QUESTIONS (question, question_date)
VALUES ('$db_question', '$db_question_date')
END;
Sign up to request clarification or add additional context in comments.

3 Comments

Thanks, I understand, this worked. So I understand and learn, why change the other section of code, what is the advantage?
The advantage is twofold: 1) your code exactly matches your intent (in that you only care if the button was pressed, not its value) and 2) brevity (the less code you write to achieve the same thing, the better it is generally speaking).
Even better, include a hidden field to signal that the form is being submitted. You don't generally want to rely on the submit-control giving you a value, because of quirks about when that control is submitted, and what the value is when it's a button.
1
  1. Make the submitAdd input field hidden
  2. Call a Javascript function on click of the button

Markup:

<input type="hidden" name="submitAdd" value="Ask Question! " />

<button type="submit" onclick="submitForm();" class="btn" name="submitAdd">
<span><span>Ask Question!</span></span></button>

Javascript:

function submitForm(){
    document.forms["form_name"].submit();
}

I wouldn't recommend it though as you would depend on javascript for form submission. But even gmail does it that way :P

Comments

0

I'm guessing <button> tags don't get submitted, and thus don't end up in $_POST. Just do this at the top of your script to verify:

print $_POST["submitAdd"];

Why did you change from input to button anyway? I would recommend adding a hidden field called form_action or something similar and base your if logic on that... if ($_POST['form_action']) instead of if ($submitAdd).

1 Comment

Yeah nothing gets printed. What should I be doing to remedy this? (PHP newbie) To answer your question button provides a better way of consistent styling (apart from IE6). Check out the buttons on Google or twitter. I'm doing a similar thing. stopdesign.com/eg/buttons/3.0/code.html
0

Per w3schools.com

Important: If you use the button element in an HTML form, different browsers will submit different values. Internet Explorer will submit the text between the and tags, while other browsers will submit the content of the value attribute. Use the input element to create buttons in an HTML form.

http://www.w3schools.com/tags/tag_button.asp

Comments

0

Had the same problem, and my solution uses no javascript. It's mainly the same as user vsr previously answered.

Add a hidden input with the data you want to sumbit:

<input name="submitAdd" type="hidden" value=" Ask Question! ">

Name the button somehow else:

<button type="submit" class="btn" name="submitsForm"> Ask Question! </button>

The button will submit the form, and the data you want will be in the hidden input, and nicely submitted further. Hope it helps!

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.