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 stackoverflow.com/questions/16885091/… — vijaykumar
– vijaykumar, Commented Sep 23, 2014 at 11:36

Community · Accepted Answer · 2017-05-23 11:49:36Z

1

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

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Sep 23, 2014 at 11:30

0x6C77

9393 gold badges13 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

update query not working

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related