PHP MySQL Update Column Error

Question

I am trying to update some columns in a row with MySQL in PHP like so:

$updateuser_sql = "
UPDATE `users`
SET
`HeaderPictureID` = $insertid,
`Bio` = '" . myre($_POST['Bio']) . "',
`ContactEmail` = '". myre($_POST['ContactEmail']) ."',
`PhoneNo` = '". myre($_POST['PhoneNo']) ."',
`TwitterHandle` = '". myre($_POST['TwitterHandle']) ."'
WHERE
`UserID` = '{$_SESSION['userID']}'
";

$mysqli->query($updateuser_sql);

if($mysqli->errno) {
    $handlerreturn['status'] = 'USER_UPDATE_FAILURE';
    console.log('FAILED');
} else {
    $handlerreturn['status'] = 'EXEC_SUCCESS';
    console.log('WORKED');
}

Unfortunately this doesn't work and I get the log 'FAILED'. How can I find out, more precisely, what is wrong and work to fix the issue? Am I doing something so obviously wrong?

Thanks!

o_O How? You can't to echo your SQL? Hm, what is 'console.log' ? — vp_arth
– vp_arth, Commented Oct 8, 2013 at 21:20

Lloyd Banks · Accepted Answer · 2013-10-08 20:46:07Z

1

Put this at the end of your page

$_POST["Bio"] = "hi";
$_POST['ContactEmail'] = "cheese";
$_POST['PhoneNo'] = "lion";
$_POST['TwitterHandle'] = "asdl";
$_SESSION['userID'] = "asdf";

$updateuser_sql = "
                    UPDATE `users`
                    SET
                    `HeaderPictureID` = 1,
                    `Bio` = '" . $_POST['Bio'] . "',
                    `ContactEmail` = '". $_POST['ContactEmail'] ."',
                    `PhoneNo` = '". $_POST['PhoneNo'] ."',
                    `TwitterHandle` = '". $_POST['TwitterHandle'] ."'
                    WHERE
                    `UserID` = '{$_SESSION['userID']}'
                    ";

echo $updateuser_sql;

It'll spit out the UPDATE statement that is sent to the database. I didn't see any syntax errors from the above. I suspect the problem has to do with your custom "myre" function.

answered Oct 8, 2013 at 20:46

Lloyd Banks

36.9k58 gold badges172 silver badges264 bronze badges

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

6 Comments

James Anderson Over a year ago

Hi Lloyd, yes, if I put all that at the bottom it works. However, it still doesn't work in a function... The function is getting called though.

Lloyd Banks Over a year ago

@JamesAnderson585 Can you post what your custom function looks like?

vp_arth Over a year ago

"'" . $var . "'" is not correct wrapping, also you need str_replace("'", "''", $var)

vp_arth Over a year ago

We asked for myre function, or better SQL from "if I put all that at the bottom it works"

Lloyd Banks Over a year ago

@JamesAnderson585 Is this the same function you're using in your code? This looks like it does something entirely different than from how the "myre" function is being used in your original question

|

Collectives™ on Stack Overflow

PHP MySQL Update Column Error

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related