what parameter can be used for this sql statement?

Question

" $SELECT = "SELECT Name From users Where Name = ? ";
$stmt = $conn->prepare($SELECT);
$stmt -> bind_param("s",$name);
$stmt -> execute();"

for the 's', i had seem 'i' and 's' only, how about other that i can use? especially for video and mage that save as blob in database .
or is there any note about these statement?

Answer 1

I addition to S(string) and i(integer), there is also d(double) and b(blob). This link might help: http://php.net/manual/en/mysqli-stmt.bind-param.php