Php - PDO - Parse error: syntax error, unexpected '.' [closed]

Question

Closed. This question is not reproducible or was caused by typos. It is not currently accepting answers.

This question was caused by a typo or a problem that can no longer be reproduced. While similar questions may be on-topic here, this one was resolved in a way less likely to help future readers.

Closed 10 years ago.

Improve this question

I have this function.

public function selection($table, $condition_var,$condition_val)
    {
        if ($condition_var != '') {

           $stm = $this->dbh->prepare("SELECT * FROM " . $table . " WHERE " . $condition_var=.":".$condition_var. " ");
           $stm->bindParam(":".$condition_var, $condition_val);
          return $stm->execute();
        }

    }

I am getting here in this below line

$stm = $this->dbh->prepare("SELECT * FROM " . $table . " WHERE " . $condition_var=.":".$condition_var. " ");

dont know what I am doing wrong here. kindly please check

I really hope all of these input parameters are carefully restricted. — tadman
– tadman, Commented Dec 4, 2014 at 20:44

RNK · Accepted Answer · 2014-12-04 20:08:48Z

2

Please refer to this: http://php.net/manual/en/pdostatement.bindparam.php

$stm = $this->dbh->prepare("SELECT * FROM " . $table . " WHERE " . $condition_var."=:condition_val");
$stm->bindParam(":condition_val", $condition_val);

edited Dec 4, 2014 at 20:08

answered Dec 4, 2014 at 19:38

RNK

5,79211 gold badges71 silver badges143 bronze badges

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

4 Comments

hellosheikh Over a year ago

hello sir I want to use the same variable on both end like this $condition_var =:$condition_var

RNK Over a year ago

so, your column name and value are the same?

hellosheikh Over a year ago

no at column i am using the string variable and for the column value i am sending some value $condition_val

RNK Over a year ago

binding parameters actually assigns the variable. And then you need to use that assigned variable in your query.

Sannek8552 · Accepted Answer · 2014-12-04 19:45:29Z

-1

$stm = $this->dbh->prepare("SELECT * FROM " . $table . " WHERE " . $condition_var . " = :param");
$stm->bindParam(":param", $condition_val);

answered Dec 4, 2014 at 19:45

Sannek8552

1332 silver badges3 bronze badges

Collectives™ on Stack Overflow

Php - PDO - Parse error: syntax error, unexpected '.' [closed]

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related