public function getAllByEstado($idEstado)
{
$caracteristicas = new ArrayObject();
$mysqli = new mysqli(Connection::DBHOST, Connection::DBUSERNAME, Connection::DBPASS, Connection::DBNAME);
$query = "SELECT id, id_estado, nombre FROM caracteristica where id_estado=?";
$statement = $mysqli->prepare($query);
$statement->bind_param("i", $idEstado);
$statement->execute();
$statement->bind_result($id, $idEstados, $nombre);
while ($statement->fetch()) {
$caracteristica = new Caracteristica();
$caracteristica->setId($id);
$caracteristica->setIdEstado($idEstados);
$caracteristica->setNombre($nombre);
$caracteristicas->append($caracteristica);
}
$mysqli->close();
return $caracteristicas;
}
