0

Help me solve this error

php script:

error found in line that contains $stmt->execute($params)

$username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING);
$passwd = filter_input(INPUT_POST, 'passwd', FILTER_SANITIZE_STRING);

$sql = "SELECT * FROM users WHERE username=:username";
$stmt = $db->prepare($sql);

// bind parameter ke query
$params = array(
    ":username" => $username

);

$stmt->execute($params);

$user = $stmt->fetch(PDO::FETCH_ASSOC);
Kampai
  • 22,848
  • 21
  • 95
  • 95
Firza Nanda Rio Aditya
  • 1
  • 1

1 Answers1

-3

You can try this

$username = filter_input(INPUT_POST, 'username', FILTER_SANITIZE_STRING);
$passwd = filter_input(INPUT_POST, 'passwd', FILTER_SANITIZE_STRING);
$sql = "SELECT * FROM users WHERE username=:username";
$stmt = $db->prepare($sql);
$stmt->bindParam('username',$username);
$stmt->execute();
$user = $stmt->fetch(PDO::FETCH_ASSOC);
sateesh roy
  • 1
  • 1
  • 1
    Since it seems to be `$db->prepare($sql)` that returns false instead of a statement, this would just give your _"Call to a member function bindParam() on boolean"_ instead. You've only moved the error. – M. Eriksson Nov 27 '19 at 06:13