execute() (PHP) - execute() - Execute the prepared statement. If the prepared statement included parameter markers, either: PDOStatement::bindParam() and/or PDOStatement::bindValue() has to be called to bind either variables or values (respectively) to the parameter markers. Bound variables pass their value as input and receive the output value, if any, of their associated parameter markers or an array of input-only parameter values has to be passed: ?php /* Execute a prepared statement by binding a variable and value */ $calories = 150; $colour = 'gre'; $sth = $dbh->prepare('SELECT name, colour, calories FROM fruit WHERE calories < :calories AND colour LIKE :colour'); $sth->bindParam('calories', $calories, PDO::PARAM_INT); /* Names can be prefixed with colons ":" too (optional) */ $sth->bindValue(':colour', "%$colour%"); $sth->execute(); ?>