Home >Backend Development >PHP Tutorial >ODBC function of php3_PHP tutorial

ODBC function of php3_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:25:02909browse

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);
?>

www.bkjia.comtruehttp: //www.bkjia.com/PHPjc/532090.htmlTechArticleNow we will 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...
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn