Multi-user Database Locking with PHP

[dlite922]

I have an application written in PHP, and i'm trying to not to convert it to Java (for its locking functionality), and possibly do it somehow with PHP.

maybe PHP and Java.

My needs are that if 20 users are accessing the system, instead of having 20 DB connections, i can have 1, 3, 5, 10 or whatever the case.

A constantly running request handler. This is also knows to some as process forking, to fork a process into child processes.

In other words, is it possible to run a PHP background process that can handle requests?

Through what i know of PHP, this is not possible, but i'm not 100% sure.

Let me know how i can achive this, or with any other technology? Java and PHP get along good?

There was a question about calling a Java function from PHP that went unanswered, so I'm not holding my breath.

thanks guys,

DM

[Chibani]

hi,
I've got a little question :
What is the purpose of the DB manager if you don't send it request directly ?
I mean, DB system are made for being asked informations, request by many users (more than 20...).

[dlite922]

hi,
I've got a little question :
What is the purpose of the DB manager if you don't send it request directly ?
I mean, DB system are made for being asked informations, request by many users (more than 20...).

well its not just the database, i was looking for ROW locking type things. and for example I also have an FTP transaction that i don't want users to do simulatneously.

For the FTP what i'm planning to do is just set a flag in a small table in the database to weather or not a user is working with the FTP site.

I think that if I had a process with active connection to the DB (maybe Java?) , i wouldn't have to do all these database connections in PHP.