Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001011

Re: [PHP-DB] Interbase 5.6 error and php 4.0.4 From: Todd Cary (todd <email protected>)
Date: 01/03/01

Greg -

I am running Interbase 6.0 with PHP 4.0.4 and IIS 5. Until I upgraded
to Interbase 6.0, I had problems. Here are some snippets that work:

  /* Open the Interbase DB */
  function db_open($host, $user, $password) {
     return ibase_connect($host, $user, $password);
  };

  /* Is the Session in the Interbase DB? */
  function db_is_session($dbh, $sid) {
    $stmnt = 'SELECT * FROM SESSIONS WHERE SES_SESSION_ID = ' . $sid;
    $sthdl = ibase_query($stmnt,$dbh);
    if ($row = ibase_fetch_row($sthdl)) {
      $retval = 1;
    } else {
      $retval = 0;
    };
    ibase_free_result;
    return $retval;
  };

Todd 

--
Todd Cary
Ariste Software
todd <email protected>

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>