PHP4: using classes for MySQL tables

rtcary

I want to rewrite a PHP4 application (the client does not want to go to PHP5 at this time). My goal is to have a class for each table, and if possible, have one class to open the DB and have the structure of the "table" classes structured so that only one DB handle would be active, regardless of how many tables are accessed.

And if possible, have one destructor (register_shutdown_function(array(&$this, "__destruct") ); that would close the DB handle.

Can this be done?

Todd

rtcary

I have an ID that sometimes is passed in the URL (get) and others as post. One way is to

$id = $POST;
if (! $id) $id = $GET;

However, I would like to keep all if the variables in an array e.g. $_POST. Is this the best way to accomplish my goal:

$ary_Data = $POST;
if (! $ary_Data["id"]) $ary_Data["id] = $GET[id];

Todd

Weedpacket

It's certainly possible (although it has to be pointed out that PHP 4 is officially obsolete, unsupported, will no longer have bugs fixed, etc. etc.).

rtcary wrote:
And if possible, have one destructor ... that would close the DB handle.

PHP 4 automatically closed database handles when the script was finished.

I have an ID that sometimes is passed in the URL (get) and others as post. One way is to

Have a look at $REQUEST. Failing that $some_array = $POST + $_GET;.

rtcary

<<<
PHP 4 automatically closed database handles when the script was finished.

Unfortunately when using using the COM direct calls, the handles are not closed.

Todd