Using PHP PDO prepared statements for update operations-PHP Chinese Network Q&A

prepare($sth);$q->execute(array(' :location'=>$location,':id'=>$id));but I get this error"> Using PHP PDO prepared statements for update operations-PHP Chinese Network Q&A

Article Topic Learning Download Q&A Programming Dictionary Game Recent Updates

简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)

Using PHP PDO prepared statements for update operations

P粉668019339 2023-08-24 19:21:05

362

I'm trying to update my database using the following query:

$sth = "UPDATE rpacks SET rpacks_location VALUES (:location) WHERE rpacks_id = (:id)"; $q = $conn->prepare($sth); $q->execute(array(':location'=>$location, ':id'=>$id));

But I get this error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 There is an error in your SQL syntax; check the Manual for the correct syntax to use near 'VALUES ('test') WHERE rpacks_id = ('2')' on line 1 of

P粉668019339

reply all (2)

P粉3156805652023-08-25 17:13:59 2 floor

change to:

$sth = "Update rpacks SET rpacks_location = :location WHERE rpacks_id = :id";

Like+0

Add Reply

P粉2486022982023-08-25 13:33:14 1 floor

There is an error in yourupdatequery because you used theinsertquery syntax.

The following is the correct query:

$sql = "UPDATE rpacks SET rpacks_location = :location WHERE rpacks_id = :id"; $stmt = $conn->prepare($sql); $stmt->execute([':location'=>$location, ':id'=>$id]);

refer to:http://dev.mysql.com/doc/refman/5.0/ en/update.html

Like+0

Add Reply