Functions
| Function | Description |
|---|---|
sqlquery |
Equivalent to mysqli_query / mysql_query in most cases. |
sqlfetch |
Equivalent to mysqli_fetch_assoc / mysql_fetch_assoc. |
sqlrows |
Equivalent to mysqli_num_rows / mysql_num_rows. |
sqlid |
Equivalent to mysqli_insert_id / mysql_insert_id. |
sqlescape |
Equivalent to mysqli_real_escape_string / mysql_real_escape_string |
sqlquery
Equivalent to mysqli_query / mysql_query in most cases.
If BigTree has enabled splitting off to a separate write server this function will send all write related queries to the write server and all read queries to the read server.
If BigTree has not enabled a separate write server the type parameter does not exist.
Return Value: A MySQL query resource.
sqlquery($query, $connection = false, $type = "read")| Parameter | Description |
|---|---|
$query |
A query string. |
$connection |
An optional MySQL connection (normally this is chosen automatically) |
$type |
Chosen automatically if a connection isn't passed. "read" or "write" to specify which server to use. |
sqlfetch
Equivalent to mysqli_fetch_assoc / mysql_fetch_assoc.
Throws an exception if it is called on an invalid query resource which includes the most recent MySQL errors.
Return Value: A row from the query in array format with key/value pairs.
sqlfetch($query)| Parameter | Description |
|---|---|
$query |
The mysql query resource (returned via sqlquery or mysql_query or mysql_db_query) |
sqlrows
Equivalent to mysqli_num_rows / mysql_num_rows.
sqlrows()sqlid
Equivalent to mysqli_insert_id / mysql_insert_id.
sqlid()sqlescape
Equivalent to mysqli_real_escape_string / mysql_real_escape_string
sqlescape()