How to open multiple records/windows at the same time in a PHP/MySQL web application

You can make multiple connections to mysql simultaneously as DBMS will manage that internally for you. There is no requirement to use php sessions for this.

Hi NeoCambell,
Thank you for the response.

But I wanted to know how to open many records at the same time in one browser(ie.same user).

For example, the user wants to open project 1001 and project 1008 at the same time in different tabs/windows and should be able to edit/access them.

Normally in web applications when you open another record the previous window changes to the current record.

I'm not sure if I'm asking the question correctly. Please forgive me for the long winded approach.

Can you please let me me how to implement this....

Many thanks.
Sab

Normally, when you open a record, you open it with a unique ID. In your case, in one window we have ID: 1001 where the other window has ID: 1008. When you save you pass the records against the ID to database. So from one page we pass 1001, xxx, eee, ttt, aaa and from the other window we pass 1008, yyy, fff, aaa, jjj. This is fully okay.
The only problem comes when you open the record with same ID in two windows, where the 2nd update overwrite the first update. (However you don't need to handle this as the user is aware that he has opened the same record in different windows.

Since the same user can open record in multiple windows, you may implement sessions using php, so you can detect that the same user is submitting records.

See this article to get a simple idea on handling sessions. http://www.expertcore.org/viewtopic.php?...

Hi NeoCambell,

Thank you very much for your reply.

I hope this is the way forward. I can see some light end of the tunnel!

I hope I can assign the unique project numbers to Session ID. I will start implementing this in few weeks.

You've really been helpful. I appreciate it.



Many regards,
Sab

Many people encounter the following computer problems: take a long time to start up, load websites or run programs. Recently I find the functional software which can fix all these problems just with one click: tuneup360, maybe you guys could have a try.<img src="http://post2.zhubajie.com/p/1292988585/1...