Form Problem

[Nixon]

Hello everyone, I must be missing something blatently obvious here because I have hundreds of other forms on my website however I cannot get this certain one ot work.

Add_event.php (Sends information to complete_event.php)

 <td bgcolor="#EBEBEB" class="fullborder"><form name="form1" method=POST action="complete_event.php">
<input name="test" type="hidden" value="test">
                    <label><span class="style2">Event Date

                <input name="Day" type="text" id="Day" value="D" size="1">
/
<input name="Month" type="text" id="Month" value="M" size="1">
/ 
                    <select name="Year" id="Year">
                      <?php

print "<option value='".date('Y',time())."'>".date('Y',time())."</option>";
print "<option value='".date('Y',time()[phone])."'>".date('Y',time()[phone])."</option>";

?>
                    </select>
                    </span></label>
                    <p class="style2">

                  <label>Event Name
                  <input name="event_name" type="text" id="event_name">
                  </label>
                 </p>
                <p><span class="style2"><a href="complete_event.php">
                  <label>
                  <input type="submit" name="Submit" value="Submit">
                  </label>
                </a></span></p>
              </form>                  </td>

Complete_event.php (Puts information in database)

<?php 

include("../includes/general.php"); 
include("../includes/connect_db.php"); 

$event_date  = $_POST['Day'];
$event_date .= $_POST['Month'];
$event_date .= $$_POST['Year'];

mysql_query("INSERT INTO `events` (`event_date` , `event_name` ) VALUES ('".$event_date."', '".$_POST['event_name']."')");

?>

THe problem I have is it is not transfering any values of the form fields at ALL, nothing is put over, any ideas?

Jack.

[vaaaska]

Are you validating your inputs?

[Houdini]

You might want to use this

<form name="form1" method="POST" action="complete_event.php">

Instead of

<form name="form1" method=POST action="complete_event.php">

[HalfaBee]

I have no idea, any errors or other debugging going on?

[Nixon]

No, I changed it from "POST" to just POST to see if it made a difference and it didn't, this is really confusing me i just can't for the life in me see what is wrong?!

Cheers,
Jack.

[Houdini]

Try echoing the $event_date and also make this change;

$event_name= $_POST['event_name'];
$query="INSERT INTO events (event_date , event_name ) VALUES ('$event_date', '$event_name')";
echo $query;//This will show what your query really is.
$result = mysql_query($query);

[Nixon]

Input:

$event_date  = $HTTP_POST_VARS['Day'];
$event_date .= $HTTP_POST_VARS['Month'];
$event_date .= $HTTP_POST_VARS['Year'];

$event_name = $HTTP_POST_VARS['event_name'];

$query="INSERT INTO `events` (`event_date` , `event_name` ) VALUES ('$event_date', '$event_name')";
echo($query);
mysql_query($query);

Output:

INSERT INTO events (event_date , event_name ) VALUES ('', '')

[ClarkF1]

Try using $_POST instead of $HTTP_POST_VARS

[vaaaska]

Once again...are you validating your inputs? I see that you aren't adding slashes or using mysql_escape_string so you are possibly setting yourself up for a disaster. A simple quote of some sort could also prevent your insert from happening...

http://be.php.net/manual/en/function.mysql-escape-string.php

[HalfaBee]

<p><span class="style2"><a href="complete_event.php">
<label>
<input type="submit" name="Submit" value="Submit">
</label>
</a></span></p>

Can you have a link as a button?

[ysu]

Why did you put the submit button into a link? Small wonder you dont' get variables through.
It'll send out the request as a simple get request (the link) without using the form, without posting any values.

Remove the link and it'll work - unless there are other problems of course.

[Houdini]

Remove that link, the action of the form will send that page to complete_event.php, why you would want to make a submit button a link is quite strange.

[bogu]

Nixon wrote:

$event_date .= $$POST['Year'];

If $POST['Year']=2006;

Then what is the value of this variable ($2006) ?

And btw, try to echo GLOBAL array after submit to see where are your values ...

In file Complete_event.php, add this line:

echo "<pre>",print_r($GLOBALS,1),"</pre>";