PHP PDO Flag for for where clause

Asked Mar 20 '21 at 17:21

Active Mar 20 '21 at 17:21

Viewed 10 times

Sorry folks but I'm starting to feel stupid. Anyway I have the following problem. I am trying to access a MySQL database from PHP by running the following command.

    $stmt = $this->conn->prepare("SELECT * FROM `pricelist` WHERE $name = :string"); // how to handle $name??
    $stmt->bindParam(':string', $string, PDO::PARAM_STR);

Unfortunately I don't know what to put there because it's not passed as a string since it's my column name.

am unfortunately still new to PHP and do not quite understand it, thank you :D

asked Mar 20 '21 at 17:21

Fbert

You cannot use prepared statements for columns names. – Syscall Mar 20 '21 at 17:25
@Syscall Using `$name` inside double quoted string isn't a part of prepared query. Of course variable should be declared with some existing value before... – biesior Mar 20 '21 at 17:30
@biesior Right, but the question was about _"how to handle $name??"_ – Syscall Mar 20 '21 at 17:31

PHP PDO Flag for for where clause

0 Answers0