Home >Backend Development >PHP Tutorial >ODBC function of php3_PHP tutorial
ODBC function of php3_PHP tutorial
- WBOYOriginal
- 2016-07-13 17:25:02932browse
Now let's list the commonly used ODBC functions in PHP3:
odbc_connect (dns, user, pass);
Returns a connection number, or 0 if the connection fails.
odbc_pconnect (dns,user,pass);
Special connection, the connection will not be disconnected after the script is finished running. The second time connecting to the same DNS is faster.
odbc_commit (connection number);
Interrupt the thread executing the connection, return True if successful, and False if failed.
odbc_autocommit (connection number, 0/1);
When the parameter is 1, set all threads executing the connection to automatically interrupt.
odbc_do/odbc_exec (connection number, sql statement);
Execute the sql statement and return a result number. If the operation fails, false is returned.
odbc_prepare (connection number, sql statement);
Returns a result number, but does not execute the sql statement. You can use odbc_execute (the result number) to execute later.
odbc_fetch_into (result number, [number of records,] array);
Put a certain record of the result (omitted to the next record) into the array (starting from [0]), regardless of the number of the array type.
Returns the position of the record in the result, or returns false if the operation fails.
odbc_fetch_row (result number, [number of records]);
Move to a certain record (omitted to the next record), which can be read and written by odbc_result.
odbc_num_fields (result number);
Returns the total number of fields.
odbc_num_rows (result number);
Returns the total number of records.
odbc_result (result number, field number/field name);
Returns the field number/field name in the current record in the result.
odbc_result_all (result number, sql statement);
Return all query results and output them in html table.
odbc_field_name/odbc_field_type/odbc_field_len (result number, field number);
Returns the field name/data type/data length of the field.
odbc_lonreaglen (result number, length);
Set the field length of the returned result. If the length is 0, all will be returned.
odbc_free_result (result number);
Release memory when the query results in memory are not needed.
odbc_cursor (result number);
Returns a pointer pointing to the result.
odbc_rollback
odbc_close (connection number);
Close the connection.
odbc_close_all();
Close all connections.
A specific example of using PHP3 to manipulate ODBC database.
db is the dsn name of odbc, tab1 is the table name
echo "ODBC Samples"."
";
$Connection_ID=odbc_connect(" db","","");
$Result_ID=odbc_exec($Connection_ID,"Select * from tab1");
$i=1;
$fldCount=odbc_num_fields($Result_ID);
echo "";
while (odbc_fetch_row($Result_ID,$i)0)
{
echo " ";
for ($j=1;$j{
echo " ".$i." ";
echo " ".odbc_result($Result_ID,$j)." ";
}
echo "
";
$i=$i+1;
}
echo " ";
?>
In fact, the query process It can also be simplified to:
$Connection_ID=odbc_connect("db","","");
$Result_ID=odbc_exec($Connection_ID,"Select * from tab1");
$fldCount=odbc_num_fields ($Result_ID);
odbc_result_all($Result_ID);
?>