MySQLi Tutorial MySQLi References

The mysqli_stmt class



The mysqli_stmt class represents a prepared statement.

Class synopsis

class mysqli_stmt {
  //Properties
  int|string $affected_rows;
  int $errno;
  array $error_list;
  string $error;
  int $field_count;
  int $insert_id;
  int|string $num_rows;
  int $param_count;
  string $sqlstate;

  //Methods
  public __construct(mysqli $mysql, ?string $query = null)
  public attr_get(int $attribute): int
  public attr_set(int $attribute, int $value): bool
  public bind_param(string $types, mixed &$var, mixed &...$vars): bool
  public bind_result(mixed &$var, mixed &...$vars): bool
  public close(): bool
  public data_seek(int $offset): void
  public execute(?array $params = null): bool
  public fetch(): ?bool
  public free_result(): void
  public get_result(): mysqli_result|false
  public get_warnings(): mysqli_warning|false
  public more_results(): bool
  public next_result(): bool
  public num_rows(): int|string
  public prepare(string $query): bool
  public reset(): bool
  public result_metadata(): mysqli_result|false
  public send_long_data(int $param_num, string $data): bool
  public store_result(): bool
}

❮ MySQLi Functions Reference