maxdb_stmt_bind_param() is used to bind variables for the parameter markers in the SQL statement that was passed to maxdb_prepare(). The string types contains one or more characters which specify the types for the corresponding bind variables.
Variables for SELECT INTO SQL statements can also be bound using maxdb_stmt_bind_param(). Parameters for database procedures can be bound using maxdb_stmt_bind_param(). See the examples how to use maxdb_stmt_bind_param() in this cases.
If a variable bound as INTO variable to a SQL statement was used before, the content of this variable is overwritten by the data of the SELECT INTO statement. A reference to this variable will be
invalid after a call to maxdb_stmt_bind_param().
For INOUT parameters of database procedures the content of the bound INOUT variable is overwritten by the output value of the database procedure. A reference to this variable will be invalid after
a call to maxdb_stmt_bind_param().
Table 1. Type specification chars
Character
Description
i
corresponding variable has type integer
d
corresponding variable has type double
s
corresponding variable has type string
b
corresponding variable is a blob and will be send in packages
/* close statement and connection */ $stmt->close();
/* Clean up table CountryLanguage */ $maxdb->query("DELETE FROM temp.mycity WHERE name='Georgetown'"); printf("%d Row
deleted.\n",$maxdb->affected_rows);
/* close statement and connection */ maxdb_stmt_close($stmt);
/* Clean up table CountryLanguage */ maxdb_query($link,"DELETE FROM temp.mycity WHERE name='Georgetown'"); printf("%d Row
deleted.\n",maxdb_affected_rows($link));
/* close connection */ maxdb_close($link); ?>
The above examples would produce the following output:
/* Performing SQL query */ $stmt=maxdb_prepare($link,"SELECT price INTO ? FROM hotel.room where hno = ? and type = ?");
if (!$stmt) { printf("Prepare failed: %s\n",maxdb_error($link));
}