update query not working

Question

Im trying to write an update query with PDO but it's not work

for ($count = 0; $count < 4; $count++) {
        if (!trim($elements[$count])=='') {

                $query = "update servers set " . '?' . "=" . '?' . "where " . '?'  . "=" . '?';
                $pdo = new PDO($db->dsn, 'adp', 'pass');
                $stmt = $pdo->prepare($query);
                $stmt->bindParam(1, $index[$count]);
                $stmt->bindParam(2, $elements[$count]);
                $stmt->bindParam(3, $index[$count]);
                $stmt->bindParam(4, $ServerName);
                $stmt->execute();
          }
}

May be possible duplicate of http://stackoverflow.com/questions/16885091/dynamically-change-column-name-in-pdo-statement — vijaykumar, Sep 23 '14 at 11:36

score 1 · Accepted Answer · edited May 23 '17 at 11:49

1

Table and Column names cannot be replaced by parameters in PDO. See this answer for more details.

edited May 23 '17 at 11:49

Community

1
1

answered Sep 23 '14 at 11:30

0x6C77

939
3
13
36

update query not working

1 Answers1