note 102534 added to function.mysql-connect

[email protected] Sat, 19 Feb 2011 14:04:26 -0800
Newsgroups php.notes
Message-ID <[email protected]>
I hope to help someone with this solution.

Recently I had many problems with updating and inserting records into mysql in more than one connection. The scenario: multiple connections to remote MySQL, and PHP CLI (php-gtk).
When not initiated a transaction to update a record when another user attempted to update the same record the script crashed and no longer came up as the connection was resumed.

Solution, for each change or insert start and end the transaction with mysql;
BEGIN and COMMIT;
----
Server IP: 189.126.97.120
Probable Submitter: 189.63.103.31
----
Manual Page -- http://www.php.net/manual/en/function.mysql-connect.php
Edit        -- https://master.php.net/note/edit/102534
Del: integrated  -- https://master.php.net/note/delete/102534/integrated
Del: useless     -- https://master.php.net/note/delete/102534/useless
Del: bad code    -- https://master.php.net/note/delete/102534/bad+code
Del: spam        -- https://master.php.net/note/delete/102534/spam
Del: non-english -- https://master.php.net/note/delete/102534/non-english
Del: in docs     -- https://master.php.net/note/delete/102534/in+docs
Del: other reasons-- https://master.php.net/note/delete/102534
Reject      -- https://master.php.net/note/reject/102534
Search      -- https://master.php.net/manage/user-notes.php