Updating Values in a row PHP/MySql

Question

Im not very experienced with PHP so I don't fully understand the syntax of PHP or MySQL Ive tried to tweak my code to create a row to update a row. this is the my attempt to update the row.

$sql = "UPDATE  `" . $table . "`SET (Expire_Date, HWID, IP_ADDRESS, PC_NAME) VALUES (?,?,?,?);";
$stmt = mysqli_stmt_init($link);

if (!mysqli_stmt_prepare($stmt, $sql)) {
    echo " sql key_register function failed";
} else {
    mysqli_stmt_bind_param($stmt, "ssss", $exp_date, $hwid, $ipaddress, $pcname);
    mysqli_stmt_execute($stmt);
    echo "licence activated";
}

I think my issue is the SQL syntax, I could just expand the code out and make a big mess but I like doing it this way because it 'seems' tidy I guess. Could someone show me what I am doing incorrectly.

Btw, that isn't the way [UPDATE](https://dev.mysql.com/doc/refman/8.0/en/update.html) works. — Funk Forty Niner, Apr 04 '20 at 14:24
Look up the UPDATE syntax and don't use any syntax that *seems tidy*. — forpas, Apr 04 '20 at 14:25
[How to get the error message in MySQLi?](https://stackoverflow.com/a/22662582/1839439) — Dharman, Apr 04 '20 at 19:29
Your code is too messy. You should use OOP-style mysqli and remove all these `if` statements. — Dharman, Apr 04 '20 at 19:30

score 0 · Answer 1 · answered Apr 04 '20 at 16:27

0

use correct UPDATE syntax:

$sql = "UPDATE  `" . $table . "`SET Expire_Date = ', HWID = ?, IP_ADDRESS = ?, PC_NAME = ?";

answered Apr 04 '20 at 16:27

draz

734
5
10

Updating Values in a row PHP/MySql

1 Answers1