Problem with passed in URL variable

dr_pardee

I can't figure out how to get the passed in variable. For example, I call the below page DBInput.php?Day=100303

I want to insert the Day variable into my mySQL DB. Here's the code...

<?php
if (isset($REQUEST['submit'])) {
mysql_connect('localhost','mike','111kl2');
mysql_select_db('RandomDBs');
mysql_query("INSERT INTO messages (name,email,message,Date) VALUES ('" .
$REQUEST['name'] ."','" . $REQUEST['email'] . "','" . $REQUEST['message'] . "','" .
$REQUEST['Day'] . "')");
header("Location: DBinput.php");
} else {
print<<<HTML
<form method="POST" action="$SERVER[PHP_SELF]">
<table>
<tr><td>Name:</td><td><input type="text" name="name"></td></tr>
<tr><td>Email:</td><td><input type="text" name="email"></td></tr>
<tr><td>Comment:</td><td><textarea name="message" COLS="30" ROWS="10"></textarea></td></tr>
<tr><td colspan="2"><input name="submit" onClick="window.close()" value="Submit Comment" type="submit"></td></tr>
<tr><td colspan="2"><input type="hidden" name="Day" value="$Day" ></td></tr>
</table>
</form>
HTML;
}
?>

The hidden type value is what I can't figure out. This line <input type="hidden" name="Day" value="$Day" > . How do I get that the URL variable?

LordShryku

REQUEST is just so vague. Try this. Notice the $GET[] var...
Also, don't really see what you're doing with the header() statement when you're doing an onClick close...

<?
if(isset($_POST['submit'])) {
    $conn = mysql_connect('localhost','mike','111kl2');
    mysql_select_db('RandomDBs');
    $sql = mysql_query("INSERT INTO messages (name,email,message,Date) 
                        VALUES ('".$_POST['name']."',
                                '".$_POST['email']."',
                                '".$_POST['message']."',
                                '".$_GET['Day']."')");

header("Location: DBinput.php");
} 
else {

print<<<_HTML_;

echo "<form method=\"POST\" action=\"".$_SERVER['PHP_SELF']."\">
      <table>
        <tr>
          <td>Name:</td>
          <td><input type="text" name="name"></td>
        </tr>
        <tr>
          <td>Email:</td>
          <td><input type="text" name="email"></td>
        </tr>
        <tr>
          <td>Comment:</td>
          <td><textarea name="message" COLS="30" ROWS="10"></textarea></td>
        </tr>
        <tr>
          <td colspan="2"><input name="submit" onClick="window.close()" value="Submit Comment" type="submit"></td>
        </tr>
        <tr>
          <td colspan="2"><input type="hidden" name="Day" value="".$_GET['Day']."\" ></td>
        </tr>
      </table>
      </form>";

print   _HTML_;
}
?>

dr_pardee

Parse error: parse error, unexpected '{' in /var/www/html/DBinput.php on line 2

when I tried your variation. Not sure why?

LordShryku

That line being
if(isset($_POST['submit'])) {

Make sure you have both closing parens

dr_pardee

all the parens are there. It's weird, if I start with
<?php

then I get
Parse error: parse error, unexpected '{' in /var/www/html/DBinput.php on line 2

if I start with <?

then I get
Parse error: parse error, unexpected '{' in /var/www/html/DBinput.php on line 1

it's weird