PHP PDO execution in a function

Question

I've created this class:

class  data
{
public function del($cat, $id)
{
    global $dbh;

    $del = $dbh->prepare("DELETE FROM :cat WHERE id = :id");
    $del->bindParam(":cat",$cat);
    $del->bindParam(":id", $id);
    $del->execute();
}
}

And I'm running into an issue with binding the

:cat

variable to the statement, if I don't use bindParam for

:cat

and just tell it which table I want it to delete it from, for example:

$del = $dbh->prepare("DELETE FROM table1 WHERE id = :id");

It works fine.

I know it has to be some stupid error, but I can't for the life of me figure it out.

You can't bind table or column __names__, only __values__ for columns — Mark Baker, May 15 '11 at 22:06

score 3 · Accepted Answer · edited May 23 '17 at 11:55

3

It seems what you're trying to do is simply not possible

edited May 23 '17 at 11:55

Community

1
1

answered May 15 '11 at 22:05

greg0ire

22,714
16
72
101

Thanks, that is really interesting. Guess I'll just have to make a switch. – Doug Barrett May 15 '11 at 22:10

score 1 · Answer 2 · edited May 23 '17 at 12:19

1

Using table as parameter name is not possible with PDO.

Stack overflow post

php.net post

edited May 23 '17 at 12:19

Community

1
1

answered May 15 '11 at 22:05

N.B.

13,688
3
45
55

PHP PDO execution in a function

2 Answers2