php odbc_connect() function description and example code_PHP tutorial

Connect to ODBC The odbc_connect() function is used to connect to ODBC data sources. This function has four parameters: data source name, user name, password, and optional pointer type parameters.

Connect to odbc
The odbc_connect() function is used to connect to odbc data sources. This function has four parameters: data source name, user name, password, and optional pointer type parameters.

odbc_exec() function is used to execute sql statements

$db_user="dbuser"; //Define the connection user name
$db_pass="dbpass"; //Password corresponding to the connecting user
$dsn="dsn"; //Define dsn data source
if(odbc_connect($dsn,$db_user,$db_pass)) //Connect the odbc data source
{
echo "Successfully connected to odbc data source"; //If the content is successfully output
}
else
{
echo "There was a problem connecting to odbc!"; //Output content if failed
}

odbc_close_all(); //Close all open connections
echo "All open odbc connections have been closed!"; //Output content after executing the function

See a more advanced connection to the host

$db_host="server.mynetwork"; //Define the host name
$db_user="dbuser"; //Define the connection user name
$db_pass="dbpass"; //Define the password corresponding to the user
$dsn="dsn"; //Define dsn
$result=odbc_pconnect($dsn,$db_user,$db_pass); //Open a continuously valid odbc connection
if ($ result) // Judgment the result
{
echo "Open a persistent and valid connection"; //Successful execution output content
}
echo "
";
if(odbc_close($result)) //Try to close the connection
{
echo "Close?"; //If the output content is successfully closed
}
else
{
echo "Can't close!"; //Output content if closing fails
}

Query database tutorial

Data source to connect

$my_sql="select * from usertable"; //Define sql statement
$result=odbc_do($myconn,$my_sql); //Execute sql statement
echo odbc_num_rows($result);
echo "n";
echo "n";
echo "n";
echo "n";
echo "n";
echo "n";
while(odbc_fetch_row($result))
{
echo "n";
echo "n";
echo "n";
echo "n";
echo "n";
}
echo "

id number	name	address
".odbc_result($result,1)."	".odbc_result($result,2)."	".odbc_result($result,3)."

";

Some related

odbc_free_result($result);   //Release the memory occupied by executing sql statements
echo "The memory occupied by the result set has been successfully released!";
odbc_rollback($myconn) cancels all uncommitted operations
odbc_commit($myconn) //Submit all uncommitted operations
odbc_autocommit($myconn,false); //Disable automatic commit
odbc_columnprivileges($myconn,"dbuser","Administrator","usertable","name"); //List the columns and permissions of a given table
$result=odbc_columns($myconn); //List the names of the columns of the specified table
echo odbc_result_all($result);

http://www.bkjia.com/PHPjc/630775.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/630775.htmlTechArticleConnect to ODBC The odbc_connect() function is used to connect to an ODBC data source. This function has four parameters: data source name, user name, password, and optional pointer type parameters. connect to odbc o...