number of variables does not match the mysqli parameters

Question

Well I am trying to make a select "bindado" however this returning the following error Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn’t match number of Parameters in Prepared statement in

    $query = "SELECT * FROM duelos WHERE status='desafiado' AND desafiado='?'";
    $statement = $mysqli->prepare($query);

    //bind parameters for markers, where (s = string, i = integer, d = double,  b = blob)
    $statement->bind_param('s',$desafiante);
    $statement->execute();

    if($statement->execute()){
        print 'Voce foi desafiado por $desafiante <br> Aceitar o desafio? <br> Sim  -  Nao';
    }else{
        print 'Nada a relatar';
    }
    $statement->close();

Answer 1

In your query there is no placeholder, values should not be passed directly but exchanged for only questions(?) it is not necessary to use simple quotes to escape them when using Prepared statements.

Change:

$query = "SELECT * FROM d
$statement->bind_param(si, $status ,$iddesafiante);uelos WHERE status='desafiado' AND iddesafiado='$iddesafiante'";

For:

$query = "SELECT * FROM duelos WHERE status = ? AND iddesafiado = ?";
$statement->bind_param('si', $status ,$iddesafiante);