$_POST in a query call

nightdesigns

I'm attempting to set this command

$query="UPDATE accounts SET Name='$_POST['Name']' WHERE ID=1";

It returns

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/x/admin/editaccount.php on line 34

Line 34 is that line above.

I'm essentially trying to take a submitted HTML form and update the database. The $_POST part is causing an error. if i replace it with a variable, the issue goes away.

Is this possible to do? Or is there a better way to do it?

Dingusboy

I'm very new at this as well, but why NOT define it as $Name prior to the query.

$Name=$_POST['Name'];

$query="UPDATE accounts SET Name='$Name' WHERE ID=1";

Installer

$query = "UPDATE accounts SET Name='" . $_POST['Name'] . "' WHERE ID=1";

Edit: Or dingusboy's solution. Either will work.

nightdesigns

Installer wrote:
$query = "UPDATE accounts SET Name='" . $_POST['Name'] . "' WHERE ID=1";
Edit: Or dingusboy's solution. Either will work.

Installer, that did the trick, thanks.

Dingusboy, i would use that solution, however I have about 30 variables to pass and didn't see the need to re-declare each one.

m_tt

Dingusboy, a simple tip. Never create variables for one-time use. It takes up memory. You should practice only creating variables if you intend on using them more than once.

nightdesigns, another method for inputting variables into strings would be the { } brackets.

Example
"SET Name = '" . $POST['Name'] . "'";
"SET Name = '{$POST['Name']}'";