[PHP] Access DB PHP

[Bob Irwin]

Hi guys,

I have a client who insists on using PHP and an Access database.  He
describes a problem with the access databases becoming locked when a user
clicks 'stop' in their browser whilst downloading the page (and I have to
stop the IIS server to release it).  I have absolutely no experience with
PHP/Access connections, so I thought I'd ding it along and see if the elite
PHP programmers of the world can pick up an error in his code.


 I connect like this:
 $conn = new COM ('ADODB.Connection');
 $conn-Open (Provider=Microsoft.Jet.OLEDB.4.0; Data
 Source='c:\\home\\westir\\data\\libcat.mdb');
 $sql = SELECT * FROM tbl_name ;
 $result = $conn-Execute($sql);

 // deal with the database generated information

 $result-Close()
 $conn-Close

Is there a better way to do this?


Best Regards
Bob Irwin
Server Admin  Web Programmer
Planet Netcom


-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: [PHP] Access DB PHP

[John W. Holmes]

 I have a client who insists on using PHP and an Access database.  He
 describes a problem with the access databases becoming locked when a
user
 clicks 'stop' in their browser whilst downloading the page (and I have
to
 stop the IIS server to release it).  I have absolutely no experience
with
 PHP/Access connections, so I thought I'd ding it along and see if the
 elite
 PHP programmers of the world can pick up an error in his code.
 
 
  I connect like this:
  $conn = new COM ('ADODB.Connection');
  $conn-Open (Provider=Microsoft.Jet.OLEDB.4.0; Data
  Source='c:\\home\\westir\\data\\libcat.mdb');
  $sql = SELECT * FROM tbl_name ;
  $result = $conn-Execute($sql);
 
  // deal with the database generated information
 
  $result-Close()
  $conn-Close
 
 Is there a better way to do this?

Have a look at register_shutdown_function() to ensure that your database
connection is closed, whether the script ends or is stopped or whatever.

www.php.net/register_shutdown_function

---John W. Holmes...

PHP Architect - A monthly magazine for PHP Professionals. Get your copy
today. http://www.phparch.com/



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php