PHP MySql $_GET problems

Question

I have tried to search through the forums but I am a novice and am getting more confused.

I am trying to bring an input from a form and use it as a variable in a MySql query. A shortened version of the form is -

echo "<form  method=\"get\" action=\"\">";
echo "<tr><td>Leave:</td><td><input value=\"".$_SESSION['leave']."\" class=\"text\" autocomplete=\"off\" type=\"text\" value=\"\" /></td></tr>";
echo "</form>";

I am then trying to store the input into a variable using code -

$newVar = $_GET['leave'];

However I am getting an undefined index error.

Can anyone help with this? Sorry if its a very basic problem :)

try echo '<form method="get" action="">';

Josua M C
– Josua M C

2013-03-28 02:31:21 +00:00
Commented Mar 28, 2013 at 2:31 — Josua M C
– Josua M C, Commented Mar 28, 2013 at 2:31

Kermit · Accepted Answer · 2013-03-20 14:49:07Z

5

The problem is with your HTML. You need to name the input.

echo '<input name="leave" class="text" autocomplete="off" type="text" value="' . $_SESSION['leave'] . '" />';

answered Mar 20, 2013 at 14:49

Kermit

34.1k13 gold badges89 silver badges121 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

span · Accepted Answer · 2013-03-20 14:49:55Z

1

You declaring the "value attribute twice, you need to declare name:

echo "<form  method=\"get\" action=\"\">";
echo "<tr><td>Leave:</td><td><input name=\"".$_SESSION['leave']."\" class=\"text\" autocomplete=\"off\" type=\"text\" value=\"\" /></td></tr>";
echo "</form>";

answered Mar 20, 2013 at 14:49

span

5,66811 gold badges67 silver badges120 bronze badges

Comments

UnholyRanger · Accepted Answer · 2013-03-20 15:00:28Z

0

echo '<form  method="get" action="">';
echo "<tr><td>Leave:</td><td><input value='{$_SESSION['leave']}' class='text' autocomplete='off' type='text' name='leave'/></td></tr>";
echo "</form>";

If you use single quotes and doubles quotes alternating, you can make your code look nicer.

For your problem, you're missing your input name:

<input type=".." name="leave" ..>

Also, notice in your output of the field, you have the value set to the session value and an empty value near the end.

value=\"\"

edited Mar 20, 2013 at 15:00

answered Mar 20, 2013 at 14:52

UnholyRanger

1,97114 silver badges24 bronze badges

Collectives™ on Stack Overflow

PHP MySql $_GET problems

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related