PHP : Function Reference : ODBC Functions (Unified) : odbc_free

Examples ( Source code ) » odbc_free_result


<?


$db_user        = "develUser";

$db_pass        = "d3v3lpa55";

$db_name        = "test";


if (PHP_OS == 'WINNT') {

$db_host        = "192.168.0.50";

$dsn =        "DRIVER={MySQL ODBC 3.51 Driver};" .

              "CommLinks=tcpip(Host=$db_host);" .

              "DatabaseName=$db_name;" .

              "uid=$db_user; pwd=$db_pass";

}

else {

$db_host        = "localhost";

$dsn =        "DRIVER={myodbc};" .

              "CommLinks=tcpip(Host=$db_host);" .

              "DatabaseName=$db_name;" .

              "uid=$db_user; pwd=$db_pass";

}


$directdsn = 'myodbc-test';



$r = odbc_connect($directdsn, $db_user, $db_pass);

//var_dump($r);

echo "resource? ".is_resource($r)."\n";

if (!$r) {

    echo odbc_errormsg();

    exit(1);

}


$rh = odbc_exec($r, "SELECT * FROM my_table");

if (!$rh) {

    echo "odbc_exec failed!\n";

    echo odbc_errormsg();

    echo odbc_close($r);    

    exit(1);

}

//var_dump($rh);

echo "resource? ".is_resource($rh)."\n";

$rows = odbc_num_rows($rh);

echo "num rows: $rows\n";

var_dump($rows);


$cols = odbc_num_fields($rh);

echo "num fields: $cols\n";

var_dump($cols);


// fetch

while ($rr = odbc_fetch_array($rh)) {

    var_dump($rr);

}


// fetch a specific row

$rr = odbc_fetch_array($rh, 3);

var_dump($rr);


// bad row

$rr = odbc_fetch_array($rh, 200);

var_dump($rr);


// free the result

echo odbc_free_result($rh);

// for good measure

echo odbc_free_result($rh);



echo odbc_close($r);


?>

("Note: If auto-commit is disabled (see odbc_autocommit()) and you call odbc_free_result() before committing, all pending transactions are rolled back.") I've looked thru the code, and that note is definitely wrong, at least in my environment (Windows/SQL Server). odbc_free_result ultimately just calls SQLFreeStmt which has NO EFFECT on outstanding transactions. In fact, it seems it must be wrong for all environments, because the SQLFreeStmt is bound to the destruction of the result resource. So unset($result) would be just as dangerous - and you're randomly and unpredictably screwed if garbage collection reaps the result set before your transaction's done.

odbc_free_result

Free resources associated with a result (PHP 4, PHP 5)
bool odbc_free_result ( resource result_id )

Code Examples / Notes » odbc_free_result

Change Language

odbc_free_result

Free resources associated with a result (PHP 4, PHP 5) bool odbc_free_result ( resource result_id )

Code Examples / Notes » odbc_free_result

Change Language

Free resources associated with a result (PHP 4, PHP 5)
bool odbc_free_result ( resource result_id )